DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Conditional Formatting
|
|
|
Sorting
|
|
|
Filtering
|
|
|
Scrubbing
|
Detailed explanation-1: -Conditional formatting is used to change the appearance of cells in a range based on your specified conditions. The conditions are rules based on specified numerical values or matching text. Changing the appearance of cells can visually highlight interesting data points for analysis.
Detailed explanation-2: -Conditional formatting is a feature of many spreadsheet applications that allows you to apply special formatting to cells that meet certain criteria. It is most often used to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.
Detailed explanation-3: -Conditional Formatting is one of the most simple yet powerful features in Excel Spreadsheets. As the name suggests, you can use conditional formatting in Excel when you want to highlight cells that meet a specified condition. It gives you the ability to quickly add a visual analysis layer over your data set.