DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Toolbar
|
|
|
Cell
|
|
|
Name Box
|
|
|
Formula Bar
|
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.
Detailed explanation-2: -A cell is the intersection point of a column and a row.
Detailed explanation-3: -Intersection of a Single Row and Column Now if you use =C2:C13 B5:D5 [Note there is a single space in between the ranges, which is also our intersect operator in Excel], it will return 523 (the value in cell C5), which is the intersection of these 2 ranges.
Detailed explanation-4: -A table is a grid of rows and columns that intersect to form cells. The lines that mark the cell boundaries are called gridlines.
Detailed explanation-5: -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.