What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20? MCQ with Answer and Explanation

Question
What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20?
A. 3
B. 1
C. 4
D. 2
Answer: Option D
Solution (By JKSSB Mock Tests)
The formula filters for numbers strictly greater than 10. Out of the given values, 15 and 20 satisfy the condition, so the function returns 2.
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
Which of the following is the default view in MS Word 2016?
A. Web Layout
B. Draft
C. Read Mode
D. Print Layout
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Print Layout is the default view.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function returns the number of cells in a range that meet multiple criteria?
A. COUNTIF()
B. COUNTIFS()
C. DCOUNT()
D. SUMIFS()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COUNTIFS handles multiple criteria.
This question belongs to: Computer Microsoft Office
Question #3
Which layout object in MS PowerPoint controls the global background colors, slide layout footprints, default paragraph sizes, and alignment rules for standard text blocks?
A. Slide Master
B. Design Ribbon
C. Handout Master
D. Notes Master
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Slide Master is the foundational blueprint that controls style formatting rules and structural layouts for every slide inside a presentation.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Abbreviations 369 Computer Hardware 430 Cyber Security 269 Memory and Storage Devices 438 Internet and Web Technologies 461
Explore Subjects
Reasoning 1111 Accountancy and Statistics 3179 Maths 5575 Static General Knowledge 6362 Science 4430
Practice Mix
Which type of soil is generally found in regions receiving rainfall greater than 200 cm annually?
That which cannot be touched
Which of the following states receives the highest rainfall during the Northeast Monsoon?
S1: Direct taxes are levied on income and wealth. S2: Direct taxes can be shifted to others. Which statement(s) is/are correct?
She identifies ___ the character.