Question 1

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

Accepted Answer

A) $ \mathrm{C} 4 $ 
B) \$C4 
C) $ \$ C \$ 4 $ 
D) $ { }^{*} C^{*} 4 $ 
A) $ \mathrm{C} 4 $ 
B) \$C4 
C) $ \$ C \$ 4 $ 
D) $ { }^{*} C^{*} 4 $ A

Question 2

The Exce $\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 )$ will calculate

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

As an engineer, most of the charts that you will create will be of which type?

Accepted Answer

A)  column charts 
B)  pie charts 
C)  line charts 
D)  xy charts 
A)  column charts 
B)  pie charts 
C)  line charts 
D)  xy charts

Question 5

Functions that allow you to test various conditions when programming formulas to analyze data are known as

Accepted Answer

A)  logical functions. 
B)  conditional functions. 
C)  analytical functions. 
D)  test functions. 
A)  logical functions. 
B)  conditional functions. 
C)  analytical functions. 
D)  test functions.

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

The intersection of a single row and a single column is called a(n)

Accepted Answer

A)  data point. 
B)  data entry. 
C)  cell. 
D)  input. 
A)  data point. 
B)  data entry. 
C)  cell. 
D)  input.

Question 10

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

Accepted Answer

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

Question 11

A number of cells that are selected simultaneously is called a

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Spreadsheets can be used to

Accepted Answer

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 
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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

In a spreadsheet, the _________ contains push buttons (icons) that execute commands used by Excel.

Accepted Answer

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

Question 17

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

Accepted Answer

A) C4 
B) $ { }^{*} \mathrm{C} 4 $ 
C) $ \mathrm{SC \$ 4} $ 
D) $ { }^{*} \mathrm{C}^{*} 4 $ 
A) C4 
B) $ { }^{*} \mathrm{C} 4 $ 
C) $ \mathrm{SC \$ 4} $ 
D) $ { }^{*} \mathrm{C}^{*} 4 $

Question 18

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

Accepted Answer

A)  $ =\operatorname{COSINE}(\mathrm{A} 1) $ 
B) $ =\operatorname{COS}(\mathrm{A} 1) $ 
A)  $ =\operatorname{COSINE}(\mathrm{A} 1) $ 
B) $ =\operatorname{COS}(\mathrm{A} 1) $

Question 19

A spreadsheet is divided into

Accepted Answer

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

Question 20

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

Accepted Answer

A) $ = $ SQUARE_ROOT $ (\mathrm{Al}) $ 
B) =SQUAREROOT(A1) 
C) =SQUARE_RT(A1) 
D) $ = $ SQRT $ (\mathrm{A} l) $ 
A) $ = $ SQUARE_ROOT $ (\mathrm{Al}) $ 
B) =SQUAREROOT(A1) 
C) =SQUARE_RT(A1) 
D) $ = $ SQRT $ (\mathrm{A} l) $

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

The Exce $\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 )$ will calculate

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

As an engineer, most of the charts that you will create will be of which type?

Functions that allow you to test various conditions when programming formulas to analyze data are known as

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

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

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

The intersection of a single row and a single column is called a(n)

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

A number of cells that are selected simultaneously is called a

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

Spreadsheets can be used to

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

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

In a spreadsheet, the _________ contains push buttons (icons) that execute commands used by Excel.

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

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

A spreadsheet is divided into

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

Introduction to the Engineering Profession

Preparing for an Engineering Career

Introduction to Engineering Design

Engineering Communication

Engineering Ethics

Fundamental Dimensions and Units

Length and Length-Related Variables in Engineering

Time and Time-Related Variables in Engineering

Mass and Mass-Related Variables in Engineering

Force and Force-Related Variables in Engineering

Temperature and Temperature-Related Variables in Engineering

Electric Current and Related Variables in Engineering

Energy and Power

Computational Engineering Tools: Matlab

Engineering Drawings and Symbols

Engineering Materials

Mathematics in Engineering

Probability and Statistics in Engineering

Engineering Economics

Filters

Exam 14: Computational Engineering Tools: Electronic Spreadsheets

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

The Exce formula = MMULT (A1:C3,E1:E3)\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 ) formula = MMULT (A1:C3,E1:E3) will calculate

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

As an engineer, most of the charts that you will create will be of which type?

Functions that allow you to test various conditions when programming formulas to analyze data are known as

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

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

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

The intersection of a single row and a single column is called a(n)

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

A number of cells that are selected simultaneously is called a

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

Spreadsheets can be used to

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

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

In a spreadsheet, the _________ contains push buttons (icons) that execute commands used by Excel.

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

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

A spreadsheet is divided into

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

Introduction to the Engineering Profession

Preparing for an Engineering Career

Introduction to Engineering Design

Engineering Communication

Engineering Ethics

Fundamental Dimensions and Units

Length and Length-Related Variables in Engineering

Time and Time-Related Variables in Engineering

Mass and Mass-Related Variables in Engineering

Force and Force-Related Variables in Engineering

Temperature and Temperature-Related Variables in Engineering

Electric Current and Related Variables in Engineering

Energy and Power

Computational Engineering Tools: Matlab

Engineering Drawings and Symbols

Engineering Materials

Mathematics in Engineering

Probability and Statistics in Engineering

Engineering Economics

Filters

The Exce $\text { formula } = \text { MMULT } ( \mathrm { A } 1 : \mathrm { C } 3 , \mathrm { E } 1 : \mathrm { E } 3 )$ will calculate

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