Page 83 - TP_iPlus_V2.1_Class7
P. 83
#Communication
#Collaboration & Teamwork
Be Creative
Design your class timetable in Excel and enhance its presentation using features such as borders,
colors, and formatting options.
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.
#Creativity & Innovativeness
#Digital Literacy
Practical Time
Open the worksheet created in previous chapter.
• Use the Autofill feature to extend the roll numbers up to 30.
• Insert a column after column D.
• Insert a row after Row no 4.
• Give border of red color to the table.
• Change the background color of table to yellow.
• The marks should be displayed in decimal form. (2 places after decimal)
• Change the font color to Blue.
Teacher’s Corner
1. The teacher should provide an overview of how to create a custom list of student names in Excel.
2. Discuss the various functions available in Excel.
81
More on Spreadsheets

