Excel Calculations | MCQs

Explanation

A constant is a set value that doesn't change and that's directly inserted into a cell.

It's not a formula and it's not calculated by a formula.

*******

VU CBT FIA  PAPER 19-12-2021

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.

We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.

Array formulas can return either multiple results or a single result.