Conditional Formatting
10 Questions
| Attempts: 1754
Questions and Answers
- 1.When we want to show the Value in bar Chart which option of conditional formatting is used ?
- A.
Data Bar
- B.
Color Scales
- C.
Icons sets
- 2.A conditional format can make negative numbers red and positive numbers black.
- A.
True
- B.
False
- 3.In which Tab of Excel Ribbon Conditional formatting can be found ?
- A.
Home
- B.
Insert
- C.
Page layout
- D.
Formula
- 4.
Which type of conditional formatting is shown in this picture ?- A.
Highlight cell rules
- B.
Color Scale
- C.
Data bars
- 5.Which option is used for Creating Rules in Conditional formatting on Excel ?
- A.
New Rules
- B.
Manage Rules
- C.
Clear Rules
- 6.In icon sets which Color shows the positive Result in Conditional Formatting on Excel ?
- A.
Red
- B.
Yellow
- C.
Green
- 7.
What is the name of this picture ?
- A.
Data bars
- B.
Color Scale
- C.
Icons Sets
- 8.How many type of conditions are avalible in conditional formatting on Excel ?
- A.
Eight
- B.
Five
- C.
Six
- 9.
In which type of Conditional formatting options you will find in this dialog box ?
- A.
Highlight cell rules
- B.
Top/Bottom Rules
- C.
Manage Rules
- 10.
Which conditional formatting is applied on the data ?
- A.
Color Scale
- B.
Data bars
- C.
Icon Sets
Related Topics
Recent Quizzes
Featured Quizzes
Back to top