Font size
WorksheetsComputer Math Final 2021
Total questions: 55
Worksheet time: 14hrs 45mins
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 Semimonthly mean?
20
12
24
2
One thing that is a downside of Excel over Google Sheets is...
the cell capacity
the cost
the local save option
the powerful functionality
What is the APR for Visa Gold 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 earned $475 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
$839.45
$846.80
$839.17
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
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
True or false: You will pay less interest on purchases that you make toward the end of the month.
True
False
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
The most common way to leverage a computer's memory is by creating a...
Variable
Constant
App
Program
Read the following line of code and decide what would be displayed on the screen.
var score;
score=100
write("score")
the word score
the value 100
Which of the following are types of loops?
For
While
Do
Do while
Infinite/Endless
When will this code finish?
When y-position equals equals 399
When y-potion is greater than 400
When the variable is greater than 400
When the text is rewritten out
In the following code, what would be the resulting value of newScore?
var score=500;
var newScore;
newScore=score+100;
100
600
500
1
In the following code, what would b end up equaling?
var a=2;
var b=2;
a=a+b;
b=a+b;
2
4
6
8
Why would the value of b be different than the value of a in the code?
*Code is identical to previous question
var a=2;
var b=2;
a=a+b;
b=a+b;
Because a's value was reassigned before b was run.
Because b's value was improperly reassigned.
Because a is in a different variable sector than b.
Because a is an odd number, so b must be even
What is a loop?
A loop without conditions
A loop with an if statement
In computer programming, a loop is an order of instructions that repeats for many times
What will this gate's output be?
0
1
What will this gate's output be?
0
1
Which logic gate represented by this symbol?
OR
XNOR
XOR
NAND
Which logic gate is represented by this truth table?
What is the final output (y) of this circuit if A is 1, B is 1, and C is 0?
True (1)
False (0)
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
Miss Decker invests in a fund with a return interest rate of 15%. How long, in years, will it take her to double her money?
480 years
5.6 years
4.8 years
3.6 years
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
If a company has a stock price of $3.33 and an EPS of $0.165, what is its PE Ratio?
20
10
2
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
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
You invest $1600 at an annual interest rate of 4.6% compounded continuously. How much will you have in the account after 4 years.
$800.26
$10,138.07
$6,701.28
$1,923.23
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
A variable is just a _____ for storing a____
constant; value
container; value
constant; variable
container; variable
Which of the following are examples of variables in a video game code?
character
score
lives
map
What word signals to the computer that you are about to create a variable?
var
con
=
score
Order when creating variables is important. The label must appear on the ____and the value must appear on the ____
left; right
right; left
What is it called when a programmer creates and assigns a variable in the same step?
Initializing the variable
Integrating the variable
Entering the variable
Evaluating the variable
What are the three questions you need to ask yourself when creating a loop?
What do I want to repeat each time?
How often do I want it repeated?
What value do I want to change each time?
When do I want to stop looping?
What does a loop break statement do?
Terminates the loop after a certain number of iterations
Terminates the loop immediately
Pauses the loop cycle
Changes the loop after a certain number of iterations
What are some benefits of loops?
They clean up the code so that code does not need to be reiterated
They speed up the coding process
They make the code more confusing so that hackers cannot change the code
They keep code encrypted for data protection
What signifies the end of a loop code?
a curly bracket }
A parentheses )
A period .
A semicolon ;
What will this gate's output be?
0
1
Which logic gate represented by this symbol?
OR
NOR
XOR
NOT
Which logic gate is represented by this truth table?
Solve the circuit if a is 1, B is 0, and C is 0
True (1)
False (0)
