Quick Question 1: Formatting and Formulas Directions: 1) Change the font of the company name in cell A15 to Times New Roman 2) Center the headings in cells C20:H20 31 Enter a formula in the green cells to calculate total expenses for each description 4) Enter a formula in the orange cell to calculate overall total of the expense 5) Enter a formula in the blue cell to calculate the maximum amount for the expenses in the cou 61 Enter a formula in the pink cell to calculate the minimum amount for the expenses in the column In Enter a formula in the yellow cell to determine the net amount due to Sara after deducting the advance 8) Set the borders of the net amount due (yellow cell) to have a single top and double bottom border 9) Use whatever means you can to get this spreadsheet to print on one page (including these instructions and the available points and your points columns) Total Occasions Event Planning EXPENSE REPORT Purpose: Trip to Rochester, NY to plan Photo Date (s): September 12-15, 2008 Date Description Meals Travel Lodging Telephone Other Total 12-Sep-2008 Employee 35 96 2315 12-Sep-2008 Entertainment 15-Sep-2008 Car Rental Charges 7 13-Sep-2008 Fuel 15-Sep-2008 Tolls 14-Sep-2008 Employee 22 Subtotal Max Min 250 Less: Advance Net due