Lesson 2: Inserting Formulas and Functions

Question 1

Are mathematical operations used in performing calculations.

Answer 1

Arithmetic Operators

Question 2

+ (Plus Sign)

Answer 2

Addition

Question 3

− (Minus Sign)

Answer 3

• Subtraction
• Negation

Question 4

• (Asterisk)

Answer 4

Multiplication

Question 5

/ (Forward Slash)

Answer 5

Division

Question 6

% (Percent Sign)

Answer 6

Modulo

Question 7

^ (Caret)

Answer 7

Exponentiation

Question 8

Are logical operators used to compare two values. The result of the comparison can either be TRUE or FALSE.

Answer 8

Comparison Operators

Question 9

=

Answer 9

Equal to

Question 10

>

Answer 10

Greater than

Question 11

<

Answer 11

Less than

Question 12

> =

Answer 12

Greater than or equal to

Question 13

<=

Answer 13

Less than or equal to

Question 14

<>

Answer 14

Not equal to

Question 15

Is used to join or connect two or more words to create a
single word. “&”

Answer 15

Text Concatenation Operator

Question 16

Are used to set a range of cells or values when computing.

Answer 16

Reference Operators

Question 17

: (Colon)

Answer 17

Range operator - used to show
reference of the range of selected cells

Question 18

, (Comma)

Answer 18

Union operator - combines values of multiple cells and creates single reference using multiple references

Question 19

(Pound)

Answer 19

Used as part of an error and
to show not enough space

Question 20

@ (At Sign)

Answer 20

Reference operator - used to show
implicit intersection in a spreadsheet
formula and can be used to reference
a row or column

Question 21

Is a function that adds all the values of the cells in the argument

Answer 21

SUM

Question 22

Is a function that computes the average value of the cells in the argument. It computes the sum first and divides it by the number of cells in the argument

Answer 22

AVERAGE

Question 23

Is a function that checks the number of cells in the range given. This function is useful if you need to count items.

Answer 23

COUNT

Question 24

Is a function that looks for the highest value in the range.

Answer 24

MAX

Question 25

Is a function that looks for the lowest value in the range.

Answer 25

MIN