Skill Review $3\mathrm{.}2$

In this project you will edit a worksheet to compute student grades and grade statistics. Be sure to save your work often!

Skills needed to complete this project:

Using Date and Time Functions $($Skill $3\mathrm{.}5)$

Using CONCAT to Combine Text $($Skill $3\mathrm{.}9)$

Formatting Text Using Functions $($Skill $3\mathrm{.}7)$

Creating Formulas Using Counting Functions $($Skill $3\mathrm{.}6)$

Using Formula AutoComplete to Enter Functions $($Skill $3\mathrm{.}2)$

Displaying and Printing Formulas $($Skill $3\mathrm{.}22)$

Naming Ranges of Cells $($Skill $3\mathrm{.}12)$

Using the Logical Function IF $($Skill $3\mathrm{.}16)$

Using the Function Arguments Dialog to Enter Functions $($Skill $3\mathrm{.}1)$

Working with Named Ranges $($Skill $3\mathrm{.}13)$

Finding Minimum and Maximum Values $($Skill $3\mathrm{.}4)$

Calculating Averages $($Skill $3\mathrm{.}3)$

Finding Data Using the VLOOKUP Function $($Skill $3\mathrm{.}18)$

Finding Data Using the XLOOKUP Function $($Skill $3\mathrm{.}19)$

Checking Formulas for Errors $($Skill $3\mathrm{.}20)$