Spreadsheets Year 7

What does conditional formatting allow you to do?

• Change cell color based on conditions

• Create formulas in cells

• Sort data alphabetically

• Freeze panes

In conditional formatting, what does the rule “Greater Than” compare?

• Text

• Dates

• Numbers

• Formulas

What symbol is used to indicate a formula in a cell?

• $

• @

• =

• *

To sum the values in cells A1 through A5, which formula would you use?

• =SUM(A1-A5)

• =SUM(A1 to A5)

• =SUM(A1:A5)

• =TOTAL(A1:A5)

What function would you use to find the average of a range of cells?

• =AVERAGE()

• =Max()

• =MEAN()

• =SUM()/COUNT()

Which function finds the highest value in a range of cells?

• =MAX()

• =LARGE()

• =TOP()

• =HIGH()

If you want to find the lowest value in a range, which function would you use?

• =LOW()

• =MIN()

• =SMALL()

• =BOTTOM()

How can you quickly calculate the sum of a column of numbers in Excel?

• =ADD()

• =TOTAL()

• =SUM()

• =COLUMN_SUM()

Which formatting option is used to add borders around selected cells

• Fill Color

• Font Color

• Border

• Alignment

Which option is used to change the background color of a cell in Excel?

• Font Color

• Fill Color

• Border

• Italic