Spreadsheet

To select multiple non-adjacent cells in a worksheet, click in the cell while holding the

• Alt key

• Ctrl key

• Shift key

• Ctrl + Alt keys

Which of the following displays the content of the active cell?

• Formula bar

• Menu bar

• Name box

• Status bar

A cell formatted to have accounting style shows negative numbers in

• bold

• double quotes

• brackets

• parenthesis

The process of identifying specific rows or columns so that these rows or columns are always visible on the screen is

• fixing

• freezing

• locking

• selecting

In a spreadsheet, which of the following is a text function?

• COUNT()

• DMAX()

• ROUND()

• UPPER()

A red triangle at the top right corner of a cell in a spreadsheet application indicates that

• the value in the cell is incorrect.

• the cell cannot accept formula.

• there is a comment associated with the cell.

• the formula entered into the cell has an error.

Which of the following displays the name of the active cell?

• Name box.

• Menu bar.

• formular bar.

• Status bar.

When a formatted number does not fit within a cell, it displays

• ######

• #DIV/0!

• #DIV/1.

• #VALUE

When one attempts to divide by zero in a worksheet, the error message displayed will be

• #####

• #DIV/0!

• #NAME?

• #NULL!

The error in #VALUE! a spreadsheet means

• you are performing a mathematical operation on a cell that contains text.

• you typed a space instead of a comma/semi colon in a function

• you typed the wrong function name

• the function cannot find the referenced data.