In the tutorial you used the Concatenate function. Which of the following is FAL

Question

In the tutorial you used the Concatenate function. Which of the following is FALSE based on the result depicted in Column F? STATE QLD QLD QLD NSW NSW MONTH? SALESPERSON ? EMPLOYEE NUME? SALES CONCATENATE QLDKENO14987 QLDFIN013786 ? JUL JUL JUL JUL JUL J. KENNEY P. FINNIAN K. YANG P. MOMBASSA O. TANG KEN014987 FINO13786 YAN0124357 MOMO00476 TANO298754 $125,622 $235,000 242,003 QLDYANO124357 122,607 NSWMOMO00476 $229,360NSWTANO298754 4 6 The formula in Cell F6 has joined the State and Employee Number Column F uses the Concatenate function which has joined the State, Salesperson and Employee number The formula in Cell F2 is CONCATENATE(A2,D2) The Concatenate function joins two columns together

Explanation / Answer

Answer is B.

The CONCATENATION function is used to join the two functions together. The F column is the combination of State and Salesperson.

Eg. A2 =QLD

D2 = KEN014987

F2 = CONCAT(A2,D2) so Answer is QLDKEN014987.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---