Exam 7: Create Workbooks With Excel 2013

In a worksheet, columns have numerical headings and rows have alphabetical headings.

When the first entry in a cell is an equal sign, clicking another cell automatically enters that cell's address after the equal sign as part of the formula being created.

Options to insert a field (e.g., a filename) into a header or footer are in the ________ group of the Design contextual tab.

The data visible in the worksheet is the ________ value.

When a new row or column is inserted in a range of cells used in a function, the range in the function is not automatically adjusted to include that new row or column.

Row height and column width can be adjusted by clicking the ________ button on the Home tab.

Before the Spelling button is clicked, it is useful to make ________ the active cell.

The ________ number format multiplies the displayed number format of the cell by 100.

Formula AutoComplete displays a list of ________ names.

A symbol for an operation-like a + for addition or a - for subtraction-is a(n) ________.

The cell reference of an active cell is displayed, to the left of the formula bar, in the ________.

Match the worksheet feature with its action. -Fill Series

The symbol on the Enter button is a(n) ________.

The fill handle is used to copy content to adjacent cells.

The ________ button inserts a function that sums selected cells.

If the Tab key is pressed when B7 is the active cell, ________ will become the active cell.

In an Excel formula, a(n) ________ is the arithmetic operator for multiplication.

Text values are aligned at the ________ cell edge.

In a worksheet, pressing Enter after entering data in cell B5, makes cell C5 the active cell.

Which term is used to refer to automatic adjustment of cell references in a copied formula?