DATABASE FUNDAMENTALS
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: -A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).
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.