Question 2

A supermarket listed ten items on sale. Use Microsoft excels application to create an inventory for the supermarket.   

(a)  Type in the following headings from cells A1 to F1 respectively: SN, Goods, Cost Price, Selling Price, Gain/ Loss and Target.

(b)  Populate the table by supplying ten different items sold in a supermarket. In column A, Fill in the numbers 1 to 10 from cells A2 to A11. Similarly, list the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cells C2 to C11 and D2 to D11 respectively. Note that it is possible to have some Selling Prices lower than the cost price. Create borders around the table.

(c)  Use formula or function to calculate:
(i) The gain (if the selling price is higher than the cost price) or the loss (if the cost price is higher than the selling price) of each item from cells E2 to E11.
(ii) 110% of the cost price of each item from cells F2 to F11.

 (d) Determine whether target is met or not by typing “target met” or “target not met” in cells H2 to H11 for each item. 
Note that target is met when the selling price is 110% of the cost price or more      otherwise, target is not met.

(e)  Insert a footer and type in your full name and index number

(f) Save your work in the folder created on the desktop using your full name as the filename.

(g)  Print your work showing formulas and functions and submit to the supervisor.

The question tested candidates’ proficiency in the use of MS Excel application.