Excel Formulas Review

Question 1

What is the shortcut to make a cell reference absolute

Accepted Answer

F4

Question 2

Every formula must begin with

Accepted Answer

= Equal sign

Question 3

A symbol that indicates what mathematical operation to perform on the operands

Accepted Answer

operator

Question 4

a selected group of cells on a worksheet

Accepted Answer

range

Question 5

Which of the following comes first in the order of operations

Accepted Answer

parenthesis

Question 6

Mathematical rules used for calculating the value of a formula

Accepted Answer

order of operations

Question 7

A number or cell reference used in a formula

Accepted Answer

operand

Question 8

An equation that that calculates a new value using values currently on a worksheet

Accepted Answer

formula

Question 9

cell reference that adjusts to a new location when copied or moved

Accepted Answer

relative reference

Question 10

Which of the following comes last in the order of operations?

Accepted Answer

subtraction

Question 11

A cell reference that DOES NOT adjust to the new cell location when copied or moved

Accepted Answer

Absolute reference

Question 12

To copy a cells contents into an adjacent cell

Accepted Answer

fill

Questions 12