100%(10)10 out of 10 people found this document helpful
This preview shows page 2 - 3 out of 3 pages.
Sub ToVisaBottom()Worksheets("Visa").Range(“LastRow”).SelectEnd SubQuestion 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.