Excel

Question 1

To add a formula, you must start with what symbol?

Answer 1

=

Question 2

When calculating complex math formulas, what sequence is followed?
(i.e. order of operations)

Answer 2

PEMDAS

PEMDAS is an acronym for the words parenthesis, exponents, multiplication, division, addition, subtraction. Given two or more operations in a single expression, the order of the letters in PEMDAS tells you what to calculate first, second, third and so on, until the calculation is complete.

Question 3

What symbol/character is used to “anchor” a formula to a particular cell?

Answer 3

$

Question 4

What is the shortcut to select an entire column?

Answer 4

Select the top cell and then CTRL + SHIFT + DOWN

Question 5

What is the shortcut to Copy?

Answer 5

CTRL + C

Question 6

What is the shortcut to Paste?

Answer 6

CTRL + V

Question 7

What is the shortcut to Find?

Answer 7

CTRL + F

Question 8

What is the shortcut to Replace?

Answer 8

CTRL + H

Question 9

What are the two ways to concatenate the values of multiple cells?

Answer 9

Option 1:
=CONCATENATE(A1,B1,C1,…)

OPTION 2:
=A1&B1&C1&…