Shelly Cashman Excel 2013  Chapter 2: SAM Project 1a Flex Cab Company ADD FORMULAS AND FORMAT A REVENUE REPORT 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

Shelly Cashman Excel 2013  Chapter 2: SAM Project 1a

Flex Cab Company

ADD FORMULAS AND FORMAT A REVENUE REPORT

1. 

Switch to worksheet Sheet1 and, in cell B13, use the SUM function to total the

values in the range B6:B12.

2. 

Using the fill handles, transfer the formula you just created in cell B13 to all the

cells in the range C13:J13.

3. 

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.

4. 

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.

5. 

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.

6. 

Format the range B7:K12 with the Comma Style Number format with two decimal

places.

7. 

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.

8. 

Format the range A6:A12 with the Short Date (like 4/13/2015) Number format.

9. 

Center the contents of cells in the range A5:K5.

10. 

Change the fill color of the range A13:K13 to Standard Yellow (4th column in the

Standard Colors palette).

11. 

Apply a Top and Thick Bottom Border cell border to the range A13:K13.

12. 

Change the width of Column A to 32.00.

13. 

In cell B23, create a formula without using a function 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.

14. 

In cell B24, create a formula without using a function 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.

15. 

Format the range B24:K24 with the Percentage Number format with two decimal

places.

16. 

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).

17. 

Change the orientation of the worksheet to Landscape.

18. 

Change the name of the worksheet to Revenue Detail.