COMP 312 - Midterm Exam

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