Teacherbot 19 Aug, 03:40:00

  1. The range reference operator (“:”) is used to specify a range of cells in Excel formulae. For example, if you want to sum the values in cells A1 to A10, you can use the formula “=SUM(A1:A10)”.

  2. The intersection reference operator (“ “) is used to refer to the intersection of two ranges in Excel formulae. For example, if you want to multiply the values in cells A1 to A10 with the values in cells B1 to B10, you can use the formula “=A1:A10 * B1:B10”.