Moving from left to right, the first calculation in the order of operations is negation (-).

Moving from left to right, the first calculation in the order of operations is negation (-).

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

The Insert Options button lists formatting options.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

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

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

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.

The range automatically selected by Excel is always correct.

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

The AVERAGE function requires that the argument be included within parentheses following the function name.

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

You cannot format an entire column at once.

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

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.

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

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

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 formula in a cell that contains a reference back to itself is called a(n) ____________________.

The / arithmetic operator indicates ____________________.

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

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

You can press the ____________________ key to quit Range Finder.

Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____________________ colors.

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

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

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

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

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

____________________ view shows the worksheet divided into pages.

Cooler colors tend to pull away from the reader.

While holding down the ALT key, you can select nonadjacent ranges and cells.

The Accounting number format assigns a floating dollar sign.

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.

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?

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?