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 Normal style is the format style that Excel initially assigns to all cells in a new workbook.
Detailed explanation-2: -How to reference another sheet in Excel. 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!A1.
Detailed explanation-3: -When you first type numbers in a worksheet, Excel applies the General number format automatically. You can unmerge a merged cell back into its original cells, but you cannot split a single cell into two new columns or two new rows. Sorting works the same whether or not the data have been formatted as a table.
Detailed explanation-4: -You should use static consolidation when the data on the source worksheets might be edited after you have created your consolidation worksheet.