Spreadsheet interview questions – page 3

If we wanted to perform a series of keystrokes more rapidly, we would use

1. A template
2. A macro
3. “what if” feature
4. None of these

To print a worksheet, one must

1. Decide whether to print the cells as they appear in the display or as they are stored in memory
2. Specify the range of cells
3. Both (a) and (b)
4. None of these

When a new row is inserted

1. All preceding rows are moved toward the top of the worksheet
2. All following rows are shifted to the right
3. All following rows are moved towards the bottom of the worksheet
4. Both (a) and (c)

A cell may be used in a mathematical formula if it contains

1. A label
2. Numerical data
3. Both (a) and (b)
4. None of these

The status line

1. Allows to communicate with the program
2. Shows what options are available while you are giving a command
3. Tells co-ordinates, value rule, and format rule of a cell
4. All of these

In the <b>paste</b> operation

1. Previous contents of the region where new entries are pasted is stored in a buffer
2. Tell the spreadsheet where to place new entries
3. Specify the range of cells to be moved
4. None of these

Typing a quotation mark in front of an entry tells the spreadsheet that the entry is a

1. Number
2. Formula
3. Label
4. None of these

A value tells the spreadsheet how to

1. Display the value
2. Calculate the cell’s value
3. Both (a) and (b)
4. None of these

If name “profit” is assigned to cell D5, then

1. Formula D5/2 may be written as “profit”/2
2. Value of D5 is “profit”
3. Both (a) and (b)
4. None of these

If a cell stores a formula, then it displays the

1. Result of computing the formula only it is the active cell
2. Formula
3. Result of computing the formula
4. None of these

If a formula should not be adjusted after it is copied, use

1. Absolute cell references
2. Mixed cell references
3. Relative cell references
4. None of these

Cell B2 contains the formula +D5+F1. If cell B2 is evaluated after cells D5 and F1, then spreadsheet is using

1. Natural recalculation order
2. Column-oriented recalculation
3. Row-oriented recalculation
4. Circular references

Which of the following cannot be changed in a spreadsheet?

1. Length of a page while printing
2. Height of a cell
3. Width of a cell
4. All of these

When we print a worksheet range that is wider than the printer page width, then it

1. Prints each worksheet page in two or more pages on printer.
2. Automatically prints the worksheet in condensed mode.
3. Prints only those columns that fit on the page.
4. All of these

Symphony allows you to calculate with

1. Times
2. Numbers
3. Dates
4. All of these

A format rule that affects the entire worksheet is called

1. Individual format rule
2. Hierarchical format rule
3. Global format rule
4. None of these

How many rows are there in a worksheet?

1. 8192
2. 8216
3. 8916
4. 9186

While using a spreadsheet program, if there is an error, such as disk error, printer not ready, it is communicated through

1. Mode indicator
2. Mode indicator and status line
3. Status line
4. Control panel

In lotus 1-2-3, pressing the Home key moves the cell pointer

1. To cell Z1
2. To cell A1
3. To left most cell of current row
4. To the top-left cell of the current screen

The address of a cell at 27th column and 30th row, is

1. AE27
2. AZ27
3. AA30
4. 27,30

The command that takes existing cell entries and replicates them in other cells is called

1. Move
2. Paste
3. Cut
4. Copy

Cell D5 is in the

1. Fourth row and the fifth column
2. Fourth row and the fourth column
3. Fifth row and the fifth column
4. Fifth row and the fourth column

Menu bars

1. Have clear explanations of all commands
2. Give a complete listing of all available commands
3. Require a small part of the screen
4. All of these

A column that stores names would need to be

1. The same width as all other columns, since width cannot be changed
2. The same width as a column that stores exam scores
3. Narrower than a column that stores exam scores
4. Wider then a column that stores exam scores

The most common method of context switching is

1. Pasting
2. Windowing
3. Linking
4. Clipping

A script of commands describing a sequence of tasks is called

1. Linkage
2. Function
3. Micro
4. Macro

The number of rows in a Spreadsheet of VisiCalc is

1. 250
2. 251
3. 252
4. 254

Which key is to be pressed to accept the suggested range?

1. Open
2. Close
3. Enter
4. Backspace

______ menu holds save as and close options.

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

Typing a slash is the normal way of entering the

1. Ready mode
2. Entry mode
3. Command mode
4. None of these