Excel Paper
1. What is the Shortcut key to insertcurrent date in a cell?
(A) Ctrl +; (B) Ctrl +:
(C) Ctrl +Shift +; (D) Ctrl +=
2.The number of rows in a worksheet in excel 2007 is…
(A) 1048555 (B) 10485756
(C) 65536 (D)1048576
3.The intersection of rows and columns is called….
(A)Cell (B)Worksheet
(C)Workbook (D) Data
4.Extension of excel file is…..
(A) .ext (B).xls
(C) .bmp (D).jkp
5.What is the shortcut key of cell formatting?
(A) Ctrl + 3 (B)Ctrl + 2
(C) Ctrl + 1 (D) Ctrl + 0
6.In excel, the shortcut key Ctrl +2 , works for ….
(A) Fill Colour (B) Bold
(C) Font Size (D) Italic
7.How many number of menu in excel 2007?
(A) 7 (B) 3
(C) 5 (D) 6
8.What is the shortcut key to go on a worksheet from other worksheet?
(A) Ctrl + Enter (B) Ctrl +Tab
(C) Ctrl + Page up /Page down (D) none of these
9.The number of columns in a worksheet is ….
(A) 65536 (B)16384
(C) 1048576 (D) 256
10.What is the shortcut key of General to Scientific?
(A) Ctrl + ~ (B)Ctrl + ^
(C) Ctrl + # (D)Ctrl +!
11.To erase a mistake, how can you undo to that action?
(A) Ctrl + X (B)Ctrl + Y
(C) Ctrl +Z (D)Ctrl +U
12.The ……. Key removes one character to the right to cursor?
(A) Backspace (B) Shift
(C) Delete (D)Enter
13.Which of the following are vertical lines in a table in excel?
(A) Row (B)Column
(C) Cell (D) None of these
14.To go to back of column the shortcut key is…..
(A) Shift + Tab (B) Tab
(C) Alt+ Tab (D) Alt+Shift +Tab
15.Cell address A$4 in a formula means it….
(A) Relative Cell Reference (B) Absolute Cell Reference
(C) Mixed Cell Reference (D) None of these
16.To insert the row and column, we use …..
(A) Ctrl + = (B)Ctrl + Shift +;
(C) Ctrl + Shift + = (D) Ctrl + /
17.Ctrl + U, shortcut key is used to…..
(A) Bold (B)Undo
(C) Underline (D) Redo
18.Now () is ……
(A) Current Date/time (B) Current Date
(C) Time (D)Current Day
19.Today () is….
(A) Current Date (B) Time
(C) Current Date /Time (D) Current Day
20.How many numbers are calculated defaultly by excel?
(A) 12 (B) 13
(C) 15 (D)11
21.What is the shortcut key of calculating numbers above 11 by the excel?
(A) # (B) ###
(C) ## ### ## (D) ##. 0
22.Excel is a …
(A) DBMS (B) Word Processing
(C) Application (D) None of these
23.Excel is also called….
(A) Spread sheet (B) Electronic Sheet
(C) Worksheet (D) Both A and B
24.Extension of bitmap file is….
(A) .jkp (B) .bmp
(C) .exc (D) .ppt
25.Extension of photos is…
(A) .jpg (B) .gkp
(C) .exc (D) .ppt
26. The key F12 opens a...
(A) New dialog box (B) Save dialog box
(C) Open dialog box (D) Save as dialog box
27.Which of the following is not a type of margin?
(A) Top (B)Left
(C) Right (D)Center
28.How many points in one inch?
(A) 70 (B)74
(C) 76 (D) 72
29.Ctrl + 3 used for ….
(A) Bold (B)Italic
(C)Underline (D) Font Size
30.What can you Find by use of mod () function?
(A) Multiple (B) Remainder
(C) Repeated Values (D) Factorial
31.Which of the following function are used to signless the number?
(A) Roundup () (B) Fact ()
(C) Trunc () (D) ABS
32.If the arguments contain no numbers, MIN returns.......
(A) 1 (B) 2
(C) 0 (D) 3
33.Which of the following functions are returns the largest value?
(A) MIN () (B) MAX ()
(C) ABS () (D) None of these
34.Text concatenation operator is
(A) # (B)&
(C)! (D) ~
35.Which of the following functions joins two or more text strings into one textstring?
(A) Concatenate () (B) Right ()
(C) Left () (D) SUM ()
36.For apply roundup, we must have…
(A) Number (B) Num_digits
(C) Num, num_digits (D) none of these
37.What are the height and width of the cell defaultly?
(A) 18, 10 (B) 12, 10
(C) 18, 12 (D) 12, 18
38.What is the shortcut key of absolute addressing?
(A) F7 (B) F4
(C) F8 (D) F5
39.What type of functions is ABS ()?
(A) Financial Function (B) Text Function
(C) Statistical Function (D)Mathematical Function
40.You can jump to previous column by.....
(A) Ctrl + Shift +Tab (B) Shift + Enter
(C) Shift + Tab (D) Alt +Tab
41.Which function is used to calculate depreciation and loan payment amounts?
(A) Financial (B) Logical
(C) Statistical (D) Mathematical
42.Ctrl + - is used for.....
(A) Inserting Cells (B) Deleting Cells
(C) Shifting Cells (D) None of these
43.=ROUND (3.25, 1) entered in a cell displays....
(A) 3.3 (B) 3.2
(C) 3 (D)None of these
44.=MOD (-3, 2) entered in a cell displays.......
(A) 0 (B) -1.5
(C) -1 (D)1
45.How many days are maximum to fulfil earn leave at the time of retirement?
(A) =SUM (Sheet2! Sheet5: B5) (B) =SUM (Sheet2:Sheet5! B5)
(C) =SUM (B5! Sheet2:Sheet5) (D) None of these
46.What can you use for fill the colour on text not cell?
(A) Font colour (B) Fill Colour
(C) Text Highlighted Colour (D)none of these
47.What is the shortcut key of Autosum?
(A) Alt + = (B) Ctrl + =
(C) Alt + Shift + = (D) Ctrl + shift + =
48.What is the shortcut key of insert hyperlink?
(A)Ctrl + O (B) Ctrl + K
(C) Ctrl + U (D) Ctrl + D
49.For getting help, we use shortcut key …..
(A) F2 (B) F4
(C) F5 (D)F1
50.To create a chart, we use …
(A)Alt+F11 (B) F1
(C) Alt+F1 (D) Both A andB
True and False Question
51. Excel is anelectronic sheet and it is a DBMS programme.
52. A Workbook isthe collection of worksheets.
53. Formula baris used for editing the cell constants.
54. For print aworksheet we press Shift+ Ctrl + F12 keys together.
55. A7:A10indicates cells A7 through A10.
56. Rows arevertical line in worksheet.
57. In excel, youcan Indicate Absolute cell addressing by the sign. of $.
58. Extension ofExcel File is .xlsc.
59. F4 is theshortcut key of Absolute Cell Addressing.
60. Sum ()function and Trunc () Function are the text function.
61. #??/?? is thesymbol of fraction in formatting cell .
62. Using theundo command you can undo multiple actions.
63. All theformulas in Excel begin with an equal sign.
64. A new Excelworkbook contains five worksheets by default.
65. The SUM ()function has more than one arguments.
66. In Excel youcan indicate absolute references by a Hash sign..
67. To displaythe current time, the NOW () function can be used.
68. Excel iscalled electronic sheet or spreadsheet.
69. =MOD (5, 3)entered in cell displays 3.
70. To refer thecell B2 on Sheet 3, we enter Sheet3! B2.
71. Theintersection of rows and column is called Cell.
72. By insert hyperlink,we can create a link to a webpage on email addresses.
73. The shortcutkey of paste function is Shift +F3.
74. Ctrl + 4 isthe shortcut key of Italic.
75. Pastefunction is the collection of readymade formulas in which you put the value toget perfect answer.
76. To make theGeometric progression series, we use growth series.
77. A1 is anexample of an absolute cell reference.
78. Formula isstarted by the equal sign.
79. For roundupthe values, we use shortcut formula # ###. ##
80. Excel probably considers the cell entryJanuary 1, 2010 to be a formula.
81. ApplyingConcatenate () function, we joins two or more text strings into one textstring.
82. Shift + F3 isthe function key when you want to choose type of text function.
83. Standardwidth of a column is 18.27.
84. At the bottomof each workbook, appearing tabs is called Sheet tabs.
85. To insertgridlines to the active chart, you have to go on Layout Tab.
86. Last columnof the worksheet windows is XFD.
87. Collate isused to find multiple copies as you want.
88. The Status Bar displays the constant valueor formula used in the active Cell.
89. The title baris available in Excel 2010.
90. Ctrl + ^ isthe shortcut key of choose Scientific number to display the values.
91. ABS ()function returns the absolute value of a number.
92. A cell entry can be edited either in the cell or in theformula bar.
93. The first cell in Excel 2010 worksheet is labeledas A0.
94. In Excel 2007, there are 16332 columns.
95. #REF! Error in MS-Excel occurs when the formularefers to an invalid cell.
96. If the text entered in a cell does not fit, Excelwill display ###### to indicate that the text is too long.
97. Date/time is not a valid data type in excel.
98. MAX () function is the statistical function.
99. It is possible to insert a sheet at the end of theworkbook.
100. Ctrl + Alt +Shift +tab keys together are theshortcut key of Decrease Indent.
Answer Sheet
| 1 | A | 21 | A | 41 | A | 61 | T | 81 | T |
| 2 | D | 22 | A | 42 | B | 62 | T | 82 | T |
| 3 | A | 23 | D | 43 | A | 63 | T | 83 | F |
| 4 | B | 14 | B | 44 | D | 64 | F | 84 | T |
| 5 | C | 25 | A | 45 | B | 65 | T | 85 | T |
| 6 | B | 26 | D | 46 | C | 66 | T | 86 | T |
| 7 | A | 27 | A | 47 | A | 67 | F | 87 | T |
| 8 | C | 28 | D | 48 | B | 68 | T | 88 | F |
| 9 | A | 29 | B | 49 | D | 69 | F | 89 | T |
| 10 | B | 30 | B | 50 | C | 70 | T | 90 | T |
| 11 | C | 31 | D | 51 | T | 71 | T | 91 | T |
| 12 | C | 32 | C | 52 | T | 72 | T | 92 | T |
| 13 | B | 33 | B | 53 | T | 73 | T | 93 | T |
| 14 | A | 34 | B | 54 | T | 74 | F | 94 | F |
| 15 | B | 35 | A | 55 | T | 75 | T | 95 | T |
| 16 | C | 36 | C | 56 | F | 76 | T | 96 | T |
| 17 | C | 37 | A | 57 | T | 77 | T | 97 | F |
| 18 | A | 38 | B | 58 | T | 78 | F | 98 | T |
| 19 | A | 39 | D | 59 | T | 79 | T | 99 | F |
| 20 | D | 40 | C | 60 | F | 80 | F | 100 | T |
Name – JyotiSahani
Father’sname – Mr. Rajesh Sahani
Course - CCC+
Address –Rahul Nagar Madya Azamgarh
Contact no. –7607743313 , 7309927181
Total Visitor
