Page 39 - Computer Genius Class 06
P. 39
Experiential Learning
Competency-based/Application-based questions
Information Literacy
1. iya has made a spreadsheet o the mar s o tained in di erent su ects y the students in her
class. he has made some changes to the mar s o some students. o she ants the total num er
o mar s or those students to e automatically updated. hich unction should she use to do so
2. our riend lisha is using cel and ants to add the current date and time in it. he doesn t no
ho to do this. Tell her the appropriate unction she can use to do so.
Experiential Learning
LAB Activity Information Literacy
reate a similar in oice in cel.
Fill up details o i e items their uantities and unit prices.
sing the roduct unction calculate the amount or each item.
sing the unction calculate the total amount.
sing a ormula calculate the T according to the gi en rate.
alculate n oice amount paya le.
Leadership & Responsibility
TECH VALUE Initiative
l ays chec the ormulas a ter entering it.
Formulas and Functions in Excel 37

