Exam 14: Electronic Spreadsheets

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

Which is the correct way to enter the following mathematical operation into Excel? $2 + \frac { 3 } { 2 } + \frac { 8 - 3 } { 6 }$ 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 )$

Spreadsheets can be used to

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. $x y$ charts

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

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

In Excel, a formula always begins with a. an equal sign $( = )$ . b. an apostrophe ('). c. a plus sign (+). d. an asterisk (*).

The Excel formula =MINVERSE(A1:C3) will calculate a. the minimum number of verses in the range A1 through $\mathrm { C } 3$ . b. the smallest value in the range A1 through $\mathrm { C } 3$ . c. the inverse of the matrix in range A1 through $\mathrm { C } 3$ . d. none of the above.

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

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

If you were to type the following into a cell, what would be the result in Excel? $= 2 + 3 * ( 4 + 5 )$ a. 25 b. 45 c. 19 d. 20

A spreadsheet is divided into

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

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)

If you were to type the following into a cell, what would be the result in Excel? $= ( 2 + 3 * 4 + 5 )$ a. 25 b. 45 c. 19 d. 20

Which of the following Excel functions will correctly calculate the cosine of the value in cell A1? a. $= \operatorname { COSINE} ( \mathrm { A } 1 )$ b. $= \mathrm { COS } ( \mathrm { A } 1 )$

A number of cells that are selected simultaneously is called a

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

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

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