ENGR 133 MIDTERM NEWEST ACTUAL 2025/2026 QUESTIONS AND VERIFIED ANSWERS

ENGR 133 MIDTERM NEWEST ACTUAL 2025/2026 QUESTIONS
AND VERIFIED ANSWERS.




how to do a percent in excel (what is 20% of 30?) - ----
Answers---20%*30


what excel function will keep count of the number of cells in a
range of numbers? - ----Answers---COUNT()


what excel function returns the smallest number in a set of
values - ----Answers---MIN()


what excel function returns the largest number in a set of
values - ----Answers---MAX()


what excel function returns the mean of a set of values - ----
Answers---AVERAGE()


what excel function returns the middle number in a set of
values - ----Answers---MEDIAN()


what excel function returns the variance of a set of values - --
--Answers---VAR.P()


what excel function returns the standard deviation of a set of
values - ----Answers---STDEV()

, what excel function returns the way the graph will tilt towards
(-/+) - ----Answers---SKEW()


on a truth table, what value is assigned to T and what value is
assigned to F - ----Answers---T=1, F=0


what excel function sorts the numbers of a list in numerical
order - ----Answers---____________.sort()


what is the difference between tuple and set - ----Answers---
tuple values CANT be changed


why do we use functions in coding - ----Answers---if you
want to perform similar tasks repetitively, functions make it
easier


when does variance increase? - ----Answers---if data points
are further from mean/ spread out from the mean or if there is
a skewed distribution


What is the forming stage of team development? - ----
Answers---when the group first meets each other and they
share personal information