GoSkills
Back to lesson
Question
1
of
3
1. Assuming we have customer numbers in column A, invoice numbers in column B and total invoice amounts in column C, which function would we reach to in order to figure out the number of times a specific customer had purchased from us?
COUNT()
SUMIF()
COUNTIF()
Don’t know
2. Assuming we have customer numbers in column A, invoice numbers in column B and total invoice amounts in column C, which function would we reach to in order to figure out the total value of goods a specific customer had purchased from us?
SUM()
SUMIF()
COUNTIF()
Don’t know
3. Suppose customer numbers (IDs) are in column A, invoice numbers in column B and total invoice amounts in column C. Which function is the easiest for discovering the total value of goods purchased by customers with a customer number above 1000?
SUMPRODUCT()
SUMIF()
COUNTA()
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement