To convert text to uppercase in Excel, which function is used? MCQ with Answer and Explanation

Question

Share Report Error

To convert text to uppercase in Excel, which function is used?

A. PROPER()

B. CAPITAL()

C. UPPER()

D. LOWER()

Answer: Option C

Solution (By JKSSB Mock Tests)

UPPER makes all letters uppercase. PROPER capitalizes each word's first letter, LOWER makes all lowercase.

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

How do you insert a comment in MS Word?

A. Select text, go to Review tab -> New Comment

B. Use Insert tab -> Comment

C. Press Ctrl + M

D. Right-click and choose 'Insert Note'

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Review tab contains New Comment. Ctrl + M increases indent.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which formula will return '5' from the text 'Excel5'?

A. =LEFT("Excel5",1)

B. =LEN("Excel5")

C. =MID("Excel5",2,1)

D. =RIGHT("Excel5",1)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
RIGHT with 1 character returns '5'. LEFT returns 'E', MID could return 'x'.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, 'Broadcast Slide Show' allows:

A. Recording a video of the presentation

B. Sending slides via email

C. Remote viewers to watch the presentation in a web browser

D. Creating a podcast

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Broadcast Slide Show (now Present Online) streams the slide show.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs