quiz 5

1/29/2019 Quizzes - CE-112-001: CEE COMPUTATIONS (Winter 2019) - Portland State University

https://d2l.pdx.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=730256&isprv=&drc=0&qi=180544&cfql=0&dnb=0 1/2

Question 1Question 1  (0.5 points)

Question 2Question 2  (0.5 points)

Question 3Question 3  (0.5 points)

 

 

 

Which of the following examples of VBA macro code could be used to define a function that solves the length of the hypotenuse of a right triangle given the lengths of the other two sides of the triangle?

Before starting this quiz, open the L5_quiz.xlsx file found on D2L in the lecture material folder for Week 5.

You are preparing to purchase your first home. Based on your income, you are able to afford to payments of $1800 per month and the current interest rate is 4.50%. To avoid paying mortgage insurance, you will be making a 20% down payment on the 30 year loan.

Referring to Problem 2 in the L5_quiz.xlsx file, use the Solver to determine the w, x, y, and z values for the system of equations found in the Excel file.

In the space below, report the value for "x" to the second decimal place. Remember to include a negative sign if applicable.

1/29/2019 Quizzes - CE-112-001: CEE COMPUTATIONS (Winter 2019) - Portland State University

https://d2l.pdx.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=730256&isprv=&drc=0&qi=180544&cfql=0&dnb=0 2/2

Question 4Question 4  (0.5 points)  

To save an Excel workbook that contains a macro the .xlsm file extension must be specified.

True

False

a)  Function hyp(opp, adj)

hyp = Sqr(x^2 + y^2)

End Function

b)  Function hyp(opp, adj)

hyp = Sqr(opp^2 + adj^2)

End Function

c)  Function hyp(opp, adj)

hyp = Sqr(opp^2 + adj^2)

d)  Function hyp(opp, adj)

hyp = Sqrt(opp^2 + adj^2)

End Function