SS Lesson 3 - Working with Formulas and Functions

The MIN and MAX functions ignore what cell content?

• jerry

• pictures

• text

• numbers

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

• multiplication

• Conditional Formatting

• formulas

• funtions

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

• $

• @

• %

• ^

Which of the following formulas shows the correct use of the SUM funtion

• (g6-/hy7)=SUM

• =SUM(G3:G10

• +SUM(H3-B7)

• (D5+G7)=SUM

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

• multiplication

• conditional formatting

• formulas

• functions

In the cell reference B$5, What part of the cell reference would remain unchanged?

• row 8

• row 7

• row 5

• row 6

In the cell reference $A5, what part of the cell reference would remain unchanged

• column D

• column C

• column A

• column B

What does the term "absolute" mean for a formula?

• it will change

• the formula remains unchanged when it moves

• the formula changes on this location

• this means it will relate to the table

What does the term "relative" mean for a formula?

• the formula will change

• the formula remains unchanged when it moves

• the formula changes based on its location

• it means that it will relate to the table

Which of the following formulas shows the correct use of the AVERAGE function?

• =(L3'L10)SUM

• =(L3'L10)AVERAGE

• =AVERAGE(L3:L10)

• =SUM(L3:L10)