DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Table array
|
|
|
Table set
|
|
|
Table range
|
|
|
None of the above
|
Detailed explanation-1: -Spreadsheet software, such as Microsoft Excel, Google Sheets, Apple Numbers and OpenOffice Calc, allow users to organize data into columns and rows.
Detailed explanation-2: -An array formula is a formula that can perform multiple calculations on one or more items in an array. You can think of an array as a row or column of values, or a combination of rows and columns of values. Array formulas can return either multiple results, or a single result.
Detailed explanation-3: -When you create a VLOOKUP or HLOOKUP function, you enter a range of cells, such as D2:F39. That range is called the table array argument, and an argument is simply a piece of data that a function needs in order to run. In this case, the function searches those cells for the data you’re trying to find.
Detailed explanation-4: -A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.