Font size
WorksheetsCOMP 312 - Midterm Exam
Total questions: 40
Worksheet time: 27mins
Which Excel function is used to find the highest value in a data range?
MIN
MAX
AVERAGE
COUNT
What is the purpose of using the IF function in Excel?
To find the total number of cells
To calculate totals
To perform a logical test and return a value based on TRUE or FALSE
To sort data alphabetically
A Mechanical Engineer uses Excel to calculate stress (σ = F/A) for multiple samples. Which Excel formula is correct if Force is in column B and Area in column C?
=C2/B2
=B2*C2
=B2/C2
=A2/B2
Which function can be used to compute the average temperature reading from cell range B2:B20?
=MEAN(B2:B20)
=AVERAGE(B2:B20)
=AVG(B2:B20)
=TOTAL(B2:B20)/COUNT(B2:B20)
Which of the following software is commonly used in Mechanical Engineering for 3D modeling and simulation?
Microsoft Excel
AutoCAD
SolidWorks
MathLab
Why is Microsoft Excel important in Mechanical Engineering?
It replaces design software
It helps in complex numerical calculations, data analysis, and reporting
It is used only for making presentations
It is not applicable in engineering
Which Excel feature is best for summarizing large data like material test results by categories (e.g., metal type, thickness)?
Charts
Pivot Tables
Conditional Formatting
Data Validation
What Excel function is used to add values in cells D2:D10 only if corresponding C2:C10 equals “Steel”?
=SUM(D2:D10)
=SUMIF(C2:C10, "Steel", D2:D10)
=IF(C2:C10="Steel", D2:D10)
=AVERAGEIF(C2:C10, "Steel", D2:D10)
In Excel, what is the intersection of a row and a column called?
Range
Worksheet
Cell
Table
What is a range in Excel?
A single value
A group of adjacent cells
A column header
A worksheet name
What is the shortcut to save a workbook?
Ctrl + N
Ctrl + S
Ctrl + P
Ctrl + Shift + S
What is the maximum number of columns in modern Excel versions (Excel 2016 or later)?
65,536
1,048,576
16,384
256
Which shortcut allows you to move to the beginning of a worksheet (cell A1)?
Ctrl + A
Ctrl + Home
Ctrl + End
Alt + Home
Which part of Excel allows you to enter or edit data or formulas in a cell?
Ribbon
Formula Bar
Status Bar
Title Bar
Which formula correctly computes the Stress (MPa) for each specimen?
=C2*D2
=D2/C2
=C2/D2
=SUM(C2:D2)
Which function can be used to find the maximum stress among all specimens?
=MAX(E2:E11)
=D2/C2=AVERAGE(E2:E11)
=C2/D2=MIN(E2:E11)
=IF(E2:E11>400)
What is the formula to return the average elongation (%) of all specimens?
(a)
What is the formula that identifies the minimum force applied among the specimens?
(a)
If you want to find the total force applied to all Aluminum specimens, which formula is correct?
=SUMIF(B2:B11,"Aluminum",C2:C11)
=AVERAGEIF(B2:B11,"Aluminum",C2:C11)
=SUMIFS(C2:C11,B2:B11,"Aluminum")
=SUM(B2:B11,"Aluminum",C2:C11)
Which function computes the average stress of Steel specimens only?
=AVERAGE(E2:E11)
=SUMIFS(E2:E11,B2:B11,"Steel")
=AVERAGEIF(B2:B11,"Steel",E2:E11)
=IF(B2="Steel",AVERAGE(E2:E11))
Which Excel feature would you use to summarize average stress per material type?
Sort
Pivot Table
Filter
Chart
In a Pivot Table showing Technician vs. Average Stress, the field “Technician” should be placed in which area?
Values
Columns
Rows
Filters
Which function can determine how many tests were conducted by “John”?
=COUNTIF(H2:H11,"John")
=IF(H2:H11="John")
=SUMIF(H2:H11,"John")
=COUNT(H2:H11,"John")
If you want to determine whether the Stress value exceeds 450 MPa, which formula is correct?
=IF(E2>450,"High","Normal")
=IF(E2=450,"High","Normal")
=IF(E2<450,"High","Normal")
=IF(E2>=450,"Normal","High")
Which formula will compute the average flow rate of all pumps?
=SUM(C2:C11)/10
=AVERAGE(C2:C11)
=MAX(C2:C11)
=COUNT(C2:C11)
Which function gives the maximum pressure recorded among all pumps?
=MIN(D2:D11)
=AVERAGE(D2:D11)
=MAX(D2:D11)
=COUNT(D2:D11)
Which function correctly finds the average efficiency of Plant D?
=AVERAGE(F2:F11)
=AVERAGEIF(B2:B11,"Plant D",F2:F11)
=SUMIF(B2:B11,"Plant D",F2:F11)
=COUNTIF(B2:B11,"Plant D")
Which formula will return “High Efficiency” if the value in F2 is greater than or equal to 85, otherwise “Normal”?
=IF(F2>=85,"High Efficiency","Normal")
=IF(F2<85,"High Efficiency","Normal")
=IF(F2=85,"Normal","High Efficiency")
=IF(F2>85,"Normal","High Efficiency")
To find the average Power Input (kW) of all pumps, use the function (a) .
To determine the highest efficiency (%), use the formula (a) .
In Excel, to get the total Maintenance Cost across all plants, the function used is (a) .
Based on the given dataset, What is the output of =SUM(D2:D21)?
(a)
Based on the given dataset, What is the output of =MAX(D2:D21)?
(a)
Based on the given dataset, What is the highest maintenance cost?
(a)
Based on the given dataset, What is the total Power Input in Plant A?
(a)
What is the total Budget allocated for all flood control projects?
(a)
What is the total Actual Cost for projects handled by AquaBuild Construction?
(a)
How many projects were completed "On Schedule"?
(a)
What is the highest project budget among all entries?
(a)
What is the total budget of projects managed by RiverSafe Engineering?
(a)
