Page 53 - TP_Plus_v4_Class6
P. 53
Scratch Your Brain. Century #Critical Thinking
21 st
Skills #Communication
1. Solve the crossword using the clues.
Across:
3. Symbols that specify what 1 2
calculations to be performed
4
5. Function used to convert 3 E O S
text string into upper case
7. Numbers or text that do not
change
5 U R Y 6
8. Function used to convert
text string into lower case
9. Function used to multiply 7 C N
values in cells
8 O R
Down:
1. Cell address that is to be
used in a calculation 9 O T
2. Function used to display
current date
4. Function used to add values in cells
6. Predefined formula in Excel
2. Competency-based/Application-based questions:
a. 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?
b. Your friend Alisha was using Excel and wants to add the date and time of her daily visit to the local
church. She doesn’t know how to do this. Tell her the appropriate function she can use to do so.
Scan the QR Code and attempt the quiz.
A Better Me! Century #Initiative
21 st
Skills #Leadership & Responsibility
Your neighbour has been preparing a list of grocery items with their prices. She has been
manually calculating the total amount. Do you think you should help people whenever you see
an opportunity?
#Charts, Formulas and Functions in Excel 51

