Which of the following is/are array formulas?
Correct Answer: =ARRAY(C11:E11)
Explanation:
Note: This question has more than 1 correct answers
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
Which of the following function(s) accepts criteria?
Statistical methods have been used for statistical analyses. A brief list of the more popular methods as following?
Which formulas use absolute references?
Which options are available for Auto Fill?
To combine data of two or more columns into another column, you can usually use the concatenation operator _____ in a formula.
If there is text in cell C5 and the formula in cell F10 =SUM(B2:E6) then the formula result will...
What is the correct term for separating contents from one cell into two by a common character?
To convert the date 12/14/2014 in cell A1 to text in the format of YYYYMMDD, which is a valid option?
What is the correct answer: A1 value = 10 A2 value = 0 =IFERROR(A1/COUNT(A1:A2),'Err')
An .xlsx file cannot store VBA macro code or Excel 4.0 macro sheets.