Multiple choice

________operators are used to combine the ranges of cells for calculation.

  1. Comparison

  2. Arithmetic

  3. Concatenation

  4. Reference

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Reference operators (such as the range operator : in Excel) are used to combine multiple cell ranges for calculations. For example, A1:A10 represents a range of cells. Comparison operators compare values, arithmetic operators perform calculations, and concatenation joins text.