Have an account?
Skip to Content
Build your own quiz
Suggestions for you
.png)
Computers
8th -
10thgrade
IT 402 CBSE Class 10 Unit 2 Electronic Spreadsheet
17 questions
Show Answers
See Preview
- 1. Multiple Choice
__________ allows you to gather data from different worksheets into a master worksheet.
Goal Seek
Solver
Data Consolidation
Total Data
- 2. Multiple Choice
Consolidate option is available under __________ menu.
Tool
Insert
Data
View
- 3. Multiple Choice
We can consolidate data by ___________
Row Label
Column Label
Both Row and Column Label
None of them
- 4. Multiple Choice
Which of the following functions are available in consolidate window?
Max
Sum
Count
All of the above
- 5. Multiple Choice
If you select ________ then any values modified in the source range are automatically updated in the target range.
Link to source data
Link to sheet data
Link to original data
Link to source range
- 6. Multiple Choice
Data can be consolidated from two sheets only (True / False).
True
False
- 7. Multiple Choice
Which option is used to name a range of cells?
Range name
Cell Range
Define Range
Select Range
- 8. Multiple Choice
Define range option is available under _________ menu.
Insert
View
Data
File
- 9. Multiple Choice
SUBTOTALS ________ data arranged in an array (a group of cells)
ADD
CLEAR
MIN
AVERAGE
- 10. Multiple Choice
SUBTOTAL is available in ________ menu.
Tools
Format
Insert
Data
- 11. Multiple Choice
In SUBTOTALS we can select up to ________ groups of arrays.
3
6
2
4
- 12. Multiple Choice
Identify the correct sequence
First open subtotal window and then select the data
First select the data and then open subtotal window
Both are incorrect
Both are correct
- 13. Multiple Choice
Scenarios are tool to test ______ questions.
if else
what if
what else
do while
- 14. Multiple Choice
Each SCENARIO has a name to identify (True / False)
True
False
- 15. Multiple Choice
SCENARIO option is available in ________ menu.
Data
Tools
Insert
Windows
- 16. Multiple Choice
We can shift from one SCENARIO to another by _________
Navigator
Find and Replace
Data Source
None of the above
- 17. Multiple Choice
We can create a maximum of 3 scenario for a given example (True / False)
False
True
- Answer choicesTagsAnswer choicesTags