Page 180 - IT 402 v2.0 class 10
P. 180
Sales in February Month
Sales in March Month
new worksheet is inserted and renamed as uarter Sales to store the otal Sales of each item.
otal Sales of individual items must be automatically calculated and stored in uarter Sales worksheet
through cell referencing using keyboard.
o calculate otal Sales of en i.e. to make the cell reference in cell :
Select the cell in uarter Sales worksheet.
ype the formula in the cell : S M anuary. February. March. .
en press ‘Enter’
key to get the
resultant ‘Total
Sales’ of Pen.
epeat the above steps for rest of the items.
178 Touchpad Information Technology-X

