Exam 95: Formulas

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

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

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

Click the ____________________ key to exit Edit mode.

When you use a(n)____ in a formula,the cell's value is automatically updated when you type a new value in one of the cells.

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

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

You can use a cell's ____________________ to copy a formula from one cell to another.

When you click a cell containing a formula,the formula becomes visible with its cell references color-coded.

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

The formula analysis process is called formula auditing.

You ____-click a cell when you want to edit the contents.

The hyphen key is used for multiplication.

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

Formulas should begin with a(n)____________________ sign.

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

In Excel,when you click the Show Formulas button,you can choose to display the formula in all cells containing a formula.

Most of the tools for auditing formulas are found on the ____________________ tab in the Function and Audit Formulas groups.

What is the value displayed in a cell that contains the formula =48+4*2?

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