Question – What is the box made up of Column and Row called in MS Excel?
(A) Sheet
(B) Cell
(C) Workbook
(D) Worksheet
[expand title=”Show Answer”]उत्तर – (B) Cell[/expand]
Question – What is the number of columns in 2000 version of MS Excel?
(A) 16384
(B) 254
(C) 256
(D) 260
[expand title=”Show Answer”]
Answer – (C) 256
[/expand]
Question – What is the number of columns in 2007 version of MS Excel?
(A) 16384
(B) 254
(C) 21256
(D) 260
[expand title=”Show Answer”]
Answer – (A) 16384
[/expand]
Question – What is the number of rows in 2000 version of MS Excel?
(A) 65563
(B) 56536
(C) 65536
(D) 54426
[expand title=”Show Answer”]
Answer – (C) 65536
[/expand]
Question – What is the number of rows in 2007 version of MS Excel?
(A) 1025478
(B) 1048575
(C) 1048576
(D) 1045875
[expand title=”Show Answer”]
Answer – (C) 1048576
[/expand]
Question – With which symbol is it necessary to start every function in MS Excel?
(A) Dollar
(B) alphabet
(C) =
(D) number
[expand title=”Show Answer”]
Answer – (C) =
[/expand]
Question – How many sheets are already provided in MS Excel?
(A) 1
(B) 3
(C) 5
(D) 7
[expand title=”Show Answer”]
Answer – (B) 3
[/expand]
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
[expand title=”Show Answer”]
Answer – (B) Workbook
[/expand]
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
[expand title=”Show Answer”]
Answer – (D) 31
[/expand]
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
[expand title=”Show Answer”]
Answer – (C) 255
[/expand]
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
[expand title=”Show Answer”]
Answer – (C) 409
[/expand]
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
[expand title=”Show Answer”]
Answer – (D) Bottom Left
[/expand]
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
[expand title=”Show Answer”]
Answer – (A) Bottom Right
[/expand]
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
[expand title=”Show Answer”]
उत्तर – (B) Absolute Cell Reference
[/expand]
Question – If 5 is divided by 0 in MS Excel, what will be the result?
(A) 0
(B) 5
(C) 2.5
(D) Error
[expand title=”Show Answer”]
Answer – (D) Error
[/expand]
Click Next Page Number to Read More