Electronic Spreadsheets

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

• (a) Consolidating data

• (b) Goal Seek

• (c) Subtotal

• (d) Page layout

2. Which of the following office tool is known for data analysis?

• (a) Writer

• (b) Calc

• (c) Impress

• Draw

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

• (a) Store and manipulate data

• (b) Create graphical representation of data

• (c) Analysis of data

• (d) Mail merge

What is the extension of spreadsheet file in Calc?

• (a) .odb

• (b) .odt

• (c) .odg

• (d) .ods

The default function while using Consolidate is ____________.

• (a) Average

• (b) Sum

• (c) Max

• (d) Count

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

• (a) Consolidate function

• (b) Group and Outline

• (c) What-if scenario

• (d) Subtotal tool

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

• (a) Consolidate function

• (b) What-if scenario

• (c) Goal seek

• (d) Find and Replace

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

• A5

• $A$5

• A#5

• $A

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

• (a) Consolidate function

• (b) Goal seek

• (c) What-if analysis

• (d) Scenario

Which tool is used to perform 'What-if' analysis in LibreOffice Calc?

• (a) Consolidate function

• (b) Goal seek

• (c) Scenario

• (d) Subtotal tool