question_answer

An organization sells its products in three regions and the quarterly sales from each region is stored in three identical worksheets. Now, the sales team want to know the total sales of each product by adding sales from all regions. Which MS-Excel tool should be used for this purpose?

A) Goal Seek         

B) Consolidate

C) Watch Window

D)        Subtotal