In Excel, what does the function =IF(A1>70, "Pass", "Fail") return if A1 contains 85? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the function =IF(A1>70, "Pass", "Fail") return if A1 contains 85?

A. 85

B. TRUE

C. Pass

D. Fail

Answer: Option C

Solution (By JKSSB Mock Tests)

The condition A1>70 is true (85>70), so IF returns the value_if_true "Pass".

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

In MS PowerPoint, which of the following is a valid animation effect category?

A. Entrance

B. Emphasis

C. All of the above

D. Exit

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Entrance, Emphasis, and Exit are the main animation categories.

This question belongs to: Computer Microsoft Office

Question #2

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. #N/A

B. #VALUE!

C. #NAME?

D. #REF!

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
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

Question #3

In PowerPoint, to add a footer to all slides, go to:

A. Design -> Slide Size

B. Transitions -> Footer

C. Insert -> Header & Footer

D. View -> Slide Master -> Insert Footer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Header & Footer dialog adds date, slide number, custom text.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs