USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Groups from worksheets
|
|
|
Group several cells
|
|
|
Meeting between rows and columns
|
|
|
Meeting between cells and ranges
|
Detailed explanation-1: -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-2: -A boundary is a line between rows or columns. The column heading is identified by a letter. Column width is the left-to-right measurement of a column.
Detailed explanation-3: -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-4: -Rows are a group of cells arranged horizontally to provide uniformity. Columns are a group of cells aligned vertically, and they run from top to bottom. Although the main reason for both rows and columns is to bifurcate groups, categories and so on, there is a fine line of difference between the two.