Description
Create an excel spread sheet and follow the instruction exactly. here are helpful materials please follow these videos and do-
Unformatted Attachment Preview
Exam #2
Q1. Josh Bartel is the senior director of the Pennsylvania field office for New Era Medical, a global
company that manufactures medical equipment. He has created a worksheet summarizing the revenue
and expenses for the first three quarters of the year. He asks for your help in determining
a. The total sales of all the regions in each quarter
b. The total sales of each region for the first three quarters (year-to-date sales)
c. Josh wants to include a visualization of the total year-to-date sales separated by
region. Insert a pie chart to provide this visualization.
(40 pts)
Q2. Enter the product list. Calculate the average, maximum and minimum price. (15 points)
Q3. Student A enrolled in a class and currently has a grade of 65. Student A needs
at least a 70 to pass the class. Luckily, the student has one final assignment that
might be able to raise the average. Calculate what grade the student needs on the
final assignment to pass the class. (20 points)
Q4. Solve the problem: A customer got a 30 year term home loan amount $1,200,000 at 3% annual
interest rate. . Calculate the items below:
1. Option to pay at the end of each year:
a. Payment @ end year
b. Total paid
2. Option to pay at the end of each month:
a. Payment @ end month
b. Total paid
3. Create an amortization table for a customer got a 30 year term home loan amount $1,200,000
at 3% annual interest rate.
(40 points)
Purchase answer to see full
attachment
