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. Fail

C. TRUE

D. Pass

Answer: Option D

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

What is the shortcut key to show/hide the ribbon in MS Office applications?

A. Alt + F2

B. Alt + F1

C. Ctrl + F1

D. Ctrl + Shift + F1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + F1 toggles the ribbon display in Office apps. Alt+F1 inserts a chart in Excel, others are not standard.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, to view two parts of a document simultaneously, use:

A. Review -> Compare

B. Window -> New Window

C. View -> Split

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Split divides one window into two panes; New Window opens a second window of same document.

This question belongs to: Computer Microsoft Office

Question #3

What is the primary difference between a 'Save' and 'Save As' command sequence in MS Office programs?

A. 'Save' completely locks down file text permissions automatically.

B. 'Save As' can only overwrite data lines on cloud folders.

C. 'Save' updates an existing file; 'Save As' allows you to save the file with a new name, format, or location.

D. There is no difference in modern 2026 software versions.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Save command saves changes to the current file name. Save As prompts for a new file name, location, or format file extension type.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs