Page 221 - Ms Excel Note and Workbook
P. 221
MICROSOFT EXCEL NOTE AND WORKBOOK
17 EXERCISE
PRACTICE QUESTION 1
1. Create the worksheet shown below and rename it as “DATA”
2. Set the alignment, column width and high appropriately.
3. Calculate the “TOTAL PRICE” for each TYPE using formula:
TOTAL PRICE = QUANTITY * PRICE PERUNIT
4. Calculate the “SUM TOTAL PRICE” using AutoSum Function.
5. Format cells E5:E11, F5:F11, H5:H11 and F12 to include RM sign with two decimal
places.
6. Using LIST function, create a drop-down list for “METHOD OF PAYMENT“. User
can choose how to pay by INSTALLMENT or CASH like figure below.
212 | P a g e
