Question 1

Which of the extension a workbook is saved with?

Accepted Answer

.xlsx

Answer

.xslx

Answer

.xlxs

Answer

.xsxl

Question 2

Which of these is a valid cell reference?

Accepted Answer

B4

Answer

4B

Answer

4

Answer

B

Question 3

=SUM(C1:C5) has cell reference address as _____________.

Accepted Answer

Relative

Answer

Absolute

Answer

Total

Answer

Mixed

Question 4

Which of these depict an absolute address?

Accepted Answer

$A$2

Answer

$A2

Answer

A2

Answer

2A

Question 5

=2^3 evaluates to ____________.

Accepted Answer

8

Answer

4

Answer

2

Answer

12

Question 6

A formula always starts with a ________sign.

Accepted Answer

= (equal to)

Answer

– (minus)

Answer

+ (plus)

Answer

/ (slash)

Question 7

Evaluating the formula =5+ 2 * 4 gives which of these results?

Accepted Answer

13

Answer

28

Answer

68

Answer

11

Question 8

Evaluating the formula =2 * -5 + 1 gives which of these results?

Accepted Answer

-9

Answer

-5

Answer

9

Answer

-11

Question 9

Evaluating the formula = (5+ 10)* 25/ 5^3 gives which of these results?

Accepted Answer

3

Answer

12

Answer

10

Answer

4

Question 10

Which error displayed when a function used in a formula is not recognized by MS Excel?

Accepted Answer

#NAME?

Answer

#REF!

Answer

#######

Answer

#VALUE!

Related quizzes

Related quizzes