Fill the blanks according to LibreOffice Calc: 1. Consolidate function is used to combine information from multiple sheets to _______________________ the information. 2. Data can be viewed and compared in a single sheet for identifying trends and re

Here are the filled-in blanks according to LibreOffice Calc:

Consolidate function is used to combine information from multiple sheets to **summarize** the information.
Data can be viewed and compared in a single sheet for identifying trends and relationships using **the Pivot Table** function.
**Consolidate** under the Data menu can be used to combine information from multiple sheets into one sheet to compare data.
The **Subtotal** tool in Calc creates the group automatically and applies functions on the grouped data.