Question

You notice that the row labels in your spreadsheet are 1, 2, 3, 8, 9. Row labels 4 through 7 are missing. What could cause this?

Select one:
A. Rows 4 through 7 are checked out to another user
B. Rows 4 through 7 are hidden
C. Rows 4 through 7 contain invalid data
D. Rows 4 through 7 have been deleted

Answer 1

The missing row labels 4 through 7 in the spreadsheet are likely due to option D: Rows 4 through 7 have been deleted.

Step-by-step explanation:

If row labels 4 through 7 are missing in the spreadsheet, it indicates that these rows have been deleted intentionally or unintentionally. Deleting rows removes both the data and the labels associated with those rows. To verify this, you can scroll through the spreadsheet to check for any gaps in the row sequence or right-click on the row labels to see if there is an option to unhide or restore deleted rows.

If rows 4 through 7 were hidden (option B), you could unhide them, but missing labels usually suggest deletion. Options A and C are less likely causes, as checking out rows to another user (A) is typically a collaborative feature, and invalid data (C) would not directly result in missing row labels.

Option D is the answer.