🧠 Smart Online Exam

Q.1

Maximum value nikalne ke liye kaunsa function use hota hai?

A. HIGH B. MAX C. LARGE D. TOP

Q.2

Kisi condition ke basis par count karne ke liye function hai:

A. COUNTIF B. IFCOUNT C. COUNT D. COUNTA

Q.3

=MAX(12,45,7,89) ka result kya hoga?

A. 45 B. 12 C. 89 D. 7

Q.4

=SUM(10,20,30) ka result kya hoga?

A. 50 B. 60 C. 70 D. 40

Q.5

Blank cell check karne ke liye function hai:

A. ISNULL B. ISBLANK C. BLANK D. EMPTY

Q.6

Minimum value nikalne ke liye kaunsa function use hota hai?

A. MIN B. SMALL C. LOW D. LESS

Q.7

Power nikalne ke liye function hai:

A. EXP B. POW C. POWER D. MUL

Q.8

Logical OR check karne ke liye function hai:

A. OR B. IF C. ANY D. EITHER

Q.9

Text ko uppercase me badalne ke liye kaunsa function use hota hai?

A. UPPER B. CAPS C. LARGE D. TOPPER

Q.10

Text ko lowercase me badalne ke liye kaunsa function use hota hai?

A. LOWER B. SMALL C. LCASE D. DOWN

Q.11

Error handle karne ke liye kaunsa function use hota hai?

A. IFERROR B. ERRORIF C. ISERROR D. FIXERROR

Q.12

Sirf numeric cells count karne ke liye kaunsa function use hota hai?

A. COUNTA B. COUNT C. COUNTIF D. NUMBER

Q.13

Exact match ke liye VLOOKUP me last argument kya hota hai?

A. TRUE B. 1 C. FALSE D. YES

Q.14

=IFERROR(10/0,"Error") ka result kya hoga?

A. 0 B. 10 C. Error D. FALSE

Q.15

Numbers ko jodne ke liye kaunsa function use hota hai?

A. ADD B. SUM C. TOTAL D. PLUS

Q.16

=IF(20>50,"Pass","Fail") ka result kya hoga?

A. Pass B. 20 C. Fail D. Error

Q.17

Current date and time lane ke liye function hai:

A. DATE B. TIME C. NOW D. TODAYNOW

Q.18

=IF(80>50,"Pass","Fail") ka result kya hoga?

A. Fail B. Pass C. 50 D. Error

Q.19

=COUNT(10,20,"A",30) ka result kya hoga?

A. 4 B. 3 C. 2 D. 1

Q.20

=DATE(2025,12,25) kya return karega?

A. Sirf year B. Sirf month C. 25-Dec-2025 type ki date D. Error

Q.21

=LEFT("COMPUTER",3) ka result kya hoga?

A. PUT B. TER C. COM D. COMP

Q.22

=LEN("Excel") ka result kya hoga?

A. 4 B. 5 C. 6 D. 7

Q.23

=MID("COMPUTER",2,3) ka result kya hoga?

A. OMP B. COM C. PUT D. TER

Q.24

Square root nikalne ke liye function hai:

A. ROOT B. SQRT C. SQR D. POWER

Q.25

Absolute reference ka example hai:

A. A1 B. A$1 C. $A$1 D. A1$

Q.26

Left side se text nikalne ke liye kaunsa function use hota hai?

A. LEFT B. LIFT C. MID D. RIGHT

Q.27

Logical AND check karne ke liye function hai:

A. IF B. AND C. BOTH D. ALL

Q.28

=ROUND(45.678,2) ka result kya hoga?

A. 45.6 B. 45.67 C. 45.68 D. 46

Q.29

VLOOKUP ka full form hai:

A. Vertical Lookup B. Value Lookup C. Variable Lookup D. Virtual Lookup

Q.30

Har word ka first letter capital karne ke liye function hai:

A. CAPITAL B. PROPER C. FIRSTCAP D. INIT

Q.31

Text ki length nikalne ke liye kaunsa function use hota hai?

A. LENGTH B. LEN C. COUNT D. TEXTLEN

Q.32

=SQRT(81) ka result kya hoga?

A. 8 B. 7 C. 9 D. 6

Q.33

Kisi condition ke basis par sum karne ke liye function hai:

A. SUMIF B. IFSUM C. TOTALIF D. ADDSUM

Q.34

=SUMIF(A1:A10,">50") ka use hota hai:

A. 50 se chhoti values ko add karna B. 50 se badi values ko add karna C. Sab values ka average D. Text ko sum karna

Q.35

Round off karne ke liye function hai:

A. RND B. ROUND C. FIX D. VALUE

Q.36

=TODAY() kya return karta hai?

A. Current time B. Current date C. Year only D. Month only

Q.37

Text me kisi specific word ki position dhundhne ke liye function hai:

A. FIND B. SEARCHPOS C. LOCATE D. TEXTFIND

Q.38

=POWER(2,4) ka result kya hoga?

A. 6 B. 8 C. 16 D. 12

Q.39

Right side se text nikalne ke liye kaunsa function use hota hai?

A. END B. LAST C. RIGHT D. RGT

Q.40

=COUNTIF(A1:A10,">50") ka use hota hai:

A. 50 se kam values count karna B. 50 se badi values count karna C. Sabhi text count karna D. Blank count karna

Q.41

Number check karne ke liye function hai:

A. ISNUMBER B. NUMBER C. CHECKNUM D. NUM

Q.42

=MIN(12,45,7,89) ka result kya hoga?

A. 12 B. 7 C. 45 D. 89

Q.43

Month nikalne ke liye function hai:

A. MONTH B. MON C. MTH D. DATE

Q.44

=NOT(TRUE) ka result kya hoga?

A. TRUE B. FALSE C. 1 D. 0

Q.45

Formula copy karne par reference badal jata hai, ise kya kehte hain?

A. Absolute reference B. Relative reference C. Mixed reference D. Fixed formula

Q.46

Date banane ke liye function hai:

A. DATE B. DAY C. TODAY D. MONTH

Q.47

=RIGHT("COMPUTER",3) ka result kya hoga?

A. TER B. COM C. PUT D. UTE

Q.48

Beech se text nikalne ke liye kaunsa function use hota hai?

A. MID B. CENTER C. BETWEEN D. PART

Q.49

Excel me formula insert karne ke liye symbol hota hai:

A. fx B. fn C. @ D. #

Q.50

Condition lagane ke liye kaunsa function use hota hai?

A. SUM B. IF C. MAX D. OR

Q.51

=OR(5<2, 10>3) ka result kya hoga?

A. FALSE B. TRUE C. 0 D. Error

Q.52

=AVERAGE(10,20,30) ka result kya hoga?

A. 15 B. 20 C. 25 D. 30

Q.53

=CONCAT("MS","Excel") ka result kya hoga?

A. MS Excel B. MSExcel C. ExcelMS D. MS-Excel

Q.54

=FIND("x","Excel") ka result kya hoga?

A. 1 B. 2 C. 3 D. 4

Q.55

Text ko jodne ke liye kaunsa function use hota hai?

A. CONCAT B. COMBINE C. JOINTEXT D. LINK

Q.56

Non-empty cells count karne ke liye kaunsa function use hota hai?

A. COUNT B. COUNTA C. COUNTIF D. TOTAL

Q.57

=NOW() kya return karta hai?

A. Sirf date B. Sirf time C. Date and time D. Error

Q.58

Average nikalne ke liye kaunsa function use hota hai?

A. AVG B. MEAN C. AVERAGE D. MID

Q.59

HLOOKUP ka full form hai:

A. High Lookup B. Horizontal Lookup C. Hyper Lookup D. Hidden Lookup

Q.60

Day nikalne ke liye function hai:

A. DAY B. DATE C. DD D. TODAY

Q.61

Year nikalne ke liye function hai:

A. YEARS B. YEAR C. YR D. DATEYEAR

Q.62

NOT function ka kaam hota hai:

A. Value ko jodna B. Logical result ulta karna C. Text ko split karna D. Average nikalna

Q.63

=UPPER("india") ka result kya hoga?

A. India B. india C. INDIA D. INdia

Q.64

Value dhundhne ke liye commonly kaunsa function use hota hai?

A. SEARCH B. FIND C. VLOOKUP D. LOCATE

Q.65

=LOWER("INDIA") ka result kya hoga?

A. INDIA B. India C. india D. InDiA

Q.66

=PROPER("vikram maurya") ka result kya hoga?

A. Vikram Maurya B. VIKRAM MAURYA C. vikram maurya D. Vikram maurya

Q.67

Current date lane ke liye function hai:

A. DATE B. TODAY C. NOWDATE D. DAY

Q.68

=COUNTA(10,"Excel","",40) ka result kya hoga?

A. 2 B. 3 C. 4 D. 1

Q.69

Excel me formula kis sign se start hota hai?

A. + B. - C. = D. %

Q.70

=AND(5>2, 10>3) ka result kya hoga?

A. FALSE B. TRUE C. 5 D. Error

Student Verification