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

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.

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

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

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

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.

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

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

____ 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.

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

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

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

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

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

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

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.

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.

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

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).

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

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.

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

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.