FUNDAMENTALS OF COMPUTER

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: -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!

Detailed explanation-4: -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-5: -Select the Format dropdown from the Cells group of the ribbon. Select the Format cells option at the bottom of the dropdown menu.