- how does the keyboard’s backspace key work?
(A) it erases characters to the left of the cursor
(B) it erases characters to the right of the cursor
(c) it moves the cursor left
(D) it erases the character above the cursor
ans(A)it erases characters to the left of the cursor
2. what is the default file extension for all word documents?
(A) T X T X
(B)W R D X
(C) D O C
(D) D O C X
ans(D) D O C X
3. which keystroke will take you at the beginning of the next or previous page of the document?
(a) ctrl+page up and ctrl+ page down
(b) shift+ home and shift + end
(c) ctrl+ home and ctrl+end
(d) the only way is by using the right scroll bar
ans(a)ctrl+page up and ctrl+ page down
4. IN MS WORD HOW CAN YOU HIGHLIGHT TEXT WITHOUT USING THE MOUSE?
(A) IT IS IMPOSSIBLE TO DO SO
(B) BY USING THE F5 KEY
(C) BY USING THE ARROW KEYS WHILE HOLDING DOWN A CTRL KEY
(D) BY USING THE ARROW KEYS WHILE HOLDING DOWN A SHIFT
ANS(D) BY USING THE ARROW KEYS WHILE HOLDING DOWN A SHIFT
5. WHICH OF THE FOLLOWING IS A TOOL TO SEND LETTER TO MANY RECIPIENTS IN MS WORD?
(A) WHAT-IF
(B) MAIL MERGE
(C) GOAL SEEKING
(D)SORTING
ANS(B)MAIL MERGE
6. TO CREATE A PARA BREAK IN MS-WORD WHICH KEY IS USED?
(A) ENTER
(B) ESC
(C) TAB
(D) SHIFT
ANS(A) ENTER
7. MARK THE MOST APPROPRIATE STATEMENT?
(A)MAIL MERGE CAN BE USED TO PRINT THE FORM LETTERS
(B) MAIL MERGE CAN BE USED TO PRINT THE FORM LETTERS AND MAILING LABELS
(C) MAIL MERGE CAN BE USED TO PRINT ENVELOPES
(D) ALL OF THE ABOVE
ANS(D) ALL OF THE ABOVE
8. WHICH OF THE FOLLOWING IS NOT A FONT STYLE?
(A) BOLD
(B) ITALICS
(C) REGULAR
(D) STRIKETHROUGH
ANS(D)STRIKETHROUGH
9. USING MICROSOFT WORD’S FIND AND REPLACE FEATURE YOU CAN ?
(A)REPLACE BOTH TEXT AND FORMATING
(B) REPLACE TEXT OF A DOCUMENT ONLY
(C) REPLACE FORMATTING ONLY
(D) REPLACE DOCUMENT’S NAME WITH A NEW NAME
ANS(B) REPLACE TEXT OF A DOCUMENT ONLY
10. PURPOSE OF ARRANGE ALL OPTION IN THE WORDS IS ?
(A) TO ALIGN ALL THE PARAGRAPHS IN A WORD DOCUMENT
(B) TO ALIGN ALL THE OPEN WORD DOCUMENTS ON SCREEN FOR EASY ACCESSIBILITY
(C) TO ARRANGE ALL OPEN WORD FILES ALPHABETICALLY
(D) NONE OF THE ABOVE
ANS(B) TO ALIGN ALL THE OPEN WORD DOCUMENTS ON SCREEN FOR EASY ACCESSIBILITY
11. THE SAVE AS DIALOG BOX CAN BE USED ?
(A) FOR SAVING THE FILE FOR THE FIRST TIME
(B)TO SAVE FILE BY SOME ALTERNATIVE NAME
(C) TO SAVE FILE IN A FORMAT OTHER THAN WORD
(D) TO SAVE FILE IN A FORMAT OTHER THAN WORD
ANS(D) TO SAVE FILE IN A FORMAT OTHER THAN WORD
12. WHICH OF THE FOLLOWING BELONGS TO APPLICATION SOFTWARE ?
(A) WORD PROCESSING SOFTWARE
(B) DEVICE DRIVER
(C) OPERATING SYSTEM
(D) LANGUAGE TRANSLATORS
ANS(A)WORD PROCESSING SOFTWARE
13. TO PASTE TEXT FROM THE CLIPBOARD IN THE DOCUMENT BEING EDITED PRESS THE KEYS?
(A)CTRL AND V
(B) CTRL AND X
(C)CTRL AND A
(D) INS
ANS(A)CTRL AND V
14. BACKGROUND COLOR OR EFFECTS APPLIED ON A DOCUMENT IS NOT VISIBLE IN ?
(A) WEB LAYOUT VIEW
(B) PRINT LAYOUT VIEW
(C) READING VIEW
(D) PRINT PREVIEW
ANS(D)PRINT PREVIEW
15. WHICH OF THE FOLLOWING IS A SHORTCUT KEY FOR ” SPELLING AND GRAMMAR”?
(A) F 7
(B) F 5
(C) F 1
(D) F 12
ANS(A) F 7
16. WHICH OF THE FOLLOWING SHORTCUT IS USED TO OPEN A NEW FILE?
(A) CTRL+S
(B) CTRL+N
(C) ALT+N
(D)CTRL+V
ANS(B) CTRL+N
17. TO CUT TEXT FROM THE DOCUMENT PRESS THE KEYS ?
(A) CTRL AND V
(B) CTRL AND C
(C) CTRL AND A
(D) CTRL AND X
ANS(D)CTRL AND X
18. ______ KEY COMBINATION CAN BE USED TO UNDERLINE A COMPLETE WORD?
(A) CTRL+U
(B) CTRL+ALT+U
(C) CTRL+A+U
(D) CTRL+ SHIFT +U
ANS(D)CTRL+ SHIFT +U
19. WHICH SOFTWARE IS USED TO PREPARE DOCUMENT FILES?
(A) SPREADSHEET
(B) DATA BASE
(C) WORD PROCESSING
(D) POWER POINT
ANS(C) WORD PROCESSING
20. TO INSERT A CHARACTER WHICH IS NOT PRESENT ON YOUR KEY BOARD IN WORD GO TO ?
(A) INSERT TAB ILLUSTRATIONS OPTION
(B) INSERT TAB LINK OPTION
(C) INSERT TAB SYMBOL OPTION
(D) INSERT TAB TEXT OPTION
ANS(C)INSERT TAB SYMBOL OPTION
21. THE ADVANTAGE OF USING A SPREADSHEET IS?
(A) CALCULATIONS CAN BE DONE AUTOMATICALLY
(B) CHANGING DATA AUTOMATICALLY UPDATES CALCULATIONS
(C) MORE FLEXIBILITY
(D) ALL OF THE ABOVE
ANS(D)ALL OF THE ABOVE
22. USING THE CELL ADDRESS $A4 WITHIN A FORMULA IN EXCEL MEANS IT IS A ?
(A) MIXED CELL REFERENCE
(B) ABSOLUTE CELL REFERENCE
(C) RELATIVE CELL REFERENCE
(D) ALL OF THE ABOVE
ANS.(A) MIXED CELL REFERENCE
23. THE WORD THAT DESCRIBE DOING ANY TYPE OF MONTH ON A SPREADSHEET LIKE AUTOSUM AVERAGE MULTIPLY IS CALLED?
(A) FORMULA
(B) CUBICLE
(C) AUTOCELL
(D) CALCELL
ANS(A) FORMULA
24. THE FUNCTION ROUND (1343.45,-2) RETURNS?
(A) 1343
(B) -1343
(C)-1300
(D) 1300
ANS(D) 1300
25. REFERENCE THAT CHANGE AUTOMATICALLY WHEN YOU COPY THEM TO A NEW CELL ARE CALLED?
(A) RELATIVE REFERENCE
(B) ABSOLUTE REFERENCE
(C) MIXED REFERENCE
(D) NONE OF THE ABOVE
ANS(A)RELATIVE REFERENCE
26. PIE CHARTS CAN BE PLOTTED ON?
(A) MULTIPLE DATA SERIES ONLY
(B) ONLY TWO DATA SERIES
(C) ONLY ONE DATA SERIES
(D) EXACTLY EIGHT DATA SERIES
ANS.(C)ONLY ONE DATA SERIES
27. HOW DO YOU CHANGE COLUMN WIDTH TO FIT THE CONTENTS?
(A) SINGLE CLICK THE BOUNDARY TO THE LEFT TO THE COLUMN HEADING
(B) DOUBLE CLICK THE BOUNDARY TO THE RIGHT OF THE COLUMN HEADING
(C) PRESS ALT AND SINGLE CLICK ANYWHERE IN THE COLUMN
(D) ALL OF THE ABOVE
ANS(B)DOUBLE CLICK THE BOUNDARY TO THE RIGHT OF THE COLUMN HEADING
28. A COLLECTION OF WORKSHEETS IS CALLED AS?
(A) EXCEL SHEETS
(B) WORKBOOK
(C) EXCEL WORKSHEETS
(D) EXCEL BOOK
ANS(b)WORKBOOK
29. BAR CHARTS CAN BE PLOTTED ON?
(A) MULTIPLE DATA SERIES ONLY
(B) ONLY TWO DATA SERIES
(C) ONLY ONE DATA SERIES
(D) NONE OF THE ABOVE
ANS(D)NONE OF THE ABOVE
30. TO CHANGE THE CELL REFERENCE C 4 : C 9 TO AN ABSOLUTE CELL REFERENCE YOU WOULD ENTER IT AS ?
(A) C 4 : C 9
(B)C $ 4 : C $ 9
(C) $ C $ 4 : $ C $ 9
(D) NONE OF THE ABOVE
ANS(C)$ C $ 4 : $ C $ 9
31. IF YOU NEED A TEXT TO SHOW VERTICALLY IN A CELL HOW WILL YOU ACHIEVE THIS?
(A) CHOOSE VERTICAL ON TEXT ALIGNMENT IN FORMAT CELLS DIALOG BOX
(B) CHOOSE 90 DEGREES IN ORIENTATION OF FORMAT CELLS DIALOG BOX
(C) CHOOSE DISTRIBUTED FROM THE VERTICAL DROP DOWN LIST OF FORM AT CELLS DIALOG BOX
(D) CHOOSE CENTER ACROSS SELECTION FROM HORIZONTAL COMBO BOX IN FORMAT CELLS DIALOG BOX
ANS(B)) CHOOSE 90 DEGREES IN ORIENTATION OF FORMAT CELLS DIALOG BOX
32. THE FORMULA IN CELL A 2 IS =B 2+C 3 ON COPYING THIS FORMULA IN CELL C 2 THE FORMULA WILL BE?
(a) = D 3+ E 4
(B) = D 2 + E 3
(C) = D 2 + E 4
(D) = D 3 + E 3
ANS.(B) = D 2 + E 3
33. WHAT DOES AN ELECTRONIC SPREAD SHEET CONSISTS OF?
(A) ROWS
(B) COLUMNS
(C) CELLS
(D)ALL OF THE ABOVE
ANS(D)ALL OF THE ABOVE
34. WHICH SOFTWARE IS USED TO STORE DATA IN TABULAR FORM AND PERFORM CALCULATIONS?
(A) SPREADSHEET
(B) DATA BASE
(C) WORD PROCESSING
(D) POWER POINT
ANS(A)SPREADSHEET
35. THE CELL ADDRESS $B$4 IN A FORMULA IN EXCEL MEANS IT IS A ?
(A) MIXED CELL REFERENCE
(B) ABSOLUTE CELL REFERENCE
(C) RELATIVE CELL REFERENCE
(D) ALL OF THE ABOVE
ANS. (B)ABSOLUTE CELL REFERENCE
36. = round (1363. 45,-2) returns?
(a) 1400
(b) -1364
(c) 1363.45
(d) 1464
ans. 1400
37. what is the intersection of a column and row on a worksheet called?
(a) column
(b) value
(c) address
(d) cell
ans. cell
38. a feature that displays only the data in column (s) according to specified criteria ?
(A) formula
(b) sorting
(C) filtering
(d) pivot
ans. filtering
39. which function in excel tells how many numeric entries are there?
(a)num
(b) count
(c) sum
(d) C H k N M U
ans. count
40. which one is not a function in ms excel?
(a) sum
(b) A V G
(c) MAX
(D)MIN
ans. A V G