question 4\nwhich function adds the cells based on a specified condition or criteria?\ncountif\nsumif\naverag…

question 4\nwhich function adds the cells based on a specified condition or criteria?\ncountif\nsumif\naverageif\naddif\nquestion 5\nwhat year was asu founded?\n1903\n1925\n1885\n1933

question 4\nwhich function adds the cells based on a specified condition or criteria?\ncountif\nsumif\naverageif\naddif\nquestion 5\nwhat year was asu founded?\n1903\n1925\n1885\n1933

Answer

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