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"}
More Surveys
Excel Training
5229
Let's know more about you
4264
Data Intelligence Team Weekly Fair
9412
Safety Analyst Training
17833
Background of Attendees
8419
Know about IoT
10521
CS FOLDER PROJECT
1589
Purchasing Document Menu Search Filter
3225
Chart visualization 101
12621
Shared tools
6320
Behavioral & Structural Design Pattern Quiz Quiz
10516
Free Day of PTO competition
1268