BIS155 Practical Final Exam Instructions-4 (v5) Complete the tasks below using Microsoft Excel. You may refer to your notes, the textbook, or other resources (for example, you may search the Web for information). You may not get interactive help from any other person (either in person or via email, text messaging, IM, or other communications channels). Save your work frequently using CTL+s. You have 4 hours to complete this exam. NOTE: Be sure you SPELL CHECK on every worksheet and correct all spelling errors. Getting started a. Open Excel (either on your desktop or in Citrix) b. If you are using Citrix, you need to upload the spreadsheet to your virtual drive before you can open it in Excel c. Open the Practical Exam spreadsheet you downloaded from the Exam page in eCollege. d. Save the spreadsheet as LastnameFirstInitial Week8 FinalExam.xlsx. Example: If your name was Jane Doe, the file name would be: DoeJ Week8 FinalExam.xlsx 1. Formatting and charts (Excel; TCOs 1, 2, & 3; 30 points). Using the Documentation sheet: a. Enter your name and today's date. Using the 'Quest 1 & 2' worksheet: b. c. d. e. f. g. h. i. Adjust the widths of the columns as needed so all data is visible. Center the title "Car Part Service - Sales by Product" across columns A-E. Increase the font size to 20, and change the font color to red and BOLD. Bold the column headings \"Category\BIS-155 Final Exam Practical Problems Car Parts Service (v-5) Name: Date: Car Parts Service Category Product Unit Price Quantity Total Sales Auto Parts Tires 15.99 95 Auto SuppliOil 7.99 60 Auto SuppliOil Filters 10.99 150 Auto AccesSpeakers 60.95 75 Auto AccesHeadsets 15.89 25 Auto AccesCar Jacks 10.5 10 Auto SuppliPaint Touch-up 2.99 45 Auto AccesWiring 8.75 15 Auto AcessAudio Equpment 25.5 19 Auto SuppliAudio Parts 10.15 45 Auto SuppliAntifreeze 9.99 75 Auto Parts Car mats 35.45 45 Auto SuppliCar Cleaner 6.55 125 Auto Parts Windshield Wipers 35.99 150 Sales Assessment 0 Poor 1000 Good 4000 Outstanding! Income Statement Annual Revenue: Tires Oil Oil Filters Speakers Headsets Car Jacks Paint Touch-up Wiring Audio Equipment Audio Parts Antifreeze Car mats Car Cleaner Windshield Wipers Va Total Revenue Total Expenses Net Income Total Revenue Annual Expenses: Variable Expenses hrs rate Payroll - part time 500 $ 8.50 Postage Sub Total Variable Expenses Fixed Expenses Insurance Maintenance Administrative and Markeing Taxes SubTotal Fixed Expenses Total Expenses Summary: Total Revenue Total Expenses Net Income 4250 150 500 250 400 2510 Payment Function and Analysis (Part B) Down PaymenPresent Value Interest/PeriodLoan Amount # Periods 1500 50000 2500 50000 Initial Value $ $ $ - $ Payment Variable Part Time Payroll Expense Impact on Net Income 8.50 $ 8.75 $ 9.00 $ 9.25 $ 9.50 $ 9.75 $ 10.00 San Francisco Branch January Tires Oil Oil Filters Speakers Headsets Car Jacks Paint Touch-U Wiring Audio Equipm Audio Parts Antifreeze Car Mats Car Cleaner Windshield Wi February 120 270 200 530 170 300 300 100 50 370 140 330 200 300 170 300 370 120 330 320 530 290 300 300 100 50 370 140 270 320 300 290 170 300 100 50 370 140 330 200 300 170 230 170 330 320 300 290 300 300 100 50 370 140 330 200 300 170 140 270 200 530 290 300 300 100 50 370 140 330 600 350 50 180 140 270 320 530 290 300 300 100 50 370 130 490 330 320 300 290 300 300 100 50 370 140 330 200 160 520 370 330 330 320 530 290 300 300 100 50 370 140 260 270 50 120 140 270 320 530 290 300 300 100 50 370 150 110 300 290 170 300 100 50 370 140 330 200 300 170 320 180 200 530 170 300 300 100 50 370 140 330 200 300 300 60 140 170 200 530 290 300 300 100 50 370 140 330 Denver Branch January Tires Oil Oil Filters Speakers Headsets Car Jacks Paint Touch-U Wiring Audio Equipm Audio Parts Antifreeze Car Mats Car Cleaner Windshield Wi February 490 200 150 400 130 230 230 80 40 280 110 250 150 230 350 230 280 90 250 240 400 220 230 230 80 40 280 110 290 240 230 220 130 230 80 40 280 110 250 150 230 130 470 130 250 240 230 220 230 230 80 40 280 110 250 150 230 130 110 200 150 400 220 230 230 80 40 280 110 250 520 260 40 140 110 200 240 400 220 230 230 80 40 280 650 370 250 240 230 220 230 230 80 40 280 110 250 150 515 390 280 250 250 240 400 220 230 230 80 40 280 110 465 200 40 90 110 200 240 400 220 230 230 80 40 280 580 80 230 220 130 230 80 40 280 110 250 150 230 130 240 140 150 400 130 230 230 80 40 280 110 250 150 230 230 50 110 130 150 400 220 230 230 80 40 280 110 250 Boston Branch January Tires Oil Oil Filters Speakers Headsets Car Jacks Paint Touch-U Wiring Audio Equipm Audio Parts Antifreeze Car Mats Car Cleaner Windshield Wi February 230 290 220 570 180 320 320 110 50 400 150 360 220 320 180 320 400 130 360 350 570 310 320 320 110 50 400 150 290 350 320 310 180 320 110 50 400 150 360 220 320 180 250 180 360 350 320 310 320 320 110 50 400 150 360 220 320 180 150 290 220 570 310 320 320 110 50 400 150 360 475 380 50 190 150 290 350 570 310 320 320 110 50 400 340 530 360 350 320 310 320 320 110 50 400 150 360 220 170 560 400 360 360 350 570 310 320 320 110 50 400 150 280 290 50 130 150 290 350 570 310 320 320 110 50 400 315 120 320 310 180 320 110 50 400 150 360 220 320 180 350 190 220 570 180 320 320 110 50 400 150 360 220 320 320 60 150 180 220 570 310 320 320 110 50 400 150 360 Place memo and Text here