Shelly Cashman Excel 2013 Chapter 2: SAM Project 1b Peter Cheung 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

Shelly Cashman Excel 2013 Chapter 2: SAM Project 1b

Peter Cheung

1. 

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

values in the range B5:B11.

2.

Using the fill handle, transfer the formula you just created in cell B12 to all the

cells in the range C12:I12.

3. 

In cell B13, use the AVERAGE function to determine the average daily income for

the range B5:B11. Using the fill handle, transfer the formula you just created in

cell B13 to the range C13:I13.

4. 

In cell B14, use the MAX function to determine the highest daily income for the

range B5:B11. Using the fill handle, transfer the formula you just created in cell

B14 to the range C14:I14.

5. 

In cell B15, use the MIN function to determine the lowest daily income for the

range B5:B11. Using the fill handle, transfer the formula you just created in cell

B15 to the range C15:I15.

6. 

Format the range B6:I11 with the Comma Number style with two decimal places.

7. 

Format the range B5:I5 with the Accounting Number style with two decimal

places. Format the range B21:I21 the same, with the Accounting Number format

with two decimal places.

8. 

Format the range A5:A11 with the Short Date Number format (like 9/21/2016).

9. 

Center the contents of the range A4:I4.

10. 

Change the fill color of the range A12:I12 to Standard Light Green (5th column in

the Standard Colors palette).

11. 

Apply a Top and Thick Bottom Border cell border to the range A12:I12.

12. 

Change the width of column A to 25.00.

13. 

In cell B22, create a formula without using a function that subtracts the value of

cell B21 (the total revenue for the Carousel in 2015) from the value of cell B12

(the total revenue for the Carousel in 2016). Copy the formula you created in cell

B22 to the range C22:I22.

14. 

In cell B23, create a formula without using a function that divides the value in

cell B22 by the value in cell B21. Copy the formula you created in cell B23 to the

range C23:I23.

15. 

Format the range B23:I23 with the Percentage Number style with no decimal

places.

16. 

Apply a new conditional formatting rule to the range B23:I23. 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 2016 Revenue Report.