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 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.
Detailed explanation-2: -A code is a group of format specifications that are assigned a name. You can display the Cell Styles gallery by clicking the Cell Styles button (Home tab | Styles group). You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.
Detailed explanation-3: -Select the cell or cells where you want to create the external reference. Type = (equal sign). Switch to the source workbook, and then click the worksheet that contains the cells that you want to link. Press F3, select the name that you want to link to and press Enter.
Detailed explanation-4: -To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2!