Advanced Features of Calc

Fill in the blanks: _________________ is a function used to combine information from multiple sheets of the spreadsheet into one place to summarize the information.

write your name

Fill in the blanks: ____________ in Calc is used to create an outline of the selected data and can group rows and columns together so that one can collapse (-) to hide it or expand (+) it using a single click on it.

Fill in the blanks: The _________ tool in Calc creates the group automatically and applies common functions like sum, average on the grouped data.

1.      Which of the following feature is not used for data analysis in spreadsheet?

• a.      Consolidating data  

• Goal Seek

•    Subtotal

• Page layout

1.      What is the extension of spreadsheet file in Calc?

• 
  

  a.      .odb

• b.      .odt

  c

• .      odg

• d.     ods

1.      The default function while using Consolidate is ____________.

• a.      Average

• b.     Sum

• c.       Max

• d.       Count

2.      Which tool is used to predict the output while changing the input?

• a.       Consolidate function

• b.      What-if scenario

• c.       Goal seek

• d.       Fine and Replace

Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.

• a. Macro                  

•      b. Solver         

•   c. Goal Seek                

• d. Sub Total

_____________ is a planning tool for what-if questions.

• Scenarios

• Data Consolidatipn

• goal seek

• subtotal