To calculate multiple cells values,select the range and type the array formula,then press the ____ keys to enter the formula.
A) Alt+Enter
B) Ctrl+Shift+Enter
C) Alt+Shift+Enter
D) Ctrl+Enter

Question

Quizplus · Accepted Answer

To calculate multiple cells using an array formula, we must select the range of cells and then press Ctrl+Shift+Enter to enter the formula. This tells Excel that we are using an array formula, which will calculate the values for all selected cells simultaneously. The other options (Alt+Enter, Alt+Shift+Enter, and Ctrl+Enter) are not used for entering array formulas.

To Calculate Multiple Cells Values,select the Range and Type the Array