USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following options are types of conditional formatting?
|
|
Color scales, data bars & Highlight cells rules
|
|
|
Tables
|
|
|
Pie Charts
|
|
|
Smart Art
|
|
|
None
|
Explanation:
Detailed explanation-1: -Data bars, color scales, and icon sets are conditional formats that create visual effects in your data. These conditional formats make it easier to compare the values of a range of cells at the same time.
Detailed explanation-2: -Color Scales are premade types of conditional formatting in Excel used to highlight cells in a range to indicate how large the cell values are compared to the other values in the range.
Detailed explanation-3: -There are actually four conditional formats that can be specified.
There is 1 question to complete.