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

B. NUMBER

C. FORMAT

D. VALUE

Answer: Option A

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

This question belongs to: Computer Microsoft Office

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

Question #1 Report Error

In PowerPoint, what file extension indicates a PowerPoint Show that opens directly in slideshow mode?

A. .ppsx

B. .pptm

C. .pptx

D. .potx

Correct Answer: Option A

Explanation:
.ppsx is PowerPoint Show. .pptx is presentation, .potx template, .pptm macro-enabled presentation.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, the keyboard shortcut to edit a cell comment (note) is:

A. Alt + F2

B. Ctrl + F2

C. F2

D. Shift + F2

Correct Answer: Option D

Explanation:
Shift+F2 inserts or edits comment.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In PowerPoint, to insert a sound clip, which tab do you use?

A. Design

B. Transitions

C. Insert

D. Animations

Correct Answer: Option C

Explanation:
Audio is inserted via Insert tab -> Media group.

This question belongs to: Computer Microsoft Office