Productivity & Collaboration Tools     Microsoft Office 2010     Excel 2010     Microsoft Office 2010: Beginning Excel (No Assessments)

---

The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.

---

---

Objectives

Excel 2010: Basic Formulas Inserting a formula using the function library Performing simple calculations Using automated formulas in a table Creating automated cumulative totals Inserting subtotals Counting cells in a range Ranking a value round numbers in Excel 2010 use replacement formulas in Excel 2010 convert number types in Excel 2010 factorize the results of a division in Excel 2010 use formulas to generate random values in Excel 2010