Practical Exam Samples Revision
1- Which of the following is not a valid data type in Excel?
A. Number B. Character C. Label D. Date/Time
2- Which area in an Excel window allows entering values and formulas?
A. Title Bar B. Menu Bar C. Formula Bar D. Standard Tool Bar
3- An Excel Workbook is a collection of
A. Workbooks B. Worksheets C. Charts D. Worksheets and Charts
4- To access the Font dialogue box of a document to change the font style, by selecting the
following menu item:
(a) Edit> Font > Font style (b) View> Font > Font style
(c) Tools> Font > Font style (d) Format> Font > Font style
5- How to set a bulleted list for the ordinary list?
A. Select the list and press the bullets icon in the toolbar
B. Press the bullets icon in the toolbar
C. Select list and select format --> bullets and numbering
D. Both A and C
6. Which of the following can be looked up (search) by using the Find tab (Ctrl+F)?
A. Format B. Characters C. Symbol D. All Of The Above
7. Which page’s header or footer is printed automatically?
(a) on the first page (b) on the last page (c) on alternate page (d) every page
8. Which of these toolbars allows you to alter the fonts’ sizes?
(a) Standard (b) Formatting (c) Options (d) All of the above
9. Shortcut to insert the current date in a word:
A. Shift+d B. Ctrl+shift+d C. Alt+shift+d D. Ctrl+d
10. By which of the following option navigation, a sound file can be added to a word document?
(a) From insert -> sound menu option
(b) From insert -> object menu option
(c) From insert -> subject menu option
(d) From insert -> file menu option
11. Graphics for a power point slides or word document is:
A. Peripheral B. Clipart C. Highlight D. Execute
12. What does the Ctrl + I shortcut key accomplish in Ms-Word?
A. It converts selected text into the next larger size of the same font.
B. It adds a line break to the document.
C. It makes the selected text bold.
D. It applies Italic formatting to the selected text.
13. Why are headers and footers used in documents?
A. To enhance the overall appearance of the document
B. To mark the starting and ending of a page
C. To make large documents more readable
D. To allow page headers and footers to appear on a document when it is printed.
14. What does the Ctrl + B shortcut accomplish in MS Word?
A. It converts selected text into the next larger size of the same font.
B. It adds a line break to the document.
C. It makes the selected text bold.
D. It applies Italic formatting to the selected text.
15. When a for-mat-ted num-ber does not fit within a cell, it displays
A. ##### B. #DIV/0 C. #DIV@ D. None of these
16. What sym-bol is used to enter function formula to get summation of some cells?
A. ‘ B. " C. = D. +
17. To select mul-ti-ple non-adjacent cells in a work-sheet, you will click them holding
A. CTRL key B. ALT key C. Shift Key D. Ctrl+Shift key
18. How many sheets are there in the Excel Work-book by default?
A. 2 B. 3 C. 4 D. 5
19. Which of the fol-low-ing com-po-nent dis-plays the con-tents of active cells?
A. Name box B. Formula bar C. Menu bar D. Status bar
20. The files created by the PowerPoint program have extension:
A. * .docx B. *.pptx C.*.xls D. *.pdf
