Ask Question
22 May, 01:11

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.

+4
Answers (1)
  1. 22 May, 01:35
    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?
Find 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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers