After completing this chapter, you will be able to: SLO 2.1 | Create and edit basic formulas. | SLO 2.2 | Use range names and relative, absolute, and mixed cell references in a formula. | SLO 2.3 | Apply mathematical order of operations when using parentheses, exponents, multiplication, division, addition, and subtraction. | SLO 2.4 | Use AutoSum and other common functions such as AVERAGE, COUNT, MAX, MIN, TODAY, and NOW. | SLO 2.5 | Apply financial, logical, and lookup functions such as PMT, IF, VLOOKUP, and HLOOKUP. | SLO 2.6 | Apply math and trigonometry functions such as SUMIF, SUMPRODUCT, and ROUND. |
|