Microsoft Excel MCQS - QUESTION DETAILS

In Excel, what does the function =SUMIFS(A1:A10, B1:B10, "Apples", C1:C10, ">100") do?
A. Adds values in the range A1:A10 based on multiple criteria in columns B and C
B. Counts the number of cells in the range A1:A10 based on a single criterion
C. Finds the average of values in the range A1:A10
D. Multiplies values in the range A1:A10 based on multiple criteria in columns B and C

No Explanation

Similar Questions

In Excel, what does the term "Data Bars" refer to in conditional formatting?






What is the purpose of the "Merge & Center" option in Excel?






What does the term "Cell Reference" mean in Microsoft Excel?






In Excel, what does the term "Consolidation" mean?






What is the purpose of the "Get & Transform" feature in Excel?






Which function in Excel is used to find the highest value in a range of cells?






Which Excel function is used to calculate the internal rate of return (IRR) of an investment?






What is the purpose of the "Watch Window" feature in Excel?






In Excel, which function is used to sum a range of cells?






Which Excel function is used to find the average of cells that meet multiple criteria?