Spreadsheets

A formula in a spreadsheet starts with:

• 1 #
• 2 =
• 3 ?
• 4 @

Which function adds the numbers in a range?

• 1 MAX
• 2 SUM
• 3 AVG only
• 4 COUNT

The intersection of a row and a column is a:

• 1 Cell
• 2 Workbook
• 3 Range
• 4 Sheet

What does =A1+B1 do?

• 1 Adds the values in A1 and B1
• 2 Multiplies A1 and B1
• 3 Joins the texts
• 4 Deletes A1

Which function finds the largest value in a range?

• 1 MAX
• 2 SUM
• 3 MIN
• 4 COUNT