Page 58 - KEC Khaitan C6 Flipbook
P. 58
LAB ACTIVITY Century #Technology Literacy
21 st
Skills
Perform the following tasks in Excel 2021.
a. Following is a list of names entered in Excel.
Create the worksheet then use different
features of Excel as instructed.
Use the sorting feature to arrange the
names in alphabetical order i.e., in
ascending order.
Then again use the sorting feature to
arrange the ages from smallest to largest.
Use the same data from the above part to
use the filter feature on.
Use the Filter option to view only the names of all the boys.
Add another filter to only see the boys whose hometown is Roorkee.
b. Create an Excel worksheet of a list of ten of your friends and their favourite movies. Also make
a column telling how many times they have watched that movie approximately. When the
data is entered, sort it alphabetically. Use the IF function to check how many of them have
watched their favourite movies more than 5 times. Then use the filter feature to only display
the names of the friends who have watched their favourite movies less than 5 times.
COding Zone COding Zone {} = COding Zone
{C ding z ne}
#Technology Literacy
21 st
Century
#Productivity & Accountability
Skills
</>
1. Write a formula using the SUM() function to calculate the total of values in cells D3 through
D10.
2. Create an IF() function formula to display “Eligible” if a value in cell E1 is greater than or equal
to 18, otherwise display “Not Eligible”.
3. Sort a dataset by two columns: first by ‘Grade’ in ascending order, and then by ‘Name’ in
alphabetical order.
FOR THE TEACHER
1. Demonstrate the concepts of sorting and filtering to the students in detail.
2. Explain the procedure of conditional formatting in detail.
56 Premium Edition-VI

