Question

Jason is working on a project that requires him to manage a huge amount of data. The spreadsheet he is working on has data related to the official budget from cell A1 through C9, and data related to actual expenditures from cell L1 through N19. How will Jason track and compare the data as he works on the spreadsheet?
A. use split worksheet view to break the worksheet into different visible sections
B. use page break view to break the worksheet into different visible sections
C. use full screen view to break the worksheet into different visible sections
D. use normal view to break the worksheet into different visible sections
E. use page layout view to break the worksheet into different visible sections

Answer 1

A. use split worksheet view to break the worksheet into different visible sections

Explanation:

Jason is working on a project that requires him to manage a huge amount of data. There are numerous instances when a user has to manage a huge amount of data within a single spreadsheet. It will cause trouble for the user to simultaneously access the data from more than one table in the same sheet.

To deal with this problem, Jason can track and compare this data as he works on the spreadsheet by using the split worksheet view to break the worksheet into different visible sections. The different sections provide a better view of the tables and data extraction and manipulation become easy.