WorksheetsAFDA Final 2021
Total questions: 43
Worksheet time: 10hrs 22mins
What is a Stock Market Index?
An industry or niche that sells stocks that are similar in nature as a bulk sale
A mathematical average that quickly tells us how the stock market is doing
A grouping of stocks that represent a corner of the economy
A mathematical average that quickly tells an investor how their stocks are performing
How many times per year does Bimonthly mean? Select all that could apply
6
12
24
2
Miss Decker earned $572 from tutoring last summer. She deposited this money in an account that pays an interest rate of 3.8% compounded monthly. What will be her balance after 15 years?
$827.52
$1011.64
$846.80
$1010.54
Selling stocks is almost like...
selling the slices of a pizza
rating the best pizza shops in your city
buying the ingredients to make a pizza
running a pizza shop
What is the APR for Visa Platinum Rewards card holders? (Click the magnifying glass to zoom and zoom in on your trackpad if necessary)
6.2%
8.2%
13.4%
18.15%
Miss Decker invests in a fund with a return interest rate of 17%. How long, in years, will it take her to double her money?
480 years
5.6 years
4.23 years
3.6 years
One thing that is a benefit of Excel over Google Sheets is...
the cloud save option
the cost
the fact that it is compatible with all computers
the powerful functionality
In spreadsheets, columns are labeled with
coordinates
letters
numbers
symbols
What lets a spreadsheet know that we are about to enter a formula?
a plus sign
the word "formula"
an equals sign
an opening parentheses
Name one benefit of a debit card.
They do not share your personal information with the company you are purchasing from.
Debit cards are accepted everywhere, even when credit cards are not.
Debit cards do not accrue interest.
Your identity cannot be stolen from a debit card.
This is the cost of borrowing money
Fees
Accrual
Investment
Interest
When you look into buying a stock, name the two things that would indicate that a stock is a good investment:
A high PE Ratio
A high EPS
A low PE Ratio
A low EPS
When you SHORT SELL a stock, you borrow the stock from a broker hoping that the stock price will
fluctuate
drop
rise
stay the same
If a company has a stock price of $5.35 and an EPS of $0.25, what is its PE Ratio?
20.2
21.4
2.14
1
APR stands for
Annual Participation Range
Annual Percentage Ratio
Annual Percentage Rate
Annual Perception Rate
True or false: an authorized user can make purchases on your credit card whether you approve them or not
True
False
True, but you can legally contest the charges
True, but you have to be present when the purchase occurs
True or false: You will pay less interest on purchases that you make toward the end of the month.
True
False
Select all of the following that are true about cash advances.
Cash advances often come with a fee and a higher interest rate.
Cash advances are considered high risk for credit card companies.
Cash advances cause an immediate negative impact on your credit score.
Cash advances come from your debit account.
Ideally, you should keep your credit usage to about
60% of your available credit
30% of your available credit
25% of your available credit
50% of your available credit
Usually, if your credit balance is paid off in 21 days, credit companies will not charge you interest. This time is referred to as the
Forgiveness period
Interest free period
Grace period
Free borrow period
Each individual set of coordinates (row and column) of a spreadsheet is known as a
cell
block
point
grid
What do hash symbols (###) mean in a spreadsheet?
The text in the cell was not translated properly
There are not enough data points in the sheet to run the desired formula
More numbers are needed to complete this calculation
There is an error with the input, output, or formula
What does a credit card represent? Check all that apply
Unlimited free money
A small loan
A line of credit
A mortgage
Select all of the topics that we have covered in class so far
Credit/Credit Cards
Spreadsheet formatting
Mortgages
Stocks/Stock Market
Spreadsheet formulas
What is debt?
Another word for death
Something, typically money, that is owed or due
A loan on which you do not have to pay interest
That which is incurred during childhood and consummated in college
What is a credit score?
a number between 300 and 850 representing your creditworthiness
a statistical number that evaluates a consumer's creditworthiness and is based on credit history.
Often referred to as a FICO score
All of the above
What is a credit report?
A detailed report of an individual's credit history prepared by a credit bureau and used by a lender in determining a loan applicant's creditworthiness
A detailed report of a bank's credit history prepared by a credit expert and used by consumers in determining a bank's creditworthiness
A report which shows which credit cards are better than others
A report invented by Allan Greenspan and credited to Al Gore
Which of the following is one of the 3 nationally recognized credit bureaus?
Equifax
Federal Reserve
Postal Credit
TripleUnion
Paying my bills late could negatively affect my credit history.
True
False
Your housing cost should make up what percent of your monthly income?
About 30%
About 50%
About 90%
About 20%
Select the "needs" below
Clothing
A high-end vehicle
Housing
Food and water
The latest fashion trends
What is the LEAST secure form of payment?
Cash
Credit Card
Debit Card
Check
True or false: Going into the stock market is a guaranteed investment.
True
False
Select all of the costs associated with owning a car
Car loan payment
Maintenance
Fuel
Escrow
Insurance
Jessica is a social media business consultant for large corporations. Her job involves traveling to various countries and moving from place to place often. Select the best choices for Jessica based on this information.
Buying an affordable home in the country
Renting an apartment with a short-term lease
Buying a high-end car
Using public transport, Uber, or Lyft
______________ insurance provides financial protection against overwhelming medical expenses
Health
Car
Comprehensive
Medical
John is over budget. He has to cut costs somewhere. Which would be easiest for John to change to save money?
Entertainment
Housing
Health Insurance
Car payments
