Performing Calculations Create Worksheet Formulas Insert Functions Reuse

Performing Calculations § Create Worksheet Formulas § Insert Functions § Reuse Formulas and Functions Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 1

Excel Formulas Formula Displayed result Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 2

The Formula Bar Cancel button Insert Function button Enter button Copyright © 2016 Logical Operations, Inc. All rights reserved. Formula Bar OV 2 - 3

A Basic Mathematical Formula Expression Result Constant Variable Operator Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 4

Elements of Excel Formulas Constant Operator Equal sign Reference Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 5

The Order of Operations Second highest precedence Third highest precedence =(A 2+B 2)^2 -10*C 2 Highest precedence Copyright © 2016 Logical Operations, Inc. All rights reserved. Lowest precedence OV 2 - 6

Intersection Operator Intersection operation Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 7

Functions SUM function Argument Function result Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 8

The Function Library Group Function categories Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 9

The Insert Function Dialog Box Function description Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 10

The Function Arguments Dialog Box Collapse Dialog buttons Required argument Optional arguments Function description Formula result Copyright © 2016 Logical Operations, Inc. All rights reserved. Argument description OV 2 - 11

Graphical Cell and Range Reference Entry Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 12

The Auto. Sum Feature Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 13

Other Commonly Used Functions Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 14

Basic Function Syntax Equal sign Function name Copyright © 2016 Logical Operations, Inc. All rights reserved. Arguments OV 2 - 15

The Formula Auto. Complete Feature Selected function’s tooltip Function started in cell Available function options Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 16

The Arguments Tooltip Current argument Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 17

The Paste Options Paste drop-down menu Copyright © 2016 Logical Operations, Inc. All rights reserved. Paste Options button OV 2 - 18

The Paste Special Dialog Box Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 19

Relative References Original function Copied function Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 20

Absolute References Relative references change Copyright © 2016 Logical Operations, Inc. All rights reserved. Absolute references don’t change OV 2 - 21

Mixed References Mixed references Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 22

Auto. Fill and Formulas Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 23

Worksheet References Cell reference Worksheet reference Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 24

Excel Errors have been corrected Cells containing errors Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 25

Error Indicators Cell with error indicator Error indicator drop-down menu Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 26

Reflective Questions 1. Which formulas and functions do you see yourself using most in your daily life? How does that relate to your current role? 2. How do you see the Auto. Fill feature saving you time and effort? Can you think of uses for it not covered so far? Copyright © 2016 Logical Operations, Inc. All rights reserved. OV 2 - 27