E-10 Final SJSU questions and
answers
If you drag cell C1 to cell C6, what will the answer be?
9
18
4
✔✔9
An inventory of parts in the ENGR 10 lab is shown in the figure.
To calculate the total number of parts in the inventory what equation would you wirte
in cell B8?
sum(b2:b7)
b2+b3+b4+b5+b6+b7
=sum(b2:b7)
=sum(b2:b8)
=sum(b2,b7)✔✔=sum(b2:b7)
The specifications for a product you are developing require that the cross-sesction
area cannot be greater than 12 in2. You have summarized the dimensions of 5
prototypes you have made. Column D has an equation to determine if your product
meets spcifications. It indicates that only specimen #5 meets the specifications.
What is the equation in cell D5?
=IF(B5*C5<12, "No","Yes")
=IF(B5*C5>12, No,Yes)
=IF(B5*C5>12, "No","Yes")
=IF(B5*C5<12, No,Yes)✔✔=IF(B5*C5>12, "No","Yes")
A student performed an experiment to determine the relationship between speed and
fuel economy (mpg). Excel created the plot shown below using the "chart wizard".
What would you do to improve this plot?
Check all answers that apply.
Delete the plot legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot✔✔Delete the plot
legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot
, In fitting a curve to data points, Excel provides a correlation value known as R2. The
range for the R2 value is:
0 to 100%
0 to 1
0 to 100
-1 to +1✔✔0 to 1
In the lab you measreed a wind speed of 20 mph on your turbine. Convert this to
m/s.
536 m/s
32,200 m/s
8.9 m/s
44.8 m/s✔✔8.9 m/s
What unit does the sentence below define?
"amount of energy required to change temperature of one gram of liquid water by
one degree Celsius"
1 Watt
1 Joule
1 calorie
1 kW-hr
1 Calorie✔✔1 calorie
A kilowatt-hour is a unit of power.
True
False✔✔False
Which of the following heaters can heat up a gallon of water from 10oC to 100oC
faster?
90 W heater
5 W heater
Insufficient information
All heaters listed will take the same amount of time
100 W heater✔✔100 W heater
A student weighs 140 lb. This student is able to run up to the 3rd floor in 20 seconds.
The 3rd floor is 10 meters above the ground floor.
Which of the following values is closest to the average power this student exerted in
climbing the stairs?
310 W
280 W
answers
If you drag cell C1 to cell C6, what will the answer be?
9
18
4
✔✔9
An inventory of parts in the ENGR 10 lab is shown in the figure.
To calculate the total number of parts in the inventory what equation would you wirte
in cell B8?
sum(b2:b7)
b2+b3+b4+b5+b6+b7
=sum(b2:b7)
=sum(b2:b8)
=sum(b2,b7)✔✔=sum(b2:b7)
The specifications for a product you are developing require that the cross-sesction
area cannot be greater than 12 in2. You have summarized the dimensions of 5
prototypes you have made. Column D has an equation to determine if your product
meets spcifications. It indicates that only specimen #5 meets the specifications.
What is the equation in cell D5?
=IF(B5*C5<12, "No","Yes")
=IF(B5*C5>12, No,Yes)
=IF(B5*C5>12, "No","Yes")
=IF(B5*C5<12, No,Yes)✔✔=IF(B5*C5>12, "No","Yes")
A student performed an experiment to determine the relationship between speed and
fuel economy (mpg). Excel created the plot shown below using the "chart wizard".
What would you do to improve this plot?
Check all answers that apply.
Delete the plot legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot✔✔Delete the plot
legend because there is only one set of data
Add a label to the x axis
Add a label to the y axis
Modify the plot title so it more clearly explains what is in the plot
, In fitting a curve to data points, Excel provides a correlation value known as R2. The
range for the R2 value is:
0 to 100%
0 to 1
0 to 100
-1 to +1✔✔0 to 1
In the lab you measreed a wind speed of 20 mph on your turbine. Convert this to
m/s.
536 m/s
32,200 m/s
8.9 m/s
44.8 m/s✔✔8.9 m/s
What unit does the sentence below define?
"amount of energy required to change temperature of one gram of liquid water by
one degree Celsius"
1 Watt
1 Joule
1 calorie
1 kW-hr
1 Calorie✔✔1 calorie
A kilowatt-hour is a unit of power.
True
False✔✔False
Which of the following heaters can heat up a gallon of water from 10oC to 100oC
faster?
90 W heater
5 W heater
Insufficient information
All heaters listed will take the same amount of time
100 W heater✔✔100 W heater
A student weighs 140 lb. This student is able to run up to the 3rd floor in 20 seconds.
The 3rd floor is 10 meters above the ground floor.
Which of the following values is closest to the average power this student exerted in
climbing the stairs?
310 W
280 W
