New Perspectives Excel 2013 Tutorial 2: SAM Project 1b 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

New Perspectives Excel 2013 Tutorial 2: SAM Project 1b

1. 

Change the theme of the worksheet to Office.

2. 

On the Facility Rental Report worksheet, apply the Title cell style to the

merged range A1:G1 and then apply bold formatting to the range.

3. 

Merge and center the range A2:G2 and then change the font size of the

merged range to 14 pt.

4. 

Merge and center the range A3:G3.

5. 

Italicize the contents of the range A5:H5 and change the font size to 14

6. 

Format the range A7:A18 using the Short Date (like 5/15/2016) number

7. 

Apply the Accent5 cell style (5th column, last row in the Themed Cell

Style section of the Cell Style palette) to the range A6:H6.

8. 

Center align and apply bold formatting to the cells in the range A6:H6.

9. 

In cell B19, create a formula using the SUM function that totals the range

B7:B18. Copy the formula you created in cell B19 to the range C19:F19.

10. 

Apply the Number format to the range B7:G19 and then format the range

to display commas as thousands separators and to display no decimals.

11. 

Apply the Percentage Number format (with no decimal places) to the

range H7:H18.

12. 

Change the background color for the range A19:G19 to Standard Light

Green (5th column, 1st row in Standard Colors Palette), and then change

the background color for cell H19 to White, Background 1 (1st column,

1st row in the Theme Colors Palette).

13. 

Change the font color for cell G19 to Standard Dark Red (1st column, 1st

row in the Standard Colors Palette).

14. 

Apply the All Borders cell border style to the range A19:G19.

15. 

Use the Quick Analysis tool to apply a conditional formatting rule to the

range C23:C34. The conditional formatting rule should identify cells with

a value greater than 590 and format those cells with Light Red Fill with

Dark Red Text.

16. 

Change the orientation of the worksheet to Landscape.

17. 

Change the margins for the Facility Rental Report worksheet to Normal.

18. 

Set rows 1–3 as print titles. (Note: Rows 1–3 should repeat at the top of

each printed page of the worksheet.)

19. 

In the center footer section of the Facility Rental Report worksheet,

enter the word Page followed by a space, a current page number

followed by a space, the word of followed by a space, and then the total

page count. Use Header and Footer Elements for the current page

number value and total page count value in this footer. For example, the

footer on the first page of the worksheet should display, “Page 1 of 2”.