Page 28 - Trackpad_V4.0_c7_Flpbook
P. 28
Art Integration Learning
Lab Activity
List the one-day matches that have taken place over the past two years. Consider any five countries that
participated, including India. Make separate columns for the country name, runs, wins, and losses. Calculate the
total number of matches and total number of runs. Find how many matches India won and how many it lost.
If Excel was a magical library, how would you sort books and filter books you had read?
CONDITIONAL FORMATTING
Suppose, you do not want to hide any rows but still want to highlight all the cells that satisfy a condition,
for example, greater than 80. This type of formatting is known as Conditional Formatting in Excel. To
apply conditional formatting to a series of data, follow these steps:
1 Select the data and click on the Select the desired conditional 2
Conditional Formatting button. formatting.
Now select the desired
option to apply on the 3
selected cell range.
The conditional formatting command has the following options:
Highlight Cells Rules: Select this option to highlight all the cells that meet a specific condition. When
you hover the mouse pointer over this option, it opens a sub-list showing criteria like Greater Than,
Less Than, Equal To, Between, etc.
Top/Bottom Rules: Select this option to highlight the top or bottom number of items in a data
series. When you hover the mouse pointer over this option, it opens a sub-list showing criteria like
Top 10 Items, Top 10%, Bottom 10 Items, Bottom 10%, etc.
Data Bars: Select this option to add data bars to the cells having numeric data. Hovering the mouse
pointer over this option opens a sub-list that displays various types and colours of bars that you can
add to the cells.
Premium Edition-VII
26

