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

Question Report Error

In Excel, which function counts all cells that are not empty in a range?

A. COUNTBLANK()

B. COUNT()

C. COUNTIF()

D. COUNTA()

Answer: Option D

Solution (By JKExamLibrary)

COUNTA counts non-empty cells. COUNT counts only numbers, COUNTBLANK empty cells.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

In MS Access, which of the following is NOT an action query?

A. Select query

B. Append query

C. Delete query

D. Update query

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Select queries retrieve data; they do not modify data. Action queries modify data.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Access, the 'Form Footer' section appears at:

A. Bottom of the screen

B. Bottom of the form

C. Bottom of each page

D. Bottom of the report

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Form Footer is at the bottom of the form.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

Which action query type in MS Access copies selected data rows from one or more existing source tables and creates a brand-new table with those records?

A. Make-Table Query

B. Crosstab Query

C. Append Query

D. Update Query

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
A Make-Table Query extracts specific records from existing source fields and uses them to create a brand-new table in the database file.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs