Destiny’s Child Excel Quiz

5th March 2019 - 9 minutes read  
Elena Larisa Andrei -

How would you tell if your boss's ability to use conditional formatting was Second Nature?

https://www.flickr.com/people/idrewuk/
Correct! Wrong!

Are you the Only One who doesn’t know how to write a VLOOKUP?

https://www.flickr.com/photos/7929420@N03/3636170107/
Correct! Wrong!

Mark which one is best:

If You Leave the $ sign out of your VLOOKUP and drag it down, what happens?

https://www.flickr.com/photos/petesekesan/8448777302/
Correct! Wrong!

Show Me The Way to copy a cell's colour (but not its contents) to another cell

https://www.flickr.com/photos/petesekesan/8448777302/
Correct! Wrong!

Why should you resist the Temptation to merge cells?

https://www.flickr.com/photos/7929420@N03/3636170107/
Correct! Wrong!

If you wanted to remove duplicates, Where'd You Go?

https://www.flickr.com/photos/petesekesan/8448777302/
Correct! Wrong!

What is the 2 Step process to writing and applying a formula correctly?

https://www.flickr.com/photos/petesekesan/8448777302/
Correct! Wrong!

Why is adding new worksheets to a .csv file a Bad Habit?

https://www.flickr.com/photos/petesekesan/8448777302/
Correct! Wrong!

What kind of cell formatting would you use to add up those Bills, Bills, Bills?

https://www.flickr.com/people/idrewuk/
Correct! Wrong!

How do you go Jumpin' Jumpin' between different worksheet tabs?

https://www.flickr.com/photos/petesekesan/8448777302/
Correct! Wrong!

Which of these If statements is the most correct?

https://www.flickr.com/photos/petesekesan/8448777302/
Correct! Wrong!

Which function would you use to count the number of letters in Rudolph the Red-Nosed Reindeer?

https://www.flickr.com/photos/7929420@N03/3636170107/
Correct! Wrong!

Destiny's Child Excel Quiz
You are KELLY! Are you even trying!?

Sadly, much like Kelly, you don't know anything about Excel. You don't know your LEN from your VLOOKUP, indeed you'd probably try text somebody from Excel much like Ms Rowland!
You are BEYONCE! You think you're an expert but you might just be confused!

Queen Bey might run the world but Excel remains a mystery to her. Sure, she might know a shortcut or two but true mastery remains beyond her.
You are MICHELLE. A true master of Excel!

Much like Michelle, you've gone quietly about your business and learnt all there is to know about Excel. From pivot tables to macros, there isn't anything you don't know!

Share your Results: