FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Reference operators Combine ranges of cells for calculations with these operators. Range operator, which produces one reference to all the cells between two references, including the two references. Union operator, which combines multiple references into one reference.

Detailed explanation-2: -A formula is: a combination of cell references, operators, values, and/or functions used to perform calculations. You should use cell references in formulas instead of constant values so that: you can change the input values without changing the formulas.

Detailed explanation-3: -The range operator (colon), which is an infix operator, is used to join two cell references to make a range reference.

Detailed explanation-4: -“, ” (comma) is the Union operator, which combines multiple Ranges into one reference, like A11:A13, A11:C11, A11 (you can refer to simple cells too, not only to ranges with multiple cells)