NEW
Font size
WorksheetsMirosoft Excel Quiz- Mamta
Total questions: 10
Worksheet time: 5mins
The function to convert string 'god alone' to capital letters is
Capital
Lower
Upper
Proper
Choose the correct function to extract rope from Europe.
=Extract(Europe,rope)
=Left("Europe","rope")
=Right("Europe",4)
=Right("Europe","rope")
To display the length of the string United Kingdom the correct function is
=Length("United Kingdom")
=Len("United Kingdom")
=Count("United Kingdom")
=Sum("United Kingdom")
To display the current date the function is
=Now()
=Date()
=Today()
=Day()
To remove extra spaces from a string use function
Trim
Remove
Replace
Delete
=Replace("clove",1,2,"st")
cstove
stove
clost
closst
To display the lowest value in a range of values the functon is
Min
Minimum
Smallest
Lowest
=if(a1<100,"Century scored","Century not Scored")
What will be the ouput of the above function in case value of a1 is 100
Century scored
Century not Scored
Error
None of the above
To combine strings 'brain' and 'storm' to form one string the function is
=concatenate(brain,storm)
=brain&storm
=combine(brain,storm)
=concatenate("brain","storm")
Count and Len functions can be interchangably used.
True
False
