Q&A Hero

Q: To obtain the coefficients of the second order polynomial that best fits a given set of x and y data, you will type the following sequence of commands: a. Coefficients = polyfit(2, x,y) b. Coefficients = polyfit(x,2,y) c. Coefficients = polyfit(x,y,2) d. none of the above

Q: In the MATLAB Command Window, if you type the following commands, what would be the result? scores = [80 90 50 70 80 60 65 95 70 40]; for i=1:1:10 if scores (i) >60 fprintf(' %g PASSING ', scores (i)); else fprintf(' %g FAILING ', scores (i)) end end

Q: In the MATLAB Command Window, if you type the following commands, what would be the result? scores = [80 90 50 70 80 60 65 95 70 40]; for i=1:1:10 if scores (i) <60 fprintf (' %g FAILING ', scores (i)) end end

Q: Find the corresponding MATLAB output: >> factorial(3) ans =

Q: Which of the following MATLAB commands would calculate the value of ex? a. e^x b. exp(x) c. exp^x d. exponent(x)

Q: What does the following MATLAB function do? log2(x) a. returns the value of base-2 logarithm of x. b. returns the value of base-10 logarithm of 2 and assigns it to x. c. returns the value of common log of 2x. d. returns the value of natural logarithm of 2 and assigns it to x.

Q: What is the MATLAB command for calculating the square root of a number? a. square_root b. sqrt c. sqr d. sq_rt

Q: In the MATLAB Command Window, if you type the following commands, what would be the result? x = 1.0; while x <=5 y=x^2+100; disp([x', y']) x = x + 1; end

Q: In the MATLAB Command Window, if you type the following commands, what would be the result? x = 1.0; for i = 1:1:5 y=x^2+100; disp([x', y']) x = x + 1; end

Q: In the MATLAB Command Window, if you type the following commands, what would be the result? y = 50 fprintf ('The value of y is %g ', y)

Q: Which of the following commands are commonly used while plotting in MATLAB? a. plot b. title c. grid d. all of the above

Q: an M-file is used to when you write a program that is more than a few lines long. a. True b. False

Q: Find the corresponding MATLAB output: >> A = [2,3,4,5;1,-3,-7,4;2,3,2,1]; >> max (A) ans =

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> min(A)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> max(B)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> length (A)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> B(2:3, 2:4)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> A(2:3,:)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> B(:,3:4)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> A(:,3)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> A(4:8)

Q: 19 - 27The following matrices have already been defined in MATLAB: What would be the outputs of the following MATLAB inputs:>> B(2:5)

Q: Shown below are MATLAB inputs. Complete each output:>> E = [10:-2:0];>> F = 20./E>> F =

Q: Shown below are MATLAB inputs. Complete each output: >> C = [1,3,-2,0]; >> D = 3./C >> D =

Q: Shown below are MATLAB inputs. Complete each output: >> A = [2:5]; >> B = 4*A >> B =

Q: Shown below are MATLAB inputs. Complete each output: >> A = [1:4]; >> B = 3.*A >> B =

Q: Suppose you have defined x = [1,2,3] and y = [2,4,6] in the Command Window. Determine the result of the following MATLAB operation: >>x .* y a. ans = 3 6 9 b.ans = 2 8 18 b. ans = 1 2 3 2 4 6 c. ans = 6 12

Q: Suppose you have defined x = [1,2,3] and y = [2,4,6] in the Command Window. Determine the result of the following MATLAB operation: >>x + y a. ans = 3 6 9 b. ans = 1 2 3 2 4 6 c. ans = 6 12 d. ans = 18

Q: To generate the set of x even numbers in the range of two to twenty, what should you enter in the Command Window? a. x = 2;2;20 b. x = 2:2:20 c. x = 2:20:2 d, x = 2,20,2

Q: In MATLAB, the elements of the matrix are enclosed in brackets [ ] and are separated by blank space, and the elements of each row are separated by a semicolon (;) a. True b. False

Q: If you define x = 2/3, and then type format bank, how will the value of x be displayed? a. x = 0.66666666667 b. x = 0.6667 c. x = 0.67 d. x = 2/3

Q: If you define x = 2/3, and then type format rat, how will the value of x be displayed? a. x = 0.66666666667 b. x = 0.6667 c. x = 0.67 d. x = 2/3

Q: If you define x = 2/3, and then type format short, how will the value of x be displayed? a. x = 0.66666666667 b. x = 0.6667 c. x = 0.67 d. x = 2/3

Q: If you define x = 2/3, and then type format long, how will the value of x be displayed? a. x = 0.66666666666666666666667 b. x = 0.66666666666667 c. x = 0.67000000000000 d. x = 2/3

Q: To clear the contents of the Command Window, type a. clear b. clr c. clc d. shift-c

Q: In MATLAB, you cannot transfer old commands from the Command History Window to the Command Window. a. True b. False

Q: In the MATLAB environment, you can assign values to a variable or define the elements of a matrix. a. True b. False

Q: The part of the screen where you enter variables and issue MATLAB commands is known as the a. menu bar. b. current folder. c. command window. d. command history window.

Q: Engineers can use MATLAB to solve a wide range of engineering problems. They take advantage of built-in functions of the software and also they can write their own programs in MATLAB. a. True b. False

Q: In VBA, the following statementAverage_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_Densitya. Trueb. False

Q: In VBA, the statement Range("A1,A6").Activate will a. activate cells A1 through A6 b. write the text "Activate" in A1 and A6 cells c. activate cells A1 and A6 only d. none of the above

Q: In VBA, the statement Cells(1, 1) = "x values" will write a. the value of x in the cell located in Row 1 and Column A b. the text "x values" in the cell located in Row 1 and Column A c. the text "x values" in all the cells in Row 1 d. none of the above

Q: In VBA, the End Sub statement ends the subroutine. a. True b. False

Q: In VBA, the following statement Sub temperature_conversion() will starts the subroutine and names it a. temperature b. conversion c. temperature_conversion d. none of the above

Q: A simple way to learn about the VBA's object-oriented commands and syntax is by using the Record Macro option. a. True b. False

Q: You can use Excel's build-in function in VBA. a. True b. False

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

Q: The Excel formula =MMULT(A1:C3, E1:E3) will calculate a. the number of multiples found in the ranges A1 through C3 and E1 through E3. b. the multitude of values 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.

Q: The Excel formula =MINVERSE(B1:D3) will calculate 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.

Q: An array of numbers, variables, or mathematical terms is known as a a. list. b. matrix. c. scalar. d. vector.

Q: A physical variable that possesses both magnitude and direction is known as a a. number. b. matrix. c. scalar. d. vector.

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

Q: In Excel, two sets of data with different ranges can be plotted on the same chart. a. True b. False

Q: 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

Q: 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? a. 74 b. 60 c. PASS d. FAIL

Q: In Excel, 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.

Q: Which of the following Excel functions will automatically update the date and time the file was last used? a. =LAST_MODIFIED b. =TODAY c. =CURRENT d. none of the above

Q: The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell A1 must be in degrees. a. True b. False

Q: Which of the following Excel functions will correctly calculate the cosine of the value in cell A1? a. =COSINE(A1) b. =COS(A1)

Q: 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)

Q: Which of the following Excel functions will calculate the mean value of the data in cells A1 through A9? a. =AVG(A1:A9) b. =AVE(A1:A9) c. =AVERAGE(A1:A9) d. =MEAN(A1:A9)

Q: The Excel functions are grouped into various categories, including mathematical and trigonometric, engineering, statistical, financial, and logical functions. a. True b. False

Q: 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. a. True b. False

Q: Which of the following is the correct entry for a relative cell reference? a. C4 b. $C4 c. $C$4 d. *C*4

Q: Which of the following is the correct entry for an absolute cell reference? a. C4 b. *C4 c. $C$4 d. *C*4

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

Q: Which is the correct way to enter the following mathematical operation into Excel? 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)

Q: If you were to type the following into a cell, what would be the result in Excel? a. 25 b. 29 c. 19 d. 20

Q: If you were to type the following into a cell, what would be the result in Excel? a. 25 b. 45 c. 19 d. 20

Q: In Excel, a formula always begins with a. an equal sign (=). b. an apostrophe ("˜). c. a plus sign (+). d. an asterisk (*).

Q: A number of cells that are selected simultaneously is called a a. group b. multi-cell c. range d. cartel

Q: Visual Basic for Applications (VBA) is a programming language that allows you to use Excel more effectively. a. True b. False

Q: The intersection of a single row and a single column is called a a. data point b. data entry c. cell d. input

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

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

Q: Active cell refers to a specific selected cell. a. True b. False

Q: In a spreadsheet, the _________ contains the name of the current active workbook. a. title bar b. active cell c. column header d. status bar

Q: A spreadsheet is divided into a. lines and spaces. b. rows and columns. c. inputs and outputs. d. problems and solutions.

Q: 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

Q: Test Bank Engineering Fundamentals, 5th ed. Chapter 14