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

Savings Account Management and Excel Functions

Interactive Video
•
Mathematics
•
9th - 10th Grade
•
Hard

Thomas White
FREE Resource
Read more
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Similar Resources on Wayground
10 questions
Understanding Charts and Graphs in Excel

Interactive video
•
9th - 10th Grade
11 questions
Understanding Compound Interest and Graphing with Desmos

Interactive video
•
9th - 12th Grade
11 questions
Understanding Linear Relationships in Graphs

Interactive video
•
9th - 10th Grade
11 questions
Recursive and Explicit Geometric Rules

Interactive video
•
9th - 10th Grade
11 questions
Exponential Growth in Savings Accounts

Interactive video
•
9th - 10th Grade
11 questions
Understanding Domain in Exponential Functions

Interactive video
•
9th - 10th Grade
10 questions
Interest Calculations and Investment Concepts

Interactive video
•
9th - 10th Grade
11 questions
Exponential Functions and Their Applications

Interactive video
•
9th - 10th Grade
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade