Since the FREQUENCY function is an array function,once it is typed into a cell you must press ________ + Enter in order for it to calculate properly.
A)Ctrl + Shift
B)Ctrl + Alt
C)Ctrl
D)Alt + Shift

Question

Quizplus · Accepted Answer

The FREQUENCY function, being an array function, requires pressing Ctrl + Shift + Enter to properly calculate and display the results in Excel. This combination tells Excel to treat the formula as an array formula, allowing it to output multiple values.

Since the FREQUENCY Function Is an Array Function,once It Is