Chapter 14 Engineering Fundamentals:
An Introduction to Engineering
1. A spreadsheet is divided into
a. lines and spaces.
b. rows and columns.
c. inputs and outputs.
d. problems and solutions.
Analysis:
2. Spreadsheets can be used to
a. record, organize, and analyze data using formulas.
b. evaluate mathematical, statistical, and logical functions.
c. plot the results of engineering analysis.
d. all of the above
Analysis:
3. In a spreadsheet, the _________ contains the name of the current active workbook.
a. title bar
b. active cell
c. column header
d. status bar
Analysis:
4. In a spreadsheet, the _________ contains push buttons (icons) that execute commands used by
Excel.
a. title bar
b. active cell
c. column header
d. toolbar
Analysis:
5. A worksheet is a spreadsheet file that you create and save whereas a workbook represents the
rows and columns where you input information.
a. True
b. False
6. In a spreadsheet, rows are marked with letters (A, B, C, etc.) while columns are marked with
numbers (1, 2, 3, etc.)
a. True
b. False
7. The intersection of a single row and a single column is called a(n)
a. data point.
b. data entry.
c. cell.
d. input.
]
Engineering Fundamentals, 5th ed. Chapter 14
Saeed Moaveni
Analysis:
8. Which of the following keys will select the edit mode?
a. F1
b. F2
c. F3
d. F4
Analysis:
9. A number of cells that are selected simultaneously is called a
a. group.
b. multi-cell.
c. range.
d. cartel.
Analysis:
10. In Excel, a formula always begins with
a. an equal sign (=).
b. an apostrophe (‘).
c. a plus sign (+).
Engineering Fundamentals, 5th ed. Chapter 14
Saeed Moaveni
d. an asterisk (*).
Analysis:
11. If you were to type the following into a cell, what would the result be in Excel?
54*32
a. 25
b. 45
c. 19
d. 20
Analysis:
12. If you were to type the following into a cell, what would the result be in Excel?
54*32
a. 25
b. 45
c. 19
d. 20
Analysis:
13. Which is the correct way to enter the following mathematical operation into Excel?
6
38
2
3
2
a. =2+3/2+8-3/6
b. =2+(3/2)+8-3/6
c. =2+3/2+(8-3)/6
d. =2+(3/2)+(8-3/6)
Analysis:
14. Which of the following is the correct entry for an absolute cell reference?
a. C4
b. *C4
c. $C$4
d. *C*4
Analysis:
15. Which of the following is the correct entry for a relative cell reference?
a. C4
b. $C4
c. $C$4
d. *C*4
Engineering Fundamentals, 5th ed. Chapter 14
Saeed Moaveni
Analysis:
16. Which of the following Excel functions will calculate the mean value of the data in cells A1
through A9?
a. =AVG(A1:A9)
b. =AVE(A1:A9)
c. =AVERAGE(A1:A9)
d. =MEAN(A1:A9)
Analysis:
17. Which of the following Excel functions will correctly calculate the square root of the value in
cell A1?
a. =SQUARE_ROOT(A1)
b. =SQUAREROOT(A1)
c. =SQUARE_RT(A1)
d. =SQRT(A1)
Analysis:
18. Which of the following Excel functions will correctly calculate the cosine of the value in cell
A1?
a. =COSINE(A1)
b. =COS(A1)
19. The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell
A1 must be in degrees.
a. True
b. False
20. Functions that allow you to test various conditions when programming formulas to analyze
data are known as
a. logical functions.
b. conditional functions.
c. analytical functions.
d. test functions.
Analysis:
21. As an engineer, most of the charts that you will create will be of which type?
a. column charts
b. pie charts
c. line charts
d. xy charts
Analysis:
Engineering Fundamentals, 5th ed. Chapter 14
Saeed Moaveni
22. Two sets of data with different ranges can be plotted on the same chart.
a. True
b. False
23. A physical variable that is identifiable by either a single value or magnitude is known as a
a. number.
b. matrix.
c. scalar.
d. vector.
Analysis:
24. A physical variable that possesses both magnitude and direction is known as a
a. number.
b. matrix.
c. scalar.
d. vector.
Analysis:
25. An array of numbers, variables, or mathematical terms is known as a
Engineering Fundamentals, 5th ed. Chapter 14
Saeed Moaveni
a. list.
b. matrix.
c. scalar.
d. vector.
Analysis:
26. The Excel formula =MINVERSE(A1:C3) will calculate
a. the minimum number of verses in the range A1 through C3.
b. the smallest value in the range A1 through C3.
c. the inverse of the matrix in range A1 through C3.
d. none of the above
Analysis:
27. The Excel formula =MMULT(A1:C3, E1:E3) will calculate
a. the number of multiples found in the ranges A1 through C3 and E1 through E3.
b. the smallest value in the ranges A1 through C3 and E1 through E3.
c. the largest value in the ranges A1 through C3 and E1 through E3.
d. the product of the matrices in ranges A1 through C3 and E1 through E3.
Analysis:
28. Finding an equation that best fits a set of data is known as
a. an analytical solution.
b. a graphical solution.
c. an approximate solution.
d. curve fitting.
Analysis:
29. Which of the following can you insert into a spreadsheet in Excel?
a. cells
b. columns
c. rows
d. all of the above
Analysis: