Unit 4 Lesson 2: Inserting Formulas and Functions

Question 1

name the 4 types of Operators

Answer 1

Arithmetic

Comparison

Text Concatenation

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 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