Page 29 - C_GPT _V4 _class_7
P. 29
Color Scales: Select this option to add color schemes to all selected cells, slowly varying from top
to bottom items. Hovering the mouse pointer over this option opens a sub-list that displays various
colour variations that can be applied to cells.
Icon Sets: This option is selected when you want to add icon sets to show which cells are acceptable,
which are moderate, and which need attention. When you hover the mouse pointer over this option,
a sub-list opens, displaying the different types of icon sets that you can add.
You can also define your own rule for highlighting cells by selecting the New Rule option from the
Conditional Formatting drop-down list. The conditional formatting features applied to a data range
can be cleared by selecting the Clear Rules option from the Conditional Formatting drop-down list.
Quick Quiz
1. What does "Sorting Data" in a spreadsheet means?
a. Organising data alphabetically or numerically based on certain criteria.
b. Changing the formatting of data cells.
2. What is the purpose of "Filtering Data" in a spreadsheet?
a. Arranging data in a specific order.
b. Displaying only the data that meets specific criteria.
3. Which feature is most helpful for identifying values in a column of numbers based on criteria like greater
than or less than?
a. Sorting Data b. Conditional Formatting
Recap
Sorting data means to organise the data in ascending or descending order.
Custom sorting is used to apply sorting to more than one column in a selected range on different
criteria.
The filters can be easily applied and removed according to the user’s requirements.
Conditional formatting can be applied on the basis of different criteria.
Assess Yourself
Choose the correct option.
1. Riyan has to arrange the roll numbers of all the students in a sequential order. Which of the following
feature of Excel will help him?
a. Sorting b. Filtering
c. Conditional Formatting d. Not possible in Excel
Advanced Features of Excel 27

