Exam 11: Excel : Formulas, Functions, and Formatting

Pressing the F9 key instructs Excel to recalculate all formulas.

_________________________ 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.

Which of the following Option buttons gives options for filling cells following a fill operation?

When you enter a two-digit year that is less than 30, Excel changes the year to _____.

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

To start a new line in a cell, press the _____ keys.

The Insert Options button lists formatting options.

A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

You can use the arrow keys to complete an entry in Point mode.

Which of the following are valid formulas?

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.

Leo, owner of Leo's Bread Company, recently installed Excel 2010 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?

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

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Point mode allows you to ____, as shown in the accompanying figure.

Worksheet _________________________ typically contain items analogous to items in a list.

The values that you use with a function are called arguments .

You can press the _________________________ key to quit Range Finder.