Which function in MS Excel counts the number of cells in a specified range that contain numerical data only? MCQ with Answer and Explanation

Question

Share Report Error

Which function in MS Excel counts the number of cells in a specified range that contain numerical data only?

A. COUNT

B. COUNTA

C. COUNTBLANK

D. COUNTIF

Answer: Option A

Solution (By JKSSB Mock Tests)

The COUNT function counts cells containing numbers only. COUNTA counts all non-empty cells regardless of data type, and COUNTBLANK counts 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

Share Report

In PowerPoint, which key can be used to zoom in on a slide during editing?

A. Ctrl + Mouse wheel up

B. Alt + Plus

C. Both A and B

D. Ctrl + Plus (+)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Plus or Ctrl+Scroll up zooms in.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to calculate the present value of an annuity?

A. PV

B. FV

C. NPER

D. PMT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
PV calculates present value, FV future value, PMT payment, NPER number of periods.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which action query type in MS Access allows a database administrator to permanently remove a specific group of records from an underlying table based on criteria filters?

A. Delete Query

B. Update Query

C. Append Query

D. Make-Table Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Delete Query targets records that match specified criteria filters and permanently deletes those rows from the database table.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs