Unit 2 Electronic Spreadsheet (Advanced) Use Consolidating data (Questions and Answers)

Very short answer questions (One mark questions)

1. The _____________ feature provides the contents of one cell from more than one sheet can be combined at 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)

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

Short answer questions:(2/3 Marks questions)

Q – 1 What do you mean by consolidating data?
Q – 3 Write the options available in consolidate dialog box.
Ans.: The following options are available in consolidate 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 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?

2 thoughts on “Unit 2 Electronic Spreadsheet (Advanced) Use Consolidating data (Questions and Answers)”

  1. AMRUTH

    IT IS VERY USEFULL TO ME

Comment Your Views

%d bloggers like this: