USING MICROSOFT EXCEL
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: -One reason why you may not be able to format cells is because the cells are locked. 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.
Detailed explanation-2: -Answer: Conditional formatting is automatically updated if you change data in the worksheet.
Detailed explanation-3: -Click the dialog box launcher in Home → Font, Home → Alignment, or Home → Number. A small downword-pointing arrow icon will be displayed to the right. In the Excel Ribbon, these arrow marks are known as dialog box launcher. Choose Format Cells from the shortcut menu after you Right-click the selected cell or range.