On what type of data can MS Excel functions operate?
Show answer & explanation
Correct answer: B
Explanation
The correct answer is Option 2 i.e. Range of cells or groups of cells.
MS Excel functions can operate on both ranges of cells and groups of cells.
- Range of Cells: A range refers to a contiguous group of cells, such as A1, where functions can perform calculations or analysis on the data contained within those cells.
- Groups of Cells: This can refer to non-contiguous cells selected together, like A1, B2, C3, where functions can still be applied to the selected cells, depending on the function being used.