Unit 4 Lesson 2: Inserting Formulas and Functions

Question 1

name the 4 types of Operators

Answer 1

Arithmetic, Comparison, Text Concatenation, and Reference

Question 2

Types of Operators:

mathematical operations used in performing calculations

Answer 2

Arithmetic Operators

Question 3

Types of Operators:

• logical operators used to compare two values

-the result of the comparison can either be TRUE or FALSE

Answer 3

Comparison Operators

Question 4

Types of Operators:

is used to join or connect two or more words to create a
single word.

Answer 4

Text Concatenation Operator

Question 5

Types of Operators:

used to set a range of cells or values when computing

Answer 5

Reference Operator

Question 6

enumerate the 3 ways to make formulas

Answer 6

Cell Reference, Point Click-Method, Fill Handle for Copying Formula