Exam 3 Instructions1

Subject:Computer SciencePrice: Bought3

Share With

Exam 3 Instructions1. Record a macro. Call your macro CIS308Exam3. Within your macro, do the following:     a. Add a worksheet to the file and call it Output.     b. Type a first name in cell A1.      c. Type a last name in cell B1.     d. In cell C1, use a formula to find If values exist in column A and B of the row, then concatenate the last name first, a comma, a space, and the first initial of the first name into column C of the corresponding row     e. Stop recording.2. Open your macro in Visual Basic edit mode - your main code area should be no more than 12 lines at this point.3. Copy your macro code and paste it into cell A1 of the "Macro Code" tab of this workbook.4. Go back to the Visual Basic, and alter your macro using no more than 25 lines in your main code:       a. Remove the code to add a sheet, and instead select the Output sheet.      b. Change the code that has your instructor's first name to ask the user for their first name and supply the information to cell A1.     c. Change the code that has your instructor's last name to ask the user for their last name and supply the information to cell B1.     d. Leave the code that concatenates the name and first initial.      e. Add code called 'addname' to ask the user if they want to input another name.     f. Declare an integer variable "k" and set it equal to 1.     g. Make a loop using Wend and While to do the following:     h. Have this repeat (A2, B2 and C2, A3, B3 and C3, etc.) until the user says "no" they do not want to input another name.     i. If the user says no, then say "Thanks for playing!" and exit the macro.