Which of the following functions in MS Excel checks whether a cell value is text and returns TRUE or FALSE? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following functions in MS Excel checks whether a cell value is text and returns TRUE or FALSE?

A. ISTEXT

B. ISNUMBER

C. ISBLANK

D. CHECKTEXT

Answer: Option A

Solution (By JKSSB Mock Tests)

ISTEXT is a built-in logical informational function that returns TRUE if the evaluated field holds alphanumeric text string structures.

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 Excel, the formula =$A1 is an example of:

A. Circular reference

B. Relative reference

C. Mixed reference (column absolute, row relative)

D. Absolute reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
$A locks column A, row remains relative.

This question belongs to: Computer Microsoft Office

Question #2

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

A. FV

B. PV

C. PMT

D. NPER

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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

This question belongs to: Computer Microsoft Office

Question #3

Which shortcut key opens the 'Find' dialog box in MS Word?

A. Ctrl + G

B. Ctrl + F

C. Ctrl + H

D. F3

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + F opens Find. Ctrl + H opens Replace, Ctrl + G opens Go To, F3 repeats last find.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs