Home > CBSE IT 402 > Quizzes > IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Analysing Data Using Scenarios And Goal Seek
IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Analysing Data Using Scenarios And Goal Seek
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 19% • Most missed: “Which of the following statement is correct with respect to scenarios print?”
IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Analysing Data Using Scenarios And Goal Seek
Time left 00:00
25 Questions

1. Read the following statements and select the correct option
A: The values changed by scenario are updated when the scenario is opened.
B: The values changed only if the formula contains the set of values with positive numbers.
2. Amish is a sales manager. He is trying to predict the total sales of all salesmen. He wants to know the options of the goal seek dialog box. Which of the following option is not present in the goal seek dialog box?
3. The __________ can be used to select arrays, and then choose a statistical function to apply them.
4. Minesh wants to switch the scenarios frequently. Which of the following options are helpful for him?
5. Mina is trying to understand formula cells and variable cells. Select the appropriate option from the following for variable cell:
6. for changing the argument user has to define
7. A _____________ is a saved set of cell values for calculation.
8. Solver is designed to
9. Divya wants to prepare a master sheet with a combination of data from another 3 worksheets. Which of the following feature is useful for her?
10. Each scenario in a spreadsheet
11. Chintan wants to limit the conditions in the solver dialog box. Which of the options can be helpful for him?
12. Preksha wants to see the maximum and minimum profits for the new product launched recently by her company. She wants to see the profits for multiple targets. Which of the following option is useful her
13. The scenarios option is available under ______ menu.
14. Which of the following is not the correct statement for the source data range?
15. The result of the solver is displayed in
16. Kapil is unable to find the subtotal option. Suggest an option to select the menu under which Subtotal is available:
17. If the value is set to equal to the current entry then
18. Gayatri is working in OO calc. She is searching for the option to define a range. Help her to search the option by selecting one of the correct options?
19. How many scenarios can be created on any range of given cells?
20. The sort option is available on _____________ tab in subtotal group.
21. To activate custom sort which of the following option is correct in oo calc?
22. Which of the following tool is used to test the what-if questions?
23. Which of the following statement is correct with respect to scenarios print?
24. Which of the following function is set as by default in data consolidation?
25. Which of the following is correct by default name for the scenarios under the scenario dialog box from Sheet1?

⚡ Recently practiced quizzes in this topic
Live quiz activity
IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Link Data And Spreadsheet IT-402 Data Entry and Keyboarding Skills Class 9 Practice Test IT 402 Important Communication Skills Class 9 Practice Test IT 402 Unit 3 RDBMS Class 10 Practice Test IT 402 Important Communication Skills Class 10 Practice Test 2 IT 402 Digital Documentation Class 10 Practice Test IT 402 ICT Skills Class 10 Practice Test 2 IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test IT-402 Digital Documentation Class 9 Practice Test IT 402 Digital Documentation Class 10 Practice Test
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.