Page 39 - iprime_V2.2_class8
P. 39
Now, perform the following tasks on the prepared spreadsheet:
a. 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)
b. She wants to select all the items to be purchased along with the quantity. Guide her
how she can select the same with the help of mouse.
c. 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.
d. In Cell E8, she typed “=sum(E2:E7), what is she trying to do?
e. She wants to find out, on which item has she spent the most? Suggest her a function
to do the same.
f. Help her prepare a pie chart so that she can observe on which item she has spent the
least.
Crack The Code
Critical Thinking
Solve the crossword using the clues.
Across:
1 2
3. Symbols that specify
4
calculations to be performed
3 E O S
5. Function used to convert
text string into uppercase
8. Numbers or text that do
5 R
not change
9. Function used to convert
text string into lowercase
10. Function used to multiply
values in cells 6
Down:
7
1. Cell address that is to be
8 C N
used in a calculation
9 O E
2. Function used to display
current date
4. Function used to add values
in cells 10 O
6. Predefined formula in Excel
7. Chart type in which data is displayed in the form of vertical bars
Spreadsheet—Functions and Charts 37

