To calculate multiple cell 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

When calculating multiple cell values using an array formula, we need to press Ctrl+Shift+Enter to enter the formula. This is because an array formula operates on the entire range of cells, rather than just a single cell, and pressing these keys tells Excel to treat the formula as an array formula. Option A (Alt+Enter) is used for adding a new line within a cell. Option C (Alt+Shift+Enter) is used for creating a new row or column within a range. Option D (Ctrl+Enter) is used for entering the same data into multiple cells at once.

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