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
You have the spreadsheet shown below and enter the following formula in C2: =IF(A2=“Juice”,B2,”Not Juice”) What is the result?
“Not Juice”
Not Juice
3
Don’t know
2
Beginner
You have the spreadsheet shown below and want to write a formula that will return the Sales $ for each row if the Product is Water or the Quantity is greater than 5, or a zero if not. What formula would you want to copy down from D2 to make this happen?
=IF(OR(A2=“Water”,B2>5),C2,0)
=IF(AND(A2=“Water”,B2>5),C2,0)
=IF(OR(A2=“Water”,B2>5),C2,”“)
Don’t know
3
Beginner
You have the spreadsheet shown below. Which formula was entered in cell D2 and copied down?
=OR(A2="Juice",C2>10)
=AND(A2="Juice",C2>10)
=A2="Juice"
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement