MS Office Microsoft office Suit एम. एस. ऑफिस के महत्वपूर्ण प्रश्न

Question – What is the box made up of Column and Row called in MS Excel?

(A)    Sheet

(B)    Cell

(C)    Workbook

(D)    Worksheet

Show Answer

उत्तर –  (B)    Cell

 

Question – What is the number of columns in 2000 version of MS Excel?

(A)    16384

(B)    254

(C)    256

(D)    260

Show Answer

Answer – (C) 256

 

Question – What is the number of columns in 2007 version of MS Excel?

(A)    16384

(B)    254

(C)    21256

(D)    260

Show Answer

Answer – (A) 16384

 

Question – What is the number of rows in 2000 version of MS Excel?

(A)    65563

(B)    56536

(C)    65536

(D)    54426

Show Answer

Answer – (C) 65536

 

Question – What is the number of rows in 2007 version of MS Excel?

(A)    1025478

(B)    1048575

(C)    1048576

(D)    1045875

Show Answer

Answer – (C) 1048576

 

Question – With which symbol is it necessary to start every function in MS Excel?

(A)    Dollar

(B)    alphabet

(C)    =

(D)    number

Show Answer

Answer – (C) =

 

Question – How many sheets are already provided in MS Excel?

(A)    1

(B)    3

(C)    5

(D)    7

Show Answer

Answer – (B) 3

 

Question – What is the file created when all the sheets open in MS Excel are saved together?

(A)    Worksheet

(B)    Workbook

(C)    Cell

(D) Wokplace

Show Answer

Answer – (B) Workbook

 

Question – What is the maximum number of characters that a sheet name can have in the 2007 version of MS Excel?

(A)    5

(B)    15

(C)    29

(D)    31

Show Answer

Answer – (D) 31

 

Question – How many characters can be the maximum width of a column in a MS Excel sheet?

(A)    100

(B)    200

(C)    255

(D)    350

Show Answer

Answer – (C) 255

 

Question – How many points can be the maximum length of a row in a MS Excel sheet?

(A)    199

(B)    250

(C)    409

(D)    431

Show Answer

Answer – (C) 409

 

Question – What is the predetermined or default alignment of character in the cell of MS Excel?

(A)    Top Left

(B)    Center Right

(C)    Bottom Center

(D)    Bottom Left

Show Answer

Answer – (D) Bottom Left

 

Question – What is the predetermined or default alignment of numbers in the cells of MS Excel?

(A)    Bottom Right

(B)    Center Right

(C)    Bottom Center

(D)    Bottom Left

Show Answer

Answer – (A) Bottom Right

 

Question – In MS Excel, there is such a cell address which does not change when copied.

(A)    Repeat Cell Address

(B)    Absolute Cell Reference

(C)    Normal Cell Reference

(D) None of these

Show Answer

उत्तर –  (B)    Absolute Cell Reference

 

Question – If 5 is divided by 0 in MS Excel, what will be the result?

(A)    0

(B)    5

(C)    2.5

(D)    Error

Show Answer

Answer – (D) Error

Click Next Page Number to Read More

Leave a Comment