1. 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
2. A spreadsheet is divided into
a. lines and spaces.
b. rows and columns.
c. inputs and outputs.
d. problems and solutions.
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
4. Active cell refers to a specific selected cell.
a. True
b. False
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
a. data point
b. data entry
c. cell
d. input
8. Visual Basic for Applications (VBA) is a programming language that allows you to use Excel
more effectively.
a. True
b. False
9. A number of cells that are selected simultaneously is called a
a. group
b. multi-cell
c. range
d. cartel
10. In Excel, a formula always begins with
a. an equal sign (=).
b. an apostrophe (‘).
c. a plus sign (+).
d. an asterisk (*).
11. If you were to type the following into a cell, what would be the result in Excel?
( )
54*32 ++=
a. 25
b. 45
c. 19
d. 20
12. If you were to type the following into a cell, what would be the result in Excel?
( )
54*32 ++=
a. 25
b. 29
c. 19
d. 20
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)
14. What are the three ways that you can refer to a cell address in a formula?
_____________
_____________
_____________
15. Which of the following is the correct entry for an absolute cell reference?
a. C4
b. *C4
c. $C$4
d. *C*4
16. Which of the following is the correct entry for a relative cell reference?
a. C4
b. $C4
c. $C$4
d. *C*4
17. The mixed cell reference could be done in one of two ways: (1) You can keep the column as
absolute (unchanged) and have a relative row, or (2) you can keep the row as absolute and have a
relative column.
a. True
b. False
18. The Excel functions are grouped into various categories, including mathematical and
trigonometric, engineering, statistical, financial, and logical functions.
a. True
Test Bank Engineering Fundamentals, 5th ed. Chapter 14
b. False
19. 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)
20. 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)
21. Which of the following Excel functions will correctly calculate the cosine of the value in cell
A1?
a. =COSINE(A1)
b. =COS(A1)
22. 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
23. Which of the following Excel functions will automatically update the date and time the file
was last used?
a. =LAST_MODIFIED
b. =TODAY
c. =CURRENT
d. none of the above
24. In Excel, 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.
25. If cell A3 contains the value of 74, and if you were to type the following command in cell B3
=IF(A3>60,”PASS”,”FAIL”), what would be the result?
a. 74
b. 60
c. PASS
d. FAIL
26. 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
27. In Excel, two sets of data with different ranges can be plotted on the same chart.
Test Bank Engineering Fundamentals, 5th ed. Chapter 14
a. True
b. False
28. 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.
29. A physical variable that possesses both magnitude and direction is known as a
a. number.
b. matrix.
c. scalar.
d. vector.
30. An array of numbers, variables, or mathematical terms is known as a
a. list.
b. matrix.
c. scalar.
d. vector.
31. The Excel formula =MINVERSE(B1:D3) will calculate
a. the inverse of each value in the range B1 through D3.
b. the smallest value in the range B1 through D3.
c. the inverse of the matrix in range B1 through D3.
d. none of the above.
32. 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 multitude of values 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.
33. 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.
34. You can use Excel’s build-in function in VBA.
a. True
b. False
35. A simple way to learn about the VBA’s object-oriented commands and syntax is by using the
Record Macro option.
a. True
b. False
36. In VBA, the following statement
Sub temperature_conversion()
will starts the subroutine and names it
a. temperature
b. conversion
c. temperature_conversion
d. none of the above
Test Bank Engineering Fundamentals, 5th ed. Chapter 14
37. In VBA, the End Sub statement ends the subroutine.
a. True
b. False
38. In VBA, the statement Cells(1, 1) = “x values” will write
a. the value of x in the cell located in Row 1 and Column A
b. the text “x values” in the cell located in Row 1 and Column A
c. the text “x values” in all the cells in Row 1
d. none of the above
39. In VBA, the statement Range(“A1,A6”).Activate will
a. activate cells A1 through A6
b. write the text “Activate” in A1 and A6 cells
c. activate cells A1 and A6 only
d. none of the above
40. In VBA, the following statement
Average_Density = Application.WorksheetFunction. Average(Range(“B5:B15”))
will select the “Average”, a built-in function of Excel, to calculate the average of density
values in cells B5 through B15 and assigns the result to the variable Average_Density
a. True
b. False