In Excel, which function converts a value to text with a specified number format? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function converts a value to text with a specified number format?

A. TEXT()

B. DOLLAR()

C. FORMAT()

D. VALUE()

Answer: Option A

Solution (By JKSSB Mock Tests)

TEXT(value, format_text) converts to text.

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

What is the maximum number of columns in a table in MS Word?

A. 10

B. No limit

C. 256

D. 63

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Word table can have up to 63 columns.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type is best for a field that stores employee ID numbers that are not used in calculations?

A. Short Text

B. AutoNumber

C. Number

D. Currency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
If not used in calculations, Short Text is suitable for alphanumeric IDs.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, to save a presentation as a template, choose:

A. .pptx

B. .pptm

C. .ppsx

D. .potx

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Template extension .potx.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs