1. On me car Lo.n Work Shoot Determine the month, payment, total payment, and interest interest is 4%.
2. Make suf. all cells in the loan calculation (From Sales Price to Interest Paid) are named by their
3. Using Scenario manager, create the current scenario and label it Pulaski. We are going to do various Interest rates.
4. Using the Scenario manager, create a new scenario labeled Bank of America with a 2.75% interest rate. 'For those that need a back story as to WHY we aren't using that rate as default, assume Bank of America needs lots more paperwork and takes longer (could be 2 months). You are working out if this extra work makes senSe.1
5 Create a Summary from the Scenario Manager, summarizing Monthly payments, total PaYments, and Interest paid.
6. Extra Credit: Copy the Car Loan tab and call it Goal Seek. On this tab, determine how mu. car can you afford (Sales Price, if you want to only make monthly payments of MO per month at
4% year, interest and 48 months, r ;
1. On the 2013 Sheet, make this a table. Use Table Style Light 10.
2. Remove Duplicates.
3. Insert 'Remaining Seats' as a column next to Seats Reserved. Calculate the remaining seats an equation for the entire column.
4. In the Air Included column, and ONLY for the actual data - not for the column itself, rnake s that the data is validated. The list of values allowed is Yes, No.
5. Add a total row. Find the total number of seats sold and the average price.
6. Determine the tours with a departure date > 6/1/2013 and with a price less than $2000. LE the tab like this. of Table
I. Go to the Pivot Table Tab. Create a pivot table on a new sheet, vvhere the Tours on the r the colurnns are by departure date
Seats reserved are in the values. We want the total number of seats reserved. Group the departure dates by month.
Create a bar chart by month for the Old Japan and Amazing Amazon Tour. Make the ch the it is easy to compare the two tours on any given month. (Hint: The two tours shot side by side on a given month.) Place the chart so that it is easy to read the pivot table
anri thp rhart takp, lin no more than 8 columns.
Attachment:- 322290_1_Excel-test.xlsx