DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
By column (letter) and row (number)
|
|
|
By row (number) and column (letter)
|
|
|
By the contents of the cell
|
|
|
Names are randomly assigned
|
Detailed explanation-1: -To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50.
Detailed explanation-2: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
Detailed explanation-3: -The ADDRESS function returns the address for a cell based on a given row and column number. For example, =ADDRESS(1, 1) returns $A$1. ADDRESS can return a relative, mixed, or absolute reference, and can be used to construct a cell reference inside a formula.
Detailed explanation-4: -Cell Reference: A cell reference is the name of the cell that 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-5: -Define a name for a cell or cell range on a worksheet Select the cell, range of cells, or nonadjacent selections that you want to name. Click the Name box at the left end of the formula bar. Type the name you want to use to refer to your selection. Names can be up to 255 characters in length.