USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -The process of summarizing data included on multiple worksheets on one worksheet is called consolidation.
Detailed explanation-2: -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-3: -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.
Detailed explanation-4: -A consolidated worksheet summarizes data from multiple worksheets using a mathematical or statistical function.
Detailed explanation-5: -To enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. You can also format or print a selection of sheets at the same time.