Excel Module 2 Simple Calculations Microsoft Office 2016

Excel Module 2 Simple Calculations Microsoft Office 2016 Introductory

REVIEW: Student Learning Outcomes l l l 2 Using FORMULAS and FUNCTIONS to Calculate Sales Data Components of a FORMULA ORDER OF OPERATIONS Components of a FUNCTION Viewing Formulas and Functions

REVIEW: Function List = 4 l l 3 =SUM =COUNT (counts cells that have numbers) =COUNTA (counts cells that are not empty) =AVERAGE

Student Learning Outcomes l l l Create Formulas and Functions Moving and Copying Cells Use a Theme Conditional Formatting (Page EX 107) Printing Options (Page EX 113 – 121) – – – 4 – Print Area Page Break Margins Center on a Page

Student Learning Outcomes EXAMPLE: EXCEL 2 folder > Module > Morning. xlsx l l l 5 Enter Simple FORMULAS Enter FUNCTIONS using =SUM function Enter FUNCTIONS using =AVERAGE function Enter FUNCTIONS using =MAX function Enter FUNCTIONS using =MIN function

Components of a FORMULA 1. 2. 3. Always starts with a = OPERANDS (Cells, Numbers, “Text”) OPERATORS ( ^ * / + - ) =C 6 / C 23 EXAMPLES: =B 12 = C 6 – (C 7 + C 8) = G 9 + G 13+ G 18 = C 9 + C 12 + C 17 + C 20 + C 22

Components of a FUNCTION 1. 2. 3. Always starts with a = Function Name Arguments (Cell, Range, Number, “Text”) EXAMPLE: = SUM(C 27: N 46) *If cells are adjacent, write the argument as a range. = SUM(G 9, G 13, G 18) *If cells are not adjacent, separate them by commas. = SUM(A 9, B 13: B 18, G 10) *Arguments can contain cells, ranges, or numbers, separated by commas.

Do NOT Combine a Formula & Function WRONG: FORMULA = G 9 + G 13 + G 18 = SUM(G 9 + G 13 + G 18) FUNCTION *OR* = SUM(G 9, G 13, G 18) *If cells are not adjacent, separate them by commas.

Function List = 6 l l l 9 =SUM =COUNTA =AVERAGE =MAX =MIN