Electronic Spreadsheet Advanced Class 10 MCQ
SESSION 1: ANALYSE DATA USING SCENARIOS AND GOAL SEEK
Multiple Choice Questions
1. _________ allows you to gather data from different worksheets into a master worksheet.
a. Data Consolidation
b. Goal Seek
c. Solver
d. Total data
Answer: a. Data Consolidation
2. _____________ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
a. Data Total
b. Goal Seek
c. Solver
d. Data Consolidation
Answer: d. Data Consolidation
3. Consolidate option is available under _________ menu.
a. View
b. Tool
c. Insert
d. Data
Answer: d. Data
4. Data can be consolidated from two sheets only. (T/F)
a. True
b. False
Answer: b. False
5. Click on _____ button to show the selected range on the Consolidated range list.
a. Sum
b. Add
c. Combine
d. Attach
Answer: b. Add
6. We can consolidate data by ________
a. Row Label
b. Column Label
c. Both of the above
d. None of the above
Answer: c. Both of the above
7. Which of the following functions are available in consolidate window?
a. Max
b. Min
c. Count
d. All of the above
Answer: d. All of the above
8. In which option do we have to specify the target range (Where we want the result to be displayed)
a. Source data range
b. Copy results to
c. Need result at
d. target range
Answer: b. Copy results to
9. Source data range can be selected by
a. Named ranges
b. Cell Reference Range
c. Both (a) and (b)
d. None of these
Answer: Both (a) and (b)
10. In which option do we have to specify the ranges to consolidate?
a. Source data range
b. Copy results to
c. Need result at
d. target range
Answer: a. Source data range
11. If you select ________ then any values modified in the source range are automatically updated in the target range.
a. Link to source data
b. Link to sheet data
c. Link to original data
d. Link to the source range
Answer: a. Link to source data
12. Can we copy the result to the defined range? (T/F)
a. True
b. False
Answer: a. True
13. The ______ specifies how the values of the consolidation ranges are linked.
a. Formula
b. Result
c. Function
d. Calculation
Answer: c. Function
14. ___________ function is the default setting for Consolidate dialog box.
a. MAX
b. AVERAGE
c. STDEV
d. SUM
Answer: d. SUM
15. Most of the available functions in the Consolidate dialog box are ______ .
a. Arithmetical
b. String
c. Statistical
d. Date and Time
Answer: c. Statistical
16. Which option is used to name a range of cells?
a. Range name
b. Cell Range
c. Define Range
d. Select Range
Answer: c. Define Range
17. Define range option is available under ________ menu.
a. Insert
b. View
c. Developer
d. Data
Answer: d. Data
18. The text in the row label or column label must be identical, otherwise, a new row or column will be inserted. (T/F)
a. True
b. False
Answer: a. True
19. To consolidate by row labels or column labels, the label must be contained in the selected ______ ranges
a. source
b. target
c. copy
d. none of these
Answer: a. source
20. If you are frequently consolidating with the same range, then you probably want to use ________ > _______ to give it a name.
a. Data > Define Range
b. Data > Consolidate
c. Data > Sort
d. Data > Filter
Answer: a. Data > Define Range
21. SUBTOTAL is a function listed under the _______ category when you use the Function Wizard (Insert > Function).
a. Mathematical
b. Statistical
c. Numerical
d. Accounting
Answer: a. Mathematical
22. SUBTOTALS _________ data arranged in an array that is, a group of cells with labels for columns and/or rows.
a. add
b. average
c. find
d. clear
Answer: a. add
23. SUBTOTALS _________ data arranged in an array that is, a group of cells with labels for columns and/or rows.
a. totals
b. average
c. find
d. clear
Answer: a. totals
24. Subtotals is available in __________ menu.
a. Tools
b. Format
c. Insert
d. Data
Answer: d. Data
25. Identify the correct sequence (Using the Subtotals dialog box and data)
a. First open the subtotals window and then select the data where we need to apply subtotals.
b. First Select data and then open the subtotals window.
c. Both of the above are correct
d. None of the above
Answer: b. First Select data and then open the subtotals window.
26. In Subtotals we can select up to _______ groups of arrays.
a. 3
b. 2
c. 4
d. Infinite
Answer: a. 3
27. While doing Subtotals, ensure that the columns have labels. (T/F)
a. True
b. False
Answer: a. True
28. In the Subtotals dialog, in the Group by box, select the ______ that you want to add the subtotals to.
a. row
b. column
c. row and column
d. none of these
Answer: b. column
29. If the contents of the selected column change, the subtotals are automatically recalculated. (T/F)
a. True
b. False
Answer: a. True
30. In the Calculate subtotals for box, select the ______ containing the values that you.
a. rows
b. columns
c. rows and columns
d. none of these
Answer: b. columns
31. The function that you want to use to calculate the subtotals, can be selected under the _______ box.
a. Group By
b. Calculate Subtotals
c. Use Function
d. None of these
Answer: c. Use Function
32. When more than one group are selected for subtotals, can be arrange the subtotals in ascending and descending order. (T/F)
a. True
b. False
Answer: True
33. The sort (ascending and descending) option is available under ______ tab in Subtotals dialog box.
a. 1st Group
b. 2nd Group
c. 3rd Group
d. Options
Answer: d. Options
34. Can you arrange the subtotals in “Custom Sort Order”. (T/F)
a. True
b. False
Answer: a. True
35. Groups can be case sensitive in subtotals, (Yes / No)
a. Yes
b. No
Answer: a. Yes
36. Can we insert page break between groups in Subtotals. (Y/N)
a. Yes
b. No
Answer: a. Yes
37. Scenarios are tool to test _________ questions.
a. if else
b. what else
c. what if
d. if
Answer: c. what if
38. Each scenario has a name. (T/F)
a. True
b. False
Answer: a. True
39. Scenarios name can be edited and formatted separately. (T/F)
a. True
b. False
Answer: a. True
40. When we print a spreadsheet, only content of active scenario is printed. (T/F)
a. True
b. False
Answer: a. True
41. We can shift from one scenario to another by ______ .
a. Navigator
b. Find and Replace
c. Data Source
d. None of the above
Answer: a. Navigator
42. Scenario option is available in _________ menu.
a. Data
b. Tools
c. Insert
d. Windows
Answer: b. Tools
43. We can create only 3 scenarios for a given range of cells. (T/F)
a. True
b. False
Answer: b. False
44. Which option is suitable to calculate the effect of different interest rates on investment.
a. Scenario
b. Subtotal
c. Consolidate
d. None of the above
Answer: a. Scenario
45. Default name of first scenario created in Sheet1 of Calc is ______.
a. Sheet1_Scenario1
b. Sheet1_Scenario_1
c. Sheet_1_Scenario1
d. Sheet_1_Scenario_1
Answer: b. Sheet1_Scenario_1
46. To select random multiple cell hold down ________ key as you click on each cell.
a. Alt
b. Shift
c. Ctrl
d. All of the above
Answer: c. Ctrl
47. Where the name of the Scenario is displayed?
a. Navigator
b. The title bar of the scenario on sheet
c. Both (a) and (b)
d. None of these
Answer: c. Both (a) and (b)
48. Information about scenario can be written in _______.
a. Comment Box
b. Scenario_Name Box
c. Display Information Box
d. None of these
Answer: a. Comment Box
49. Comment box of scenario is compulsory. (T/F)
a. True
b. False
Answer: b. False
50. This information written in the comment box is displayed in the ______ when you click the Scenarios icon and select the desired scenario.
a. Title
b. Navigator
c. Both (a) and (b)
d. None of these
Answer: b. Navigator
51. Using ________ , you can discover what values will produce the result that you want.
a. Solver
b. Goal Seek
c. Scenario
d. Sort
Answer: b. Goal Seek
52. Only ______ argument can be altered in a single goal seek.
a. one
b. two
c. three
d. four
Answer: a. one
53. The Chief Financial Officer of a company is developing sales projections for each quarter of the forthcoming year. She knows what the company’s total income must be for the year to satisfy stockholders. She also has a good idea of the company’s income in the first three quarters.
The CFO can enter the projected earnings for each of the other three quarters along with a formula that totals all four quarters. Then she runs a ________ on the empty cell for Q4 sales and receives her answer.
a. Solver
b. Goal Seek
c. Scenario
d. Subtotal
Answer: b. Goal Seek
54. Goal Seek option is available under ________ menu.
a. Insert
b. Data
c. Tools
d. Format
Answer: c. Tools
55. Which of the fields are available in the Goal Seek dialog box.
a. Formula cell
b. Target value
c. Variable cell
d. All of these
Answer: d. All of these
56. Place the cursor in the __________ , and choose Tools > Goal Seek.
a. formula cell
b. value cell
c. address box
d. anywhere in the sheet
Answer: a. formula cell
57. _______ filed, contains the address of that cell which value to be changed.
a. Formula cell
b. Target value
c. Variable cell
d. None of these
Answer: c. Variable cell
58. _______ filed, contains the desired result of the formula.
a. Formula cell
b. Target value
c. Variable cell
d. None of these
Answer: b. Target value
59. After clicking on the OK button in the Goal Seek dialog box, A dialog box appears for informing you that the Goal Seek was successful.
i. Click Yes to enter the result in the cell with the variable value.
ii. Click No to remain the previous value in the result cell and variable value cell.
a. Only I is correct.
b. Only II is correct
c. Both I & II are correct
d. I is correct but II is wrong.
Answer: c. Both I & II are correct
60. _______ is a more advanced form of Goal Seek.
a. Solver
b. Goal Seek
c. Scenario
d. Subtotal
Answer: a. Solver
61. Solver option is available under _______ menu.
a. Insert
b. Data
c. Tools
d. Format
Answer: c. Tools
62. _______ deals with the one variable, while _______ deals with multiple unknown variable.
a. Solver, Goal Seek
b. Goal Seek, Solver
c. Scenario, Goal Seek
d. Solver, Scenario
Answer: b. Goal Seek, Solver
63. _________ is specifically designed to minimize or maximize the result according to a set of customize and defined rules.
a. Solver
b. Goal Seek
c. Scenario
d. Subtotal
Answer: a. Solver
64. In solver, rules sets up whether an argument in the formula should be ___________ to the value you enter.
a. greater than
b. lesser than
c. equal
d. All of these
Answer: d. All of these
65. In Solver, If you want the argument to remain unchanged, you enter a rule that the cell that contains it should be _______ to its current entry.
a. greater than
b. lesser than
c. equal
d. Any one (a), (b) or (c)
Answer: c. equal
66. The solver dialog box has following options –
a. Target cell
b. By Changing cell
c. Optimize result to
d. All of the above
Answer: d. All of the above
67. In solver dialog box, You can Optimize result to ________.
a. Maximum
b. Minimum
c. Value of
d. All of the above
Answer: d. All of the above
68. In solver dialog box, enter limiting conditions for the variables by selecting the __________.
a. Cell reference filed
b. Operator field
c. Value filed
d. All of the above
Answer: d. All of the above
69. After Clicking on OK button in the Solver dialog box. An another dialog appears informing you that the Solving is successfully finished.
Click _______ to enter the result in the cell with the variable value.
a. Keep Result
b. Store Result
c. Save Result
d. None of these
Answer: a. Keep Result
70. A student is planning her goals about the marks she should attain in the forthcoming Semester 4 examinations in order to achieve a distinction (75%). Assuming that the examination of each subject is for 100 marks, her marks of the previous semesters are given as under.
Suggest a suitable method to find out how many marks should she obtain in 4th semester to secure distinction.
a. Solver
b. Goal Seek
c. Scenario
d. Subtotal
Answer: a. Solver
Class 10 Employability skills
- Class 10 Unit 1 – Communication Skills Important Question Answer
- Class 10 Unit 3 – Information and Communication Technology ICT Skills II 100+ MCQ’s SET-1
- Class 10 Employability Skills Unit 1 Communication Skills 50+ MCQ’s
- Class 10 Employability skills Unit 2 Self Management Skills 100+ MCQ’s
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 2
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 3
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 4
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 5
- Class 10 Unit 3 Information and Communication Technology ICT Skills II 50+ MCQs
- Class 10 Employability Skills Unit 4 Entrepreneurial Skills 100+ MCQ’s
Class 10 Info Tech 402
- Class 10 Info Tech Unit 1 Digital Documentation Create and Apply Styles MCQs
- Class 10 Info Tech Unit 1 Digital Documentation Create and Use Templates MCQs
- Class 10 Info Tech Digital Documentation Insert and Use Images
- Class 10 – Unit 3 ICT Skills 100+ MCQ’s Set 2
- Class 10 Unit 3 Information and Communication Technology ICT Skills II 50+ MCQs
- Class 10 Info Tech Unit 1 Digital Documentation Create and Customize Table of Contents MCQs 50+
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 1 – Analyse Data Using Scenarios and Goal Seek MCQs
- Class 10 Info Tech Unit 1 Digital Documentation Session 5 Implement Mail Merge MCQs
- Class 10 Info Tech Unit 3 RDBMS Session 1 Appreciate the Concept of Database Management System MCQs
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 2 – Link Data and Spreadsheets MCQ’s
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 3 – Share and Review a Spreadsheet MCQ’s
- Class 10 Info Tech Electronic Spreadsheet Advanced Session 4 – Create and Use Macros in Spreadsheets MCQs