FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry. The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Detailed explanation-2: -Consolidate by position: Used when data in all the worksheets is arranged in exactly the same order and location. Consolidate by category: Used when the worksheets have the same row and column labels, but the rows and columns aren’t arranged in the same order on all the worksheets.

Detailed explanation-3: -On the Data tab, under Tools, click Consolidate. In the Function box, click the function that you want Excel to use to consolidate the data. In each source sheet, select your data, and then click Add.

Detailed explanation-4: -A consolidated worksheet summarizes data from multiple worksheets using a mathematical or statistical function.

Detailed explanation-5: -Click Data>Consolidate (in the Data Tools group). In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM. Select your data.