DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
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: -To check if the cells are locked, go to the Review tab and click on Protect Sheet. If there is a checkmark next to Locked, then the cells are locked and you will not be able to format them. To unlock the cells, simply uncheck the Locked option and then click OK. You should now be able to format the cells.
Detailed explanation-3: -Text formatting in Excel works in the same way as it does in other Microsoft tools such as Word and PowerPoint. This includes changing Font, Font Size, Font Color, Font Attribute (Such as making text, Bold, Italic, Underlined, etc.), text alignment, background color change, etc.
Detailed explanation-4: -Click File > Options. In the Excel Options box, click Proofing > AutoCorrect Options. On the AutoFormat As You Type tab, check the boxes for the auto formatting you want to use.