1. Answer this one using a spreadsheet application(MS Excel).
2. Send your answers to this email address: mustachoariel@gmail.com
(Note: The whole .xlsx document must be attach meaning you need to copy the format of the problem including its corresponding cell references/rows and columns.)
Sending your file:
Sample header
To: mustachoariel@gmail.com
Subject: YOUR COMPLETE NAME & SECTION
Then attach your file.
PROBLEM 1
Provide the formula of the following:
1. Knowledge - 15% 2. Process/Skills - 25% 3. Understanding - 30% 4. Product - 30%
5. Final Grade 6. Letter Equivalent (Use IF function)
PROBLEM 2
Provide the formula of the following:
1. Discounted Price 2. Total 3. Change
Discounted Price:
If Quantity is greater than or equal to 3, the discount will be 25%.
If Quantity is less than 3, the discount will be 10%.
