80 likes | 223 Views
Excel Core Objective 5: Applying Formulas and Functions. Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice. Story/Walls. Create Formulas. Mouse and Keyboard Methods: Use basic operators Revise formulas. 2. Enforce Precedence. Ribbon Methods:
E N D
Excel Core Objective 5: Applying Formulas and Functions Microsoft Office 2010 Certification Prep: Microsoft Office Specialist 2010 Exam Practice Story/Walls
Create Formulas • Mouse and Keyboard Methods: • Use basic operators • Revise formulas MOS 2010 Excel Expert Objective 5 2
Enforce Precedence • Ribbon Methods: • Order of evaluation • Precedence using parentheses • Precedence of operators for percent vs. exponentiation MOS 2010 Excel Expert Objective 5 3
Apply Cell References in Formulas • Shortcut Methods: • Use relative references • Use absolute references • Use mixed references in formulas MOS 2010 Excel Expert Objective 5 4
Apply Conditional Logic in a Formula • Ribbon and Mouse Methods: • Create a formula with values that match conditions MOS 2010 Excel Expert Objective 5 5
Apply Conditional Logic in a Formula (cont.) • Ribbon and Mouse Methods: • Edit defined conditions in a formula • Use a series of conditional logic values in a formula MOS 2010 Excel Expert Objective 5 6
Apply Named Ranges in Formulas • Ribbon and Shortcut Methods: • Define ranges in formulas • Edit ranges in formulas • Rename a named range MOS 2010 Excel Expert Objective 2 7
Apply Cell Ranges in Formulas • Ribbon, Mouse, and Shortcut Methods: • Enter a cell range definition in the formula bar • Define a cell range MOS 2010 Excel Expert Objective 5 8