DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A formula can only be applied if the table is loaded (populated) with data.
|
|
True
|
|
|
Fals
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Look up values vertically in a list by using an exact match. To do this task, you can use the VLOOKUP function, or a combination of the INDEX and MATCH functions.
Detailed explanation-2: -Calculated columns in Excel tables are a fantastic tool for entering formulas efficiently. They allow you to enter a single formula in one cell, and then that formula will automatically expand to the rest of the column by itself.
Detailed explanation-3: -One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed.
There is 1 question to complete.