DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Top 10%
|
|
|
Bottom 10 items
|
|
|
Duplicate values
|
|
|
Color scales
|
|
|
None
|
Detailed explanation-1: -Formulas to compare values (numbers and text) In a similar fashion, you can create a conditional formatting rule to compare values of two cells. For example: =$A2<$B2-format cells or rows if a value in column A is less than the corresponding value in column B.
Detailed explanation-2: -More formatting options to show highest and lowest values On the Home tab, click Conditional Formatting > New Rule. In the New Formatting Rule dialog box, choose Format only top or bottom ranked values. In the drop-down list, select Top or Bottom, and type how many values to highlight in the box next to it.
Detailed explanation-3: -Conditional formatting presets They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.