Sub ToVisaBottom End Sub Question 55 Part a

Sub tovisabottom end sub question 55 part a

This preview shows page 2 - 3 out of 3 pages.

Sub ToVisaBottom() Worksheets("Visa").Range(“LastRow”).Select End Sub Question 55 Part a) Give one reason why you might want to write a macro in a situation where you could just use a formula instead. Part b) Besides the fact that we just like to name things, why is it better to have a named range of cells in a macro rather than a range with cell references (eg. C13:E42)? Question 56 Congratulations! You have just been hired as a new CS 200 tutor. On the Excel assignment, students were asked to use formulas to fill in the appropriate information in C3 and in column F. They were asked to record two macros: one to sort by date and one to insert a new row, add in the date and to put a formula in column F.Find four errors in this student's submission and explain either how to correct it or why it is wrong.
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture