DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Conditional formatting
|
|
|
Data bars
|
|
|
Sparklines
|
|
|
Charts
|
Detailed explanation-1: -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-2: -Detailed Solution. The correct answer is Conditional formatting. Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value.
Detailed explanation-3: -Answer: Conditional formatting allows you to automatically apply formatting-such as colors, icons, and data bars-to one or more cells based on the cell value.
Detailed explanation-4: -Select the cells with the Excel Style. Right-click the applied style in Home > Cell Styles. Select Modify > Format to change what you want.