MS EXCEL LEVEL DETERMINATION
Excel Mastery Quiz
Test your Excel skills with our challenging quiz designed to assess your level of proficiency. Whether you're a beginner or looking to validate your expertise, this quiz covers various Excel fun
Key Features:
- 10 Multiple Choice Questions
- Instant Feedback on Your Answers
- Learn Excel Tips and Tricks
In the formula =IF( A1 < 80,"Scheme A", Scheme B"), what will be the result if A1 is 86?
Scheme A
Scheme B
None of the above
86
I don't know
In VLOOKUP function, if the values to be searched are in column A and the value to appear is in column H, what will be the value of X in "=VLOOKUP(L1,A:J,X,0)"?
9
10
8
1
None of the above
I don't know
In the formula =INDEX(B2:E5,MATCH(D1,A2:A5,0),3), what does D1 provide?
Lookup value for row
Lookup value for column
Starting value for MATCH range
Starting value for INDEX range
None of the above
I don't Know
What symbol is used to lock cells so that it will not change the reference relative to its position when copied?
:&
$
@@
#
I don't know
Which formula is guaranteed to return the phrase “You win!” if the value in cell B2 is 20?
=if(B2=20,"try again!","you win")
=if(and(B2=20,C2=10),"you win!","try again!")
=if(or(B2=20,C2=10),"You win!","try again!")
I dont know
None of the above
Which is the best formula to return the phrase “You win!” if both cell B2 equals 20 and cell C2 equals 10?
=if(and(B2=20,C2=10),"you win!","try again!")
=if(or(B2=20,C2=10),"You win!","try again!")
=if((B2=20,if(C2=10,"you win!","try again"),"try again!")
None of the above
I dont know
Which formula returns the value of cell C5 if this value is greater than 5?
=C5=TRUE=C5
=if(C5=5,C5,0)
=if(C5>5,C5,0)
I don't know
None of the above
What would be the correct formula for sum in Excel?
=SUM(B3:B9)
=SUM:B3+B9
=ADD(B3.B9)
SUM(B3.B9)
None of the aove
I don't know
Which Formula would you use to calculate how many sales are over 20 KWD rom a series?
SUM
Average
IFSUM
SUMIF
IFAVERAGE
I don't know
SUMIF Excel function calculates the sum of a range of cells based on given criteria
True
False
{"name":"MS EXCEL LEVEL DETERMINATION", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your Excel skills with our challenging quiz designed to assess your level of proficiency. Whether you're a beginner or looking to validate your expertise, this quiz covers various Excel functions, formulas, and practical applications.Key Features:10 Multiple Choice QuestionsInstant Feedback on Your AnswersLearn Excel Tips and Tricks","img":"https:/images/course8.png"}