Important Questions Use Consolidating data Class 10

In this article, we are going to discuss Important Questions Use Consolidating data Class 10. Let’s start it!

Important Questions Use Consolidating data Class 10

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 10.

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 will get short answers questions of 2 marks.

Short answer questions:(2/3 Marks questions)

Q – 1 What do you mean by consolidating data?
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?
That’s all from the topic Use Consolidating data Class 10. If you have doubt or query related to this topic, feel free to ask in the comment section.

2 thoughts on “Important Questions Use Consolidating data Class 10”

  1. AMRUTH

    IT IS VERY USEFULL TO ME

Comment Your Views

%d bloggers like this: