DATABASE FUNDAMENTALS
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 consolidated main workbook that contains links to the separate workbooks is called the dependent workbook.
Detailed explanation-2: -Linking is the process of using references to cells in external workbooks to get data into your worksheet. Consolidating involves combining or summarizing information from two or more worksheets (which can be in multiple workbooks).
Detailed explanation-3: -Open the Data Tab. Click on Edit Links from the Connections group. A dialog box Edit Links will open up and list all the linked workbooks.
Detailed explanation-4: -The Normal style is the format style that Excel initially assigns to all cells in a new workbook. The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.