Spreadsheet interview questions

_____ function is the most commonly used function.

1. Average
2. Minus
3. Sum
4. Sigma

_____ icon is used to display the contents of the selected cells in currency format in StarOffice Calc?

1. Currency
2. Percent
3. Change font
4. Delete decimal

The cell referencing that does not get changed when copied is

1. Absolute cell addressing
2. Comparative
3. Relative cell addressing
4. Reference

File commands in StarOfficeCalc is available under the menu

1. View
2. File
3. Format
4. Edit

The default date format used in spreadsheet is

1. yy/dd/mm
2. dd/mm/yyyy
3. mm/dd/yy
4. dd/mm/yy

Which features is used to enter the same formula or data in various cells?

1. Automatic fill
2. Copy icon
3. Fill
4. Fill series

Which can be typed in a cell?

1. Text
2. Formula
3. Numbers
4. All the above

The icon used to import data from different files into a worksheet is

1. Insert Plug-in icon
2. Insert Applet icon
3. Insert Floating Frame icon
4. Insert from Image Editor icon

Which icon is to be clicked to draw in a Spreadsheet?

1. Show draw function icon
2. Colour icon
3. Insert picture icon
4. Draw icon

Which of the following is used to separate two different sheets in a formula?

1. Semicolon
2. Comma
3. Colon
4. Hyphen

The active cell in a spreadsheet is identified by

1. Keyboard pointer
2. Mouse pointer
3. Cell pointer
4. Insertion pointer

_____ menu can be used to format cells.

1. Format
2. Edit
3. File
4. All the above

With the help of which menu column width and row height can be changed?

1. Format
2. File
3. Tools
4. Edit

To do the calculations for different worksheets in a particular sheet, we use

1. 2D formula
2. 3D formula
3. selection
4. function

Which keys help us to move around the worksheet?

1. Tab & Home
2. Pageup & Tab
3. Tab, Home, Pageup and Pagedown
4. Home & Pagedown

The icon used for presenting data in the worksheet in form of charts is

1. Insert OLE Object icon
2. Insert from Image Editor icon
3. Insert Format icon
4. Insert Chart icon

Which option is used to print all sheets in the documents?

1. Page View
2. Print → Print range → All
3. Format
4. Print

The option under the File menu used to print the worksheet is

1. Page View
2. Print Range
3. Print Preview
4. Print

The command New → Spreadsheet is used to

1. Open New Worksheet
2. Close New Document
3. Open New Document
4. Close New Worksheet

The icon used to insert objects from other applications into a worksheet is

1. Insert Formula icon
2. Insert Applet icon
3. Insert OLE Object
4. Insert Plug-in

In a Spreadsheet the rows are numbered from _____ in StarCalc.

1. 1 to 16,000
2. 1 to 18,000
3. 1 to 32,000
4. 1 to 36,000

Worksheet can be opened by clicking on

1. Format → Open
2. File → Close
3. File → Open
4. File → Edit

The option under the File menu used to quit the StarOffice is

1. save
2. exit
3. open
4. close

In order to open attributes dialog box in StarOffice Calc select the option as

1. Format → Rows
2. Format → Cells
3. Format → Table
4. Format → Columns

The height of the row can be changed using the command

1. Format → Width → Row
2. Format → Height → Row
3. Format → Row → Height
4. Format → Row → Width

A continuous group of cells in a worksheet is called as

1. address
2. function
3. range
4. grid

Non numerical entries are called

1. functions
2. labels
3. cells
4. range

_____ option is used to preview a worksheet before printing?

1. Page
2. Page preview
3. Colour
4. All

In order to shift the content of a cell to the right and to create an empty cell, select the cell and a click is made on

1. Insert Columns icon
2. Insert Rows icon
3. Insert cells Down icon
4. Insert cells Right icon

The key combination used to open print dialog box in StarOffice Impress is

1. Ctrl + P
2. Shift + P
3. Alt + P
4. Ctlr + Shift +P