PART 1 Sheet1
Instructions:
1. Create a spreadsheet document following the figure above.
2. Provide the formula of the following using VLOOKUP:
- Product name
- Price
- In stock
- On order
3. The user will just type/search the Product ID and then your spreadsheet document will return the value of: product name, price, in stock and on order automatically.
PART 2 Sheet2
Instructions:
1. Provide the formula of the following:
- Quizzes - 10%
- Activities - 20%
- Project - 35%
- Exam - 35%
- Final Grade
- Equivalent
EQUIVALENT - If FINAL GRADE is equal to 100, the equivalent will be 1.0 and so on...
Follow the given equivalent in the right side, you can use "IF" or "VLOOKUP" for solving that one, but if I were you. VLOOKUP is BETTER....
2. Once you're done, send your .XLSX to this email address, mustachoariel@gmail.com
PART1 & PART2 must be in "one" workbook only, SHEET1 & SHEET2...
Good Luck!
Deadline: MONDAY 3-23-2015, 11:59 PM
