DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It is the rectangle at the intersection of a row and column on a spreadsheet.
|
|
|
It is a highlighted rectangular box.
|
|
|
It is an expression which calculates the value of a cell.
|
|
|
It is a feature that allows the user to extend a series of numbers, dates, or text to have the amount of wanted cells.
|
Detailed explanation-1: -In any spreadsheet program such as Excel, each rectangular box in a worksheet is referred to as a cell. A cell is the intersection point of a column and a row. Data entered into Excel is always stored in a cell.
Detailed explanation-2: -Cells are the boxes you see in the grid of an Excel worksheet, like this one. Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.
Detailed explanation-3: -Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which 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-4: -The intersection of row and column is called a cell. A cell is a rectangle that is formed when a column and a row intersect. A cell is formed when a row and a column meet at one point. Each cell in Excel has its own address, which is made up of the column letter and row number.
Detailed explanation-5: -Intersect Operator in Excel can be used to find the intersecting value(s) of two lists/ranges. This an unusual operator as it is represented by a space character (yes that’s right). If you use a space character in between two ranges, then it becomes the Intersect operator in Excel.