MULTIPLE CHOICE QUESTIONS
A. Insert Menu
B. View Menu
C. Format menu
D. Tools Menu
Correct Answer: A
2. To get to the ‘Symbol’ dialog box, click on the ______ menu and choose ‘Symbol’.
A. Insert
B. Format
C. Tools
D. Table
Correct Answer: A
3. _______ option from clipboard is used to move data from one place to another in a document.
A. Copy & Paste
B. Cut & Paste
C. Bold
D. Justify
Correct Answer: B
4. ______ is an option in Font Group.
A.Strikethrough
B.Find
C.Replace
D. Change Styles
Correct Answer: A
5. Name the button in the picture?
A. Font Color
B. Fill Color
C. Page Color
D. Highlighter tool
Correct Answer: D
6. Shortcut for document views toolbar is situated in ______ bar.
A. Task bar
B. Status bar
C. Tool bar
D. Title bar
Correct Answer: B
7. Bullets and Numbering is in _____ tab.
A. Home tab
B. Insert tab
C. Pagelayout tab
D. View tab
Correct Answer: A
8. To open a existing document, click on the ________ and then select Open.
A. MS Office button
B. Quick Access Toolbar
C. Document Views
D. Ribbon
Correct Answer: A
9. Cut, Copy and Paste is in ________ Group in the Home tab.
A. Font
B. Page Setup
C. Clipboard
D. Editing
Correct Answer: C
10. _______ is used to covert from upper case to lower case and vice versa.
A. Toggle case
B. Sentence case
C. Lower case
D. Upper case
Correct Answer: A
11. Pressing F8 key for three times selects
A) A word
B) A sentence
C) A paragraph
D) Entire document
Correct Answer: B
12. What is the shortcut key you can press to create a copyright symbol?
A) Alt+Ctrl+C
B) Alt + C
C) Ctrl + C
D) Ctrl + Shift + C
Correct Answer: A
13. What is the smallest and largest font size available in Font Size tool on formatting toolbar?
A) 8 and 72
B) 8 and 64
C) 12 and 72
D) None of above
Correct Answer: A
14. Which of the following is graphics solution for Word Processors?
A) Clipart
B) WordArt
C) Drop Cap
D) All of above
Correct Answer: A
15. The keystrokes Ctrl + I is used to
A) Increase font size
B) Inserts a line break
C) Indicate the text should be bold
D) Applies italic format to selected text
Correct Answer: D
16. A character that is raised and smaller above the baseline is known as
A) Outlined
B) Raised
C) Superscript
D) Subscript
Correct Answer: C
17. Thesaurus tool in MS Word is used for
A) Spelling suggestions
B) Grammar options
C) Synonyms and Antonyms words
D) All of above
Correct Answer: C
18. Why Drop Caps are used in document?
A) To drop all the capital letters
B) To automatically begin each paragraph with capital letter
C) To begin a paragraph with a large dropped initial capital letter
D) None of above
Correct Answer: C
19. A bookmark is an item or location in document that you identify as a name for future reference. Which of the following task is accomplished by using bookmarks?
A) To add anchors in web page
B) To mark the ending of a paragraph of document
C) To quickly jump to specific location in document
D) To add hyperlinks in webpage
Correct Answer: C
20. Which of the following is not valid version of MS Office?
A) Office XP
B) Office Vista
C) Office 2007
D) None of above
Correct Answer: B
21. You cannot close MS Word application by
A) Choosing File menu then Exit submenu
B) Press Alt+F4
C) Click X button on title bar
D) From File menu choose Close submenu
Correct Answer: D
22. The key F12 opens a
A) Save As dialog box
B) Open dialog box
C) Save dialog box
D) Close dialog box
Correct Answer: A
23. What is the short cut key to open the Open dialog box?
A) F12
B) Shift F12
C) Alt + F12
D) Ctrl + F12
Correct Answer: D
24. . A feature of MS Word that saves the document automatically after certain interval is available on
A) Save tab on Options dialog box
B) Save As dialog box
C) Both of above
D) None of above
Correct Answer: A
25. Which of the following is not available on the Ruler of MS Word screen?
A) Tab stop box
B) Left Indent
C) Right Indent
D) Center Indent
E) All of them are available on ruler
Correct Answer: D
26. Which file starts MS Word?
A) Winword.exe
B) Word.exe
C) Msword.exe
D) Word2003.exe
Correct Answer: A
27. If you want to keep track of different editions of a document which features will you use?
A) Editions
B) Versions
C) Track Change
D) All of above
Correct Answer: B
28. 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
Correct Answer: D
29. What is a portion of a document in which you set certain page formatting options?
A) Page
B) Document
C) Section
D) Page Setup
Correct Answer: C
30. Borders can be applied to
A) Cells
B) Paragraph
C) Text
D) All of above
Correct Answer: D
31. Which of the following is not a type of page margin?
A) Left
B) Right
C) Center
D) Top
Correct Answer: C
32. What is the default left margin in Word 2003 document?
A) 1"
B) 1.25"
C) 1.5"
D) 2"
Correct Answer: B
33. Portrait and Landscape are
A) Page Orientation
B) Paper Size
C) Page Layout
D) All of above
Correct Answer: A
34. If you need to change the typeface of a document, which menu will you choose?
A) Edit
B) View
C) Format
D) Tools
Correct Answer: C
35. Which of the following is not a font style?
A) Bold
B) Italics
C) Regular
D) Superscript
Correct Answer: D
36. What happens when you click on Insert >> Picture >> Clip Art
A) It inserts a clipart picture into document
B) It lets you choose clipart to insert into document
C) It opens Clip Art taskbar
D) None of above
Correct Answer: C
37. Which option is not available in Insert Table Autofit behavior?
A) Fixed Column Width
B) AutoFit to Contents
C) Autofit to Window
D) Autofit to Column
Correct Answer: D
38. To autofit the width of column
A) Double click the right border of column
B) Double click the left border of column
C) Double click the column header
D) All of above
Correct Answer: A
39. Which of the following statement is false?
A) You can set different header footer for even and odd pages
B) You can set different page number formats for different sections
C) You can set different header footer for first page of a section
D) You can set different header and footer for last page of a section
Correct Answer: D
40. Where can you change the vertical alignment?
A) Formatting toolbar
B) Paragraph dialog box
C) Page Setup dialog box
D) Standard toolbar
Correct Answer: C
41. AutoCorrect was originally designed to replace _________ words as you type.
A) Short, repetitive
B) Grammatically incorrect
C) Misspelled
D) None of the above
Correct Answer: C
42. Which of the following is the second step in creating a macro?
A) Start recording
B) Using your mouse or keyboard, perform the task you want to automate
C) Assign a keyboard shortcut to the macro
D) Give the macro a name
Correct Answer: C
43. In Word, the mailing list is known as the ____________.
A) Data sheet
B) Source
C) Data source
D) Sheet
Correct Answer: C
44. Which of the following is not one of the three ‘Mail Merge Helper’ steps?
A) Merge the two files
B) Create the main document
C) Set the mailing list parameters
D) Create the data source
Correct Answer: C
45. Which of the following button will allow you to add, delete, or change records in your Data Source?
A) ‘Data Source’ button
B) ‘Edit’ button
C) ‘Edit Data Source’ button
D) ‘Data editing’ button
Correct Answer: C
46. It is possible to _______ a data source before performing a merge.
A) Create
B) Modify
C) Sort
D) all of the above
Correct Answer: D
47. Comments can be added to cells using …..
A. Edit -> Comments
B. Insert -> Comment
C. File -> Comments
D. View –> Comments
Correct Answer: B
48. Which of the following is not a valid Zoom percentage in Excel?
A) 10
B) 100
C) 300
D) 500
Correct Answer: D
49. The spelling tool is placed on ______ toolbar
A) Standard
B) Formatting
C) Drawing
D) Reviewing
Correct Answer: A
50. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
Correct Answer: B
51. Comments put in cells are called …..
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
Correct Answer: B
52. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View –> Split
Correct Answer: C
53. You can activate a cell by
a. Pressing the Tab key
b. Clicking the cell
c. Pressing an arrow key
d. All of above
Correct Answer: D
54. When you use the fill effects in the format data series dialog box, you can not
a. rotate text on the chart
b. select a fore ground color
c. select a pattern
d. select a background color
Correct Answer: A
55. To insert three columns between columns D and E you would
a. Select column D
b. Select column E
c. Select columns E, F and G
d. Select columns D, E, and F.
Correct Answer: B
56. Hyperlinks cannot be
a. Special shapes like stars and banners
b. Drawing objects like rectangles ovals
c. Pictures
d. All can be hyperlinks
Correct Answer: D
57. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
a. Standard
b. Formatting
c. Drawing
d. Picture
Correct Answer: D
58. To drag a selected range of data to another worksheet in the same workbook, use the
a. Tab key
b. Alt key
c. Shift key
d. Ctrl key
Correct Answer: D
59. When you print preview a worksheet
a. the entire worksheet is displayed
b. the selected range is displayed
c. the active portion of the worksheet is displayed
d. a, b and c
Correct Answer: D
60. You can open the Sort dialog box by choosing Sort from the ….. menu
a. View
b. Format
c. Tools
d. Data
Correct Answer: D
61. When working in the page break preview, you can
a. view exactly where each page break occurs b. add or remove page breaks
c. change the print area
d. all of above
Correct Answer: D
62. Which of the following is not a valid Zoom percentage in Excel?
A) 10
B) 100
C) 300
D) 500
Correct Answer: D
63. The spelling tool is placed on ______ toolbar
A) Standard
B) Formatting
C) Drawing
D) Reviewing
Correct Answer: A
64.Formatting a cell in Currency, you can specify
A) Decimal Places
B) Currency Symbol
C) Both of above
D) None of above
Correct Answer: C
64. Formatting a cell in Number format you can’t set
A) Decimal Places
B) Use 1000 separator
C) Negative numbers
D) Currency Symbol
Correct Answer: D
65. What is entered by the function =today()
A) The date value for the day according to system clock
B) The time value according to system clock
C) Today’s date as Text format
D) All of above
Correct Answer: A
66. Which function will you use to enter current time in a woksheet cell?
A) =today()
B) =now()
C) =time()
D) =currentTime()
Correct Answer: B
67. Merge cells option can be applied from
A) Format Cells dialog box Alignment Tab
B) Formatting toolbar
C) Both of above
D) None of above
Correct Answer: A
68. Which of the following format you can decide to apply or not in AutoFormat dialog box?
A) Number format
B) Border format
C) Font format
D) All of above
Correct Answer: D
69. How can you remove borders applied in cells?
A) Choose None on Border tab of Format cells
B) Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C) Both of above
D) None of above
Correct Answer: C
70. You can set Page Border in Excel from
A) From Border tab in Format Cells dialog box
B) From Border tool in Formatting toolbar
C) From Line Style tool in Drawing toolbar
D) You can not set page border in Excel
Correct Answer: D
71. You can check the conditions against __________ when applying conditional formatting
A) Cell value
B) Formula
C) Both of above
D) None of above
Correct Answer: C
72. When a range is selected, how can you activate the previous cell?
A) Press the Alt key
B) Press Tab
C) Press Enter
D) None of above
Correct Answer: D
73. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
A) work sheet
B) chart sheet
C) module sheet
D) data sheet
Correct Answer: D
74. Which of the following Excel screen components can NOT be turned on or off?
A) Formula Bar
B) Status Bar
C) Tool Bar
D) None of above
Correct Answer: D
75. Which of the following option is not available in Paste Special dialog box?
A) Add
B) Subtract
C) Divide
D) SQRT
Correct Answer: D
76. Which of the cell pointer indicates that you can fill series?
A) Doctor’s symbol (Big Plus)
B) small thin plus icon
C) Mouse Pointer with anchor at the tip
D) None of above
Correct Answer: C
77. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1
Correct Answer: B
78. Which symbol must all formula begin with?
a. =
b. +
c. (
d. @
Correct Answer: A
79. Which of the following formulas is not entered correctly?
a. =10+50
b. =B7*B1
c. =B7+14
d. 10+50
Correct Answer: D
80. Which of the following formulas will Excel Not be able to calculate?
a. =SUM(Sales)-A3
b. =SUM(A1:A5)*.5
c. =SUM(A1:A5)/(10-10)
d. =SUM(A1:A5)-10
Correct Answer: a
81. A worksheet range is a
a. A command used for data modeling
b. A range of values such as from 23 to 234
c. A group of cells
d. A group of worksheets
Correct Answer: C
82. The auto calculate feature
a. Can only add values in a range of cells
b. Provides a quick way to view the result of an arithmetic operation on a range of cells
c. Automatically creates formulas and adds them to a worksheet
d. A and c
Correct Answer: B
83. Excel uniquely identifies cells within a worksheet with a cell name
a. Cell names
b. Column numbers and row letters
c. Column letters and row numbers
d. Cell locator coordinates
Correct Answer: C
84. To drag a selected range of data to another worksheet in the same workbook, use the
a. Tab key
b. Alt key
c. Shift key
d. Ctrl key
Correct Answer: D
85. Hyperlinks can be
a. Text
b. Drawing objects
c. Pictures
d. All of above
Correct Answer: D
86. To activate the previous cell in a pre-selected range, press
a. The Alt key
b. The Tab key
c. The Enter key
d. None of the above
Correct Answer: d
87. Which button do you click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
Correct Answer: a
88. When the formula bar is active, you can see
a. The edit formula button
b. The cancel button
c. The enter button
d. All of the above
Correct Answer: d
89. In a worksheet you can select
a. The entire worksheet
b. Rows
c. Columns
d. All of the above
Correct Answer: b
90. Which area in an excel window allows entering values and formulas
a. Title bar
b. Menu bar
c. Formula bar
d. Standard toolbar
Correct Answer: c
91. To edit in an embedded excel worksheet object in a word document
a. Use the excel menu bar and toolbars inside the word application
b. Edit the hyperlink
c. Edit the data in a excel source application
d. Use the word menu bar and toolbars
Correct Answer: a
92. To create a formula, you can use:
a. Values but not cell references
b. C ell references but not values
c. Values or cell references although not both at the same time
d. Value and cell references
Correct Answer: d
93. Status indicators are located on the
a. Vertical scroll bar
b. Horizontal scroll bar
c. Formula bar
d. Standard toolbar
Correct Answer: c
94. An excel workbook is a collection of
a. Workbooks
b. Worksheets
c. Charts
d. Worksheets and charts
Correct Answer: d
95. Excel files have a default extension of
a. Xls
b. Xlw
c. Wk1
d. 123
Correct Answer: a
96. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
a. IF
b. AND
c. OR
d. NOT
Correct Answer: a
97. Macros are “run” or executed from the ….. menu.
a. Insert
b. Frmat
c. Tools
d. Data
Correct Answer: c
98. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
a. Insert
b. Format
c. Tools
d. Data
Correct Answer: d
99. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
Correct Answer: c
100. Gridlines
a. May be turned off for display but turned on for printing
b. May be turned on or off for printing
c. The be turned off for display and printing
d. a, b and c
Correct Answer: d