DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell
|
|
|
Rows
|
|
|
Table
|
|
|
None of the above
|
Detailed explanation-1: -The intersection of a row and a column is called a cell. In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. A cell can only store 1 piece of data at a time.
Detailed explanation-2: -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-3: -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.
Detailed explanation-4: -The Correct Answer is “Cell". A worksheet in Excel is made up of Rows and Columns. The intersection of a Row and column in an Excel worksheet is a rectangle called a Cell. Cells store a value, a formula, or text.
Detailed explanation-5: -A table is a grid of rows and columns that intersect to form cells. The lines that mark the cell boundaries are called gridlines.