Data Consolidation & Subtotals in Libre Office Calc

Which feature in LibreOffice Calc is used to combine data from different worksheets into one summary sheet?

• a) Sort
  

• b) Consolidate
  

• c) Filter
  

• d) Freeze Cells

Which function is commonly used while creating Subtotals in LibreOffice Calc?

• a) CONCATENATE
  

• b) IF
  

• c) SUM
  

• d) COUNTIF

Which menu contains the Consolidate option in LibreOffice Calc?

• a) Insert
  

• b) Format
  

• c) Data
  

• d) Tools

Which of the following can be used in Data Consolidation?

• a) SUM
  

• b) AVERAGE
  

• c) MAX
  

• d) All of these

Before applying Subtotals, the data should preferably be:

• a) Colored
  

• b) Sorted
  

• c) Deleted
  

• d) Hidden

The Subtotals feature is available under which menu?

• a) View
  

• b) File
  

• c) Data
  

• d) Sheet

In Data Consolidation, the “Source Data Range” refers to:

• a) Destination cell
  

• b) Chart area
  

• c) Data selected for combining
  

• d) Page margin

What is the main purpose of Subtotals?

• a) To insert formulas automatically for grouped records
  

• b) To delete duplicate data
  

• c) To create animations
  

• d) To protect worksheets