Absolute references

Which of the following has a cell reference?

• 5%
• =4*3.7
• =G4/E3
• sub-total

This operator symbol is for what type of operation?   /

• addition
• subtraction
• multiplication
• division

If you want to subtract two numbers in a formula, which formula would be correct?

• =1.2*3
• =e3+e7
• =A2-30
• -E7=A3

This operator symbol is for what type of operation?   /

• addition
• subtraction
• multiplication
• division

What term refers to mathematical equations used in Excel to perform calculations?

• Format
• Summations
• Cell
• Formulas

=Sum(A5:A10)

• Formula
• Function

The Order of Operations means to do what first?

• section in Parentheses
• subtraction
• work from left to right
• addition

What is the main purpose of using cell references when doing formulas & functions?

• So you don't have to redo the math if something changes
• It feels fancier therefore you're smarter
• It's the ONLY way to get the right math answer
• Confuse students in Info Tech class

Which of the following formulas includes an absolute cell reference?

• =B1/$B$25
• =B1/B25
• =B1*#B#25
• =AVERAGE(B1:B25)

What symbol is used to designate an absolute cell reference?

• $
• !
• @
• #