Page 39 - Digicode_AI_class_6
P. 39
Experiential Learning
Competency-based/Application-based questions Information Literacy
1. 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?
2. Your friend Alisha is using Excel and wants to add the current date and time in it. She doesn't know
how to do this. Tell her the appropriate function she can use to do so.
Experiential Learning
byte TASK Information Literacy
Create a similar invoice in Excel.
Fill-up details of five items, their quantities and unit prices.
Using the Product function, calculate the amount for each item.
Using the SUM function, calculate the total amount.
Using a formula, calculate the GST according to the given rate.
Calculate Invoice amount payable.
Leadership & Responsibility
TECH VALUE Initiative
Always check the formulas after entering it.
Formulas and Functions in Excel 37

