Exam 7: Create Workbooks With Excel 2013

When a range is selected, the name box displays the cell address of ________.

The Header & Footer button is in the Text group on the ________ tab.

Pressing Ctrl + Home keys makes ________ the active cell.

The Spelling dialog box does NOT suggest corrections for words identified as misspelled.

Placing content in a cell can be done by pressing the Enter key or by clicking the ________.

A prewritten Excel formula that uses values, performs arithmetic operations, and returns a value is a(n) ________.

If content exists in cell B1, and a long text value is entered into cell A1, the A1 display is ________.

In a worksheet the intersection of a column and row is a(n) ________.

If cell B7 includes the formula =B5 + B6, and the fill handle is used to copy the formula to cell C7, what is the underlying formula in cell C7?

Which feature displays the formatting of the style moused over in the Cell Styles gallery on the selected cells in the worksheet?

An underlying value that does mathematical calculations on numeric values in a worksheet is ________.

What is the address of the cell where the third column and fourth row intersect?

Match the worksheet feature with its action. -Fill handle

Select the ________ option from the Auto Fill Options menu to keep numeric values unchanged when using the fill handle.

The Increase Decimal and Decrease Decimal buttons actually add or remove decimal places to the underlying value in a cell.

When a range is selected, a thick green line surrounds the range, and all cells except the first cell are shaded.

Directional arrow keys can be used to move the active cell indicator in the direction of the arrow.

The letter D in the cell address D5 refers to ________.

Match the worksheet feature with its action. -Relative cell reference

Double -clicking on a cell displays the shortcut menu and Mini toolbar.