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

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

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

3. Consolidate option is available under _________ menu.

a. View

b. Tool

c. Insert

d. Data

4. Data can be consolidated from two sheets only. (T/F)

a. True

b. False

5. Click on _____ button to show the selected range on the Consolidated range list.

a. Sum

c. Combine

d. Attach

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

9. Source data range can be selected by

a. Named ranges

b. Cell Reference Range

c. Both (a) and (b)

d. None of these

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

11. If you select ________ then any values modified in the source range are automatically updated in the target range.

d. Link to the source range

12. Can we copy the result to the defined range? (T/F)

a. True

b. False

13. The ______ specifies how the values of the consolidation ranges are linked.

a. Formula

b. Result

c. Function

d. Calculation

14. ___________ function is the default setting for Consolidate dialog box.

a. MAX

b. AVERAGE

c. STDEV

d. SUM

15. Most of the available functions in the Consolidate dialog box are ______ .

a. Arithmetical

b. String

c. Statistical

d. Date and Time

16. Which option is used to name a range of cells?

a. Range name

b. Cell Range

c. Define Range

d. Select Range

17. Define range option is available under ________ menu.

a. Insert

b. View

c. Developer

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

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

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

22. SUBTOTALS _________ data arranged in an array that is, a group of cells with labels for columns and/or rows.

b. average

c. find

d. clear

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

24. Subtotals is available in __________ menu.

a. Tools

b. Format

c. Insert

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

27. While doing Subtotals, ensure that the columns have labels. (T/F)

a. True

b. False

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

29. If the contents of the selected column change, the subtotals are automatically recalculated. (T/F)

a. True

b. False

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

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

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

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

34. Can you arrange the subtotals in “Custom Sort Order”. (T/F)

a. True

b. False

35. Groups can be case sensitive in subtotals, (Yes / No)

a. Yes

b. No

36. Can we insert page break between groups in Subtotals. (Y/N)

a. Yes

b. No

37. Scenarios are tool to test _________ questions.

a. if else

b. what else

c. what if

d. if

38. Each scenario has a name. (T/F)

a. True

b. False

39. Scenarios name can be edited and formatted separately. (T/F)

a. True

b. False

40. When we print a spreadsheet, only content of active scenario is printed. (T/F)

a. True

b. False

41. We can shift from one scenario to another by ______ .

a. Navigator

b. Find and Replace

c. Data Source

d. None of the above

42. Scenario option is available in   _________  menu.

a. Data

b. Tools

c. Insert

d. Windows

43. We can create only 3 scenarios for a given range of cells. (T/F)

a. True

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

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

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

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

49. Comment box of scenario is compulsory. (T/F)

a. True

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

51. Using ________ , you can discover what values will produce the result that you want.

a. Solver

b. Goal Seek

c. Scenario

d. Sort

52. Only ______ argument can be altered in a single goal seek.

a. one

b. two

c. three

d. four

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

54. Goal Seek option is available under ________ menu.

a. Insert

b. Data

c. Tools

d. Format

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

56. Place the cursor in the __________ , and choose Tools > Goal Seek.

a. formula cell

b. value cell

d. anywhere in the sheet

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

58. _______ filed, contains the desired result of the formula.

a. Formula cell

b. Target value

c. Variable cell

d. None of these

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

61. Solver option is available under _______ menu.

a. Insert

b. Data

c. Tools

d. Format

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

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

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

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)

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

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