# 6 Week 2 Overview

Now that you have had experience building a spreadsheet, the next steps are to incorporate formulas that will quickly return the information you request.

In the Public Expenses by Quarter, you will learn to average string of numbers quickly. From a group of numbers, you will be able to find the largest and smallest number in just a few stokes as well as the ability to count how many numbers are in a column.

In the Sales Calculation, you will learn about Relative Referencing and Absolute Referencing.

### Learning Outcomes: The student will:

• Apply AVE, MAX, MIN, Count features
• Understand the difference between relative and absolute referencing
• Apply the absolute referencing to find “What If?”
• Understand the Order of Precedence when it comes to creating complex formulas

1. Public Expenses by Quarter. Student is introduced to new formulas, (AVE, MAX, MIN, COUNT) and these apply these formulas. (20 points)
2. Relative Referencing and Absolute Referencing: Read this informational
3. Sales Calculation. Developed a formula to answer the question “What If?” What if analysis is a decision-making tool in which data is changed and formulas ae recalculated, in order to predict various possible outcomes. (20 points)