Practice Final Exam

ChE 2002 Introduction to Chemical Engineering Computing

**Part 1 Circle all answers that are correct; there can be 0 to 5 correct answers.**

**(5 points)**Which of the statements below is true?

- A subroutine cannot open a message box
- A subroutine can only return ONE value to an open spreadsheet
- A subroutine can insert a new spreadsheet
- A subroutine cannot use a function
- A subroutine can use either a function and/or another subroutine

**(5 points)**Which of the statements below is false regarding Macro Recording?

- The macro recorder creates a subroutine that can format a table
- The macro recorder creates a function that generates a plot in an open worksheet
- The macro recorder creates VBA code that can calculate a formula by using values from a spreadsheet
- The macro recorder creates VBA code for a user-defined function within a subroutine
- The macro recorder creates a subroutine that assigns a variable type in a message box

**(10 points)**If the VBA code below was complete, what is the value of TodaysValue assuming ? Show the calculation the computer would do.

Dim Values(1 To 10, 1 To 10) As Single

For i = 1 To 10

For j = 1 To 10

Values(i, j) = (i+50) / (k * j)

Next j

Next i

TodaysValue = Values(3, 2)

After the code has executed what is the value of the variable TodaysValue?

TodaysValue = __________

**Part 2 Programming Exercises**

*Note: Prepare all of your programming solutions in ONE Excel workbook. Put EACH PROBLEM on a SEPARATE WORKSHEET. Save the workbook with your name, for example *

**Last First Final Exam.xlsm**

*. Submit your Excel workbook on D2L in the electronic drop box designated for the Final Exam.*

**Problem 1 (20 points) **

Using **Sheet1** of your Excel workbook, write a user defined function with an statement to evaluate the following function, :

Use your user defined function to plot from to .

**Problem 2 (20 points)**

On **Sheet2** of your workbook, find the number of real roots of the following polynomial using a user defined function:

Remembering that the number of real roots equals the number of times the polynomial crosses the x-axis, find the roots by plotting the polynomial on the interval . List the number and approximate value of the roots you find:

- Number of real roots = _________________________
- Approximate value of roots = ______________________________________________

**Problem 3 (35 points)**

The Maclaurin series for the inverse hyperbolic tangent is given by

Using **Sheet3** of your workbook, create a UserForm that allows the user to

- Choose the option to write the n
^{th}term of the series on the worksheet - Choose the option to write the sum of the first n-terms on the worksheet
- Make the OK CommandButton and the OptionButton for the sum of the n-terms as the default buttons
- Create a button on the spreadsheet that starts the UserForm

For use your program on **Sheet3** to calculate:

- The value of the 10
^{th}term in the series: ____________________ - The sum of the first 10 terms in the series: ___________________

**Due on:**24 Jun, 2015 06:52:00

**Asked on:**24 Jun, 2015 08:54:36

**Trina**

- Ratings 0
- Grade:
**No Rating** - Questions 11
- Solutions 0
- Blog 0
- Earned: $0.00