Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
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()
COUNTIF()
SUMIF()
Don’t know
2
Beginner
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
Beginner
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?
SUMIF()
COUNTA()
SUMPRODUCT()
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement