Exam 12: Creating a Worksheet

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

Table rows are typically labeled with ____.

Use the ____________________ button to quickly create a function to calculate the total of a column or row of cells.

-In the figure above, the formula is entered in the cell ____.

Note that an asterisk (*) instead of the letter X is used for multiplication.

It is important to distinguish between a value and a cell when entering information into an Excel worksheet.Please describe both a label and a value.

-Referring to the figure above, the range of values in rows 3 through 6 in the D column would be written as ____.

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

Use the ____ to move the insertion point in the formula bar, and use the Backspace and Delete keys to delete characters.

If a label is too long to fit in the current cell, it extends into the cells ____ if they are empty.

You can use the ____ function to calculate all types of loan payments, such as those for a car or for a house.

If you don't use parentheses, Excel calculates the result using the standard mathematical order of operations-multiplication and division, then addition and subtraction.

A formula always begins with a plus sign (+) and can use cell references that point to the contents of other cells.

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

A ____ is any text entered into a cell of the worksheet.