CPEC EduCation
ModEl PaPEr – i (PrEParation)
1. Which of the following is not a valid data type in excel?
Ans- character
2. What is the shortcut key to replace a data with another in sheet?
Ans- ctrl+h
3. To remove the content of selected cells you must issue_______command
Ans- Clear contents
4. Paste special allows some operation while you paste to new cell. Which of the following
operation is valid?
Ans- Divide
5. Which of the following you can paste selectively using paste special command?
Ans- Validation, Formulas, Formats
6. The shortcut key Ctrl+R is used in Excel to
Ans- fill the selection with active cells to the right
7. Ctrl+D shortcut key in excel will
Ans- fill down in the selection
8. Long text can be broken down into many lines within a cell. You can do this through
Wrap text in Format>cells
Ans- wrap text in format>cells
9. You can auto fit the width of column by
Ans- double clicking on column right border on column header
10. Which of the cell pointer indicates you that you can make selection?
Ans- Doctor’s symbol(Big Plus)
11. Which command will you choose to convert a column of data into row?
Ans-paste special> Transpose
12. How can you update the values of formula cells if auto calculate mode of excel is disabled?
Ans- F9
13. Each excel file is a workbook that contains different sheets. Which of the following can not be
a sheet in workbook?
Ans- Data sheet
14. Tab scroll buttons are place on excel screen
Ans- towards the bottom left corner
15. Can You can set page border in excel form
Ans- you cannot set page border in excel.
16. If you press __________ the cell accepts your typing as its contents?
Ans- Enter
17. What is the keyboard shortcut (button or button to be pressed) for creating a chart from the
selected cells?
Ans- F11
18. The auto fill feature
Ans- Extends a sequential series of data
19. To protect a worksheet, you can choose protection and the protect sheet from the
__________menu
Ans- Tools
20. You can quickly change the appearance of your work by choosing auto format from the
_____menu.
Ans- Format
21. Which type of chart is useful for composing values over categories ?
Ans- Column Chart
22. Which function in excel tells how many numeric entries are there ?
Ans- COUNT
23. Which ONE is not a function in MS EXCEL ?
Ans- A & G
24. Function in MS Excel must begin with an ( ) sign ?
Ans- An equal Sign
25. The__________ fetcher of MS Excel quickly completes a series of data.
Ans- Auto Fill
26. How many sheets are there by default when we create a new Excel file?
Ans- 3
27. An Excel file is generally called a ____?
Ans- Workbook.
28. In Excel which one denoted arrange from B1 through E5
Ans- B1:E5
29. Which features is used to make selected sentence to all Capital letters or all small ?
Ans- Change Case
30. By default footer are printed on?
Ans- All Pages.
31. The _______feature of MS Excel quickly completes a series of data
Ans- auto fill
32. The process of arranging the items of a column in some sequence or order is known as:
Ans- Sorting
33. What type of chart is useful for showing trends or changes over time?
Ans- Line chart
34. Which function in excel checks whether a condition is true or not?
Ans- IF
35. Which function in excel tells how many numeric entries are there?
Ans; count
36. Which of the following section does not exist in a slide layout?
Ans-animations
37. In slide layout panel how many layouts are available for text layout by default?
Ans -4
38. 38.The default file extension of MS Excel is
Ans. Xls
39. 26. Which command is used to close the window of excel?
Ans. Altl+F4
40. Which tab in Excel is used for proofing, protecting and marking up a spread sheet ?
Ans. Review
41. Which function key used to open Go to dialogue box in MS Excel ?
Ans. F5
42. What type of chart is useful for comparing values over categories?
Ans. column chart
43. Which functioning Excel checks whether a condition is true or not ?
Ans- If
44. In Excel , columns are labeled as ___________?
Ans – A,B,C, etc
45. You can set Page Border in Excel from ___________?
Ans - You cannot set page border in Excel
46. Which tool you will use to join some cells and place the content at the middle of joined cell?
Ans - From format cells dialog box click on merge cells check box
47. Tab scroll the buttons are place on Excel screen?
Ans - Towards the bottom left corner
48. The name box on to the left of formula bar ?
Ans - Shows the name of cell or range currently working on
49. How can you show or hide the gridlines in Excel Worksheet?
Ans - Both of above
50. Which of the cell pointer indicates you that you can make selection ?
Ans – Doctor’s symbol ( Big plus)
51. You can auto fit the width of column by ?
Ans – Double clicking on column right border on column header
52. Which of the cell pointer indicated that you can fill series ?
Ans – Small thin plus icon
53. What is the shortcut key to replace a data with another in sheet ?
Ans – Ctrl + H
54. Commen ts can be added to cells using _____________?
Ans - Review > comments
55. Which area in an Excel window allows entering values and formulas?
Ans – Formula bar
56. How many users can open the Excel file at the same time?
Ans – 256 users
57. Which keyboard shortcut is used to apply “ wrap text ’’ on the selected text ?
Ans – Alt + H + W
58. Step for protecting a sheet by password in MS Excel ?
Ans – Under the review tab , click on protect sheet
59. Which option allows you to display all numbers which are less the 0 (negative numbers ) in
red color in MS Excel ?
Ans – Conditional formatting
60. Show / Hide Gridlines option is available on the _____________menu ?
Ans - Page layout
61. Who is the father of Computer?
ANS- Charles Babbage
62. The Collection of files
ANS- Folder
63. Examples of Output Device are-
ANS- Printer
64. 1 Byte=
ANS- 8 Bits
65. Ctrl+ k is used for
ANS - Hyperlink
66. Which of the following is also known as brain of Computer?
ANS – Control Processing Unit
67. RAM is an example of
ANS – Both A and B
68. The Computer size was very large in
ANS – First Generation Computer
69. DOS Stands for :
ANS – Disk Operating System
70. In notes master view, how do you modify the font size of text for all hte4 notes of a
presentation?
Ans. Modify the text within the body placeholder
71. Want your logo in the same position on every slide, automatically? Insert it on the
Ans. Slide master
72. Which of the following views is the best view to use when setting transition effects for all
slides in a presentation?
Ans. Slide sorter view
73. Objects on the slide that hold text are called
Ans. Placeholders
74. Which of the following provides a means of printing out feature notes with a miniature slide
on a printed page?
Ans. Audience handout
75. Second Generation Computer were developed during:
ANS – 1956 to 1963
76. EEPROM stands for:
ANS- Electrically Erasable Programmable Read Only Memory
77. Which command brings you to the first slide in your presentation?
Ans. Ctrl + Home
78. In normal view, how can you quickly change to handout master view?
Ans. Press the shift key and click the handout master view button
79. How can you quickly reinstate a deleted footer placeholder in master view?
Ans. Re-apply the footer placeholder
80. Which of the following can you use to add times to the slides in a presentation?
Ans. Rehearse timings button
81. What is MS Word?
Ans. A Word Processing software
82 Which Shortcut key is used to insert a bullet point quickly ?
Ans. Ctrl + Shift +L
83. What is the default file extension of MS Word ?
Ans. .doc
84 . Portrait and Landscape are example of ?
Ans. Page Orientation
85. Which option can be used to change page size and page margin in MS Word ?
Ans. Page - setup
86. Which shortcut key is used to display the full page or print preview ?
Ans. Ctrl + F2
87. Ctrl + M is used to ?
Ans. Left Indent
88 What is the use of Ctrl + = key ?
Ans. Subscript
89. In Which tab you will find Auto sum button?
Ans. Formulas tab
90. Which shortcut key is used to inserts a new worksheet?
Ans. Alt + Shift + F1
91. Where a row and column meet, are known as _____________?
Ans. Cell
92. Hyperlinks can be ____________?
Ans. Text, Pictures, Drawing Objet
93. What is the shortcut key to "Center Align" the selected text?
Ans. Ctrl + E
94. What is the shortcut key for Spelling Check in document?
Ans. F7
95. What is the shortcut key to Update Formula in a table?
Ans. F9
96. What is the shortcut key for "Font" dialog box?
Ans. Ctrl + D
97. What is the shortcut key for "Find and Replace" dialog box?
Ans. Ctrl + H
98. What is the shortcut key to "Insert Hyperlink" in a document?
Ans. Ctrl + K
99. How can you access the font size tool on formatting toolbar?
Ans. Ctrl + Shift + P
100. What is the shortcut key for "Subscript" the selected text?
Ans. Ctrl + =
