To demonstrate your competence with navigating a worksheet with VBA, create a workbook named whatever you want (dont forget to save as macro-enabled: .xlsm), and do the following.

1. Write code to do the following:
   1. Make A1 the active cell.
   2. Offset 3 rows and 2 columns, and make that the new active cell
      1. Set the value of the new active cell equal to your firstname
   3. Offset 3 rows and -2 columns, and make that the new active cell
      1. Set the value of the new active cell equal to your lastname
   4. Make the cell furthest up from the current active cell the newactive cell (use .end)
      1. Set the value of the new active cell equal to yourprofessors last name.
   5. Activate Sheet2
      1. Set the value of the new active cell equal to your desiredor current major.
2. Make all of this code run in a single Sub that is triggered by a button somewhere on the 1st worksheet.

I'm not sure how to start or what exactly I need to do with this instruction.