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
Intermediate
Your boss has given you a list of data and asked you to identify who your star customers are (your top 30%). How would you indicate this visually?
Highlight the total spend column and apply a star icon set to it
Highlight the total spend column and apply data bars to it
Write a formula to identify if each customer is in the top 30
Don’t know
2
Intermediate
Assuming that you have a range of data in D10:D50, how could you quickly color all the values over $5,000?
Write a formula in E10 that reads =IF(D10>5000,”Over”,””) and copy it down beside the table.
Sort the data in D10:D50, then color it
Set up a Greater Than 5000 conditional formatting rule over D10:D50
Don’t know
3
Intermediate
If you wanted to identify the top 25% and bottom 25% of values in a column, which would be the best way to do it?
Sort the data ascending and use a formula to determine which cells fit into each quartile
Set up a Highlight Cells Between conditional formatting rule
Set up a Top 10% and Bottom 10% conditional formatting rule, changing the % to 25% for each
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement