LESSON 5: Using Simple Formulas and Functions

 

 

Size

Duration

            EXERCISE LESSONS

5-1

Create a Workbook from a Template

651 KB

1:48

5-2

Create and Copy Addition Formulas

2,053 KB

3:38

5-3

Create and Copy Subtraction Formulas

1,393 KB

2:32

5-4

Create Multiplication Formulas

1,861 KB

3:26

5-5

Edit a Formula in the Formula Bar

765 KB

1:26

5-6

Create Division Formulas

1,448 KB

2:38

5-7

Apply the Percent Style and Increase Decimal Positions

1,269 KB

2:25

5-8

Compare Formulas

2,335 KB

4:37

5-9

Revise a Formula in the Worksheet

1,078 KB

2:04

5-10

Use SUM and the Formula Bar

1,672 KB

3:21

5-11

Use the Insert Function Dialog Box

1,715 KB

3:10

5-12

Use the AVERAGE Function

1,441 KB

2:44

5-13

Use the MIN and MAX Functions

1,310 KB

2:29

5-14

Use the COUNT Function

1,033 KB

1:57

5-15

Use the COUNTA Function

1,424 KB

2:40

5-16

Copy a Formula with a Relative Reference

2,010 KB

3:56

5-17

Create a Formula with an Absolute Reference

1,225 KB

2:23

5-18

Use Mixed References

1,054 KB

2:04

5-19

Add Borders and Shading

1,274 KB

2:24

5-20

Change Page Orientation

668 KB

1:23

5-21

Change Scaling and Page Margins

1,073 KB

2:12

5-22

Print Formulas

1,698 KB

3:07