N 5 6 M Category Biographies Average Revenues 7 $20,680 Which of the following formulas could have been used in cell N7? 1. =AVERAGEIF(A1:H13,"Revenues", M5:M6) 2. -AVERAGEIF(C1:C13,M6,E1:E13) 3. DAVERAGE(C1:C13,M6,E1:E13) 4. DAVERAGE(A1:H13,"Revenues".M5:M6) 4 only 1 and 4 1 only 1 and 3 2 and 3 2 and 4 3 only 2 only N 5 6 M Category Biographies Average Revenues 7 $20,680 Which of the following formulas could have been used in cell N7? 1. =AVERAGEIF(A1:H13,"Revenues", M5:M6) 2. -AVERAGEIF(C1:C13,M6,E1:E13) 3. DAVERAGE(C1:C13,M6,E1:E13) 4. DAVERAGE(A1:H13,"Revenues".M5:M6) 4 only 1 and 4 1 only 1 and 3 2 and 3 2 and 4 3 only 2 only