Information Technology
Class-10
Part-B
Unit- 2 Electronic Spreadsheet (Advanced)
PART-I
A. Multiple Choice Questions:
1. _____________ is a tool to test "what-if" questions.
a. Scenario b. Solver c. Macro d. Average
Answer: Solver
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: Goal Seek
3. In a subtotal function what are the functions can be performed on the group of cells:
a. Sum b. Count c. Average d. All of the above
Answer: 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: Scenario
5. Solver command is found in _________ tab.
a. Data b. Tools c. Format d. Edit
Answer: Data
6. In data consolidate what are the operations we can perform_______.
a. Sum b. Average c. Max d. All of the above
Answer: 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: 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: 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: 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: Scenario
11. What does it mean by Goal Seek in spreadsheet?
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: To determine the value of cell for given result
12. Which function is not available in consolidating data?
a. Sum and count b. Max and Min c. Average and Product d. Percentage
Answer: Max and Min
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: 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: Solver
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: 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: 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: 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: Macros
19. Which language is used to create macros in MS-Excel?
a. Java b. Visual Basic c. Access d. Visual C++
Answer: Visual Basic
B. Write T for true or F for false:
1. Data can be consolidated from two worksheets only.
Answer: F
2. If the contents of selected columns are changed, the subtotals are automatically recalculated.
Answer: T
3. Subtotals can be arranged either in ascending or descending order.
Answer: T
4. We cannot insert page break between groups in subtotals.
Answer: F
5. Scenario does not have any name.
Answer: F
6. We can create only two scenarios for a given range of cells.
Answer: F
7. Scenario is more advanced form of solver.
Answer: F
8. Excel files can be shared only between two users.
Answer: F
9. While sharing an Excel file, password is optional.
Answer: T
10. When you have shared a file, you have to accept all changes done by the other user.
Answer: T
11. Macro is written in Visual C.
Answer: T
12. Macro can be used to sort data in a worksheet.
Answer: T
Some other links:
No comments:
Post a Comment