Class 10 Info Tech Electronic Spreadsheet Advanced Session 1 – Analyse Data Using Scenarios and Goal Seek MCQs

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 Info Tech 402


You cannot copy content of this page

Scroll to Top