Page 62 - TP_Prime_v2.2_Class_6
P. 62
b. Nidhi is making a spreadsheet and she wants that date and time of the sheet
should show on top every time it is opened or used, so as to take screenshots
of the time when it is opened or altered. Which function would be helpful for
this?
Activity Time 21 st #Critical Thinking
Century
Skills
Prime (Ver. 2.2)-VI Down: 3 E 2 4
Solve the crossword using the clues.
1
1. Cell address that is to be used in a calculation
2. Function used to display current date
S
O
4. Function used to add values in cells
6. Predefined formula in Excel
Across: 5 R 6
3. Symbols that specify calculations to
60 be performed
5. Function used to convert text string 7 C N
into uppercase 8 O
7. Numbers or text that do not change
8. Function used to convert text string
into lowercase 9 O
9. Function used to multiply values in cells
Find Out Century #Communication
21 st
Skills
Talk to the various departments in your school and find out how they use Excel. Discuss the
collected information with your class.
21 st
In the Lab Century #Initiative
#Productivity & Accountability
Skills
Create a similar invoice in Excel.
1. Fill-up details of five items, their quantities and
unit prices.
2. Using Product function, calculate the amount
for each item.
3. Using SUM function, calculate the total amount.
4. Using formula, calculate the GST according to the given rate.
5. Calculate Invoice amount payable.

