In Excel, which function converts a text string to proper case (first letter capitalized)? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function converts a text string to proper case (first letter capitalized)?

A. LOWER()

B. PROPER()

C. SENTENCE()

D. UPPER()

Answer: Option B

Solution (By JKSSB Mock Tests)

PROPER capitalizes the first letter of each word.

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

Share Report

In Excel, the function to return the position of a substring within a string is:

A. SEARCH()

B. Both A and B

C. FIND()

D. MATCH()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both FIND and SEARCH return the starting position of a substring. FIND is case-sensitive, SEARCH is not. MATCH is for ranges.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

To select the entire row in Excel, press:

A. Shift + Spacebar

B. Ctrl + Shift + Spacebar

C. Ctrl + Spacebar

D. Alt + Spacebar

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Shift+Spacebar selects the entire row. Ctrl+Spacebar selects entire column.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which chart type shows the proportion of each data series relative to the total using nested rings?

A. Treemap

B. Doughnut

C. Sunburst

D. Pie

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Doughnut chart is like a pie with a hole, can show multiple series. Sunburst shows hierarchical rings.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs