Page 29 - Plus V4 with Adobe class 7
P. 29
Scan the QR code and learn more about Excel.
21 st
DIY In The Lab Century #Technology Literacy
Skills
To
Subject Excel Skills
Go to your computer lab and do the following:
1. Open Excel in your computer. Create a Blank Workbook and make a list of your 10 friends.
a. Insert columns for the distance of their home from school, distance of post office from their home, etc.
b. Now click on Sort & Filter command and sort the data in an order.
c. Click on Conditional Formatting command to highlight the cells which have distance less than 2.5 km
in any cell.
2. Create an Excel sheet and make a list of 15 teachers and subjects taught by them.
a. Click on Sort & Filter command from the Editing group under Home tab and apply Filters on the
Subject Taught field.
b. Sort the records according to Teacher Name field in descending order.
C. Take printouts of various filter options of subjects and their result.
For The Teacher
Demonstrate to the students the concepts discussed in the chapter.
Make the students understand differences between filtering and sorting features.
#Advanced Features of Excel 27

