Page 51 - Plus V4 with Adobe class 6
P. 51
2. Competency-based/Application-based questions:
a. Siya has made a spreadsheet of the marks obtained in different subjects by the students in her
class. She has made some changes to the marks of some students. Now she wants the total number
of marks for those students to be automatically updated. Which function should she use to do so?
b. Your friend Alisha was using Excel and wants to add the date and time of her daily visit to the local
church. She doesn’t know how to do this. Tell her the appropriate function she can use to do so.
Scan the QR Code and attempt the quiz.
A Better Me! Century #Initiative
21 st
Skills #Leadership & Responsibility
Your neighbour has been preparing a list of grocery items with their prices. She has been manually
calculating the total amount. Do you think you should be helping people whenever you see an
opportunity?
21 st
DIY In The Lab Century #Technology Literacy
#Productivity & Accountability
Skills
To
Subject Using Formulas
1. In Excel, enter the data for your daily expenses. Now, create a chart based on the above data.
2. Create a similar invoice in Excel.
Fill-up details of five items, their quantities and unit prices.
Using Product function, calculate the amount for each item.
Using SUM function, calculate the total amount.
Using formula, calculate the GST according to the given rate.
Calculate Invoice amount payable.
For The Teacher
Do a walk-through of all the Excel topics in detail listed in the chapter on the computer screen.
Explain to the children the use of Excel at homes, shops, business, industries etc.
#Charts, Formulas and Functions in Excel 49

