How do array formulas work?

Related questions

1. How do I create an array in Excel?
2. What are the formulas used in Excel?
3. What is an array formula in Google Sheets?
4. How do you create an array formula in Excel for Mac?
5. How do I create a formula for multiple cells in Excel?
6. What does '$' mean in Excel formula?
7. What is an array formula in Excel?

Tags

1. #return
2. #think
3. #formulas
4. #either
5. #single
6. #result
7. #formula
8. #results
9. #perform
10. #array
11. #combination
12. #column
13. #items
14. #values
15. #multiple
16. #columns
17. #calculations