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. ISNUMBER

B. ISBLANK

C. ISTEXT

D. CHECKTEXT

Answer: Option C

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 MS Word, the 'Print Layout' view shows:

A. Only text without formatting

B. Outline headings

C. Document as it will appear when printed, with margins and page breaks

D. Thumbnails

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Print Layout is WYSIWYG view.

This question belongs to: Computer Microsoft Office

Question #2

Which of the following is the shortcut to save the current workbook in Excel?

A. Alt + F4

B. Ctrl + Shift + S

C. Ctrl + S

D. F12

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + S saves. F12 opens Save As. Alt + F4 closes Excel.

This question belongs to: Computer Microsoft Office

Question #3

To launch the 'Slide Show' from the beginning in PowerPoint, press:

A. Ctrl + F5

B. F5

C. Alt + F5

D. Shift + F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
F5 from beginning.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs