Font size
WorksheetsExcel Formulae
Total questions: 10
Worksheet time: 9mins
Which of the following SUM Formulae are Wrong? (Select 2)
=SUMM(A1+B1+C1+D1)
=SUM(A1:A9)
=SUM(A1:A9:)
=SUM(A1+B1+C1+D1)
If Cell Position "A7" is smaller than or equal to Cell Position "B9" then print "A7 Lost", else print "B9 Lost".
Write Formula to do this.
=IF(A7 >= B9, "A7 Lost", "B9 Lost")
=IF(A7 <= B9, "A9 Lost", "B9 Lost")
=IF(A7 <= B9, "A7 Lost", "B9 Lost")
Question Is Wrong
Which of following "Average" Formula is Wrong for Cells Positions A1 to B9?
None of these is wrong
=SUM(A1 : B9) / COUNT(B1 : B9)
=AVERAGE(A1:B9)
=SUM(A1 : B9) / COUNT(A1 : B9)
Which of these formulae you have NOT learnt till now?
IF , SUM
AVERAGE
ANDIF
DIVISION , COUNT
If output of an excel formula is
"#NAME?"
What It means? Select All correct Answer
There is something wrong with Formula
We have Not Used "" is the string output
Cell Position is Not Correct
None of the Above
Is the formula =((A2+B5) * 5% correct?
Yes
No
Both True and False
None of the above
=IF( 100 < 1001/10, "510", "120")
What will be output for above formula?
उपरोक्त सूत्र के लिए आउटपुट क्या होगा?
"120"
"510"
510
"510"
Tell me Output of Formula:
मुझे फॉर्मूला का आउटपुट बताओ:
=IF (A1 >= B7, B9+C6, "I am Idiot")
Where
A1 = 100, B7=101, B9=102, C6=103
100
205
101
I am Idiot
To Put Series Number 1.......... 45 in a Column,
How may ways are taught till now?
0
1
2
3
If
Answer1 = 70% of 500 Marks
Answer2 = 60% of 600 Marks
Answer3 = 40% of 800 Marks
Write the correct sequence of output of these Number in Descending Order?
Answer1 > Answer3 > Answer2
Answer2 > Answer3 > Answer1
Answer2 > Answer1 > Answer3
Answer1 > Answer2 > Answer3
