Page 57 - 2620_Birla Open Mind C-6

E. Brain Boost. 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 returns the sum of values
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.

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 55