DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The column
|
|
|
The cell
|
|
|
The row
|
|
|
None of the above
|
Detailed explanation-1: -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.
Detailed explanation-2: -Excel mixed cell reference. A mixed cell reference in Excel is a reference where either the column letter or a row number is fixed. For example, $A1 and A$1 are mixed references.
Detailed explanation-3: -The default reference style By default, Excel for the web uses the A1 reference style, which refers to columns with letters (A through XFD, for a total of 16, 384 columns) and refers to rows with numbers (1 through 1, 048, 576). These letters and numbers are called row and column headings.
Detailed explanation-4: -What is R1C1 Reference Style in Excel? R1C1 is the other type of reference style that you can use in Excel. Here, R refers to the Row and C refers to the column, so R1C1 would refer to the cell in the first row and first column. Similarly, R2C3 would refer to the cell in the second row and third column.