Exam 10: Excel: Formulas, Functions, and Formatting

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

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

In the order of operations, the last operation Excel performs is ____________________.

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

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

You should ____ a function name in the Formula AutoComplete list to select the function.

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.

Critical Thinking Questions Case 2-1 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?

Modified Multiple Choice Which of the following actions are provided by the Paste Options button?

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.

A ____ is text and graphics that print at the bottom of every page.

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

Typing =av in a cell displays the ____________________, as shown in the accompanying figure.

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Clicking the Create Function box opens the Function Arguments dialog box.

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.