Page 38 - Trackpad_ipro 4.1_Class8
P. 38
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 #Experiential Learning
#Coding & Computational Thinking
Solve the crossword using the clues.
Across:
1 2
3. Symbols that specify
4
calculations to be
3 E O S
performed
5. Function used to convert
text string into uppercase
5 R
8. Numbers or text that do
not change
9. Function used to convert
text string into lowercase
6
10. Function used to multiply
values in cells
7
Down:
8 C N
1. Cell address that is to be
9 O E
used in a calculation
2. Function used to display
current date
10 O
4. Function used to add values
in cells
6. Predefined formula in Excel
7. Chart type in which data is displayed in the form of vertical bars
36 iPro (Ver. 4.1)-VIII

