# Excel Project (Multiple Worksheets): Download the attached Excel file (MIS 303 Excel New Proj.xlsx). Instructions: There are 3 Worksheet Tabs in this Excel file; First Term GPA, First Q Income, and Mi

Excel Project (Multiple Worksheets): Download the attached Excel file (MIS 303 Excel New Proj.xlsx).Instructions: There are 3 Worksheet Tabs in this Excel file; First Term GPA, First Q Income, and Minivan Purchase.

1. The First Term GPA tab shows the 5 courses that a student took in Fall 2022 with their grades and credit hours. For this tab,

• GPA Calculation:

### Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
• 1. Calculate the GPA (F9) for this semester using the given Grades. (15 points)
• Conditional Formatting:

• 2. If a “Grade” is greater than 3.5, change the cell color to Red with Yellow font color. (5 points)
• Goal Seek Analysis:

• 3. What should be the grade for ENGL 200 if you wish the GPA to be equal to 3.5? (10 points)
• Sparkline

• 4. Create a Sparkline for the “Grades” in cell B12. (5 points)
2. The First Q Income tab shows the Income Statement for a supply company in the first quarter of this year. For this tab:

• Complete the worksheet (B7 through E14) with the given data (figures listed under the “Facts”). (4 points for each row, total of 32 points)
• Create a 3-D Pie Chart, similar to the given screenshot, using the Net Income of Lang’s Company. Then replace the image (screenshot) with the 3-D Pie Chart. (8 points)
3. The Minivan Purchase tab shows the information that is needed to buy a Minivan for the above supply company. For this tab,

• Review the instructions on the top of the worksheet carefully.
• Calculate the Monthly Payment (B15) for the car loan based on the given information. (15 points)
• If the Lang’s Supply Company wants to pay off the minivan loan faster, by paying every other week, how much do they have to pay bi-weekly (B16)? (5 points)