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

In Excel, which function is used to convert a number to text with a specific format?
A. FORMAT
B. VALUE
C. NUMBER
D. TEXT
Answer: Option D
Solution (By JKSSB Mock Tests)
TEXT converts a numeric value to text with a specified number format. VALUE converts text to number.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
What is the shortcut key to open the 'Page Setup' dialog in MS Excel?
A. Alt + P, S, P
B. Ctrl + P
C. F5
D. Ctrl + Shift + P

Correct Answer: Option A


Explanation:
Alt+P,S,P opens Page Setup in Excel. Ctrl+Shift+P is not standard. Ctrl+P is Print. F5 is Go To.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, the VLOOKUP function's fourth argument (range_lookup) set to FALSE indicates:
A. Exact match
B. Approximate match
C. Closest match
D. Descending order

Correct Answer: Option A


Explanation:
FALSE requires an exact match. TRUE or omitted allows approximate match.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the automated reference assistant feature that scans across an entire document to build a hyperlinked directory map of heading milestones is called:
A. Smart Lookup framework
B. Bookmark registry
C. Cross-reference guide
D. Navigation Pane

Correct Answer: Option D


Explanation:
The Navigation Pane indexes document headings (formatted with Heading styles), creating an interactive, click-to-jump directory outline map on the left side of the screen.

This question belongs to: Computer Microsoft Office