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

Question Report Error

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

A. Fail

B. TRUE

C. Pass

D. 85

Answer: Option C

Solution (By JKExamLibrary)

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

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

In Access, which of the following is a valid expression for a validation rule?

A. Between 1 And 10

B. Like A

C. >0 And <100

D. All of the above

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
All are valid validation rule expressions.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

What is the shortcut key to apply or remove bold formatting in MS Word?

A. Ctrl + Shift + B

B. Ctrl + U

C. Ctrl + I

D. Ctrl + B

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Ctrl + B toggles bold. Ctrl + I italic, Ctrl + U underline, Ctrl + Shift + B opens bookmark list in Word.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

What does Ctrl + Shift + End do in MS Word?

A. Selects the last page

B. Deletes to the end of the line

C. Selects from the cursor position to the end of the document

D. Moves cursor to the end of the document

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Ctrl+Shift+End selects from the insertion point to the end of the document.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs