In Excel, the 'IF' function falls under which category? MCQ with Answer and Explanation

In Excel, the 'IF' function falls under which category?
A. Statistical
B. Text
C. Information
D. Logical
Answer: Option D
Solution (By JKSSB Mock Tests)
IF is a logical function.

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 create a new presentation in MS PowerPoint?
A. Ctrl + O
B. Ctrl + N
C. Ctrl + M
D. Ctrl + S

Correct Answer: Option B


Explanation:
Ctrl + N creates a new blank presentation. Ctrl + M inserts a new slide. Ctrl + O opens a presentation. Ctrl + S saves.

This question belongs to: Computer Microsoft Office
Question #2
What is the native file extension format for database files saved in modern editions of Microsoft Access?
A. .accde
B. .mdb
C. .dbf
D. .accdb

Correct Answer: Option D


Explanation:
.accdb is the standard native database file extension for MS Access files since the 2007 version, replacing the legacy .mdb format.

This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, 'Slide Master' is used to:
A. Apply transitions
B. Insert media
C. Create a new slide
D. Make universal style changes to all slides

Correct Answer: Option D


Explanation:
Slide Master controls the look of all slides.

This question belongs to: Computer Microsoft Office