Which function in MS Excel calculates the number of cells within a specified range that contain any type of information, including text, errors, or numeric digits? MCQ with Answer and Explanation

Question

Which function in MS Excel calculates the number of cells within a specified range that contain any type of information, including text, errors, or numeric digits?

A. COUNTA

B. COUNT

C. COUNTIF

D. COUNTBLANK

Answer: Option A

Solution (By JKSSB Mock Tests)

The COUNTA function counts all non-empty cells within a range, regardless of whether they contain numbers, text, or errors. The COUNT function counts cells with numbers only.

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

Share Report

What is the purpose of the HLOOKUP function in Excel?

A. Performs a case-sensitive search

B. Searches horizontally for the maximum value

C. Looks up a value in the leftmost column and returns from a column to the right

D. Looks up a value in the top row of a table and returns a value from a specified row below it

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
HLOOKUP searches for a value in the first row and returns from a specified row. VLOOKUP searches in first column.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, what does the 'Watermark' feature do?

A. Adds a border around the page

B. Inserts faded text or image behind the document content

C. Marks the document as draft

D. Protects the document from editing

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Watermark is a background text/image (e.g., CONFIDENTIAL).

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to paste without formatting in MS Office?

A. Both B and C

B. Ctrl + Shift + V

C. Ctrl + Alt + V

D. Alt + E, S, V

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Alt+V opens Paste Special, then you can choose unformatted text. Alt+E,S,V also does that. Ctrl+Shift+V is not standard in Office (it works in some non-Office apps).

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs