USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Formatting worksheet data by changing the look of the cells that meet specified conditions
|
|
Conditional Formatting
|
|
|
Sorting
|
|
|
Filtering
|
|
|
Scrubbing
|
Explanation:
Detailed explanation-1: -Excel’s predefined conditional formatting, such as Data Bars, Color Scales and Icon Sets, are mainly purposed to format cells based on their own values. If you want to apply conditional formatting based on another cell or format an entire row based on a single cell’s value, then you will need to use formulas.
Detailed explanation-2: -Conditional formatting is used to change the appearance of cells in a range based on your specified conditions.
Detailed explanation-3: -Conditional Formatting in Excel enables you to the cells with certain color depending on the condition. It is an excellent way to visualize data in a spreadsheet. You can also create rules with your own custom formulas.
There is 1 question to complete.