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

Question
In Excel, which function is used to convert a number to text with a specific format?
A. NUMBER
B. TEXT
C. VALUE
D. FORMAT
Answer: Option B
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 PowerPoint, what is the purpose of Slide Master?
A. Inserts animations on an object
B. Controls the overall design and layout of all slides
C. Adds transitions between slides
D. Runs a spelling check for the entire presentation
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Slide Master defines global formatting, placeholders, and layouts that apply to the entire presentation.
This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which of the following is used to create a list of headings and their page numbers?
A. Table of Contents
B. Table of Figures
C. Bibliography
D. Index
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Contents generates a list of headings with their corresponding page numbers based on heading styles. Index lists keywords, Table of Figures lists captions, Bibliography lists sources.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, the error '#REF!' indicates:
A. Formula name not recognized
B. Wrong data type
C. Invalid cell reference (cell may have been deleted)
D. Division by zero
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
#REF! means a reference is invalid. #DIV/0! division by zero, #NAME? unrecognized text, #VALUE! wrong type.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: