Page 171 - Ms Excel Note and Workbook
P. 171
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.
7. Using IF formula, determine the “DISCOUNT”. If quantity is less than 10, there is NO
discount but if more than 10, user will get the discount. Use the formula:
=IF(D5>10, “YES”,”NO”)
162 | P a g e
