FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Why do we need to do formatting in Excel? Choose the correct answer.
A
The formatting displays the worksheets in an attractive and more legible outlook.
B
The formatting feature automatically corrects all the mistakes in an excel worksheet.
C
The formatting is used to delete all the content of an Excel worksheet.
D
The formatting is used to save all the contents of the worksheet.
Explanation: 

Detailed explanation-1: -Formatting text or numbers can make them appear more visible especially when you have a large worksheet. Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects.

Detailed explanation-2: -It is used to display the worksheets attractive and legible manner. Explanation :-Formatting is the very important feature in Excel which is used to show the worksheets in an attractive and beautiful manner.

Detailed explanation-3: -Answer: With formatting, we can make some data to be bolder, rotated or in different color. So, basically formatting provides worksheet a neater and more legible outlook.

Detailed explanation-4: -Conditional formatting makes it easy to highlight certain values or make particular cells easy to identify. This changes the appearance of a cell range based on a condition (or criteria). You can use conditional formatting to highlight cells that contain values which meet a certain condition.

There is 1 question to complete.