Multiple choice general knowledge science & technology

Enter a formula as an array

  1. CTRL + SHIFT + ENTER
  2. CTRL + SHIFT + $

  3. CTRL + SHIFT + 9

  4. CTRL + 0
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To enter a formula as an array formula in Excel, you press CTRL + SHIFT + ENTER instead of just ENTER. This tells Excel to treat the formula as an array formula, performing calculations on multiple cells simultaneously and returning results to multiple cells.

Keep practicing — related questions