If cell H12 displays a value of 689 what is the absolute val

If cell H12 displays a value of -6.89, what is the absolute value of that cell location? (ABS(H12))

a. -6.89

b. 6.9

c. 6.89

d. 7.0

In using the RAND funciton, when is the random value calculated?

a. Every time the worksheet performs a new claculation

b. When you enter the function into a formula

c. Whenever the user requests it

d. Once a week

Using the AutoFilter function allows you to:

a. find specific data in a spreadsheet

b. filter out certain values in a database

c. filter out automatically created formulas

d. recover your most recently saved file

The function SQRT (9) returns a value of:

a. 9

b. 3

c. 27

d. 18

The function that calculates straight line depreciation is:

a. DEPR

b. DDB

c. SYD

d. SLN

Solution

If cell H12 displays a value of -6.89, what is the absolute value of that cell location? (ABS(H12)) ?

The answer is  6.89 (c)

In using the RAND funciton, when is the random value calculated?

The answer is Every time the worksheet performs a new claculation (a)

Using the AutoFilter function allows you to:

The answer is find specific data in a spreadsheet (a)

The function SQRT (9) returns a value of:

The answer is 3 (b)

The function that calculates straight line depreciation is:

The answer is SLN (d)