DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
cell
|
|
|
name box
|
|
|
entry bar
|
|
|
none of the above
|
Detailed explanation-1: -A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row.
Detailed explanation-2: -Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column “C” in Row “3” would be cell C3.
Detailed explanation-3: -The symbol is already used in table references to indicate implicit intersection. Consider the following formula in a table =[Column1]. Here the indicates that the formula should use implicit intersection to retrieve the value on the same row from [Column1].
Detailed explanation-4: -The space character (” “) is actually intersect operator for Excel. Putting a space between two ranges returns the intersection cell or range that two ranges shares.
Detailed explanation-5: -A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows.