What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)? MCQ with Answer and Explanation

Question Report Error

What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)?

A. #NULL!

B. #REF!

C. #NAME?

D. #VALUE!

Answer: Option C

Solution (By JKExamLibrary)

The #NAME? error occurs when Excel does not recognize text within a formula, which is typically caused by a misspelled function name or a missing quote around a text string.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

To go to the next cell in a table in MS Word, press:

A. Shift + Tab

B. Tab

C. Arrow Right

D. Enter

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Tab moves forward; Shift+Tab backward.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, the function =COLUMN() in cell D5 returns:

A. Error

B. 5

C. D

D. 4

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Column D is 4th column.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS PowerPoint, what is the default orientation applied to presentation slides upon initial file creation in modern 2026 software environments?

A. A4 printable grid setup

B. Portrait (4:3 ratio standard format)

C. Landscape (16:9 widescreen format layout)

D. Square configuration matrix

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Modern versions of MS PowerPoint deploy Landscape orientation using a 16:9 widescreen aspect ratio layout as the default preset.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs