Exam 12: Creating a Worksheet

The letter "X" is used for multiplication in Excel.

A collection of worksheets is sometimes called a _____.

Which of the following signs is used when creating an absolute reference?

To create an absolute reference, insert a pound sign (#) before the column reference and another pound sign before the row reference.

After you click a cell for a formula, a rectangle of dashes called a(n) ____________________ appears around that cell.

In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used.

To select a range of cells for use as arguments in a function, click the upper-left cell and release the mouse button.

Which of the following should be added before a number if you want to enter a number as a label, for example, as a telephone number?

Excel worksheets are saved in a(n) two-dimensional workbook.

A(n) ____________________ is any text entered into a cell of a worksheet.

One of the commonly used functions is the function MAXIMUM .

A worksheet ____________________ is the rectangle formed by the intersection of a column and row.

You can build complex formulas using arithmetic operators, parentheses, and a mixture of _____.

The method of creating formulas based on clicking cells instead of typing the cell reference is called the _____ method.

Which of the following data should be entered as a label?

A(n) ____________________ consists of values or cell references used to calculate the result of the function.

When specifying a range, use a _____ to separate the first and last cells.

If the label is too long to fit in the current cell and the cells on the right are not empty, _____.

The default workbook contains _____ worksheets.

Referring to the accompanying figure, the marquee around one of the cells can be removed by clicking the _____ key.