What is an array formula in Excel?
a) A formula that operates on a single cell
b) A formula that can perform multiple calculations on one or more items in an array
c) A formula used only for text data
d) A formula that links to another worksheet
Answer: b) A formula that can perform multiple calculations on one or more items in an array
How do you enter an array formula in Excel?
a) Press Enter
b) Press Ctrl + Shift + Enter
c) Press Alt + Enter
d) Press Ctrl + Alt + Enter
Answer: b) Press Ctrl + Shift + Enter
What indicates that a formula is an array formula in Excel?
a) The formula is in bold
b) Curly braces {} appear around the formula
c) The formula is in italics
d) The cell background changes color
Answer: b) Curly braces {} appear around the formula
Which function is commonly used with array formulas to sum a range based on multiple criteria?
a) SUM
b) AVERAGE
c) SUMIF
d) SUMPRODUCT
Answer: d) SUMPRODUCT
Can array formulas be used to return multiple values to multiple cells?
a) Yes
b) No
Answer: a) Yes
Which of the following can be achieved using an array formula?
a) Summing a range of values
b) Counting the number of occurrences of a specific value
c) Finding the maximum value in a range
d) All of the above
Answer: d) All of the above
Which function would you use with an array formula to perform a logical AND operation across multiple ranges?
a) AND
b) OR
c) IF
d) AVERAGE
Answer: a) AND
When using an array formula, what happens if you try to edit part of the array without selecting the entire range?
a) The formula will update correctly
b) An error message will be displayed
c) The entire array formula will be deleted
d) The array formula will be converted to a regular formula
Answer: b) An error message will be displayed
Which of the following is a limitation of array formulas in Excel?
a) They cannot perform calculations
b) They require more memory and processing power
c) They can only be used in Excel 2016 and later
d) They cannot be used with text data
Answer: b) They require more memory and processing power
What is the purpose of using the TRANSPOSE function in an array formula?
a) To change the text case
b) To sort the data
c) To flip the orientation of a range from horizontal to vertical or vice versa
d) To find unique values in a range
Answer: c) To flip the orientation of a range from horizontal to vertical or vice versa
