Spreadsheets - Lesson 3

Sum, average, count, and maximum value are examples of what?

• Formulas
• Calculations
• Functions
• Spreadsheet Data

Addition, subtraction, multiplication, division, and exponentiation are examples of what?

• Formulas
• Conditional Formatting
• Functions
• Spreadsheet Data

Which of the following allows a user to automatically format cells based on the data within a cell?

• Formula
• Conditional Formatting
• Function
• Calculation

What symbol is used to begin a formula?

• +
• =
• -
• >

What does the term “relative” mean for a formula?

• The formula remains unchanged when it is moved.
• The formula is related to another spreadsheet.
• The formula is related to the cells before it.
• The formula changes based on its location.

What does the term “absolute” mean for a formula?

• The formula remains unchanged when it is moved.
• The formula is related to another spreadsheet.
• The formula is related to the cells before it.
• The formula changes based on its location.

What character is used to change a cell references from relative to absolute?

• $
• %
• *
• +

When a formula contains several operations, which of the following operations would be performed first?

• Subtraction
• Addition
• Division
• Multiplication

What character is used in a spreadsheet formula to represent exponent calculation?

• /
• ^
• x
• =

Which of the following formulas show the correct use of the SUM function?

• -SUM(G3-G10)
• =SUM(G3...G10)
• =SUM(G3:G10)
• +SUM(G3:G10)