The text in A1 is My. The text in A2 is Sweet. The text in A3 is Home. What will be the result if you use the formula: =CONCATENATE(A1," ",A3) ? Ops: A. Sweet Home B. MySweet C. MyHome D. My Home

The text in A1 is My. The text in A2 is Sweet. The text in A3 is Home. What will be the result if you use the formula: =CONCATENATE(A1," ",A3) ? Ops: A. My Home B. MySweet C. Sweet Home D. MyHome Q 08. In AVERAGE( number1, [number2], ... [number_n] ), the syntax of Average Function, what are the possible types of numbers? Ops: A. Numbers, arrays, or references to numbers only. B. Numbers, named ranges, arrays, lists or references to numbers. C. Numbers, named ranges, arrays, or references to numbers only. D. Numbers, references to numbers only.

Which Excel function is used to combine text from different cells into one cell?

What will the formula =TRIM(" Excel ") return?Answer( Please choose a correct answer )   CLEAR" Excel ""Excel"" Excel""Excel "

Strings must always be in quotations, otherwise Excel formulas do not understand them, however, inside a regular cell, they may or may not be in quotations and Excel will recognize them as strings. True False

When a formula is entered into a cell, it also appears in the _______________.Select one:a.Task barb.Address barc.Formula bard.Title bar