How does the appearance of an array formula differ from that of a standard formula?
- In a worksheet cell, array formulas have a small blue triangle in the cell’s upper-right corner.
- A heavy border appears around the range that is occupied by the array formula.
- In the formula bar, an array formula appears surrounded by curly brackets.
- When a cell that contains an array formula is selected, range finders appear on the worksheet around the formula’s precedent cells.
The correct answer is:
- In the formula bar, an array formula appears surrounded by curly brackets.
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers