In Excel, which function is used to convert a number to text with a specific format? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to convert a number to text with a specific format?

A. NUMBER

B. VALUE

C. TEXT

D. FORMAT

Answer: Option C

Solution (By JKSSB Mock Tests)

TEXT converts a numeric value to text with a specified number format. VALUE converts text to number.

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 'Draft' view shows the document with:

A. Minimal formatting, no page breaks

B. Full formatting and page layout

C. Web page preview

D. Outline structure

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Draft view (previously Normal view) shows the document with minimal formatting, does not show headers/footers or page breaks, and uses a continuous layout.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, the 'Design Ideas' feature suggests:

A. Transition timings

B. Slide master edits

C. Professional layouts and design options for slides

D. Animation effects

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Design Ideas (Office 365) provides automatic design suggestions.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, which option allows you to insert a chart?

A. Insert > Table

B. Insert > SmartArt

C. Insert > Shapes

D. Insert > Chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Chart command is under the Insert tab, in the Illustrations group. SmartArt is for diagrams, Shapes for shapes, Table for tables.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs