Question: A worksheet contains over 4 0 0 rows. The first 1 0 rows contain input data, and functions containing summary statistics are in the last

A worksheet contains over 400 rows. The first 10 rows contain input data, and functions containing summary statistics are in the last 10 rows. What is the most efficient method to see the input area and summary statistics at the same time without having to scroll back and forth between sections? (1 point)
Use the Split command and adjust one pane to see the input section and another pane to see the summary statistics.
Open multiple windows of the same workbook and use the Arrange Windows command to tile the windows.
Select the summary statistics and use the Freeze Panes option.
Display a Watch Window for the input section as you view the summary statistics section.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!