Exam 48: Formulas

Formula analysis is called formula auditing.

A formula is an expression that generally results in a numerical value.

After you have finished entering a formula,complete the process by pressing the Enter key.

To type an exponent as a cell value such as 4²,you would type the number 4,hold down the Shift key,and then press 2.

Excel starts working on the left when calculating a formula,and then follows ____ as it moves to the right.

To simplify formulas,you can assign ____ to specific cells,and then use them in formulas instead of cell addresses.

A cell containing a formula will always display the result of the formula.

Double-clicking a cell performs the same action as pressing the ____ key.

What is the value displayed in a cell that contains the formula =4*(5+6)?

The hyphen character is used for multiplication.

In most situations,Excel formulas contain specific values and not cell references.

In Excel,when you click the Show Formulas button,all cells containing a formula will display the formula instead of the formula result.

The advantage of using a(n)____ in a formula is that the result is automatically updated if a cell's value changes.

You can show all of a spreadsheet's formulas by pressing the ____ key combination.

A name assigned to a range of cells is called a ____ name.

To perform a division operation,use the ____ key on the keyboard or keypad.

What is the value displayed in a cell that contains the formula =15*4/6?

A defined name as a cell reference must always be unique.

To analyze an existing formula in a cell for accuracy,use the ____.

In most situations,formulas contain ____.