Which office tool is known for data analysis?

Which operation cannot be performed using LibreOffice Calc?

What is the extension of a spreadsheet file in Calc?

The default function while using Consolidate is:

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?

A Consolidated function is used to combine information from two or more sheets into one.

The Consolidated function cannot be used to view and compare data.

Link to source data is checked to update the target sheet if any changes are made in the source data.

Using subtotal in Calc requires using filter data for sorting.

The Subtotal tool can use only one type of summary function for all columns.

Only one scenario can be created for one sheet.

The default name of a scenario is

The Goal seek analysis tool is used while calculating the output depending on the input.

The output of the What-if tool is displayed in the same cell.

Which function is used to combine information from multiple sheets?

Which tool allows data to be viewed and compared in a single sheet to identify trends?

Which of the following creates groups automatically and applies functions on the grouped data?

What is the planning tool for What-if questions?

Which analysis tool helps in finding input for a specific output?

Which menu enables macro recording in spreadsheets?

Which of the following is an invalid Macro Name?

What is the programming language used in LibreOffice Macros?

The default name of a macro is:

Macros allow us to add and delete a module using:

The Macro code begins with and ends with:

Which option in LibreOffice allows linking external data?

The Insert Sheet dialog can be invoked from:

The extension of LibreOffice Base is:

Hyperlink feature allows users to jump to another spreadsheet.

A sheet can only be added before the current sheet.

Which of the following allows multiple users to simultaneously edit a spreadsheet?

Some features become unavailable when a spreadsheet is in shared mode.

The color of the border of a changed cell in tracking mode is:

The title bar displays (Shared) next to the filename for a spreadsheet in:

Which menu is used to track changes in a spreadsheet?

Which tool is used for reviewing changes made by team members?

Reviewing spreadsheet changes allows a user to:

Which feature in Calc is used to compare two versions of the same spreadsheet?

Merging spreadsheets helps users to:

What is the advantage of extracting data from a web page into Calc?

What does Goal Seek help users to find?

The shortcut key to execute a macro module is:

Which option adds notes or suggestions to a cell?

The color of tracked changes in Calc is:

The feature that ensures collaborative editing in spreadsheets is:

The tool used to jump to different locations within the same sheet or to different sheets is: