Excel Practice Test 10 Sample Excel Assessment Test ...

Excel Practice Test 10 Sample Excel Assessment Test

Questions and Answers

Resources

Question 1

Resources

Question:

Excel Assessment Test

Applying AutoSum formulas in the range B12:E12 render wrong results, why is that?

CHOOSE ONE:

A AutoSum formulas exclude last row from results

B AutoSum formulas refer to the column left of their cells

C

AutoSum formulas are referring to their own cells causing error

D

AutoSum formulas, includes header values in the calculation

Resources

Correct Answer

Excel Assessment Test

AutoSum formulas do not exclude last row.

AutoSum formulas are not referring to left row as the data is on the columns.

AutoSum formulas do not refer to the cells they are placed in.

AutoSum

D formulas, includes header values in the calculation

Resources

Question 2

Resources

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download