Functions and Formulas Chapter 3

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

• formulas

• calculations

• functions

• spreadsheet data

Add, subtract, multiply, divide, and exponents are examples of what?

• formulas

• conditional formatting

• functions

• spreadsheet data

Which of the following allows a user to automatically format cells based on 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?

• formula changes based on its location

• formula remains unchanged when it is moved

• formula is related to another spreadsheet

• formula is related to the cell before it.

What does the term absolute mean for a formula?

• formula remains unchanged when it is moved

• formula related to another spreadsheet

• formula changes based on its location

• formula is related to the cells before it.

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?

• multiplication

• addition

• subtraction

• division

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

• /

• ^

• X

• =

Which of the following shows the correct use of the SUM function?

• SUM (G3-G10)

• +SUM (G3:G10)

• =SUM (G3..G10)

• =SUM (G3:G10)