Question: The following CONCATENATE function was entered into a cell on the Summary worksheet in an Excel workbook: = CONCATENATE ( A 5 ,
The following CONCATENATE function was entered into a cell on the Summary worksheet in an Excel workbook: CONCATENATEACODE,
Which of the following identifies a flaw with this function? Select all that apply.
The word CODE must be enclosed in quotations or the output of the function will produce the #NAME? error code.
Arguments that are defined with numeric values must be enclosed in quotations.
The arguments of the CONCATENATE function cannot be defined with words or nonnumeric data.
Quotation marks should not be used when arguments are defined with cell references.
The arguments of the CONCATENATE function cannot be defined with numeric values.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
