Exam 9: Excel_Module_2

The / arithmetic operator indicates ____________________.

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

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

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

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

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.

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

Which of the following calculations multiplies 23 by 0.01?

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

The most common error when entering a formula is to reference the wrong cell in the formula.

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

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.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

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

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

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

You cannot format an entire column at once.

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

The adjusted cell references in a copied and pasted formula are called ____ cell references.

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