Page 50 - TP_Pluse_V2.2_Class_6
P. 50
b. Anjana has prepared stationery list to be purchased for her daughter in Excel as
shown below:
(i) In E2, she is writing the formula for calculating the amount spent on Notebooks, as C2 * D2,
but she is not getting any answer. Why? (Help her write the correct input)
(ii) After rectifying the formula in cell E2 she wants to calculate the Amount for all remaining
items, suggest her the simplest way to do the same.
(iii) In Cell E8, she typed “=sum(E2:E7), what is she trying to do?
(iv) She wants to find out, on which item has she spent the most? Suggest her a function to do
the same.
teCh Zone
Let's soLve 21 st #Productivity & Accountability
Century #Critical Thinking
Solve the crossword using the clues. Skills
Down:
1. Cell address that is to be 1 2
used in a calculation 4
3 E O S
2. Function used to display
current date
4. Function used to add
values in cells 5 R 6
6. Predefined formula in
Excel
7 C N
Across:
8 O
3. Symbols that specify
calculations to be
performed
9 O
5. Function used to convert
text string into uppercase
7. Number or text that does not change
8. Function used to convert text string into lowercase
9. Function used to multiply values in cells
48 Plus (Ver. 2.2)-VI

