DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column, Columns
|
|
|
Row, Rows
|
|
|
Cell, Cells
|
|
|
Worksheet, Worksheets
|
Detailed explanation-1: -Rows are groups of horizontal rows which appear from left to right in the Excel workbook. Rows range from 1 to 1, 048, 576.
Detailed explanation-2: -A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or nonadjacent. Commands executed by Excel will affect the entire range. A range is identified by the cell references of the cells in the upper left and lower right corners of the range.
Detailed explanation-3: -Column. A column is a group of cells that runs vertically from top to bottom. Columns are identified by letters.
Detailed explanation-4: -Range: A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range. An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon. (Example: A3:B5).
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.