Page 79 - iPrime_V2.2_class7
P. 79
2. Analyse the given table of Excel.
a. In the given table, you have to merge cell B1 and C1. How will you do so?
b. You have to calculate the total marks of all the students. Which formula will you use for
each student and in which cell will you type the formulas?
Crack The Code
Critical Thinking
Locate six features of Excel in the grid.
W R A P T E X T T F J A
R V G E U R E T I O O U
A H T G M F D R M R C T
M N X C O L U M N M E O
T B F R F W S W J U M F
M E R G I N G C E L L I
X O U M N L H E K A F L
T C E L L N I I B S I L
SDG Activity
Use Excel to create a budget tracker where you input your weekly savings
and expenses. Apply sorting to organise your expenses by amount, and
use conditional formatting to highlight any expenses that exceed your
budget limits. Analyse the results to see how managing your finances can
lead to better economic stability.
More on Spreadsheets 77

