Savings Account Management and Excel Functions

This tutorial by Sister Jensen for Math 100g guides students through exercises 11 and 12 of section 4.1, focusing on creating a savings plan using Excel. It covers setting up Excel with category headings, calculating future value with formulas, automating calculations for 20 years, and creating a line graph to visualize savings growth. The tutorial emphasizes practical application for a portfolio project, encouraging students to create a realistic savings plan.

What is the main purpose of the tutorial presented by Sister Jensen?

• To teach basic Excel skills

• To help with a specific math problem

• To introduce a new math topic

• To provide a general overview of math 100G

What is the first step Sister Jensen takes in Excel for the savings account exercise?

• Calculating interest

• Typing category headings

• Creating a graph

• Entering formulas

What is the initial amount deposited into the savings account?

• $100

• $400

• $200

• $300

How often is the $25 deposit made into the savings account?

• Annually

• Bi-weekly

• Weekly

• Monthly

What is the annual interest rate for the savings account?

• 4%

• 5%

• 6%

• 7%

How many times per year is the interest compounded?

• 4 times

• 6 times

• 12 times

• 24 times

Which Excel function is used to calculate the future value of the savings account?

• PMT

• FV

• AVERAGE

• SUM

What is the future value of the savings account at the end of one year?

• $560.72

• $540.72

• $520.72

• $500.72

What is the purpose of dragging the formula down in Excel?

• To change its color

• To delete it

• To move it to another sheet

• To apply it to multiple cells

What type of graph is used to visualize the savings growth over time?

• Bar graph

• Pie chart

• Scatter plot

• Line graph