Intermediate Spreadsheets 2

Table of Contents

1.

Introduction

22.

Header & Footer

2.

Wrapping Text in a Cell 

23.

Ex-Header & Footer

3.

Ex-Wrapping Text in a Cell 

24.

Hiding Rows & Columns

4.

Changing the Orientation of Data

25.

Ex-Hiding Rows & Columns

5.

Ex-Changing the Orientation of Data

26.

Sorting Data

6.

Cell Borders

27.

Ex-Sorting Data

7.

Ex-Cell Borders

28.

Print Area 

8.

Cell Shading

29.

Ex-Print Area 

9.

Ex-Cell Shading

30.

Print Scaling

10.

Styles

31.

Ex-Print Scaling

11.

Ex-Styles

32.

Printing Titles & Gridlines

12.

Inserting Clip Art

33.

Ex-Print Titles & Gridlines

13.

Ex-Inserting Clip Art

34.

Creating Charts

14.

Ex-Resizing Clip Art

35.

Ex-Creating Charts

15.

Adding Drawings

36.

Modifying Charts-1

16.

Ex-Adding Drawings

37.

Ex-Modifying Charts-1

17.

Modifying Drawings

38.

Modifying Charts-2

18.

Ex-Modifying Drawings

39.

Ex-Modifying Charts-2

19.

Quiz 1

40.

Interpreting Data & Charts

20.

Page Breaks

41.

Quiz 2

21.

Ex-Page Breaks

42.

End