Question 1

Excel Project 1

Please read the information below carefully

This project has 2 parts:

Part 1: Excel Formulas:

1. Click here to download your data.

2. You must read the tutorial from here. The tutorial explains the Nested IF function in Excel which is necessary for this project.

3. Once you completed all the calculations in Excel, save your workbook with an .xlsx extension and upload it below.

4. If you forget to upload your excel file or accidentally submit the project, you will receive 0 for the excel section of the project (you cannot send the excel file manually).

5. You must use Nested IF function to solve this project.

6. Use relative and absolute references properly inside the Nested IF:

– If you choose a relative reference where an absolute reference is necessary, your answer will be wrong.

7. Pay close attention to inequality signs you use in yourNested IF (If the correct answer is “<" and you use "<=" or vice versa, you will not receive Excel marks). 8. This project is meant to help you get familiar with Nested IF, absolute and relative references. If you avoid using a Nested IF statement, and calculate the answers manually or with your calculator, you won't receive Excel marks.Instructions are uploaded