Here are the filled-in blanks according to LibreOffice Calc:
1. Consolidate function is used to combine information from multiple sheets to **summarize** the information.
2. Data can be viewed and compared in a single sheet for identifying trends and relationships using **the Pivot Table** function.
3. **Consolidate** under the Data menu can be used to combine information from multiple sheets into one sheet to compare data.
4. The **Subtotal**