PROJECT DESCRIPTION - Weebly



4839335-450850left323850Shelly Cashman Excel 2013Chapter 2: SAM Project 1aFlex Cab CompanyAdd formulas and format a revenue reportProject GoalM Project NameProject Goal00Shelly Cashman Excel 2013Chapter 2: SAM Project 1aFlex Cab CompanyAdd formulas and format a revenue reportProject GoalM Project NameProject GoalPROJECT DESCRIPTIONSimone Kisawa works in the accounting department of Flex Cab Company, a taxi service in Toronto, Ontario. Simone has created a revenue detail report for the week of April 13, 2015. She would like you to complete the report by adding formatting and calculations.GETTING STARTEDDownload the following file from the SAM website:SC_Excel2013_C2_P1a_FirstLastName_1.xlsxOpen the file you just downloaded and save it with the name:SC_Excel2013_C2_P1a_FirstLastName_2.xlsxHint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.With the file SC_Excel2013_C2_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPSChange the worksheet theme to Integral.Switch to worksheet Sheet1 and, in cell B13, use the SUM function to total the values in the range B6:B12.Using the fill handles, transfer the formula you just created in cell B13 to all the cells in the range C13:J13.In cell B14, use the AVERAGE function to determine the average daily income for the range B6:B12. Using the fill handle, transfer the formula you just created in cell B14 to all the cells in the range C14:K14.In cell B15, use the MAX function to determine the maximum daily income for the range B6:B12. Copy the formula you just created in cell B15 to the range C15:K15.In cell B16, use the MIN function to determine the minimum daily income for the range B6:B12. Copy the formula you just created in cell B16 to the range C16:K16.Format the range B7:K12 with the Comma Style Number format with two decimal places. Format the range B6:K6 with the Accounting Number format with two decimals places. Also format the range B13:K13 with the Accounting Number format with two decimal places. (Hint: Your number format should use the $ symbol with no special regional formatting options like $ English (United States).)Format the range A6:A12 with the Short Date (like 4/13/2015) Number format.Center the contents of cells in the range A5:K5.Change the fill color of the range A13:K13 to Standard Yellow (4th column in the Standard Colors palette).Apply a Top and Thick Bottom Border cell border to the range A13:K13.Change the width of Column A to 32.00.In cell B23, create a formula that subtracts the value of B22 (Dispatch Center 1’s total revenue for the previous week) from the value of cell B13 (Dispatch Center 1’s total revenue for the current week.) Copy the formula you created in cell B23 to the range C23:K23. In cell B24, create a formula that divides the value in B23 (weekly change in revenue) by the value in cell B22 (revenue for the previous week). Copy the formula you created in cell B24 to the range C24:K24.Format the range B24:K24 with the Percentage Number format with two decimal places.Apply a new conditional formatting rule to the range B24:K24. The rule should format cells with a cell value less than 0 with a Standard Orange fill color (3rd column, 7th row in the Background Color palette). Change the orientation of the worksheet to Landscape.Change the name of the worksheet to Revenue Detail.Your workbook should look like the Final Figure on the following page. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.Final Figure: Revenue Detail worksheetcenter2838153Microsoft product screenshots used with permission from Microsoft Corporation.Copyright ? 2014 Cengage Learning. All Rights Reserved.020000Microsoft product screenshots used with permission from Microsoft Corporation.Copyright ? 2014 Cengage Learning. All Rights Reserved. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download