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

Question
In Excel, the 'IF' function falls under which category?
A. Information
B. Statistical
C. Text
D. Logical
Answer: Option D
Solution (By JKSSB Mock Tests)
IF is a logical function.
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 Word, which of the following is used to create a mail merge document?
A. Review tab
B. Insert tab
C. References tab
D. Mailings tab
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Mail Merge features are located under the Mailings tab in Word.
This question belongs to: Computer Microsoft Office
Question #2
In MS Word, what is the default line spacing configuration applied to a brand-new blank document based on the standard 'Normal.dotm' template in modern versions?
A. 1.15 lines
B. 1.0 lines
C. 1.5 lines
D. 2.0 lines
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Modern versions of MS Word apply a default paragraph line spacing configuration of 1.15 lines, along with an 8-point spacing buffer after paragraphs.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, a unique key that prevents duplicate entries and uniquely distinguishes each record or row in a table database is known as the:
A. Composite Key
B. Candidate Key
C. Foreign Key
D. Primary Key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Primary Key is a field or combination of fields that uniquely identifies each record in an Access table and cannot contain null or duplicate values.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Cyber Security 269 Computer Abbreviations 369 Operating Systems 510 Computer Software 347 CPU (Central Processing Unit) 327
Explore Subjects
Accountancy and Statistics 3179 Science 4430 Computer 5279 History GK 3374 Current Affairs 575
Practice Mix
The receipt ______ they gave is fake.
Identify the error: 'He is the most young of the team.'
Which view in PowerPoint displays thumbnails of all slides for easy rearrangement?
A sum of money at compound interest doubles in 5 years. In how many years will it become 4 times?
Which of the following is an example of educational software?