ADVANCED MICROSOFT EXCEL CIJ.z TRUE/FALSE

Report 7 Downloads 207 Views
Name:

ADVANCED MICROSOFT EXCEL CIJ.z TRUE/FALSE True/False Write a T or F to indicate whether the statement is true or false.

1.

Pressing the F9 key instructs Excel to recalculate all formulas.

2.

In the formula operation (*).

3.

The order of operations is from right to left.

4.

Point mode allows you to create formulas using the mouse.

5.

When an effor occurs in a formulaina cell, Excel displays the Trace Error button next to the cell and places a green triangle in the upper left of the cell.

6.

A blank cell in Excel has the numeric value of -1.

7.

To use Range Finder to veri$, that a formula contains the intended cell reference, double-click the cell containing the formula you want to check.

8.

The Currency style format cannot be used with a floating dollar sign.

9.

A condition for

:4 * 6 -

8, the subtraction operation

(-) is completed before the multiplication

a cell can only be true or false.

10. Hiding cells is a technique you can use to hide

data that you do not want others to see.