USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
New Rule
|
|
|
Manage or Clear Rules
|
|
|
Data Bars
|
|
|
Color Scales
|
|
|
None
|
Detailed explanation-1: -To remove conditional formatting from specific cells, select the cells, click the Quick Analysis button, and click Clear Format. To remove all conditional formatting from the entire worksheet, click the Conditional Formatting button on the HOME tab, point to Clear Rules, and click Clear Rules from Entire Sheet.
Detailed explanation-2: -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.
Detailed explanation-3: -On the Home tab, in the Font group, click Clear All Formatting. On the Message tab, in the Basic Text group, click Clear All Formatting.
Detailed explanation-4: -There are a few ways to remove conditional formatting but keep the effects. One way is to use the Clear Rules feature. To do this, select the cells that have the conditional formatting that you want to remove. Then, go to Home > Styles > Clear Rules.