Page 39 - ThinkGPT_V2.1_C6_Flipbook
P. 39
7. Function used to convert text string into uppercase
1
P 2 F T N
3
O L
M 4 T O Y
5 C L E E
7
6 S U
P
R
Critical Thinking
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 func-
tion 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.
Technology Literacy
Information Literacy
byte TASK
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 payable.
Leadership & Responsibility
TECH VALUE Initiative
Always check the formulas after entering it.
Formulas and Functions in Excel 37

