Homework answers / question archive / New Perspectives Excel 2013 Tutorial 2: SAM Project 1a John Kim 1

New Perspectives Excel 2013 Tutorial 2: SAM Project 1a John Kim 1

MS Excel

Share With

---

New Perspectives Excel 2013 Tutorial 2: SAM Project 1a

John Kim

1. 

Change the theme of the worksheet to Ion.

2. 

On the Website Visitors Report worksheet, apply the Title cell style to

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

3. Merge and center the range A2:H2 and then change the font size of the

merged range to 14 pt.

4. 

Merge and center the range A3:H3.

5. 

Italicize the contents of the range A3:H3 and change the font size to 12

6. 

Format the range A7:A18 using the Short Date (like 3/13/2016) number

7. 

Apply the Accent1 cell style (1st column, 4th row in the Themed Cell

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

8. 

Center and apply bold formatting to 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 into the range C19:F19.

10. 

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

the range to display commas as thousands separators and to display no

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 the 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:H19.

15. 

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

range E23:E34. The conditional formatting rule should identify cells with

a value greater than 420 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 Website Visitors Report worksheet to Wide.

18. 

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

each printed page of the worksheet.)

19. 

In the center footer section of the Website Visitors 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,