Question

Which of the following statement is wrong about consolidate data?

• A. Select all the files to be consolidated
• B. On 'File' menu select 'consolidate'
• C. On window menu click the names of the files with data to be consolidated
• D. Select the cells to consolidate and click 'add' order in the consolidate dialog box click 'OK'.

Answer 1

Answer:

B. On 'File' menu select 'consolidate'

To Consolidate data

• Select all the files to be consolidated 
• On 'Data' menu select 'consolidate'
• On window menu click the names of the files with data to be consolidated.
• Select the cells to consolidate and click 'add' order in the consolidate dialog box click 'OK'.