Exam 11: Excel : Formulas, Functions, and Formatting

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Clicking the Insert Function box opens the Function Arguments dialog box, as shown in the accompanying figure.

Which of the following calculations multiplies 23 by 0.01?

A _____ is a prewritten formula that is built into Excel.

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

The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

Briefly discuss the order of operations.

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

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

To print a range of cells in the active worksheet, click _____ in the Settings area in the Print gallery, as shown in the accompanying figure.

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

You can learn more about Excel's functions with options in the _________________________ dialog box.

You can click the Page Layout view button on the _________________________ to switch to Page Layout view.

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

A(n)_________________________ is a dot on the screen that contains a color.

The function, or _________________________, of a worksheet is to provide a user with direct ways to accomplish tasks.

The / arithmetic operator indicates _________________________.

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.After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by spaces from the actual value.He would prefer that the dollar sign appear immediately to the left of the first digit of the value.To specify a floating dollar sign, which of the following formats should Leo apply?