WorksheetsMamaraximov E
Total questions: 14
Worksheet time: 7mins
Excel dasturida sonning kvadrat ildizini topuvchi funksiya nomini toping?
Katta harflarda kiriting
=????
(a)
Excel dasturida yozilgan quyidagi misol javobini toping?
=CONCAT("O'z",IF(5>(2^(TRUE+2*3)),"bek","ak"))
O'zbek
O'zak
O'zbekak
O'zakbek
Excel dasturida quyidagi to'g'ri yozilgan formulani toping?
=IF(AND(A1>10, B1<5), "Tugadi", "Tugamadi")
=IF(OR(A1>10, B1<5), "Tugadi"; "Tugamadi")
=IF(A1>10;"Tugadi"; IF(B1<5, "Tugadi";"Tugamadi"))
=IF(A1>10, "Tugadi", IF(B1<5, "Tugamadi"))
Excel dasturida quyidagi formulani yozing?
=SUMIF(A1:A10, ">5", B1:B10)
=SUMIF(A1:A10, ">5", B1:B10)
=SUMIF(A1:A10, "<5", B1:B10)
=SUMIF(A1:A10, "=5", B1:B10)
=SUMIF(A1:A10, "5", B1:B10)
Excel dasturida quyidagi formulani yozing?
=INDEX(A1:A10, MATCH(5, B1:B10, 0))
=INDEX(A1:A10, MATCH(5, B1:B10, 0))
=MATCH(A1:A10, INDEX(5, B1:B10), 0)
=LOOKUP(A1:A10, 5, B1:B10)
=VLOOKUP(A1:A10, 5, B1:B10, FALSE)
Excel dasturida quyidagi formulani yozing?
=COUNTIF(A1:A10, ">5")
=COUNTIF(A1:A10, ">5")
=COUNTIF(A1:A10, "<5")
=COUNTIF(A1:A10, "=5")
=COUNTIF(A1:A10, "5")
Excel dasturida quyidagi formulani yozing?
=AVERAGEIF(A1:A10, ">5", B1:B10)
=AVERAGEIF(A1:A10, ">5", B1:B10)
=AVERAGEIF(A1:A10, "<5", B1:B10)
=AVERAGEIF(A1:A10, "=5", B1:B10)
=AVERAGEIF(A1:A10, "5", B1:B10)
A1=-4; A2=2; B1=9; B2=4 bo’lsin. Formula natijasini aniqlang.
=MIN(ABS(A1),B2,ABS(B1*A2))
0
1
-1
4
Excel dasturida quyidagi formulani yozing?
=IF(OR(A1>10, B1<5), "Tugadi", "Tugamadi")
=IF(AND(A1>10, B1<5), "Tugadi", "Tugamadi")
=IF(OR(A1>10, B1<5), "Tugadi", "Tugamadi")
=IF(A1>10, "Tugadi", IF(B1<5, "Tugadi", "Tugamadi"))
=IF(A1>10, "Tugadi", IF(B1<5, "Tugamadi", "Tugadi"))
Excel dasturida quyidagi formulani yozing?
=AVERAGEIF(A1:A10, "<5", B1:B10)
=AVERAGEIF(A1:A10, ">5", B1:B10)
=AVERAGEIF(A1:A10, "<5", B1:B10)
=AVERAGEIF(A1:A10, "=5", B1:B10)
=AVERAGEIF(A1:A10, "5", B1:B10)
Excel dasturida quyidagi formulani yozing?
=SUMIF(A1:A10, "<5", B1:B10)
=SUMIF(A1:A10, ">5", B1:B10)
=SUMIF(A1:A10, "<5", B1:B10)
=SUMIF(A1:A10, "=5", B1:B10)
=SUMIF(A1:A10, "5", B1:B10)
Excel dasturida quyidagi formulani yozing?
=IF(OR(A1<10, B1>5), "Tugadi", "Tugamadi")
=IF(AND(A1<10, B1>5), "Tugadi", "Tugamadi")
=IF(OR(A1<10, B1>5), "Tugadi", "Tugamadi")
=IF(A1<10, "Tugadi", IF(B1>5, "Tugadi", "Tugamadi"))
=IF(A1<10, "Tugadi", IF(B1>5, "Tugamadi", "Tugadi"))
Excel dasturida quyidagi formulani yozing?
=MAX(A1:A10, B1:B10)
=MAX(A1:A10, B1:B10)
=MIN(A1:A10, B1:B10)
=SUM(A1:A10, B1:B10)
=AVERAGE(A1:A10, B1:B10)
Excel dasturida quyidagi formulani yozing?
=IFERROR(VLOOKUP(A1, Sheet2!A:B, 2, FALSE), "Not Found")
=IFERROR(VLOOKUP(A1, Sheet2!A:B, 2, FALSE), "Not Found")
=IFNA(VLOOKUP(A1, Sheet2!A:B, 2, FALSE), "Not Found")
=ISERROR(VLOOKUP(A1, Sheet2!A:B, 2, FALSE), "Not Found")
=ERROR(VLOOKUP(A1, Sheet2!A:B, 2, FALSE), "Not Found")
