Ask Question
5 May, 21:29

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)
  1. 6 May, 00:52
    0
    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
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers