DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
cell reference
|
|
|
range
|
|
|
value
|
|
|
function
|
Detailed explanation-1: -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-2: -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-3: -A cell is the intersection point of a column and a row. Data entered into Excel is always stored in a cell.
Detailed explanation-4: -A cell is the intersection of a row and a column-in other words, where a row and column meet.
Detailed explanation-5: -Difference between a column and row. The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right.