ICT Spreadsheets Lesson 3 Review

Sum, average, count, maximum value, and minimum 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 shows the correct use of the SUM function?

• -SUM(G3-G10)

• =SUM(G3..G10)

• =SUM(G3:G10)

• +SUM(G3:G10)