Challenge Yourself $1\mathrm{.}4$

In this project you will work with a college budget spreadsheet. You will change a few values in the budget, modify number formats, and calculate totals and the difference between expected income and expenses. You will then create a new budget workbook from a template, and practice changing the zoom level and arranging the workbooks.

Skills needed to complete this project:

Working in Protected View $($Skill $1\mathrm{.}3)$

Entering and Editing Text and Numbers in Cells $($Skill $1\mathrm{.}4)$

Navigating a Workbook $($Skill $1\mathrm{.}2)$

Using AutoSum to Insert a SUM Function $($Skill $1\mathrm{.}13)$

Calculating Totals with the Quick Analysis Tool $($Skill $1\mathrm{.}14)$

Using the Status Bar $($Skill $1\mathrm{.}15)$

Applying Number Formats $($Skill $1\mathrm{.}5)$

Understanding Absolute and Relative References $($Skill $1\mathrm{.}11)$

Entering Simple Formulas $($Skill $1\mathrm{.}10)$

Checking Spelling $($Skill $1\mathrm{.}19)$

Using the Recommended Charts Feature $($Skill $1\mathrm{.}9)$

Exploring Charts $($Skill $1\mathrm{.}8)$

Creating a New Workbook Using a Template $($Skill $1\mathrm{.}17)$

Arranging Workbooks $($Skill $1\mathrm{.}18)$

Changing the Zoom Level $($Skill $1\mathrm{.}16)$