Answer:
performs calculations
Explanation:
The SUBTOTAL function in Excel allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Thus, the SUBTOTAL function in Excel helps in analyzing the data provided.
Answer:
1. Select below the row where you want the split, or the column to the right of where you want the split.
2. On the View tab, in the Window group, click Split.
Explanation:
CTRL - (select sentence) - ALT
I believe you are talking about spell check.
Answer:
Structured Documents
Explanation:
Structured Documents consist of hierarchy in the files. They may include data files. HTML (Hyper-text markup language) documents and XML (Extensible Markup Language) applications are the examples of Structured Documents.