Exam 9: Excel_Module_2

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

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

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.

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

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

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

The Accounting number format assigns a floating dollar sign. _________________________

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

The ____ function displays the highest value in a range.

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

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

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

A ____ is text and graphics that print at the top of each page.

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

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.

Which of the following are valid formulas?

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

The range automatically selected by Excel is always correct.

All of the following are valid Excel arithmetic operators EXCEPT ____.

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.