Deck 14: Computational Engineering Tools: Electronic Spreadsheets

Question 1

Which of the following Excel functions will correctly calculate the cosine of the value in cell A1?

Answer 1

B

Question 2

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

Answer 2

D

Question 3

Which of the following Excel functions will calculate the mean value of the data in cells A1 through A9?

Answer 3

C

Question 4

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.

Question 5

In Excel, a formula always begins with

Question 6

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

Question 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.

Question 8

Which of the following Excel functions will correctly calculate the square root of the value in cell A1?

Question 9

Which is the correct way to enter the following mathematical operation into Excel?

Question 10

A spreadsheet is divided into

A) lines and spaces.
B) rows and columns.
C) inputs and outputs.
D) problems and solutions.

Question 11

A number of cells that are selected simultaneously is called a

A) group.
B) multi-cell.
C) range.
D) cartel.

Question 12

If you were to type the following into a cell, what would the result be in Excel? $= ( 2 + 3 * 4 + 5 )$

A) 25
B) 45
C) 19
D) 20

Question 13

In a spreadsheet, the _________ contains the name of the current active workbook.

A) title bar
B) active cell
C) column header
D) status bar

Question 14

Which of the following is the correct entry for a relative cell reference?

Question 15

The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell
A1 must be in degrees.

Question 16

If you were to type the following into a cell, what would the result be in Excel? $= 2 + 3 * ( 4 + 5 )$

A) 25
B) 45
C) 19
D) 20

Question 17

In a spreadsheet, rows are marked with letters (A, B, C, etc.) while columns are marked with
numbers (1, 2, 3, etc.)

Question 18

A worksheet is a spreadsheet file that you create and save whereas a workbook represents the
rows and columns where you input information.

Question 19

Which of the following is the correct entry for an absolute cell reference?

Question 20

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

Question 21

An array of numbers, variables, or mathematical terms is known as a

A) list.
B) matrix.
C) scalar.
D) vector.

Question 22

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.

Question 23

A physical variable that possesses both magnitude and direction is known as a

A) number.
B) matrix.
C) scalar.
D) vector.

Question 24

Which of the following can you insert into a spreadsheet in Excel?

A) cells
B) columns
C) rows
D) all of the above

Question 25

Two sets of data with different ranges can be plotted on the same chart.

Question 26

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.

Question 27

The Exce $\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 )$ 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.