USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Direct formatting will NOT change if you change themes. Theme fonts, font colors, and cell colors appear at the top of the selection list when you click the appropriate button. To center a label across several columns, use the Merge & Center button.
Detailed explanation-2: -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-3: -Check the rule you created. Double-check the rule in the Conditional Formatting Rules Manager. Sometimes, for no reason at all, Microsoft Excel distorts the rule you have just created. So, if the rule is not working, go to Conditional Formatting > Manage Rules and check both the formula and the range it applies to.
Detailed explanation-4: -When you modify the formatting of a style, what happens to cells to which the style was already applied? They automatically reflect the new formatting.
Detailed explanation-5: -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.