11 edpm practice oct

The text “Total Amount” in a cell is best described as a _____________

A.

• Value

• Formula

• Label

• Function

A cell contains the formula = SUM (A5:A10) + 17. Which of the following statements is UNTRUE?

• SUM is the name of a function

• A5:A10+17 is a formula

• 17 is a constant

• The result will be the sum of the values in A5, A10 and 17

Which punctuation mark should be used at the start of a cell entry when using a value such as ‘2008’ as a label?

• ‘

• ’

• #

• ;

A ####### error occurs when

• A column is not wide enough to display the cell’s content

• You press the # key too many times

• The value entered is too big for the spreadsheet to process

• The formula entered produces an incorrect result

Where is an active cell reference displayed?

• Formula bar

• Name box

• Cell

• Cell reference

How do you know what data is in a cell?

• The name box

• The formula bar

• The cell

• The data

A ___________ is an equation that performs calculations on values in your worksheet

• Formula

• Cell reference

• Constant

• Label

Which of the following is NOT a purpose of a spreadsheet?

• To create simple tabulations such as invoices and prices lists

• To hold accounting or financial data

• To perform advanced text processing

• To capture, manipulate and display numeric data

Microsoft Excel is a ___________ program that stores a series of ____________ in one of the many ___________ that it creates.

• Spreadsheet, worksheets, workbooks

• Workbooks, worksheets, spreadsheets

• Spreadsheet, workbooks, worksheets

• Worksheet, spreadsheets, workbooks

(B5:D9) is best described as a:

• Cell range

• Row range

• Column range

• Cell reference