NEW
Font size
WorksheetsSpreadsheet Closing Quiz
Total questions: 21
Worksheet time: 11mins
What is the main use of the IF function in Excel?
Combine two texts
Check conditions and give different results
Get the first letter of text
Sum numbers
What is the purpose of the following formula? =IF(A1>50,"Pass","Fail")
Sum the value in A1
Display 'Pass' if A1 is greater than 50, otherwise 'Fail'
Combine text in A1
Count the number of students who pass
Which is the correct writing of IF?
IF(A1=10,"Yes")
=IF(A1=10,"Yes","No")
IF(A1>10;"Yes";"No")
=IF(A1,>10,"Yes","No")
What does Nested IF mean?
IF written in an empty cell
IF used repeatedly in one formula for many conditions
IF combined with SUM
IF to combine text
What does the following formula mean? =IF(A1>80,"A",IF(A1>60,"B","C"))
If A1 is greater than 80 then 'A', if not greater than 60 then 'B', if not then 'C'
If A1 is greater than 80 then 'B', if not then 'C'
If A1 equals 80 then 'A'
The formula is incorrect
When should we use Nested IF?
When wanting to calculate total numbers
When conditions are more than one category
When wanting to combine text
When copying formulas
What is the use of the CONCATENATE function?
Count the number of letters in text
Combine several texts into one
Get the last letter of text
Check conditions
What is the main difference between CONCATENATE and CONCAT in the new version of Excel?
There is no difference
CONCAT is only for numbers, CONCATENATE is only for text
CONCAT is the modern version replacing CONCATENATE
CONCAT is used for IF
What will the formula =CONCAT(A1," ",B1) produce if A1="John" and B1="Smith"?
JohnSmith
John Smith
John+Smith
Error
Which is the correct writing of CONCATENATE?
=CONCATENATE(A1,B1)
=CONCATENATE(A1+B1)
CONCATENATE(A1;B1)
=CONCATENATE(A1
What is the correct way to write CONCATENATE?
=CONCATENATE(A1,B1)
=CONCATENATE(A1+B1)
CONCATENATE(A1;B1)
=CONCATENATE(A1:B1,C1)
What is the use of the LEFT function in Excel?
To take the first letter of text according to the specified number
To take the last letter of text
To combine two texts
To check conditions
The result of the formula =LEFT("ICT",2) is…
IC
CT
I
ICT
The formula =LEFT(A1,3) if A1 = "Spreadsheet" results in…
She
Spr
pre
ree
Which of the following is incorrect?
=LEFT("Excel",2)
=LEFT(A1,5)
=LEFT("Excel")
=LEFT("Excel",1)
What is the function of RIGHT in Excel?
To take letters from the left of the text
To take letters from the right of the text
To combine texts
To count the number of letters
The result of =RIGHT("Excel",2) is…
Ex
el
ce
xl
The formula =RIGHT(A1,3) if A1 = "Computer" results in…
Com
put
ter
omp
If we want to take the last letter from the text, the correct formula is…
=RIGHT(A1,1)
=LEFT(A1,1)
=CONCATENATE(A1,1)
=IF(A1,1)
Which combination of formulas is correct to display “Mr. John Smith” if A1=“John” and B1=“Smith”?
=CONCAT("Mr. ",A1," ",B1)
=LEFT("Mr. ",A1," ",B1)
=IF(A1,"Mr. John Smith")
=RIGHT(A1,B1,"Mr.")
If we want to grade a student's score: A1 ≥ 90 → “Excellent”, A1 ≥ 70 → “Good”, otherwise → “Try Again”. The correct formula is:
=IF(A1>=90,"Excellent","Good")
=IF(A1>=90,"Excellent",IF(A1>=70,"Good","Try Again"))
=IF(A1,"Excellent","Try Again")
=CONCAT(A1,"Excellent")
