Deck 14: Electronic Spreadsheets

Question 1

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

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

Answer 1

C

Question 2

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

Answer 2

False

Question 3

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

Answer 3

A

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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 buttons

Question 11

Which of the following keys will select the edit mode?

Question 12

A number of cells that are selected simultaneously is called a

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

Question 13

A spreadsheet is divided into

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

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.

Question 15

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 16

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 17

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 18

In Excel, a formula always begins with

Question 19

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

Question 20

Which of the following Excel functions will automatically update the date and time the file was last used?

Question 21

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

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

Question 22

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

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

Question 23

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 24

The Excel formula =MINVERSE(A1:C3) will calculate

Question 25

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 26

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

Question 27

The Excel formula =MMULT(A1:C3, E1:E3) will calculate

Question 28

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

Question 29

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

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

Question 30

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.