A student presented a budget in the form of a worksheet as follows
The student intends to have spent half the amount by midterm
(a) Given that the vale 0.5 is typed in cell B9, write the shortest formula that would be typed in cell C2 and then copied down the column to obtain half the values in column B.
= $B49* B2
(b) Write two different formulae that can be typed to obtain the total in cell B6 and then copied to cell C6
= sum (B2: B5)
= B2 + B3 + B4 + B5
Follow AtikaSchool.Org on our Social Channels
This gives you an opportunity to get our latest uodates, changes and firsthand information
Leave a Reply.
P.O Box 1189 - 40200 Kisii
Tel: 0728 450 424
Tel: 0738 619 279
Tel: 0763 450 425
E-mail - firstname.lastname@example.org