Spreadsheet Data Analysis Quiz

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

• Consolidating data

• Goal Seek

• Subtotal

• Page layout

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

• Writer

• Calc

• Impress

• Draw

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

• Store and manipulate data

• Create graphical representation of data

• Analysis of data

• Mail merge

What is the extension of a spreadsheet file in Calc?

• .odb

• .odt

• .odg

• .ods

The default function while using Consolidate is __.

• Average

• Sum

• Max

• Count

Group by is used in _ tool to apply summary functions on columns.

• Consolidate function

• Group and Outline

• What-if scenario

• Subtotal tool

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

• Consolidate function

• What-if scenario

• Goal seek

• Find and Replace

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

• C5

• $C$5

• $C

• #C

_ analysis tool works in reverse order, finding input based on the output.

• Consolidate function

• Goal seek

• What-if analysis

• Scenario

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

• True

• False