Question

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?(a) Open multiple windows of the same workbook and use the Arrange Windows command to tile the windows.(b) Display a Watch Window for the input section as you view the summary statistics section.(c) Select the summary statistics and use the Freeze Panes option.(d) Use the Split command and adjust one pane to see the input section and another pane to see the summary statistics.

Answer 1

Answer:

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 is b) Display a Watch Window for the input section as you view the summary statistics section.

Step-by-step explanation:

A Watch Window in Excel is a window that floats in front of your workbook that lets you see selected cells from anywhere in your workbook, or even other workbooks. This can be very helpful when you want to see how changes affect cells on other tabs or that aren't within view on a large spreadsheet.

A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template.

The definition of a spreadsheet is a piece of paper or a computer program used for accounting and recording data using rows and columns into which information can be entered. Microsoft Excel, a program in which you enter data into columns, is an example of a spreadsheet program.