Consolidating data from multiple sources  Excel MCQs

By: Prof. Dr. Fazal Rehman Shamil | Last updated: August 1, 2024

  1. Which feature in Excel allows you to combine data from multiple ranges into a single summary?
    a) Data Validation
    b) Consolidate
    c) Filter
    d) Sort
    Answer: b) Consolidate
  2. When using the Consolidate feature, which function can you NOT use to summarize data?
    a) Sum
    b) Average
    c) Product
    d) VLOOKUP
    Answer: d) VLOOKUP
  3. In the Consolidate dialog box, what must you add to specify the ranges to be consolidated?
    a) Formulas
    b) References
    c) Labels
    d) Functions
    Answer: b) References
  4. Which tab in the Excel ribbon contains the Consolidate feature?
    a) Insert
    b) Formulas
    c) Data
    d) Review
    Answer: c) Data
  5. When consolidating data, which option should you select if your data includes labels in the top row and left column?
    a) Use labels in: Top row
    b) Create links to source data
    c) Use labels in: Left column
    d) Both a and c
    Answer: d) Both a and c
  6. What does the option “Create links to source data” do when consolidating data?
    a) It copies the source data to a new location
    b) It creates hyperlinks to the source data
    c) It updates the consolidated data when the source data changes
    d) It merges the data into one cell
    Answer: c) It updates the consolidated data when the source data changes
  7. Which of the following is NOT a step in the consolidation process?
    a) Select the destination range
    b) Click on the Consolidate button
    c) Define the references for the data ranges
    d) Insert a Pivot Table
    Answer: d) Insert a Pivot Table
  8. Can you consolidate data from different worksheets within the same workbook?
    a) Yes
    b) No
    Answer: a) Yes
  9. What should you do if you want to consolidate data from multiple workbooks?
    a) Open all workbooks
    b) Close all workbooks
    c) Only open the destination workbook
    d) It is not possible to consolidate from multiple workbooks
    Answer: a) Open all workbooks
  10. Which function in the Consolidate dialog box would you use to count the number of entries in the source ranges?
    a) Sum
    b) Count
    c) Average
    d) Max
    Answer: b) Count

Related Posts: