🧠 Smart Online Exam

Q.1

Year nikalne ke liye function hai:

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

Q.2

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

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

Q.3

Absolute reference ka example hai:

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

Q.4

Maximum value nikalne ke liye kaunsa function use hota hai?

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

Q.5

Excel me formula kis sign se start hota hai?

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

Q.6

Logical OR check karne ke liye function hai:

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

Q.7

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

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

Q.8

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

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

Q.9

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

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

Q.10

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

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

Q.11

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

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

Q.12

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

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

Q.13

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

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

Q.14

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

Condition lagane ke liye kaunsa function use hota hai?

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

Q.16

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

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

Q.17

Blank cell check karne ke liye function hai:

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

Q.18

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

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

Q.19

Day nikalne ke liye function hai:

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

Q.20

Round off karne ke liye function hai:

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

Q.21

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

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

Q.22

Month nikalne ke liye function hai:

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

Q.23

Power nikalne ke liye function hai:

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

Q.24

=NOW() kya return karta hai?

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

Q.25

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

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

Q.26

=SQRT(81) ka result kya hoga?

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

Q.27

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

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

Q.28

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

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

Q.29

Current date and time lane ke liye function hai:

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

Q.30

Logical AND check karne ke liye function hai:

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

Q.31

HLOOKUP ka full form hai:

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

Q.32

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

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

Q.33

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

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

Q.34

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

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

Q.35

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

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

Q.36

Minimum value nikalne ke liye kaunsa function use hota hai?

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

Q.37

Text ko jodne ke liye kaunsa function use hota hai?

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

Q.38

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

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

Q.39

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

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

Q.40

Error handle karne ke liye kaunsa function use hota hai?

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

Q.41

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

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

Q.42

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

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

Q.43

Numbers ko jodne ke liye kaunsa function use hota hai?

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

Q.44

Date banane ke liye function hai:

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

Q.45

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

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

Q.46

Excel me formula insert karne ke liye symbol hota hai:

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

Q.47

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

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

Q.48

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

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

Q.49

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

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

Q.50

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

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

Q.51

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

Average nikalne ke liye kaunsa function use hota hai?

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

Q.53

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

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

Q.54

VLOOKUP ka full form hai:

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

Q.55

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

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

Q.56

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

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

Q.57

Value dhundhne ke liye commonly kaunsa function use hota hai?

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

Q.58

Square root nikalne ke liye function hai:

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

Q.59

Number check karne ke liye function hai:

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

Q.60

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

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

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

Q.62

=TODAY() kya return karta hai?

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

Q.63

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

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

Q.64

=NOT(TRUE) ka result kya hoga?

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

Q.65

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

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

Q.66

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

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

Q.67

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

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

Q.68

NOT function ka kaam hota hai:

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

Q.69

Current date lane ke liye function hai:

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

Q.70

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

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

Student Verification