Exam 13: Formulas, Functions, and Formatting Question

You can press the ____________________ key to quit Range Finder.

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

A ____ is text and graphics that print at the bottom of every page.

The / arithmetic operator indicates ____________________.

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

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Which of the following are valid formulas?

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

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.

The default view in Excel is called ____ view.

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

In designing a worksheet, visual aesthetics should same first.

The ____ Autosamplete list santains those functions that alphabetically match the letters you type following the equal sign.

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

You cannot format an entire salumn at once.

The Acsaunting number format assigns a floating dollar sign.

Which of the following is a method of entering functions?

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

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