TEST OF PRACTICAL KNOWLEDGE QUESTION
A supermarket listed ten items on sale.
Use Microsoft Excel application to create an inventory for the supermarket.
(a) Type in the following headings from cell 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 cell 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 th file name.
(g) Print your work showing formulas and functions and submit to the supervisor.
To create an inventory for the supermarket using Microsoft Excel, follow these steps:
(a) In cell A1 to F1 respectively, type in the following headings: SN, Goods Cost Price, Selling Price, Gain/Loss, and Target.
(b) Populate the table with ten different items sold in the supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. List the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell 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 formulas or functions 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 using the formula: =D2-C2.
(ii) 110% of the cost price of each item from cells F2 to F11 using the formula: =C2*1.1.
(d) Determine whether the target is met or not by typing "target met" or "target not met" in cells H2 to H11 for each item. Note that the target is met when the selling price is 110% of the cost price or more; otherwise, the target is not met. Use the formula: =IF(D2>=F2,"target met","target 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 file name.
(g) Print your work showing formulas and functions and submit it to the supervisor.
In summary, to create an inventory for a supermarket using Microsoft Excel, you need to add headings, populate the table with the necessary information, use formulas or functions to calculate the gain/loss and target, and insert a footer with your name and index number. Finally, save your work using your name as the file name and print your work showing formulas and functions before submitting it to your supervisor.
To create an inventory for the supermarket using Microsoft Excel, follow these steps:
(a) In cell A1 to F1 respectively, type in the following headings: SN, Goods Cost Price, Selling Price, Gain/Loss, and Target.
(b) Populate the table with ten different items sold in the supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. List the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell 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 formulas or functions 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 using the formula: =D2-C2.
(ii) 110% of the cost price of each item from cells F2 to F11 using the formula: =C2*1.1.
(d) Determine whether the target is met or not by typing "target met" or "target not met" in cells H2 to H11 for each item. Note that the target is met when the selling price is 110% of the cost price or more; otherwise, the target is not met. Use the formula: =IF(D2>=F2,"target met","target 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 file name.
(g) Print your work showing formulas and functions and submit it to the supervisor.
In summary, to create an inventory for a supermarket using Microsoft Excel, you need to add headings, populate the table with the necessary information, use formulas or functions to calculate the gain/loss and target, and insert a footer with your name and index number. Finally, save your work using your name as the file name and print your work showing formulas and functions before submitting it to your supervisor.