Intermediate Spreadsheets 2

Table of Contents

1.

Introduction

23.

Ex-Header & Footer

2.

Wrapping Text in a Cell

24.

Hiding Rows & Columns

3.

Ex-Wrapping Text in a Cell

25.

Ex-Hiding Rows & Columns

4.

Changing the Orientation of Data

26.

Sorting Data

5.

Ex-Changing the Orientation of Data

27.

Ex-Sorting Data

6.

Cell Borders

28.

Filtering Data

7.

Ex-Cell Borders

29.

Ex-Filtering Data

8.

Cell Shading

30.

Print Area 

9.

Ex-Cell Shading

31.

Ex-Print Area 

10.

Styles

32.

Print Scaling

11.

Ex-Styles

33.

Ex-Print Scaling

12.

Inserting Clip Art

34.

Printing Titles & Gridlines

13.

Ex-Inserting Clip Art

35.

Ex-Print Titles & Gridlines

14.

Ex-Resizing Clip Art

36.

Creating Charts

15.

Adding Drawings

37.

Ex-Creating Charts

16.

Ex-Adding Drawings

38.

Modifying Charts-1

17.

Modifying Drawings

39.

Modifying Charts-2

18.

Ex-Modifying Drawings

40.

Ex-Modifying Charts

19.

Quiz 1

41.

Interpreting Data & Charts

20.

Page Breaks

42.

RS-Guidelines for Creating Spreadsheets

21.

Ex-Page Breaks

43.

Quiz 2

22.

Header & Footer

44.

End