E-10 Final SJSU Test Questions with Correct Answers Latest Update 2025
If you drag cell C1 to cell C6, what will the answer be?
9
18
4
The question has an error. The $ shouldn't be there - Answers 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) - Answers =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) - Answers =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 - Answers 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 - Answers 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 - Answers 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 - Answers 1 calorie
A kilowatt-hour is a unit of power.
True
False - Answers 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 - Answers 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
If you drag cell C1 to cell C6, what will the answer be?
9
18
4
The question has an error. The $ shouldn't be there - Answers 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) - Answers =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) - Answers =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 - Answers 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 - Answers 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 - Answers 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 - Answers 1 calorie
A kilowatt-hour is a unit of power.
True
False - Answers 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 - Answers 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
