USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Highlight Cells rules
|
|
|
Color Scales
|
|
|
Data Bars
|
|
|
Icon Sets
|
Detailed explanation-1: -The correct answer is Data Bars. We can use conditional formatting Data Bars to represent data graphically inside a cell. The longest bar represents the highest value and shorter bars represent smaller values. Navigation: select the cells > click conditional formatting > data bars and choose the bar type.
Detailed explanation-2: -Select the range that needs data bars. On the Home tab, in the Styles group, select Data Bars from the Conditional Formatting tool. From there you can select data bars of different colors and opacities (see Figure 3.19).
Detailed explanation-3: -Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, under Format, click Conditional Formatting. Point to Data Bars, and then click a gradient fill or a solid fill.
Detailed explanation-4: -As you already know, the validation criteria are defined on the Settings tab of the Data Validation dialog box (Data tab > Data Validation).