What will be the result of the MS Excel formula =COUNTA(A1:A4) if cell A1=10, A2="Text", A3=EMPTY, and A4=0? MCQ with Answer and Explanation

Question

Share Report Error

What will be the result of the MS Excel formula =COUNTA(A1:A4) if cell A1=10, A2="Text", A3=EMPTY, and A4=0?

A. 2

B. 4

C. 3

D. 1

Answer: Option C

Solution (By JKSSB Mock Tests)

The COUNTA function counts any non-empty cells within a range. Out of four cells, three are occupied (10, "Text", 0) and one is blank, yielding 3.

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, what does the shortcut Ctrl + ] do?

A. Increases font size by 1 point

B. Toggles bold

C. Increases indent

D. Applies superscript

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + ] increases font size by 1 point; Ctrl + [ decreases.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what is the default size of a Short Text field?

A. 255 characters

B. 64 characters

C. 50 characters

D. 100 characters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Short Text can hold up to 255 characters; default field size is 255 but may be set smaller.

This question belongs to: Computer Microsoft Office

Question #3

In Access, which of the following is a valid query that updates data?

A. Update Query

B. All of the above

C. Delete Query

D. Append Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Update, Append, and Delete are all action queries that modify data.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs