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: -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). Each cell has its own name-or cell address-based on its column and row.
Detailed explanation-2: -Cell: A cell is a rectangular area formed by the intersection of a column and a row.
Detailed explanation-3: -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-4: -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-5: -What is Group in Excel? The “Group” is an Excel tool which groups two or more rows or columns. With grouping, the user has an option to minimize and maximize the grouped data. The rows or columns of the group collapse on minimizing and expand on maximizing.