Spreadsheet interview questions – page 2

In StarOffice Calc, a Spreadsheet contains

1. multiple cells
2. multiple sheets
3. no sheets
4. a single sheet

The formula to add the number in cell A3 with the number in cell A4 is

1. = avg (A3 : A4)
2. sum (A3 : A4)
3. = sum (A3 : A4)
4. sum (A3 + A4)

The active cell in StarCalc is identified by the

1. insertion pointer
2. cell address
3. cell pointer
4. cursor

The cell address that does not change when copied is

1. Absolute
2. Printer
3. Relative
4. All the above

_____ text box appears in the middle of the window of the function wizard.

1. Array
2. Data
3. Number
4. Result

Which appears on the formula bar while editing data in a worksheet?

1. Horizontal beam
2. Horizontal cursor
3. Vertical cursor
4. Vertical beam

Which command is used to generate a series of data directly from the values of the selected cells?

1. Auto Fill
2. Fill
3. Range Fill
4. Row Fill

Which is used to copy the contents of a cell or to create a series?

1. Automatic fill
2. Column fill
3. Range fill
4. Series fill

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

1. Standard
2. Change font
3. Percentage
4. Currency

Which a new spreadsheet is opened, at the top of window you have a

1. Function bar
2. Formula bar
3. Object bar
4. Menu bar

The formula used to perform calculations in the worksheet can be inserted with the help of

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

Which are entered in a cell?

1. Data and Formulae
2. Function
3. Data
4. Formulae

Where is a list of all functions displayed?

1. Text box
2. Dialog box
3. Function box
4. Category box

______ can be entered in the worksheet with the help of StarCalc?

1. Date and Time
2. Time
3. Date
4. Year

In _____ box, a preview for each style is displayed.

1. Auto format
2. Category
3. Dialog
4. Text

To retrieve an entry from a table, we use a

1. Logical function
2. Table function
3. Look-up function
4. None of these

Address of first cell in the worksheet is

1. A
2. A0
3. A1
4. 1A

When merging two worksheets

1. Label and formulas cells are not affected by the incoming value
2. Empty cells acquire the value of the incoming value
3. Number cells have their value added to the incoming value, so that the sum of the two values is displayed
4. All of these

Copy command in a spreadsheet

1. Copies formulas giving a special treatment in order to handle different types of addresses
2. Copies only these formulas with addresses of one type
3. Copies formulas treating them like labels
4. Never copies formulas

The formula in the cell B5 is +A4+C3. This is copied to cell D8. What will be the formula in D8?

1. +C7+E6
2. +C4+E3
3. +E7+C5
4. +A4+C3

The formula cell A2 is +B2+C3. On copying this formula to cell C2, the formula in cell C2 will be

1. +A2+C3
2. +B2+E3
3. +D2+C3
4. +D2+E3

Maximum width of a cell is

1. 128 characters
2. 240 characters
3. 480 characters
4. 1024 characters

Values, entered in a cell, are always

1. Centred
2. Left aligned
3. Right aligned
4. Not aligned at all

To create a worksheet, it is

1. Not important to be knowledgeable about the task to be done
2. Important to understand a programming language
3. Important to be knowledgeable about the spreadsheet
4. Both (a) and (b)

Mixed cell references are useful if

1. A formula should be interpreted relative to the formula’s current row position but should not be adjusted because of its column position
2. References to the cells that contain the worksheet’s critical assumptions should not be adjusted
3. A formula should be interpreted relative to the formula’s current position
4. None of these

If cell D1 contains 20, cell D2 contains 30, and cell D3 contains the formula +D1+D2, then cell D3 display 50. If cell D1 has its value changed to 12, then cell D3 will now display

1. +D1+D2
2. 12
3. 30
4. 42

The control panel displays a/an

1. Window into the spreadsheet
2. Entry line
3. Status and help area
4. Both (a) and (c)

The easiest way to modify slightly a cell that contains a long label is to

1. Use an erase command to erase the cell and start over
2. Retype the correct entry
3. Use an edit command to edit the cell
4. None of these

To keep a portion of the worksheet fixed in place regardless a how the rest of the worksheet is moved, use

1. PROTECT command
2. WINDOW command
3. FIX command
4. TITLE command

Column-oriented recalculation will evaluate a formula in cell C3 before evaluating a formula in

1. Cell A2
2. Cell B5
3. Cell E3
4. Both (a) and (c)