NEW
Font size
WorksheetsNetwork Topology and excel IF function
Total questions: 15
Worksheet time: 9mins
LAN stands for?
London Area Network
Local Angled Network
Local Area Network
Long Area Network
How many cables are required for 10 PCs in Full mesh Topology?
Full mesh Topology me 10 PCs ke liye kitni cables lagegi?
10
100
45
50
Which network topology uses a backbone to connect all of the computers?
Kaunsi network topology sabhi computers ko connect karne ke liye backbone ka use karti hai?
Bus
Ring
Star
It is a network topology that uses mix or any two or more topologies
Yeh ek network topology hai jo do ya zyada topologies ka mix ya combination use karti hai.
Ring
Hybrid
Mesh
Star
In Excel, which of the following would count only numbers but not words?
Excel me, niche diye gaye mein se kaunsa sirf numbers ko count karega, words ko nahi?
COUNT
COUNTA
COUNTIF
SUM
Which of the following would count both numbers and words?
Niche diye gaye mein se kaunsa dono numbers aur words ko count karega?
COUNT
COUNTA
COUNTIF
SUM
How does a COUNTIF function look like?
COUNTIF function kaise dikhta hai?
=COUNTIF(A1_A5, 2)
=COUNTIF(A1:A5, "2")
=COUNTIF(A1:A5, 2)
=COUNTIF(A1-A5, "2")
What is the formula in G5? (Sales over $100)
G5 mein formula kya hai? (Sales $100 se zyada)
=COUNTIF(D5:D12,">100"
=COUNTA(D5:D12,">100"
=COUNT(D5:D12,">100"
=SUM(D5:D12,">100"
What is the formula to count "JIM"?
"JIM" ko count karne ke liye formula kya hai?
=COUNTIF(B5:B12,JIM)
=COUNTIF(B5:B12,(JIM))
=COUNTIF(B5:B12,<JIM>)
=COUNTIF(B5:B12,"JIM")
if statement structure is:
if statement ka structure kya hota hai?
if(value-if-true,logical-test,value-if-false)
if(logical-test,value-if-false-value-if-true)
if(logical-test,value-if-true,value-if-false)
Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"
Yeh function likhne ka sahi tareeka kaunsa hai:
Agar B4, 200 se zyada hai, toh "High" dikhaye, warna "Low" dikhaye.
IF(B4>200;"High";"Low")
=IF(B4<200,"High","Low")
=IF(B4>200,"High","Low")
=IF(B4>200"High","")
A2 = 20, B2 = 30, C2 =40 then what value should be returned for =IF(B2<>C2, A2*10,"")?
Agar A2 = 20, B2 = 30, C2 = 40 hai, toh =IF(B2<>C2, A2*10,"") ke liye kaunsi value return karni chahiye?
20
300
200
400
If the value of B2 is 68, what will this IF function give as a result? =IF(B2>60, 'pass', 'fail')
Agar B2 ki value 68 ho, to ye IF function kya result dega? =IF(B2>60, 'pass', 'fail')
pass
fail
60
B5 = 56
B4 = 89
=IF(B5>B4, "Large", "Small")
What is the result that this IF statement will return?
Yeh IF statement kya result return karega?
Large
Small
