Survey Maker Survey Templates Contact Privacy & Security

MS EXCEL LEVEL DETERMINATION

A vibrant and engaging illustration of a computer screen displaying a complex Excel spreadsheet with colorful charts and graphs, surrounded by Excel icons and formulas, conveying a sense of learning and mastery in Excel.

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 functions, formulas, and practical applications.

Key Features:

10 Multiple Choice Questions
Instant Feedback on Your Answers
Learn Excel Tips and Tricks

10 Questions2 MinutesCreated by ExcelEagle42

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

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)"?

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"}