CBSE-SOLUTIONS
CLASS-10
PART-B
UNIT-II ELECTRONIC SPREADSHEET(ADVANCED)
A. Multiple Choice Questions:
1. _________ is a tool to test “what-if” questions.
(a) Scenario
(b) Solver
(c) Macro
(d) Average
Answer: (a) Scenario
2. Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.
(a) Macro
(b) Solver
(c) Goal Seek
(d) Subtotal
Answer: (c) Goal Seek
3. In a Subtotal function what are the functions that can be performed on the group of cells?
(a) Sum
(b) Count
(c) Average
(d) All of the above
Answer: (d) All of the above
4. A __________ is a What-if Analysis tool that allows you to substitute set of values automatically in a worksheet.
(a) Navigator
(b) Scenario
(c) Subtotal
(d) Goal Seek
Answer: (b) Scenario
5. Solver command is found in __________ tab.
(a) Data
(b) Tools
(c) Format
(d) Edit
Answer: (b) Tools
6. In Data Consolidate what are the operations we can perform __________.
(a) Sum
(b) Average
(c) Max
(d) All of the above
Answer: (d) All of the above
7. __________ hyperlink contains a full URL.
(a) Absolute
(b) Relative
(c) Both (a) and (b)
(d) None of the above
Answer: (a) Absolute
8. __________ can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to websites.
(a) Illustrations
(b) Hyperlinks
(c) Links
(d) Filter
Answer: (b) Hyperlinks
9. Shortcut to open the list of recorded Macros in MS-Excel are:
(a) Alt+F8
(b) Alt+F5
(c) Alt+F4
(d) Alt+F7
Answer: (a) Alt+F8
10. A __________ is a What-if Analysis tool that allows you to substitute set of values automatically in a worksheet.
(a) Navigator
(b) Scenario
(c) Subtotal
(d) Goal Seek
Answer: (b) Scenario
11. What does it mean by Goal Seek in spread sheet?
(a) To draw the curve for given cell value
(b) To determine the value of cell for given result
(c) To omit the cell data for given graph
(d) None of the above
Answer: (b) To determine the value of cell for given result
12. Which function isn't available in consolidating data?
(a) Sum and Count
(b) Max and Min
(c) Average and Product
(d) Percentage
Answer: (d) Percentage
13. Shortcut to open the list of recorded Macros in MS-Excel are:
(a) Alt+F8
(b) Alt+F5
(c) Alt+F4
(d) Alt+F7
Answer: (a) Alt+F8
14. Ramesh wants to solve one variable problem. Suggest him which of the data analysis tools is best suited for him.
(a) Solver
(b) Goal Seek
(c) Scenario
(d) Data table
Answer: (d) Data table
15. Pankaj wants to combine and find the sum/average of marks obtained by the students in the previous three periodic tests. The data is stored in various sheets of a workbook. Which of the following tools is best suited for him?
(a) Data Range
(b) Data Consolidation
(c) Data Review
(d) Data Merge
Answer: (b) Data Consolidation
16. Rakesh wants to apply a formula in the entire column of the spreadsheet, with respect to only one cell. What referencing he will use to get the correct result?
(a) Relative Referencing
(b) Absolute Referencing
(c) Mixed Referencing
(d) Hyperlink
Answer: (b) Absolute Referencing
17. Kartik and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work?
(a) Consolidate Worksheet
(b) Shared Worksheet
(c) Link Worksheet
(d) Lock Worksheet
Answer: (b) Shared Worksheet
18. Pratham wants to do the same set of tasks to be done repeatedly like formatting or applying a similar formula in a similar range of data. Suggest him a suitable tool for that.
(a) Goal Seek
(b) Solver
(c) Scenario
(d) Macros
Answer: (d) Macros
19. Which language is used to create macros in MS-Excel?
(a) Java
(b) Visual Basic
(c) Access
(d) Visual C++
Answer: (b) Visual Basic
