Spreadsheet Formula Test

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which button can you click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

Which formula gets the smallest value of a range of cells?

• MAX
• MIN
• SMALL
• SUM

Which symbol must all formula begin with?

• =
• +
• (
• @

What text formula joins the text from two or more cells?

• concatenate

• proper

• left

• e=mc2

Which formula will calculate the average based on a condition? (return the average of sales if over $20)

• average

• countif

• averageif

• sumif

Which formula would you use to calculate how many sales are over $20 from a series.

• sum

• sumif

• count

• countif

Which formula will automatically capitalize the first letter of a word?

• abra-ka-dabra

• proper

• capitalize

• upper-case

Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

• format cell

• conditional formatting

• fill color

• magic cell