Ooh Excel Friends!

A bright and colorful illustration featuring Excel spreadsheets, numeric formulas, and business graphics, depicting a person enthusiastically solving problems on a computer, with elements representing data analysis and collaboration.

Excel Mastery Quiz

Test your knowledge of Excel functions and troubleshooting with this engaging quiz designed for both beginners and advanced users. Whether you're looking to sharpen your skills or assess your understanding of crucial Excel concepts, this quiz has something for everyone.

7 thought-provoking questions
Multiple choice and interactive formats
Perfect for self-assessment or friendly competition

7 Questions2 MinutesCreated by AnalyzingData42

How would you find the total number of sales orders by a customer Reference NES100, where the reference is not the only part of the range cell.?

=COUNTIF(A1:A100,"*NES100*")

=SUMIF(A1:A100,"*NES100*")

=COUNTIF(A1:A100,"NES100")

=COUNTIF(A1:A100,"NES100*")

True or False? XLOOKUP is useful to look for text in a row and return the corresponding value?

True

False

What does a #REF error represent?

A space in the formula.

An issue with the name of the formula.

An incorrect cell being included.

You have got a cell error. You have already checked the range and the formula help in Excel. What is your next step?

Give up.

Use copy/paste instead.

Procrastinate the issue.

Try talk the formula out to yourself or ask for help.

Which is the correct version of the index match function?

=INDEX(Main!A1:A100,MATCH(Main!C1:C100,A4,0),1)

=INDEX(Main!A1:A100,MATCH(A4,Main!C1:C100),1)

=INDEX(Main!A1:A100,MATCH(A4,Main!C1:C100,0))

=INDEX(Main!A1:A100,MATCH(A4,Main!C1:C100,0),1)

Ooh Excel Friends!

Excel Mastery Quiz

More Quizzes