When the data cells are below and to the right of the cell containing a function, the function argument is automatically entered.

Question

Quizplus · Accepted Answer

When entering a function in a spreadsheet program like Microsoft Excel, the function arguments (the cells the function will act upon) are not automatically entered based on their position relative to the function cell. The user must specify the cells or range of cells to be included in the function.

When the Data Cells Are Below and to the Right