In Excel, which function counts all cells that are not empty in a range? MCQ with Answer and Explanation

Question
In Excel, which function counts all cells that are not empty in a range?
A. COUNT()
B. COUNTBLANK()
C. COUNTIF()
D. COUNTA()
Answer: Option D
Solution (By JKSSB Mock Tests)
COUNTA counts non-empty cells. COUNT counts only numbers, COUNTBLANK empty cells.
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
What is the function of the 'Ctrl + Shift + End' key combination in Excel?
A. Moves the active cell to the last cell
B. Saves and closes the workbook
C. Deletes all data to the right
D. Selects all cells from the current position to the last used cell in the worksheet
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Shift+End extends the selection to the bottom-right used cell.
This question belongs to: Computer Microsoft Office
Question #2
In MS Access, the 'Indexed' property set to 'Yes (No Duplicates)' creates:
A. A foreign key
B. A unique index, preventing duplicate values
C. A primary key
D. An index allowing duplicates
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
No Duplicates enforces uniqueness.
This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, which button allows you to present online to remote viewers?
A. Share via OneDrive
B. Skype Meeting
C. Present Online (or Office Presentation Service)
D. Broadcast Slide Show
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Present Online (Office Presentation Service) lets others view in a browser. In newer versions, it's 'Present Online' or 'Share'. Broadcast Slide Show was older term.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: