?_^"l!8;Zmain  /&;)z4|CONTEXT/|CTXOMAP|FONT|SYSTEM|TOPIC|TTLBTREE BN1 N Vergil ECDL Mocksq7 : BoECDL Mock TestModule 4 SpreadsheetsVergil LtdYou have 45 minutes to complete this task. When you are ready to begin press the Start Button on the Vergil Timer provided.1 Open the spreadsheet located on the floppy disk in the Work Files folder named Red Wing Taxis.xls2 Apply a Bold and Italic format to all cells that have titles or headings. Use appropriate alignment methods to ensure clarity of Headings and data. Throughout the spreadsheet apply the appropriate format to the numbers, use currency or 2 decimal places or integer where necessary.#N+ $3 Create the appropriate formula to calculate the Weeks Total Mileage for each car.4 Using the values provided in cell B13 calculate the Fuel Cost and the Mpg for each car. Use absolute referencing in the relevant formula.5 By applying similar techniques of using absolute cell referencing work out a formula for calculating the Car Earnings for each car. Remember to deduct the Fuel Cost.6 Using the appropriate Functions calculate the Average Mileage, the Average Fuel and the Maximum Earned.- (7 Format every cell that has a formula to blue font colour.8 Rename Sheet1 to Week1, Sheet2 to Week2 and Sheet3 to Week3.9 Copy the entire contents of Week1 sheet to Week2 and repeat for Week3 sheet.10 In both Week2 & Week3 sheets delete all of the table data in the range B4 to H8 that does not have a formula. If you have followed the instructions correctly this will be the data that is not blue. Ignore any DIV errors etc that will appear.11 In the Week2 sheet create a reference formula in the Start Mileage cell B4 to refer to the Finish Mileage for the same car in Week1 sheet. Replicate this formula for all of the other cars.c" ) 12 Repeat the process for Week3 sheet however, this sheet needs to refer to Week2 sheet.13 On Week1 sheet produce a Column Chart to display the earnings for each car. Select the Car Registration Data and the Car Earnings Data ONLY for the chart. Apply appropriate titles for the chart and the axes and remove the default legend. Save the chart as a new sheet within the workbook entitled Week1 Chart14 Create a similar chart for Week2 & Week3 sheets. Obviously the content of the charts will be empty but they will fill when data is entered on a weekly basis. Save these as Week2 Chart and Week3 Chart.Q . *15 Rearrange all of the Chart sheets to the back of the worksheet list. Make sure that all of the other sheets are in numerical order.16 Save the spreadsheet using your surname as the file name into the root of the floppy disk. 17 Find the file Red Wing Taxis Answers.xls located on the floppy disk to check your results.END1" 1=4MS Sans SerifTimes New RomanTimes New Roman CETimes New Roman CyrTimes New Roman GreekTimes New Roman TurTimes New Roman BalticSymbol /&;)LzVergil ECDL Mocksj /&;)L4A