Spreadsheets in Excel - Functions & Referencing

When starting a formula what is the first thing you type in the cell?

• +

• -

• %

• =

Adding two cells

• =SUM(A1+A13)
• =SUM(__)
• A1+A13= SUM
• Total

to count any fields containing numbers we use:

• countIF function

• counta function

• count function

• countIFs function

Formulas can be copied to adjacent cells with the ____________.

• Fill handle

• PgDn Key

• Function key F4

• None of the above

the structure of countif is:

• contif(criteria,range of cells)

• countif(range of cells, criteria, range of cells)

• countif(range of cells, criteria)

the structure of sumif is:

• sumif(range of cells to be sdded,criteria, range of cells to be tested)

• sumif(criteria,range of cells to be tested)

• sumif(range of cells to be tested,criteria,range of cells to be added)

What would be a correct formula for SUM in excel?

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

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 formula will calculate the average based on a condition? (return the average of sales if over $20)

• average

• countif

• averageif

• sumif