Exam 2: Formulas,Functions,and Formatting

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

When you decrease the row height to ____,the row is hidden.

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.

You can click the ____ button to undo an automatic correction.

To copy cell contents,you can select the cell and then press the ____ keys.

A formula in a cell that contains a reference back to itself is called a(n)____________________.

To set row height to best fit,____________________ the bottom boundary of the row heading.

You can press the ____________________ key to quit Range Finder.

You can click the Page Layout button on the status bar to switch to ____________________ view.

To use Range Finder to verify that a formula contains the intended cell references,click or tap the cell with the formula you want to check.

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

Which of the following is the path to the Conditional Formatting button?

Leo, owner of Leo’s Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format. -Leo wants the sales numbers for rye bread,onion rolls,and bagels to look different each time the sales for each exceeds $500.What Excel feature can Leo use to accomplish this?

The Accounting number format assigns a floating dollar sign._________________________

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Briefly discuss the order of operations.

Cooler colors tend to pull away from the reader._________________________

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.