In Excel, what does the formula =SUMIF(A1:A10, ">5") do? MCQ with Answer and Explanation

Question
In Excel, what does the formula =SUMIF(A1:A10, ">5") do?
A. Counts cells greater than 5
B. Sums values in A1:A10 that are greater than 5
C. Sums all values and adds 5
D. Returns error
Answer: Option B
Solution (By JKSSB Mock Tests)
SUMIF with criteria ">5" sums cells >5 in the range.
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 specific line spacing property option applies a rigid spacing dimension that Excel or Word cannot adjust automatically?
A. At least spacing metric
B. Exactly
C. Multiple line layouts
D. Double line spacing preset
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The 'Exactly' line spacing property fixes the line spacing to a specific point size that Word will not adjust automatically, even if font sizes within the line change.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function is used to calculate the average of a set of numbers but ignores zero values?
A. AVERAGEIF
B. AVERAGEA
C. AVERAGE
D. MEDIAN
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AVERAGEIF can exclude zero by using criteria 0. AVERAGE includes zeros, AVERAGEA includes logicals, MEDIAN is middle value.
This question belongs to: Computer Microsoft Office
Question #3
What type of special motion visual effect occurs when transitioning from one slide display to another during a slide show in MS PowerPoint?
A. Transition
B. Entrance Effect
C. Animation
D. Morphing
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Transitions control the cinematic visual effects that execute during movement between slides, while Animations control motions inside a single slide.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Memory and Storage Devices 438 Computer Networking 325 Computer Abbreviations 369 Database Management System (DBMS) 278 CPU (Central Processing Unit) 327
Explore Subjects
Maths 5575 Geography GK 6121 Economy GK 2220 History GK 3374 Accountancy and Statistics 3179
Practice Mix
The 'Deccani' style of painting developed in:
He ___ be very upset; he's not talking to anyone.
Which cloud type appears as thin, feathery streaks?
Two numbers are in the ratio 4:8 and their sum is 512. Find the numbers.
By the time you return, I ________ the house.