Electronic Spreadsheet Class 10 Quiz

What is the extension of a spreadsheet file in Calc?

• .ods

• .csv

• .xlsx

• .xls

Which software is best for data analysis?

• LibreOffice Writer

• LibreOffice Calc

• LibreOffice Impress

• None of the above

What is the function that combines data from multiple sheets?

• Goal Seek

• Solver

• Consolidating Data

• SubTotal

What do scenarios in spreadsheets help to test?

• What-if

• Drop Down

• Auto

• Goal Seek

Which option is used to open Data Consolidation?

• Insert > Consolidate

• View > Consolidate

• Data > Consolidate

• None of the above

What is the shortcut key for opening the consolidated dialog window?

• None of the above

• Shift + D

• Alt + D

• Ctrl + D

Which function cannot be performed through Subtotal?

• Product

• Average

• Percentage

• Sum

What does 'Copy result to' mean in data consolidation?

• None of the above

• Specify where to display the result

• Add all addresses of consolidation data

• Insert the formula for finding data

In LibreOffice Calc, how do you collapse to hide data?

• / Sign

• + Sign

• - Sign

• * Sign

Which tool is used to display the hierarchical structure of data?

• Subtotal

• Scenario

• Goal Seek

• Solver