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: -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. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.
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: -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.
Detailed explanation-5: -Rows and Columns To quickly adjust the row height or column width, use a double-click shortcut. Double-click to adjust the height of all the selected rows.