You cannot use column and row titles within formulas when you want to refer to the related data by name.

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

A code is a group of format specifications that are assigned a name.

If you change the Normal style, Excel applies the new format specifications to all cells, including those assigned other styles.

To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.

A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

____ ensures that users do not change values inadvertently that are critical to the worksheet.

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

The arguments in ____ in the ScreenTip for a function are optional.

Which of the following is the path to the Financial button and the PMT function?

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.

Which of the following format codes insures that Excel will display a decimal point in the number?

A(n) ____ reference is a formula that depends on its own value.

To select nonadjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

Why is the VLOOKUP function used more often than other lookup functions?

____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

The process of filtering activity based on one or more filter criteria is called a ____.