Ooh Excel Friends!
Excel Mastery Quiz
Test your knowledge of Excel fun
- 7 thought-provoking questions
- Multiple choice and interactive formats
- Perfect for self-assessment or friendly competition
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)
What is the name of the function used to check where a cell you are in is used in future formulas?
{"name":"Ooh Excel Friends!", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsMultiple choice and interactive formatsPerfect for self-assessment or friendly competition","img":"https:/images/course6.png"}