E-10 Final SJSU Exam Questions With Correct Answers

E-10 Final SJSU Exam Questions With
// // // // //




Correct Answers
// //




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 //- //correct //answer(s) //✔✔ //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) //- //correct //answer(s) //✔✔ //=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) //- //correct //answer(s) //✔✔ //=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 //- //correct
answer(s) //✔✔ //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 //- //correct //answer(s) //✔✔ //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 //- //correct //answer(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 //- //correct //answer(s) //✔✔ //1 //calorie
//




A //kilowatt-hour //is //a //unit //of //power.



True //

False //- //correct //answer(s) //✔✔ //False