Multiple choice

Which of the following is correct about ‘Consolidate’ item in Microsoft Excel?

  1. To prevent invalid data being entered into cell.

  2. To delete duplicate rows from the sheet.

  3. To separate the contents of one Excel into separate columns.

  4. To combine values of multiple ranges into one new range.

  5. To check the values in the cells.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Consolidate option is used to combine the values of multiple ranges into a new range.

Keep practicing — related questions