Electronic Spreadsheet Class 10 Quiz
Authored by Blooming_students2023 undefined
Information Technology (IT)
9th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
52 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the extension of a spreadsheet file in Calc?
.ods
.csv
.xlsx
.xls
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which software is best for data analysis?
LibreOffice Writer
LibreOffice Calc
LibreOffice Impress
None of the above
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function that combines data from multiple sheets?
Goal Seek
Solver
Consolidating Data
SubTotal
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What do scenarios in spreadsheets help to test?
What-if
Drop Down
Auto
Goal Seek
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which option is used to open Data Consolidation?
Insert > Consolidate
View > Consolidate
Data > Consolidate
None of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the shortcut key for opening the consolidated dialog window?
None of the above
Shift + D
Alt + D
Ctrl + D
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function cannot be performed through Subtotal?
Product
Average
Percentage
Sum
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
