Savings Account Management and Excel Functions

Savings Account Management and Excel Functions

Assessment

Interactive Video

Mathematics

9th - 10th Grade

Hard

Created by

Thomas White

FREE Resource

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.

Read more

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the initial amount deposited into the savings account?

$100

$400

$200

$300

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Annually

Bi-weekly

Weekly

Monthly

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the annual interest rate for the savings account?

4%

5%

6%

7%

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How many times per year is the interest compounded?

4 times

6 times

12 times

24 times

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

PMT

FV

AVERAGE

SUM

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?