Page 32 - Trackpad_V4.0_c7_Flpbook
P. 32
SDG Activity
Use Excel to create a budget tracker where you input your weekly savings and expenses.
Apply sorting to organise your expenses by amount, and use conditional formatting to
highlight any expenses that exceed your budget limits. Analyse the results to see how
managing your finances can lead to better economic stability.
Explore in the Lab 21 st Century #Technology Literacy
Skills
To
Subject Data in an Excel sheet
Enter the following data in an Excel sheet and perform the actions given below:
Name Location Product Purchased Purchase Amount Loyalty Program Status
Sameer Delhi Electronics 500 Member
Emily Mumbai Clothing 150 Non-Member
Neha Kolkata Electronics 700 Member
Sarah Kerala Electronics 450 Non-Member
Chirag Delhi Books 80 Member
Divya Lucknow Electronics 600 Non-Member
Amit Mumbai Electronics 800 Member
Komal Miami Clothing 120 Non-Member
Sort the data based on 'Purchase Amount' in descending order.
Filter the data to show only customers who are members of the loyalty program.
Apply conditional formatting to highlight purchases made in Mumbai.
For The Teacher
Demonstrate to the students the concepts of Excel discussed in the chapter.
Make the students understand differences between filtering and sorting features.
Premium Edition-VII
30

