Important Questions Use Consolidating data
.jpg)
Let’s start the article Important Questions Use Consolidating data Class 10 with very short answer questions of one mark.
Very short answer questions (One mark questions)
1. The _____________ feature provides the contents of one cell from more than one sheet that can be combined in one place.
2. You cannot combine more than one worksheet cell data into different sheets and use the formula. (True/False)
3. How to open a consolidated dialog box in OO Calc?
4. To create a range, which of the following option is used?
a. Insert → Names → Rang b. Insert → Names → Define c. Insert → Range d. None of these
5. Which of the following button is used to define a range after typing name?
a. Add b. OK c. More d. Delete
6. The row labels and column labels options will only available when you click on _______ button.
7. The __________ option is used to update the value in consolidated worksheet formula cell automatically when the user changes data in source cell.
8. Which of the following option allows to select the source of data for the consolidation?
a. Function b. Consolidation Ranges c. Source Data range d. Copy results to
9. Which of the following option of consolidate dialog box allow to select destination cells?
a. Function b. Consolidation Ranges c. Source Data range d. Copy results to
10. Once ranges are added to consolidated dialog cannot be deleted. (True/False)
Find the answers for Objective Type Questions for Use Consolidating data Class
Answers
1. Consolidate
2. False
3. Click on Data → Consolidate option.
4. ( b.) Insert → Names → Define
5. ( a.) Add
6. Consolidate by
7. Link to source data
8. c. Source Data range
9. Copy result to
10. False
In the next section of the article Use Consolidating data Class 10 you wilto l get short answers questions of 2 marks.
Short answer questions:(2/3 Marks questions)
Q – 1 What do you mean by consolidating data?
Ans.:
Consolidating data is a process to gather data from various separate worksheets and add to a master worksheet.
In other words, data consolidation takes data from a series of worksheets or workbooks and summaries it into a single worksheet that can be updated easily.
Q – 2 Write steps to use consolidating data in OO Calc.
Ans.: Follow these steps to consolidate data:
Create separate worksheets as per the requirements.
Place the cursor in the target worksheet where data consolidation is needed.
Click on Data – Consolidate option. A data consolidate dialog box appears.
Select the required function from the Function drop-down button.
Add the ranges by selecting the Source data range and Add button as you need.
Select the copy results to cell to display the result.
Click on OK button.
Q – 3 Write the options available in the Consolidate dialog box.
Ans.: The following options are available in consolidating the dialog box.
Function
Consolidate Ranges
Select data range
Copy results to
Labels
Link to source data
Button – OK, Cancel, Help, Add, Delete, More
Q – 4 What is the role of function option in consolidate dialog box?
Ans.: The function option in consolidate dialog box allows to select the function in the destination cells. This is the first thing that has been done by the user in the consolidating data process.
Q – 5 What is the consolidation ranges list?
Ans.: The consolidation ranges list displays the list of selected ranges from where the input is coming. It is the ranges of other sheets or input values. It is displayed like this: $Sheet1.$A$6.
Q – 6 How to add input value cells without creating ranges for data consolidation?
Ans.:
Step 1: Click on the source data range option.
Step 2: Click on the shrink button.
Step 3: Move to the source worksheet and select the cell.
Step 4: Now again click on the shrink button.
Step 5: Click on the Add button.
Q – 7 How to define ranges?
Ans.: Follow the given steps to define ranges in OO Calc.
Select the cells for which range is going to be defined.
Click on Data – Define Range option.
Name for the range.
Click on OK button.
Q – 8 What is the significance of Copy results to option in Data consolidation?
Ans.: Copy results to option in data consolidation provides the option to select the cell where the result will be displayed. Basically, it contains the function and target cells to calculate the result.
Q – 9 Name a few functions available in the data consolidation function drop down.
Ans.: The data consolidation function drop-down has the following functions in the Function drop-down list.
Sum
Count
Average
Max
Min
Product etc.
Q – 10 Explain the option Link to source data.
Ans.: The option Link to source data is given to insert the formulas. Basically, it produces the results in the target range instead of the actual results.
If this option is clicked in data consolidation, then any values modified in the source ranges are automatically updated in the target range.
The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed.
Q – 11 What is the use of consolidate by? What are the options provided by OO calc under this option?
Ans.: The option consolidate by is used to select the matching the row label or column label. It has two options:
Row labels
Columns labels
To consolidate by row labels or column labels, the label must be contained in the selected source ranges. The text in the labels must be identical so that rows or columns can be accurately matched.
Scenarios class 10 IT 402 questions
A ___________ function provides a tool to test and quickly change the arguments of formula and view the new results.
You can use _________ to modify existing scenarios.
Which menu contains the option of creating scenarios?
File
Edit
Tools
Data
Click on _______ –> ___________ to open navigator window.
Which of the following is a shortcut key to open navigator window?
F2
F5
F3
F4
A ____________ is the information displayed in navigator when you click the scenarios icon and select the desired scenario.
Which of the following option is not available under settings checkboxes in create scenario dialog box?
Display Border
Copy Back
Prevent Changes
Navigator
The __________ option displays the arrow points to the cells directly dependent on the current cell.
To edit a scenario including its name and comments, right-click on the scenario name and choose the _____________ option.
You cannot delete a scenario once it is created. (True/False)
A ____________ tool is used to create a formula array in OO Calc.
Which of the following statement is/are correct with respect to multiple operations?
It is a function that acts on other functions.
It allows computing different results without having to enter and run them separately.
You need two arrays for cell for multiple operations.
All of the above
Only Option 1 or only option 2 or only option 3
Option 1, 2 and 3
Option 1 and 3
Only option 1
Click on ____________ –> _____________ option to open multiple operations in OO Calc.
You can only compute the results by input rows using Multiple Operations. (True / False)
You can easily select the cell for the input cell by clicking _________ button in the Multiple Operations dialog box.
In OO Calc, Data –> Multiple Operations option is enabled, by default . (True / False)
Find answers for scenarios class 10 IT 402 questions – objective types questions below:
Answers
What-if Scenarios
Navigator
Tools
View –> Navigator
F5
Comment
4. Navigator
Trace Dependents
Properties
False
Multiple Operations
2. Options 1, 2 and 3
Data, Multiple Operations
False
Shrink
False
Short Answer Questions (2/3 Marks) – Scenarios class 10 IT 402 questions
[1] What do you mean by what-if scenarios?
Ans. Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited and formatted separately. When you print the spreadsheet, only the content of the currently active scenario is printed.
A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells.
[2] What are the basic requirements needed for using what-if scenarios?
Ans. The basic requirements needed for using what-if scenarios are given below:
1. Data to be considered for scenarios
2. A formula which calculates the data
3. Data should be entered for the first scenarios as default
[3] Explain the options available under what-if scenarios dialog box?
Ans. The scenarios dialogbox has three options and three buttons:
1. Options: Name of scenario, Comment and Settings
2. Buttons: OK, Cancel and Help
[4] What are the rules you should follow while giving the name of the scenarios?
Ans.The rules should be followed while giving the name of scenarios are:
1. Do not use any space in scenario names.
2. Do not use any special characters except _ (Underscore) in scenario name.
3. Keep the names short as much as possible and simple.
4. Ensure each scenarios name is unique.
[5] Which setting options do you need to check before creating a scenario? Explain each of them in short.
Ans.The scenario settings should be checked before creating scenarios are as following:
1. Display border and its colour
2. Copy back
3. Prevent Changes
[6] How to edit an existing scenario?
Ans.: To edit an existing scenarios follow the given steps:
1. Click on View – Navigator. A navigator opens.
2. Find the button scenarios.
3. Write on the button and choose Properties.
4. Do the changes needed.
5. Click on OK.
[7] Write steps to delete a scenario?
Ans. Follow below given steps to delete a scenarios:
1. Open Navigator.
2. Do right click on the scenario name to be deleted.
3. Choose Delete option from the pop up menu.
4. Click on Yes button when prompt a message to delete selected scenario.
5. Close the navigator.
Long answer questions (4/5 Marks) – Scenarios class 10 IT 402
There is only one long answer important scenarios class 10 IT 402 question.
Write steps to create scenarios.
Ans.: Follow these steps to create scenarios.
1. Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the Ctrl key as you click each cell.
2. Choose Tools > Scenarios.
3. On the Create Scenario dialog , enter a name for the new scenario. It‘s best to use a name that clearly identifies the scenario, not the default name.
4. Optionally add some information to the Comment box. The example shows the default comment. This information is displayed in the Navigator when you click the Scenarios icon and select the desired scenario.
5. Optionally select or deselect the options in the Settings section. See below for more information about these options.
6. Click OK to close the dialog. The new scenario is automatically activated.
Objective Type Questions – questions GoalSeek Solver
Class 10 IT 402 1 Mark Questions
Fill in the blanks, MCQ , True/False or one-word answer
1 A _______ feature provides a target-based result and informs the user about the changes in value in the applied formula.
Ans.: GoalSeek
2 To run a GoalSeek, at least one of the values for an argument must be
a) value
b) range
c) cell reference
d) b and c
3 How many arguments can be altered in GoalSeek?
Ans.: One
4 You cannot replace the original value with GoalSeek resultant value. (True/False)
Ans.: False
5 You must place a cursor in a formula cell before using GoalSeek. (True/False)
Ans.: True
6 A ___________ option displays a cell address in GoalSeek dialogbox.
Ans.: Formula Cell
7 Which of the following option is used to type a resultant value to achieve the goal?
a) Goal Value
b) Target Value
c) Variable Value
d) GoalSeek Value
Ans. b) Target Value
8 The ______________ option allows to select a cell to display or set the result value in a GoalSeek dialog box.
Ans.: Variable Cell
9 OO Calc display the change of value in which of the following?
a) In the variable cell
b) In the dialog box
c) In a message
d) All of the above
Ans.: a) In the variable cell
10 When you click on OK button in GoalSeek dialogbox, ____________ will appear in OO Calc.
Ans.: GoalSeek Successful Message box
11 The GoalSeek Successful Message box will show only the target value as result. (True/False)
Ans.: False
12 A ___________ feature is more elaborate form of GoalSeek.
Ans. Solver
13 Which feature of OO Calc deals with formulas with multiple unknown value?
Ans.: Solver
14 Click on __________ -> ___________ to open GoalSeek dialog box.
Ans: Tools –> GaolSeek
15 Click on _______ -> _______ to open solver dialog box.
Ans.: Tools –> Solver
16 You can set any kind of value like greater than, lesser than, equal or specific value using solver. (True/False)
Ans.: True
17 You can optimize result to which of the following using solver?
a) Best value, Value of, Exact Value
b) Maximum, Minimum, Value of
c) Less Than, Greater than or Equal to
d) All of the above
18 In solver dialog box ____________ option indicates the formula cell.
Ans.: Target Cell
19 You cannot select any range for changing cells option in the Solver dialog box. (True/False)
Ans.: False
20 The solver dialog box displays the value as a result in a result message box. (True/False)
Ans.: False
2/3 Marks Questions – questions GoalSeek Solver Class 10 IT 402
1 What do you mean by GoalSeek?
Ans.:
Goal seek is an important feature of the spreadsheet that is used to find the values which are required to achieve a certain target. It allows changing the cell value which produces the desired target value. In goal seek any one value can be altered to get the desired result.
2 What are the basic predefined requirements for using GoalSeek?
Ans.:
To use goal seek you need to have values and a cell where a formula can be used.
3 Distinguish the Formula Cell and Variable cell.
Ans.:
The formula cell contains the formula.
Variable cell means in which cell you want to change the value to get desired goal.
4 Enlist the options provided by GoalSeek and explain all of them in one line each.
Ans.:
The options provided by Goal Seek are as follows:
Formula cell – A cell where the formula is used
Target Value – A numeric value that indicates what target can be achieved
Variable Cell – The variable cell is a cell whose value can be altered
OK Button – After setting up the goal seek parameter click on the OK button to see the result
Cancel Button – If the user wants to change any of the goalseek settings this button should be used
Help Button – If any assistance is required related to Goalseek, this button is used
5 What is Solver?
Ans.:
Solver is a more elaborated form of goalseek. As in goal seek you alter only one value can , in solver you can alter multiple values.
6 What is role of optimized result to option in the Solver dialog box?
Ans.:
The option optimized result to provide the value which can be achieved. OO Office calc provides 3 options to optimize results:
Maximum – It is the highest value can be achieved through parameters provided
Minimum – It is the lowest value that can be achieved through parameters supplied
Value of – The exact value which can be achieved using a solver
7 What are the options available in options button of Solver dialog box?
Ans.:
The options button provides the settings related to the solver engine. It provides the option as follows:
8 What happens when click on Solve button?
Ans.:
When the solve button is clicked it assumes the value can be put to achieve the desired goal. These values can be selected randomly and then the result is displayed in dialog box. If user want to keep the result he can otherwise he can cancel also.
Watch this video to get the solution to questions given in the CBSE study material:
5 marks questions GoalSeek Solver Class 10 IT 402
1 Write the complete procedure to perform GoalSeek in OO Calc.
Ans.:
Enter the values required in the cells,
Enter the desired formula.
Click on Tools – Goal Seek
Ensure the cell should be selected for the formula is correct.
Enter the target value.
Select the variable cell and click ok.
2 Write the complete procedure to use solver in OO Calc.
Ans.:
Prepare worksheet and enter values as per the requirement.
Click on Tools – Sovler.
Now select the formula cell.
Select the appropriate option to optimize the result out to maximum, mininum or value.
Now select the cells/ranges to be selected by changing cells.
Select various options to cell references conditions.
Click on OK to get the result.
Objective type questions –
Assignments setup multiple sheets
Fill in the blanks, MCQs and True/False
1 User can manage multiple sheets from which of the following part of spreadsheet software?
a) Status bar
b) Sheet tab
c) Formula bar
d) Worksheet Area
2 To insert new worksheet from Home tab click on ________–>_______ option.
Ans.: Insert, Insert Sheet (In OO Calc – Insert –> Sheet)
3 When user inserts a new worksheet in spreadsheet software, the new worksheet will be inserted to ___________
a) Next to the current sheet
b) Previous to the current sheet
c) At the end in sheet tab (Last Position)
d) At the beginning of the sheet tab (First Position)
(In OO Calc you have to choose the position)
4 The user cannot rename your worksheet with their desired names. (True/False)
5 Rename sheet option is available in _______ group of Home tab.
Ans.: Cells (In OO Calc Format –> Sheet –> Rename)
6 Once user deletes the worksheet it can’t be undone. (True/False)
7 The shortcut key to move to next worksheet (Right) is _________
Ans.: Ctrl + PageDown (PGDN)
8 The shortcut key to move to previous worksheet (Left) is ________
Ans. Ctrl + PageUp (PGUP)
9 The user can apply any color to the sheet tab. (True/False)
10 The user cannot delete multiple sheets at a time. (True/False)
11 To select multiple sheets, the user can click on the worksheet by holding which of the following key?
a) Alt
b) Ctrl
c) Shift
d) End
12 The user can move the worksheet anywhere in the workbook or in other spreadsheet as well. (True/False)
Objective type questions
Fill in the blanks, MCQs and True/False (1 Mark Questions)
1) A ________ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that is used in formula to calculate.
Ans.: cell reference
2) You can’t use another spreadsheet data into the main worksheet. (True/False)
3) Which of the following statement(s) is/are correct to create a reference in the spreadsheet:
a) Data from one or more contiguous cells on the worksheet
b) Data contained in different areas of a worksheet
c) Data on other worksheets in the same workbook
d) All of these
4) To insert new worksheet, press _______ + _____ shortcut key
Ans. : Shift, F11
5) To create a cell reference in another spreadsheet you must need to start with = sign. (True/False)
6) Ms. Chandani is working on two worksheets named – Data.xlsx and profile.xlsx. She has created one cell reference into profile.xlsx from data.xlsx. The cell address is A3. So the destination cell looks like:
a) data!$A$3
b) data!$A3
c) data!A3
d) data!A$3
7) The ________ allows you to render to another document or website.
Ans.: Hyperlink
8) The hyperlink option is available under which group of insert tab?
a) Hyperlinks
b) links
c) Create Hyperlinks
d) Text
9) A ________ field of insert hyperlink dialog box displays the address which is hyperlinked in the spreadsheet.
Ans. Address
10) A ____ + ___ is a shortcut key of insert hyperlink.
Ans.: ctrl, k
11) You can do hyperlink on only the files saved in your computer. (True/False)
12) You can create a new file from insert hyperlink dialog box to create hyperlink. (True/False)
13) When you select Create New Document option from insert hyperlink dialog box and you can edit that document anytime by default. (True/False)
14) You cannot change the hyperlinked document once hyperlink is created. (True/False)
15) You will get remove hyperlink button from which of the following command?
a) Insert Hyperlink
b) Edit Hyperlink
c) Delete Hyperlink
d) All of these
.png)
.png)
.png)
.png)
.png)
.jpg&description=Important Question IT (402) Board Examination 2023-24 : Open office calc){kind=link}
0 Comments