Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

A. Select row 17 and click View tab > Window group > Split.

B. Select rows 2 to 16 and click View tab > Window group > Split.

C. Select rows 2 to 16 and click View tab > Window group > New Window > Split.

D. Select row 16 and click View tab > Window group > Split > Arrange All.

Question

Braden Steele

Computers & Technology

7 June, 23:33

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

A. Select row 17 and click View tab > Window group > Split.

B. Select rows 2 to 16 and click View tab > Window group > Split.

C. Select rows 2 to 16 and click View tab > Window group > New Window > Split.

D. Select row 16 and click View tab > Window group > Split > Arrange All.

+1

Answers (1)

Know the Answer?

Anne Mcclain · Answer 1

A. Select row 17 and click View tab > Window group > Split.

Explanation:

This option will allow the user to scroll down to 180th position while displaying top 16 rows.

The option B will not lock the upper rows.

The option C is not a valid option in MS Excel.

The option D is used for two or more worksheets but our data is all compiled in a single sheet.

Hence the option A will be feasible to achieve the desired comparison view