Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use?
A) AVGIF
B) AVERAGEIFS
C) IF
D) SUMIF