Basic Excel Terms and Symbols

What type of reference is $B$2?

• a relative cell reference

• an absolute cell reference

=B1+C1

• This is a function.

• This is a formula.

Which operation happens first in Excel?

• subtraction

• addition

• multiplication

• exponentiation

What kind of operation is this: =B1*B2 ?

• addition

• subtraction

• multiplication

• division

• =

• <=

• =<

• <>

B1:B5 is an example of this:

• a cell

• an absolute cell reference

• a range

• a formula

Use this symbol to indicate the presence of text, as opposed to a number or a code.

• (

• <

• !

• "

This shortcut turns a relative cell reference into an absolute cell reference:

• F1

• F2

• F3

• F4

greater than or equal

• <=

• =<

• >=

• =>

 $5^2$     ("five square" in Excel)

• 5>2

• 5<2

• 5^2

• 5'2