Question: Save the test file (Your name as File name), continually save the file as you work on it and upload your completed file on the
Save the test file (Your name as File name), continually save the file as you work on it and upload your completed file on the blackboard exam link once you are done. 1. In the sheet1 Create a Sum formula in B8 that adds the above Variable Cost for Jan, from the Cloth to Packaging, and copy the formula to the right. (5%) 2. Create a formula in B19 that adds the Total Variable plus the Total Fixed for Jan, and copy the formula to the right. (5%) 3. In cell I4 Create a Sum formula to add all the Cloth cost in Row 4. Copy the formula down to cell I22. (5%) 4. In cell J4 find the % change from the Jan cloth cost to Jul cloth cost. Copy the formula down to J7 Format the values in Column J to be percentages with one decimal place. (10%) 5. Go to the sheet named Finance. In cell B5 find the monthly payment for this car loan using the PMT function. (15%) 6. Go to the sheet Car Dealership. Create a formula in F2 that determines the Sales Tax. (Sales Price * the Tax in cell J1) With the
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
