If you sort a portion of an excel sheet and you get an error message such as #div/0, what is a likely cause of the error message?
a. the cell ranges are incorrect.
b. one or more cells contain absolute cell references.
c. you're attempting to sort too many cells.
d. one or more cells contain relative cell references.

Jenny needs to record the names of 30 students, write down the subjects they studied, and note their grades in each subject after the midsemester exams and the end-of-semester exams. she divides the midsemester and end-of-semester information into two separate worksheets, sheet 1 and sheet 2. how will she rename the two worksheets?