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

Question
To convert text to uppercase in Excel, which function is used?
A. CAPITAL()
B. PROPER()
C. LOWER()
D. UPPER()
Answer: Option D
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
What is the maximum number of columns that can be inserted in a single Excel worksheet (version 2016 and later)?
A. 256
B. 1048576
C. 65536
D. 16384
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Excel 2007 and later versions support 16,384 columns (up to column XFD) and 1,048,576 rows. Therefore, the correct maximum columns is 16384.
This question belongs to: Computer Microsoft Office
Question #2
Which of the following features in MS PowerPoint lets you bundle multiple distinct design elements (shapes, images, text) into a single object container?
A. Merge Shapes
B. Selection Canvas
C. SmartArt Layout
D. Group
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Grouping (Ctrl + G) bundles multiple selected design assets together so they can be moved, scaled, or formatted as a single unit.
This question belongs to: Computer Microsoft Office
Question #3
Which features in MS Word are used to divide a single document into separate formatting zones for columns, page numbering styles, or custom margins?
A. Section Breaks
B. Style Sets
C. Paragraph Indents
D. Page Breaks
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Section breaks allow you to isolate and apply different layouts, headers, footers, and structural configurations within the same document.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?