We can consolidate data by which labels?

Which of the following functions are available in the Consolidate window?

If you select this option, then any values modified in the source range are automatically updated in the target range.

Which option is used to name a range of cells?

Subtotals perform which action on data arranged in an array (group of cells)?

In Subtotals we can select up to how many groups of arrays?

We can shift from one scenario to another by using which option?

Scenarios are a tool to test which type of questions?

Identify the correct sequence for applying Subtotals.

Which option is suitable to calculate the effect of different interest rates on an investment?

Default name of first scenario created in Sheet1 of Calc is what?

Which is a more elaborate form of Goal Seek?

Which of the following elements are present in the Insert Sheet dialog box?

We can rename an existing sheet in Calc by which method?

Formula to refer to cell A3 in sheet named S1 is what?

The cell reference for cell range G2 to M12 is what?

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 the suitable option.

Which feature of Calc is used to test what-if questions?

Which feature adds data arranged in a group of cells in Calc with labels for columns and/or rows?

Which of the following is the best tool if you have a problem with multiple unknown variables?

Which function cannot be performed through Subtotal in a spreadsheet?

State whether True or False: Data can be consolidated from two sheets only.

State whether True or False: We can create only 3 scenario for a given range of cells.

Which of the following features is not used for data analysis in a spreadsheet?

Which of the following office tools is known for data analysis?

Which of the following operations cannot be performed using LibreOffice Calc?

What is the extension of a spreadsheet file in Calc?

The default function while using Consolidate is what?

Group by is used in which tool to apply summary functions on columns?

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

Which of the following is an example of absolute cell referencing?

Which analysis tool works in reverse order, finding input based on the output?

Which of the following is the correct sequence to remove Subtotals from your worksheet within the range?

When you use the Subtotals feature in a worksheet, a hierarchy of groups appears, known as an Outline. To remove the outline from the worksheet, click on which sequence?

To delete a scenario, right-click on it in the ________ and select Delete.

Which of these actions should be performed first while using the Subtotals command?

Pooja has last year sales reports of North, East, West, and South Zones. She wants to combine all the data to view the total sales of every month. Which feature of Calc should she use?

While consolidating data, a cell range can be named using ______ option.

________ is a set of values that can be used within the calculations in the spreadsheet to explore and compare various alternatives depending on changing conditions.

Consolidate function is used to combine information from multiple sheets to ________ the information.

Data can be viewed and compared in a single sheet for identifying trends and relationships using ________ function.

_______ under Data menu can be used to combine information from multiple sheets into one sheet to compare data.

The ____ tool in Calc creates the group automatically and applies functions on the grouped data.

_______ scenario is used to explore and compare various alternatives depending on changing conditions.

_______ is a planning tool for what-if questions.

What-if analysis tool uses ______ array of cells, one array contains input values and the second uses the _______.

_______ helps in finding out the input for the specific output.

If you want to link the data of the consolidated range to the source data, then click on Options and select the Link to Source data option in the in the _____ dialog box.