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

Question

Share Report Error

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

A. Low

B. Medium

C. High

D. Error

Answer: Option B

Solution (By JKSSB Mock Tests)

A1=15, first condition >10 true, then nested IF: A1>20 false, so "Medium".

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 Access, to set a field as the primary key, use:

A. Table Design view -> select field -> Primary Key button

B. Database Tools -> Relationships

C. Create tab -> Primary Key

D. Datasheet view -> right-click -> Primary Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Primary Key is set in Design view.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, which tab contains the 'Record' option?

A. Slide Show

B. Design

C. Insert

D. Animations

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Record Slide Show is on Slide Show tab.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, what occurs when you click the 'B' key on the keyboard during an active, full-screen slide show presentation?

A. Launches the drawing pen annotation tool

B. Moves the presentation instantly to the previous slide layout

C. Whites out the screen display completely

D. Blacks out the screen display completely

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Pressing the 'B' key during a live presentation blacks out the screen. Pressing the 'W' key turns the screen completely white. Pressing either key again returns to the slide show.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs