Exam 2: Formatting, functions, and Formulas

is the ________ button.

To hide a row of information,you place the mouse pointer over the row heading,________.

is the ________ button.

When cell D5 containing the formula =B5+E5 is copied to cell F6,the formula in cell F6 is =D6+G6.

A(n)________ is a value used for calculation or comparison purposes that is stored in a single location and can be used many times but be edited in that single location.

You should use at most three fonts in a worksheet.

When using a table, is the Sort arrow.

You can apply a different theme to each worksheet in your workbook.

A table style is a predefined set of formatting properties that control the appearance of a table.

The Comma format is just the Accounting format with the currency symbol.

When cell C6 containing the formula =D6/E7 is copied to cell A1,the formula in cell A1 is ________.

A(n)________ is a collection of fonts,styles,colors,and effects applied to a worksheet.

To see more of a worksheet,you can ________ a tab to hide the Ribbon.

The Table Styles gallery is displayed by clicking Format as Table in the ________.

Pressing the ________ key deactivates Format Pointer.

The ________ paste option pastes a range of cells to a new range of cells with columns and rows switched.

The Conditional Formatting button is located in the ________.

The Show Formulas button in located in the ________.

When adding a border to a cell,the Borders menu is displayed by clicking the ________.