MO-210 Practice Questions - Microsoft Excel (Microsoft 365 Apps) (MO-210) Exam

Which formula correctly sums all values in column B where the corresponding cell in column A equals "East"?

=COUNTIF(A:A,"East",B:B) =SUMIF(A:A,"East",B:B) =SUMIFS(A:A,"East",B:B) =IF(A:A="East",SUM(B:B))

=SUMIF(A:A,"East",B:B)

Access more questions from this quiz

Continue to MO-210 Practice Questions - Microsoft Excel (Microsoft 365 Apps) (MO-210) Exam for more practice questions and the full quiz experience.