In Excel, the formula =IF(A1>10, IF(A1>20, "High", "Medium"), "Low") will return what if A1=15? MCQ with Answer and Explanation

In Excel, the formula =IF(A1>10, IF(A1>20, "High", "Medium"), "Low") will return what if A1=15?
A. High
B. Error
C. Medium
D. Low
Answer: Option C
Solution (By JKExamLibrary)
A1=15, first condition >10 true, then nested IF: A1>20 false, so "Medium".

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 MS PowerPoint, what key should a presenter hold down while using the pen tool during a live show to draw rigid horizontal or vertical annotation lines?
A. Alt
B. Ctrl
C. Shift
D. Tab

Correct Answer: Option C


Explanation:
Holding the Shift key during a presentation slide delivery locks the integrated pen tool tracking into perfect horizontal or vertical lines.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Access, what is the default value for 'Allow Zero Length' property?
A. Yes
B. True
C. Null
D. No

Correct Answer: Option D


Explanation:
By default, zero-length strings are not allowed.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
What is the shortcut key to go to the beginning of a document in MS Word?
A. Ctrl + Home
B. Home
C. Ctrl + End
D. Ctrl + Page Up

Correct Answer: Option A


Explanation:
Ctrl + Home moves the cursor to the beginning of the document. Ctrl + End goes to the end. Home moves to the beginning of the line. Ctrl+Page Up moves to previous page.

This question belongs to: Computer Microsoft Office