Exam 5: Creating a Worksheet

The active cell is the cell you can currently edit or modify, and it is marked with a(n) black outline.

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

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?

Functions can have _____ argument(s).

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

Delete an existing worksheet by right-clicking the worksheet's tab and clicking _____.

A cell ____________________ is the column and row location of a cell.

Referring to the accompanying figure, the active cell is cell _____.

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When that formula is copied to cell C7, the relative references in the formula change to _____.

The columns are typically labeled with _____.

To edit a label after you've pressed the Enter key, click the cell, then click in the ____________________ bar.

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

In addition to writing your own formulas, you can use predefined formulas called _____.

After you select a function, you have to specify the _____.

Using formulas is a basic part of Microsoft Excel. Please describe a formula and a cell reference and how they interact.