Site MapHelpFeedbackWorking with Formulas and Functions
Working with Formulas and Functions


After completing this chapter, you will be able to:

SLO 2.1Create and edit basic formulas.
SLO 2.2Use range names and relative, absolute, and mixed cell references in a formula.
SLO 2.3Apply mathematical order of operations when using parentheses, exponents, multiplication, division, addition, and subtraction.
SLO 2.4Use AutoSum and other common functions such as AVERAGE, COUNT, MAX, MIN, TODAY, and NOW.
SLO 2.5Apply financial, logical, and lookup functions such as PMT, IF, VLOOKUP, and HLOOKUP.
SLO 2.6Apply math and trigonometry functions such as SUMIF, SUMPRODUCT, and ROUND.
"Check For Understanding" quizzes available in the drop-down menu.










Nordell, 1eOnline Learning Center

Home > Excel > Chapter 2