PCIC3B2-GS3 Key Applications-Excel (2007)
Prepares learners for the IC3 GS3 exam: Key Applications

Unit 1

Unit 2

Unit 3

B

Introduction

B1.19

Quiz 1-1

B1

Unit 1

B1.20

Fonts

B1.1

Spreadsheets Overview

B1.21

Ex-Fonts

B1.2

Getting Started

B1.22

Alignment

B1.3

Ribbon

B1.23

Ex-Alignment

B1.4

Entering Data

B1.24

Number Formats

B1.5

Ex-Entering Data

B1.25

Ex-Number Formats

B1.6

Editing Data

B1.26

Format Painter

B1.7

Ex-Editing Data

B1.27

Ex-Format Painter

B1.8

Formulas

B1.28

Resizing Rows & Columns

B1.9

Ex-Formulas

B1.29

Ex-Resizing Rows & Columns

B1.10

Functions

B1.30

Printing

B1.11

Ex-Functions

B1.31

Ex-Printing-1

B1.12

Saving Workbooks

B1.32

Ex-Printing-2

B1.13

Ex-Saving Workbooks-1

B1.33

Office Clipboard

B1.14

Ex-Saving Workbooks-2

B1.34

Ex-Office Clipboard

B1.15

Creating a New Workbook

B1.35

Getting Help

B1.16

Ex-Creating a New Workbook

B1.36

Ex-Getting Help

B1.17

Opening Workbooks

B1.37

Quiz 1-2

B1.18

Ex-Opening Workbooks

B1.38

Unit 1 End

B2

Unit 2

B2.19

Inserting Functions in Formulas

B2.1

Filling Cells

B2.20

Ex-Inserting Functions in Formulas

B2.2

Ex-Filling Cells

B2.21

Modifying Formulas & Functions

B2.3

Moving & Copying Data Efficiently

B2.22

Ex-Modifying Formulas & Functions

B2.4

Ex-Moving & Copying Data Efficiently

B2.23

Copying Formulas & Functions

B2.5

Inserting & Deleting Cells

B2.24

Ex-Copying Formulas & Functions

B2.6

Ex-Inserting & Deleting Cells

B2.25

Formula & Function Errors

B2.7

Inserting & Deleting Rows & Columns

B2.26

Ex-Formula & Function Errors

B2.8

Ex-Inserting & Deleting Rows & Columns

B2.27

Organizing Worksheets

B2.9

Data Fitting Errors

B2.28

Ex-Organizing Worksheets

B2.10

Spelling Check

B2.29

Templates

B2.11

Ex-Spelling Check

B2.30

Ex-Templates

B2.12

Find & Replace

B2.31

Time Saving Tips

B2.13

Ex-Find & Replace

B2.32

Ex-Time Saving Tips

B2.14

Quiz 2-1

B2.33

RS-Save Formats

B2.15

Formulas Containing Multiple Operators

B2.34

Ex-Save Formats

B2.16

Ex-Formulas Containing Mult. Operators

B2.35

Quiz 2-2

B2.17

Commonly Used Functions

B2.36

Unit 2 End

B2.18

Ex-Commonly Used Functions

B3

Unit 3

B3.23

Hiding Rows & Columns

B3.1

Wrapping Text in a Cell

B3.24

Ex-Hiding Rows & Columns

B3.2

Ex-Wrapping Text in a Cell

B3.25

Sorting Data

B3.3

Changing the Orientation of Data

B3.26

Ex-Sorting Data

B3.4

Ex-Changing the Orientation of Data

B3.27

Filtering Data

B3.5

Cell Borders

B3.28

Ex-Filtering Data

B3.6

Ex-Cell Borders

B3.29

Print Area

B3.7

Cell Shading

B3.30

Ex-Print Area

B3.8

Ex-Cell Shading

B3.31

Print Scaling

B3.9

Styles

B3.32

Ex-Print Scaling

B3.10

Ex-Styles

B3.33

Printing Titles & Gridlines

B3.11

Inserting Clip Art

B3.34

Ex-Printing Titles & Gridlines

B3.12

Ex-Inserting Clip Art

B3.35

Creating Charts

B3.13

Ex-Resizing Clip Art

B3.36

Ex-Creating Charts

B3.14

Adding Drawings

B3.37

Modifying Charts-1

B3.15

Ex-Adding Drawings

B3.38

Ex-Modifying Charts-1

B3.16

Modifying Drawings

B3.39

Modifying Charts-2

B3.17

Ex-Modifying Drawings

B3.40

Ex-Modifying Charts-2

B3.18

Quiz 3-1

B3.41

Interpreting Data & Charts

B3.19

Page Breaks

B3.42

RS-Guidelines for Creating

B3.20

Ex-Page Breaks

B3.43

Quiz 3-2

B3.21

Header & Footer

B3.44

Unit 3 End

B3.22

Ex-Header & Footer