Electronic Spreadsheet Class 10 Quiz

What is the extension of a spreadsheet file in Calc?

• .odt

• .odb

• .odg

• .ods

The LibreOffice Calc can perform _.

• Calc can share and review data

• Analysis automate repeated tasks

• Calc can create link

• All of the above

Which of the following software is best for data analysis?

• LibreOffice Calc

• None of the above

• LibreOffice Writer

• LibreOffice Impress

__ is a function which combines data from multiple sheets and summarizes the information in one place.

• Solver

• Goal Seek

• Consolidating Data

• SubTotal

__ compare a variety of data in a single spreadsheet to identify relationships and trends.

• Solver

• Goal Seek

• Consolidating Data

• SubTotal

What we need to check before consolidating data in LibreOffice Calc?

• First column should be primary column

• Match the levels from all the sheets

• Data types must match

• All of the above

Which option you will select to open Data Consolidation?

• Insert > Consolidate

• Data > Consolidate

• View > Consolidate

• None of the above

Which function cannot be performed through Subtotal in a Spreadsheet?

• Percentage

• Average

• Product

• Sum

Scenarios are a tool to test questions.

• Drop Down

• What-if

• Goal Seek

• Auto

_ means combining data in a spreadsheet from different worksheets into master worksheet.

• Hyperlinks

• Filter

• Consolidating

• Linking