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.
Question
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.
Solution
The answers to your questions are:
For the first question, the result of the formula =CONCATENATE(A1," ",A3) will be "My Home". So, the correct option is A. My Home.
For the second question, in AVERAGE( number1, [number2], ... [number_n] ), the possible types of numbers are numbers, named ranges, arrays, or references to numbers only. So, the correct option is C. Numbers, named ranges, arrays, or references to numbers only.
Similar Questions
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
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, or references to numbers only. C. Numbers, references to numbers only. D. Numbers, named ranges, arrays, lists or references to number
When would it be appropriate to use the =AVERAGEA function in Excel?When you are trying to find an average in a data set that contains both words and numbersWhen you want to find the average of a specific set of numbersWhen you are looking for the average of any cell containing an algebra formula
What function can be used in Google Sheets to find the average of a range of numbers
If cell range A1:A3 contains the numbers 5, 6 and 7, then =AVERAGE(A1:A3, 10) will return __________*1 point671.818
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.