What error code is returned by an MS Excel cell formula if a required lookup value cannot be matched or found inside a VLOOKUP search block? MCQ with Answer and Explanation

Question

What error code is returned by an MS Excel cell formula if a required lookup value cannot be matched or found inside a VLOOKUP search block?

A. #REF!

B. #N/A

C. #NAME?

D. #VALUE!

Answer: Option B

Solution (By JKSSB Mock Tests)

The #N/A (Not Available) error occurs when a formula or function cannot locate the target data requested, such as an exact match lookup missing from a reference table.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

What is the shortcut to open the 'Find and Replace' dialog with Go To tab in Word?

A. Ctrl + G

B. F5

C. Both A and B

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+G or F5 opens Go To.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, which view allows you to see the presentation as it will appear in a web browser?

A. Reading View

B. Normal View

C. Web Layout View

D. Slide Show View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Reading View in PowerPoint displays slides in a window with navigation controls, similar to a web browser. Slide Show is full screen, Normal is editing. There is no Web Layout View in PowerPoint.

This question belongs to: Computer Microsoft Office