Excel 2016:
9. which of the following statements describes the reason you would want to record a macro with absolute references rather than relative references?

a. you want to preserve the integrity of any cells referenced by formulas in the macro.
b. you want the values of any cells copied to the macro to be accurate.
c. you want the results of any formulas produced by the macro to be accurate.
d. you want the macro to reproduce its results in the same place each time.

8. create an abstract student class for parker university. the class contains fields for student id number, last name, and annual tuition. include a constructor that requires parameters for the id number and name. include get and set methods for each field; the settuition() method is abstract. create three student subclasses named undergraduatestudent, graduatestudent, and studentatlarge, each with a unique settuition() method. tuition for an undergraduatestudent is $4,000 per semester, tuition for a graduatestudent is $6,000 per semester, and tuition for a studentatlarge is $2,000 per semester. write an application that creates an array of at least six objects to demonstrate how the methods work for objects for each student type. save the files as student. java, undergraduatestudent. java, graduatestudent. java, studentatlarge. java, and studentdemo. java.