Excel - Formulas and Functions Part 3 (MCQ)

If =left(A1,3) is applied, what is the result?

• SEC

• OND

• 123

• SECO

If =right(B2,2) is applied, what is the result?

• _7

• 0)

• ND

• 56

If =mid(B1,3,4) is applied, what is the result?

• LE(2

• LE(

• 8_7

• 3456

If =mid(A1,4,2) is applied, what is the result?

• ON

• ECON

• 45

• 2345

If =left(B2,1) is applied, what is the result?

• :

• :9

• F

• 7

If =right(A2,3) is applied, what is the result?

• 456

• 654

• 123

• SEC

What is =COUNTA function?

• counts the number of cells that are not empty.

• counts the number of cells that contain a number.

• counts the number of cells in a range, that meets a given criteria.

• counts the number of cells that are empty.

What is =COUNT function?

• counts the number of cells that are not empty.

• counts the number of cells that contain a number.

• counts the number of cells in a range, that meets a given criteria.

• counts the number of cells that are empty.

What is =COUNTIF function?

• counts the number of cells that are not empty.

• counts the number of cells that contain a number.

• counts the number of cells in a range, that meets a given criteria.

• counts the number of cells that are empty.

If =COUNTA(A1:A6) is applied, what is the result?

• 5

• 6

• 2

• 3