Question 1

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

Accepted Answer

A) C4 
B) *C4 
C) $C$4 
D) *C*4 
A) C4 
B) *C4 
C) $C$4 
D) *C*4

Question 2

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 3

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?

Accepted Answer

A) 74 
B) 60 
C) PASS 
D) FAIL 
A) 74 
B) 60 
C) PASS 
D) FAIL

Question 4

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 5

In VBA, the following statement Sub temperature_conversion()
Will starts the subroutine and names it

Accepted Answer

A) temperature 
B) conversion 
C) temperature_conversion 
D) none of the above 
A) temperature 
B) conversion 
C) temperature_conversion 
D) none of the above

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

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 10

A physical variable that is identifiable by either a single value or magnitude is known as a

Accepted Answer

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

Question 11

If you were to type the following into a cell, what would be the result in Excel?

Accepted Answer

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

Question 12

What are the three ways that you can refer to a cell address in a formula?

Accepted Answer

absolute,

Question 13

In Excel, two sets of data with different ranges can be plotted on the same chart.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Finding an equation that best fits a set of data is known as

Accepted Answer

A) an analytical solution. 
B) a graphical solution. 
C) an approximate solution. 
D) curve fitting. 
A) an analytical solution. 
B) a graphical solution. 
C) an approximate solution. 
D) curve fitting.

Question 16

Active cell refers to a specific selected cell.

Accepted Answer

A) True 
 B)False

Question 17

The Excel formula =MINVERSE(B1:D3) will calculate

Accepted Answer

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

Question 18

In Excel, a formula always begins with

Accepted Answer

A) an equal sign (=). 
B) an apostrophe ('). 
C) a plus sign (+). 
D) an asterisk (*). 
A) an equal sign (=). 
B) an apostrophe ('). 
C) a plus sign (+). 
D) an asterisk (*).

Question 19

The intersection of a single row and a single column is called a

Accepted Answer

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

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

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

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?

Spreadsheets can be used to

In VBA, the following statement Sub temperature_conversion() Will starts the subroutine and names it

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

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

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.

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

A physical variable that is identifiable by either a single value or magnitude is known as a

If you were to type the following into a cell, what would be the result in Excel?

What are the three ways that you can refer to a cell address in a formula?

In Excel, two sets of data with different ranges can be plotted on the same chart.

A spreadsheet is divided into

Finding an equation that best fits a set of data is known as

Active cell refers to a specific selected cell.

The Excel formula =MINVERSE(B1:D3) will calculate

In Excel, a formula always begins with

The intersection of a single row and a single column is called a

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 an absolute cell reference?

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

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?

Spreadsheets can be used to

In VBA, the following statement Sub temperature_conversion() Will starts the subroutine and names it

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

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

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.

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

A physical variable that is identifiable by either a single value or magnitude is known as a

If you were to type the following into a cell, what would be the result in Excel?

What are the three ways that you can refer to a cell address in a formula?

In Excel, two sets of data with different ranges can be plotted on the same chart.

A spreadsheet is divided into

Finding an equation that best fits a set of data is known as

Active cell refers to a specific selected cell.

The Excel formula =MINVERSE(B1:D3) will calculate

In Excel, a formula always begins with

The intersection of a single row and a single column is called a

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