Font size
WorksheetsQR Midterm Review
Total questions: 25
Worksheet time: 11mins
A mixed cell reference that holds the row looks like......
C3
$C$3
C$3
$C3
Pick the correct equation for SUM
=SUM(C3+C13)
=SUM(C3:C13)
=SUM(C3/C13)
=SUMC3+SUMC13
The function INT does what in Excel?
Rounds the answer to two decimal places
Rounds the answer to the integer
Truncates the answer to two decimal places
Truncates the answer to the integer
$C$3 is called
mixed cell reference
absolute cell reference
cell reference
max
Pick the correct formula to find the Heart Rate (cell C9)
=(220-C8)*0.70
=(220-C8)*70
= 220 - C8*70
=(220-C9)*C8
What formula do you use to find the value in E15?
=ADD(E4+E13)
=AVG(E4:E13)
=SUM(E4:E13)
=SUM(E4+E13)
Pick all equations that would solve for F9?
=C9*F$11/C$11
=C9/C$11
=F$11*C9/C$11
=F$11*C9/F$9
The input is the ____________ variable.
dependent
independent
A 1 to 1 function has
one input, many outputs
many inputs, many outputs
many inputs, one output
one input, one output
Principal is
amount of money paid back in a loan.
profit from a sale.
money borrowed from a lender.
amount of time you borrow money.
Pick all that are correct:
Types of Ratios
part to part
part to whole
whole to whole
The ratio of Iphones:cell phones is
part to part
part to whole
Numbers typically used for scale
10
100
1
.10
What are the weights in the following problem:
You buy 4 children's tickets at $5 and 7 adult tickets at $10.
4 and 7
5 and 10
4, 5, 7 and 10
none of them
What type of proportion equation is this:
y = k/x
direct proportion
indirect proportion
Is the following proportional:
population of math class: area of campus
Yes
No
Is the following proportional:
you IQ: your Age
Yes
No
What is a PE Ratio?
An activity in gym class
How to buy a stock
Price of stock/earnings of the stock
One share of stock
The ratio 32 degrees F to 32 degrees C is what type of ratio?
Interval units
ratio units?
Convert 1 kg to mg
100mg
1000mg
10,000 mg
1,000,000mg
Convert 123456 inches to miles
1.95 miles
0.52 miles
280.6 miles
10288 miles
Model scale can
have units
be unitless
have units or be unitless
be divided by zero
T or F. Dosage is the ratio of the amount of medication to the weight of the patient.
True
False
T or F. Rate does not use per in it.
True
False
This review is what the midterm will be like.
Yes, this is a review sheet.
No, this is just to guide you.
Hopefully some of the questions will be similar.
Help!! I am lost by this and need to ask questions!
