Question: 1 . Record a macro. Call your macro CIS 3 0 8 Exam 3 . Within your macro, do the following: a . Add a

1. Record a macro. Call your macro CIS308Exam3. Within your macro, do the following: a. Add a worksheet to the file and call it Exam3. b. Type the first name of the President of ASU in cell A1. c. Type the last name of the President of ASU 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 rowNOTE** You must to use an IF formula with AND to find if values exist.HINT** Your final formula should have IF, AND, CONCATENATE and LEFT in it! 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!