Exam 11: Excel : Formulas, Functions, and Formatting

To set row height to best fit, _________________________ the bottom boundary of the row heading.

_________________________ view shows the worksheet divided into pages.

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

The equal sign (=)precedes a formula.

In designing a worksheet, visual aesthetics should come first.

The most popular background color is _____.

Which of the following happens when you enter the formula =G15 into a cell?

You cannot format an entire column at once.

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

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

All of the following are valid Excel arithmetic operators except _____.

Discuss how to determine the formulas and functions needed for a worksheet.

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

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

Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

Clicking the _____ opens the Insert Function dialog box shown in the accompanying figure.