Sovi.AI - AI Math Tutor

Scan to solve math questions

QUESTION IMAGE

question 4 which function adds the cells based on a specified condition…

Question

question 4
which function adds the cells based on a specified condition or criteria?
countif
sumif
averageif
addif
question 5
what year was asu founded?
1903
1925
1885
1933

Explanation:

Brief Explanations
  • For Question 4: The SUMIF function in spreadsheet software sums cells that meet a specified condition. COUNTIF counts cells based on a condition, AVERAGEIF finds the average of cells based on a condition, and ADDIF is not a standard function.
  • For Question 5: Arizona State University (ASU) was founded in 1885.

Answer:

  • Question 4: B. SUMIF
  • Question 5: C. 1885