Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Q1. _________ data is the process to extract useful information
for making effective decisions
a. Reading
b. Analysing
c. Testing
d. Training
Q2. Which software is used to analyse data?
a. Spreadsheet
b. Writer
c. Impress
d. Paint
Q3. The spreadsheet component in LibreOffice is known as ________
a. Writer
b. Impress
c. Base
d. Calc
Q4. _______________ is a function used to combine information
from multiple sheets of the spreadsheet into one place to summarize the information
a. Goal seek
b. Subtotal
c. Solver
d. Consolidate
Q5. Consolidate option is available under _________ menu.
a. View
b. Tool
c. Insert
d. Data
Q6. Data can be consolidated from two sheets only.(T/F)
a. True
b. False
Q7. Aman wants to summarise the data from three different sheets in Calc. Which option will help him complete this task?
a. Sort
b. Solver
c. Count
d. Consolidate
Q8. We can consolidate data by ________
a. Row Label
b. Column Label
c. Both of the above
d. None of the above
Q9. Anshul wants to consolidate data from three sheets in Calc. He wants to consolidate the data using “Row Labels“. He opened the Consolidate Data dialog box, but he could not find the “Row Labels” option. By clicking on which of the following will the “Row Labels” option become visible?
a. Functions
b. Options
c. Advanced
d. More
Q10. The ranges of all the sheets that we want to consolidate in LibreOffice Calc are visible under the ___________________ option.
a. Consolidation ranges
b. Source Data Ranges
c. Link to Data Source
d. Copy results to
Q11. Which of the following functions are available in consolidate window?
a. Max
b. Min
c. Count
d. All of the above
Q12. In which option 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
Q13. 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 source range
Q14. Default function in Consolidata data dialog box is _________.
a. Average
b. Sum
c. Count
d. Max
Q15. The sources data range list contains ________________ to quickly select from that.
a. Consolidation options
b. Name of functions
c. Existing named ranges
d. Name of style
Q16. __________________ is checked to make the modification automatically in the consolidated (target) sheet while making any
changes in the source data.
a. Column labels
b. Row labels
c. Copy results to
d. Link to source data
Q17. _________ allows you to gather data from different worksheets into a master worksheet.
a. Data Consolidation
b. Goal Seek
c. Solver
d. Total data
Q18. We can consolidate data by ________
a. Row Label
b. Column Label
c. Both of the above
d. None of the above
Q19. In which option 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
Q20. 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 source range
Q21. Which option is used to name a range of cells?
a. Range name
b. Cell Range
c. Define Range
d. Select Range
Q22. Define range option is available under ________ menu.
a. Insert
b. View
c. Developer
d. Data
Q23. The text in the row label or column label must be identical, otherwise, new row or column will be inserted.(T/F)
a. True
b. False
Q24. SUBTOTALS _________ data arranged in an array (that is, a group of cells )
a. Add
b. Average
c. Find
d. Clear
Q25. Subtotals is available in __________ menu.
a. Tools
b. Format
c. Insert
d. Data
Q26. Identify the correct sequence
a. First open subtotals window and then select the data where we need to apply subtotals.
b. First Select data and then open subtotals window.
c. Both of the above are correct
d. None of the above
Q27. Scenarios are tool to test _________ questions.
a. if else
b. what else
c. what if
d. if
Q28. Each scenario has a name.(T/F)
a. True
b. False
Q29. Scenario option is available in ___________________ menu.
a. Data
b. Tools
c. Insert
d. Windows
Q30. When we print a spreadsheet, only content of active scenario is printed.(T/F)
a. True
b. False
Q31. We can shift from one scenario to another by _____________
a. Navigator
b. Find and Replace
c. Data Source
d. None of the above
Q32. We can create only 3 scenario for a given range of cells.(T/F)
a. True
b. False
Q33. Which option is suitable to calculate the effect of different interest rates on an investment.
a. Scenario
b. Subtotal
c. Consolidate
d. None of the above
Q34. 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
Q35. 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
Q36. Goal Seek Option available in __________ menu.
a. Tools
b. Format
c. Data
d. Insert
Q37. Comment in Create Scenario dialog box is Optional(T/F)
a. True
b. False
Q38. We can give different colors to different scenario?(T/F)
a. True
b. False
Q39. ________________ in Calc is used to create an outline of the selected data and can group rows and columns together.
a. Solver
b. Goal Seek
c. Scenario
d. Group and Outline
Q40. Group and Outline option is available in __________ menu.
a. Insert
b. Edit
c. Data
d. Tools
Q41. _________________ tool in Calc creates the group automatically and applies functions like sum, average on the grouped data.
a. Subtotal
b. Group and Outline
c. Goal Seek
d. Consolidate
Q42. Which button in subtotal dialog box help us to clear the current subtotal settings?
a. Remove
b. Reset
c. Clear
d. Cancel
Q43. Aman wants to sort grouped data in ascending or descending order. Under which tab of the Subtotals dialog box sort option is available?
a. 1st Group
b. 2nd Group
c. Options
d. 3rd Group
Q44. What is the default function selected in subtotal dialog box?
a. Sum
b. Count
c. Average
d. Max
Q45. Arun is working on the Subtotal feature of Calc. After grouping the data, he saw group indicators like ‘+’ and ‘–’ signs on the left side of the grouped data. What is the purpose of the ‘+’ sign?
a. To collapse the data
b. To expand the data
c. To hide data
d. To delete data
Q46. Anju used the Group and Outline feature of Calc to group the data. Now she wants to remove the created outline. Which of the following option will help her to perform this task?
a. Data > Group and Outline > Remove Outline
b. Data > Group and Outline > Delete Outline
c. Data > Group and Outline > Clear Outline
d. Data > Group and Outline > Ungroup Outline
Q47. Several scenarios can be created in the same sheet. (T/F)
a. True
b. False
Q48. Kumar created five groups in Calc using the Group and Outline feature. Now his teacher asked him to remove only the third group. Which option should he choose?
a. Remove Group
b. Remove Outline
c. Delete Group
d. Ungroup
Q49. Arun wants to start a new project. Which of the following feature of Calc can be used by Arun at the beginning of the project to optimise the output?
a. Scenario
b. Group and Outline
c. Goal Seek
d. Solver
Q50. Parth wants to take a loan from bank to start his startup. Now he wants to analyse the EMI and total interest paid for different loan amount and time period. Which of the following feature of Calc will help him?
a. Goal Seek
b. Scenario
c. Solver
d. Group and Outline
Q51. We can give different colours to different scenario? (T/F)
a. True
b. False
Q52. ____________ icon in Calc is used to manage scenario in Calc
a. Style
b. Find and Replace
c. Navigator
d. Functions
Q53. ___________ tool uses two arrays of cells, one array contains the input values and second array uses the formula and display the result. tell me the answer and check grammar.
a. Multiple Operations
b. Goal Seek
c. Scenario
d. Group and Outline
Q54. _____________ tool is very helpful when we want to know how much profit we earn for a particular product for a series of selling units. tell answer and check grammar
a. Scenario
b. Multiple Operations
c. Goal Seek
d. Style
Q55. Multiple Operations is available in ____________________ menu.
a. Tools
b. Insert
c. Data
d. Format
Q56. Which of the following option is not available in Multiple Operation dialog window?
a. Formulae
b. Row input cell
c. Column input cell
d. Formula Cell
Q57. _____________ helps in finding out the input for the specific output.
a. Goal Seek
b. Multiple Operations
c. Scenario
d. Consolidate
Q58. Which of the following option is not available in Goal seek
dialog window?
a. Formula Cell
b. Variable Cell
c. Target Value
d. Cell Address
Q59. Vivek’s school teacher is reading the following line from IT book.
“Let us take a very simple example to perform the backward calculation to find out an input depending upon the specific output”
Can you guess which topic he is teaching?
a. Scenario
b. Multiple Operations
c. Goal Seek
d. Consolidate
Q60. A student has received marks in 4 subjects and has to
appear for the 5th subject and plans an aggregate as 70. So, he
can use _________________ tool to check how many marks he has to score in the 5th subject to get the required percentage
a. Multiple Operations
b. Goal Seek
c. Scenario
d. What if condition
Important links of Class X (IT – 402)
Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
Chapter 1. Introduction to Styles – NOTES
Chapter 1. Introduction to Styles – Question Answers
Chapter 2. Working with Images – NOTES
Chapter 2. Working with Images – Question Answers
Chapter 3. Advanced features of Writer – NOTES
Chapter 3. Advanced features of Writer – Question Answers
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Chapter 4. Analyse Data using Scenarios and Goal Seek – NOTES
Chapter 4. Analyse Data using Scenarios and Goal Seek – Question Answers
Chapter 5. Using Macros in Spreadsheet – NOTES
Chapter 5. Using Macros in Spreadsheet – Question Answers
Chapter 6. Linking Spreadsheet Data – NOTES
Chapter 6. Linking Spreadsheet Data – Question Answers
Chapter 7. Share and Review a Spreadsheet – NOTES
Chapter 7. Share and Review a Spreadsheet – Question Answers
Unit 3: Database Management system using LibreOffice Base
Chapter 8. Introduction to DBMS – NOTES
Chapter 8. Introduction to DBMS – Question Answers
Chapter 9. Starting with LibreOffice Base – NOTES
Chapter 9. Starting with LibreOffice Base – Question Answers
Chapter 10. Working with Multiples Tables – NOTES
Chapter 10. Working with Multiples Tables – Question Answers
Chapter 11. Queries in LibreOffice Base – NOTES
Chapter 11. Queries in LibreOffice Base – Question Answers
Chapter 12. Forms and Reports – NOTES
Chapter 12. Forms and Reports – Question Answers
Unit 4: Prevent Accident and Emergencies
Chapter 13. Health, Safety and Security at Workplace – NOTES
Chapter 13. Health, Safety and Security at Workplace – Question Answers
Chapter 14. Workplace Safety Measures – NOTES
Chapter 14. Workplace Safety Measures – Question Answers
Chapter 15. Prevent Accidents and Emergencies – NOTES
Chapter 15. Prevent Accidents and Emergencies – Question Answers
UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) – MCQ
UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) – MCQ
UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) – MCQ
Disclaimer : I tried to give you practice of Analyse data using Scenarios and Goal Seek MCQ. This way you can find out your weak areas of Ch-4 Analyse data using Scenarios and Goal Seek MCQ . All the questions given above of Analyse data using Scenarios and Goal Seek MCQ are designed from NCERT book. If you find any mistake in the above questions of Analyse data using Scenarios and Goal Seek MCQ, you can directly contact me at csiplearninghub@gmail.com
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
Analyse data using Scenarios and Goal Seek MCQ
v v v v v v v