DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Name Box
|
|
|
Column
|
|
|
Row
|
|
|
Formula Bar
|
Detailed explanation-1: -Detailed Solution. The address of the Current Active Cell is displayed in the Cell Name box. Data or Formula of Current Active Cell can be viewed inside the Cell Contents box of the Excel Formula bar.
Detailed explanation-2: -You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2, 3) returns $C$2. As another example, ADDRESS(77, 300) returns $KN$77.
Detailed explanation-3: -Detailed Solution The correct answer is the Formula bar. The formula bar displays the content of the active cell in MS Excel.
Detailed explanation-4: -A reference is a cell’s address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.