🧠 Smart Online Exam

Q.1

=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.2

Error handle karne ke liye kaunsa function use hota hai?

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

Q.3

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

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

Q.4

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

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

Q.5

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

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

Q.6

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

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

Q.7

Condition lagane ke liye kaunsa function use hota hai?

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

Q.8

Logical OR check karne ke liye function hai:

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

Q.9

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

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

Q.10

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

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

Q.11

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

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

Q.12

Value dhundhne ke liye commonly kaunsa function use hota hai?

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

Q.13

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

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

Q.14

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

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

Q.15

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

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

Q.16

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

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

Q.17

Text ko jodne ke liye kaunsa function use hota hai?

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

Q.18

Current date lane ke liye function hai:

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

Q.19

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

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

Q.20

NOT function ka kaam hota hai:

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

Q.21

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

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

Q.22

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

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

Q.23

=SQRT(81) ka result kya hoga?

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

Q.24

=NOW() kya return karta hai?

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

Q.25

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

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

Q.26

Minimum value nikalne ke liye kaunsa function use hota hai?

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

Q.27

Maximum value nikalne ke liye kaunsa function use hota hai?

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

Q.28

Average nikalne ke liye kaunsa function use hota hai?

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

Q.29

Day nikalne ke liye function hai:

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

Q.30

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

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

Q.31

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

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

Q.32

Year nikalne ke liye function hai:

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

Q.33

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

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

Q.34

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

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

Q.35

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

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

Q.36

Square root nikalne ke liye function hai:

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

Q.37

Current date and time lane ke liye function hai:

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

Q.38

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

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

Q.39

VLOOKUP ka full form hai:

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

Q.40

HLOOKUP ka full form hai:

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

Q.41

Month nikalne ke liye function hai:

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

Q.42

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

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

Q.43

Absolute reference ka example hai:

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

Q.44

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

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

Q.45

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

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

Q.46

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

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

Q.47

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

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

Q.48

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

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

Q.49

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

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

Q.50

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

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

Q.51

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

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

Q.52

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.53

Date banane ke liye function hai:

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

Q.54

Blank cell check karne ke liye function hai:

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

Q.55

=NOT(TRUE) ka result kya hoga?

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

Q.56

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

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

Q.57

Excel me formula insert karne ke liye symbol hota hai:

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

Q.58

Logical AND check karne ke liye function hai:

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

Q.59

=TODAY() kya return karta hai?

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

Q.60

Number check karne ke liye function hai:

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

Q.61

Round off karne ke liye function hai:

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

Q.62

Excel me formula kis sign se start hota hai?

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

Q.63

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

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

Q.64

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

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

Q.65

Power nikalne ke liye function hai:

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

Q.66

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

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

Q.67

Numbers ko jodne ke liye kaunsa function use hota hai?

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

Q.68

=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.69

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

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

Q.70

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

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

Student Verification