Page 52 - Plus_V2.2_C6_Flipbook
P. 52
5. Function used to convert text 1 2
string into uppercase 4
3 E O S
7. Numbers or text that do not
change
8. Function used to convert text
string into lowercase 5 R 6
9. Function used to multiply
values in cells
7 C N
8 O
9 O
Let's exPLore
Talk to the various departments in your school and find out how to use Communication
Excel. Discuss with your class.
teCh PraCtiCe Subject Enrichment
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.
50 Premium Edition-VI

