
#1. One can find "Merge & Center" option under________
#2. From which menu you can insert Header and Footer?
#3. Command used to copy data from a Visual FoxPro table to a file in a different format______
#4. In slide layout panel how many layouts are available for text layout by default?
#5. Command used to copy data from a Visual FoxPro table to a file in a different format.________
#6. 'Sorting' order relates to which of the following ?
#7. You can edit a cell by______
#8. Check the odd term out________
#9. What is a motion path?
#10. Central Processing Unit is a Combination of______
#11. Portrait and Landscape are________
#12. What PowerPoint feature will you use to apply motion effects to different objects of a slide?
#13. Default font size in MS word is________
#14. How many types of Tab are available in MS-Word?
#15. CTOD stands for _________
#16. Computer is an______device
#17. How many different positions can you set for Drop Cap?
#18. To hide status bar command is________
#19. How can you remove borders applied in cells?
#20. Which file starts MS Word?
#21. Default date format in visual FoxPro________
#22. How many types of Page Orientation are there in MS-Word?
#23. Excel uniquely identifies cells within a worksheet with a cell name________
#24. What happens when you click on Insert --> Clip Art?
#25. Copy and Xcopy are same in the sense________
#26. An Optical Input Device that interprets pencil marks on paper media is______
#27. To create A New Database With The Same Structure______
#28. DropCap means________
#29. Extension of a label file in FoxPro________
#30. PowerPoint presentations are widely used as______
#31. REPLACE command is used for________
#32. Maximum number of fields in a table can be______
#33. How does a reference to a range appear in the Consolidate dialog box?
#34. How do you rearrange the data in ascending or descending order?
#35. In Microsoft PowerPoint two kinds of sound effects files that can be added to the presentation are________
#36. Changing the appearance of a document is called______
#37. CD-ROM stands for______
#38. How many types of Paragraph Alignment are there in MS Word?
#39. FoxPro is a Kind of________
#40. Which command brings you to the first slide in your presentation?
#41. What feature will you use to apply motion effects in between a slide exits and another enters?
#42. To change the Date format to British type________
#43. Which of the following panes is NOT available in Task Pane?
#44. The control unit of a microprocessor________
#45. Predict the output of the following function: power(5,2)______
#46. A Billionth of a second is defined as a______
#47. One of the Important components of first generation computer was________
#48. Excel probably considers the cell entry January 1, 2000 to be a________
#49. Getting data from a cell located in a different sheet is called?
#50. Comments can be added to cells using________
#51. By Formatting a cell in Currency format, you can specify?
#52. To open a particular database________
#53. The Name box on to the left of formula bar______
#54. Autotext is under______
#55. Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?
#56. One can find "Autosum" option under________
#57. Which can be used for quick access to commonly used commands and tools?
#58. How many sheets are there in Excel Workbook by default?
#59. Databases store information in the form of________
#60. How many steps are there between Start and Finish in AutoContent Wizard?
#61. Columns Dialog Box 2003 can be opened from________
#62. Which was the computer conceived by Babbage?
#63. Format Painter copy
#64. To insert a hyperlink in a slide________
#65. How many ways you can save a document?
#66. Memory Unit is a part of________
#67. In FoxPro, default date format is________
#68. Data can be arranged in ascending or descending order by using________
#69. End Key is used to________
#70. A Computer-assisted method for the Recording and Analyzing of existing or Hypothetical Systems is______
#71. 1 Nibble equals to______
#72. How many Tabs are there in a Ribbon of MS Word?
#73. What is the term used when a clip art image changes the direction of faces?
#74. Endnote appears at________
#75. To see the listing of the output come in a different Window the command________
#76. Data Types available in Visual FoxPro are______
#77. 'List' Command shows________
#78. Create command creates________
#79. Extension of a Database table file is ________
#80. To want a PowerPoint photo album slide show to play continuously______
#81. In MS-Word, By default we get _________ number of Columns
#82. How are data organized in a spreadsheet?
#83. Ellipse Motion is a predefined _________
#84. To insert a Drop Cap in one of the paragraphs, you should access________
#85. How do you select an entire column?
#86. Command used to tag the current record for deletion______
#87. The slide that is used to introduce a topic and set the tone for the presentation is called the______
#88. For Sorting the data we use are________
#89. Objects on the slide that hold text are called________
#90. To select all of the boxes of an organization chart________
#91. How many data types are there in visual FoxPro?
#92. DropCap is used on ?
#93. The selected design template can be applied________
#94. How can the slide show be repeated continuously?
#95. Extension of Excel 2007 file________
#96. Closing a Database refers to which command?
#97. How many characters can be typed in a single cell in Excel?
#98. Getting data from a cell located in a different sheet is called ________
#99. DBF' stands for________
#100. Formatting a cell in Number format you can't set______
Finish
Results
Congratulations
Try
#1. If the number of columns is selected 1 and the line between check box is marked, where is the line drawn?
#2. What is the smallest width of a column?
#3. In mail merge operation which of the following might represent the main document?
#4. A _____ contains buttons, boxes, and menus that allow tasks to be performed more quickly than using the menu bar.
#5. To move the cursor page to page of document
#6. What is the shortcut key to “Insert Hyperlink” in a document?
#7. By default, your document prints with:
#8. What is the default font used in MS Word 2007 document?
#9. In Word you can force a page break
#10. How do you close a word document without closing Word window?
#11. Single spacing in MS-WORD document causes ____ point line spacing?
#12. Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.
#13. Tabs stop position cannot be the following alignment
#14. After typing header text, how can you quickly enter footer text?
#15. Which of the following is not on Home ribbon?
#16. You need to jump to the next column breaking current column right at the cursor position. How can you break column?
#17. In a document what is the maximum number of columns that can be inserted in MS Word Table?
#18. Which feature is used to replace straight quotes with smart quotes as you type?
#19. A feature of MS Word that saves the document automatically after certain interval is available on
#20. What is the smallest and largest font size available in Font Size tool on formatting toolbar?
#21. The file type _____ indicates the file is a Word document.
#22. When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:
#23. A master document contains_________, each of which contains a pointer to a file on a disk?
#24. How many ways you can save a document?
#25. Which enables you to move directly to specific location in a document?
#26. You cannot close MS Word application by
#27. Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.
#28. A (n) _____is a dot or other symbol positioned at the beginning of a paragraph.
#29. Ctrl + E
#30. Which of the following is not a type of page margin?
#31. Which option in File pull-down menu is used to close a file in MS Word?
#32. To convert a hyperlink e-mail address to regular text, right-click the e-mail address and then click _____ on the shortcut menu.
#33. Which of the following is the second step in creating a macro?
#34. Which of the following command is not available in Tools menu?
#35. The _____ in the Resume Wizard dialog box indicates the wizard is ready to create the document.
#36. What is the maximum number of lines you can set for lines to drop box?
#37. What does Ctrl + = key effect?
#38. To switch between insert mode and over type mode, _____.
#39. When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that?
#40. Word is preset to use standard 8.5-by-11-inch paper with _____ margins.
#41. Ctrl + A
#42. Ctrl + B
#43. The Footnote Text style defines characters as _____.
#44. When three hyphens, underscores, equal signs, asterisks, or number signs are typed and then the enter key is pressed, the Auto Format feature _____.
#45. What is the maximum scale percentage available in Scale drop down box?
#46. How many columns can you insert in a word document in maximum?
#47. What is the short cut key to open Font dialog box?
#48. What should you do if you require to paste the same format in many places?
#49. What is the shortcut key for Spelling Check in document?
#50. What is the shortcut key for “Subscript” the selected text?
#51. Which would you choose to save a document with a new name?
#52. A letterhead should contain all of the following EXCEPT ____.
#53. When you click on File menu in Word 2010, it opens
#54. Which option is not available in Insert Table Auto fit behavior?
#55. When typing in a word field manually, what must you press to insert the code’s braces?
#56. Pressing F8 key for three times selects
#57. The word wrap creature
#58. How to use Format Painter multiple times
#59. Which of the following enables you to paste data multiple times?
#60. What is the default font size of a new Word document based on Normal template in Word 2003?
#61. What is the shortcut key to “Center Align” the selected text?
#62. Which of the following option is not available in Insert >> Picture ?
#63. How much space in minimum must be provided between columns?
#64. Word, by default, places a tab stop at every _____ mark on the ruler.
#65. When a custom tab stop is set, Word _____.
#66. Uppercase on Change Case dialog box and All Caps on Fonts dialog box both converts selected text into Capital Letters. What’s the difference between the two?
#67. What is the shortcut key you can press to create a copyright symbol?
#68. What is the shortcut key for “Font” dialog box?
#69. How can you make the selected character super scripted
#70. With Word’s Auto Correct entries, to display an indifferent face ( ?? ) type _____.
#71. Word includes a series of predefined graphics called _____ that can be inserted into a Word document.
#72. Which of the following button will allow you to add, delete, or change records in your Data Source?
#73. The minimum number of rows and columns in MS Word document is
#74. Ctrl + O
#75. What does Ctrl + = key effect?
#76. The spike
#77. Which of the following is not available in Font Spacing?
#78. What is the maximum font size you can apply for any character
#79. What is the shortcut key for “Find and Replace” dialog box?
#80. How many different documents you can open at one time?
#81. Ctrl + Z
#82. What is the default file extension for all Word documents?
#83. How will MS Word will respond in repeated word.
#84. What is the shortcut key to Update Formula in a table?
#85. Which feature do you use to create a newspaper like document?
#86. What is the default left margin in Word 2003 document?
#87. What is a Document Outline View?
#88. Which key is used to increase left indent?
#89. Microsoft Office Word is a (n) _____.
#90. What is the short cut key to open the Open dialog box?
#91. What do you call ‘a collection of character and paragraph formatting commands’?
#92. What is the shortcut key to split a table?
#93. How can you access the font size tool on formatting toolbar?
#94. Why the document you created at home displays with a different font at school?
#95. You can jump to the next column by
#96. How many different positions can you set for drop cap?
#97. How can you increase the font size of selected text by one point every time?
Finish
#1. Which of the following is not an option in the spelling dialog box?
#2. Text formulas:
#3. Which of the following formulas is not entered correctly?
#4. Which of the following is not an example of a value?
#5. You can convert existing excel worksheet data an charts to an HTML document by using
#6. You can activate a cell by
#7. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
#8. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
#9. Macros are “run” or executed from the ….. Menu.
#10. The auto calculate feature
#11. On an excel sheet the active cell in indicated by ?
#12. How many characters can be typed in a single cell in Excel?
#13. Which of the following methods cannot be used to enter data in a cell?
#14. Which symbol must all formula begin with?
#15. To edit in an embedded excel worksheet object in a word document
#16. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
#17. When you want to insert a blank embedded excel object in a word document you can
#18. To copy cell contents using drag and drop press the
#19. A typical worksheet has …. Number of columns
#20. What symbol is used before a number to make it a label?
#21. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
#22. A numeric value can be treated as a label value if it precedes with
#23. You can use the drag and drop method to
#24. A circular reference is
#25. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
#26. Which of the following is a popular DOS based spreadsheet package?
#27. What is an expression that tells how the numbers in a determined set of cells are to be calculated?
#28. What Pivot Table toolbar button updates the data in a Pivot Table ?
#29. Which of the following is the oldest spreadsheet package?
#30. What does the VLOOKUP function do?
#31. Excel is a
#32. When a label is too long to fit within a worksheet cell, you typically must
#33. Hyperlinks can be
#34. Files created with Lotus 1-2-3 have an extension
#35. Getting data from a cell located in a different sheet is called
#36. Status indicators are located on the
#37. The name box
#38. It is acceptable to let long text flow into adjacent cells on a worksheet when
#39. You can edit existing Excel data by pressing the
#40. Which types of charts can excel produce?
#41. Each excel file is called a workbook because
#42. If you press …., the cell accepts your typing as its contents.
#43. Which of the following options is not located in the Page Setup dialog box?
#44. Which of the following methods cannot be used to enter data in a cell
#45. Rounding errors can occur
#46. When the formula bar is active, you can see
#47. Which of the following is an absolute cell reference?
#48. To create a formula, you can use:
#49. The number of rows in a worksheet is
#50. Which of the following will not set text in selected cells to italics?
#51. You can print only an embedded chart by
#52. You cannot link excel worksheet data to a word document
#53. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
#54. Which function calculates your monthly mortgage payment?
#55. “Qtr 1, Qtr 2, Qtr 3” is an example of a
#56. The number of columns in a worksheet is
#57. When you insert an excel file into a word document. The data are
#58. Which of these will not select all the cells in a document?
#59. You can use the horizontal and vertical scroll bars to
#60. To save a workbook, you:
#61. Which of the following methods cannot be used to edit the content of cell?
#62. Excel uniquely identifies cells within a worksheet with a cell name
#63. If you press ___, the cell accepts your typing as its contents?
#64. You can use the format painter multiple times before you turn it off by
#65. To activate the previous cell in a pre-selected range, press
#66. The Chart wizard term data categories refers to;
#67. The auto fill feature
#68. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
#69. Documentation should include
#70. Which of the following is not information you can specify using the solver?
#71. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
#72. Which of the following methods can not be used to edit the contents of a cell?
#73. Each excel file is called a workbook because
#74. A function inside another function is called a ….. Function.
#75. Which of the following will not cut information?
#76. A worksheet range is a
#77. Which button do you click to add up a series of numbers?
#78. Which menu option can be sued to split windows into two
#79. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result.
#80. How do you select an entire column?
#81. Comments put in cells are called
#82. When you link data maintained in an excel workbook to a word document
#83. Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?
#84. Tab scrolling button
#85. To center worksheet titles across a range of cells, you must
#86. You can edit a cell by
#87. Gridlines
#88. Data can be arranged in a worksheet in a easy to understand manner using
#89. To copy cell contents using drag and drop, press the
#90. In a worksheet you can select
#91. You can use the formula palette to
#92. How can you print three copies of a workbook?
#93. Which of the following is not a valid data type in excel
#94. Which of the following is not a basic step in creating a worksheet?
#95. How can you delete a record?
#96. To delete an embedded objects, first
#97. How do you delete a column?
#98. Right clicking something in Excel:
#99. To create a formula, you first:
#100. Which of the following is not a way to complete a cell entry?
#101. You can select a single range of cells by
#102. To view a cell comment
#103. Which area in an excel window allows entering values and formulas
#104. You can open the consolidate dialog box byte choosing Consolidate from the ….. Menu.
#105. You can enter which types of data into worksheet cells?
#106. When integrating Word and Excel, Word is usually the
#107. Which of the following is a correct order of precedence in formula calculation?
#108. Which of following is Not one of Excel’s what-if function?
#109. How are data organized in a spreadsheet?
#110. Comments can be added to cells using
#111. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
#112. Statistical calculations and preparation of tables and graphs can be done using
#113. Excel files have a default extension of
#114. How can you find specific information in a list?
#115. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
#116. A features that displays only the data in column (s) according to specified criteria
#117. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
#118. The Paste Special command lets you copy and paste:
#119. The autofill feature
#120. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
#121. With which of the following all formulas in excel starts?
#122. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
#123. Which of the following formulas will Excel Not be able to calculate?
#124. What term describes explanatory text attached to a cell?
#125. You can copy data or formulas
#126. Which of the following is the latest version of Excel
#127. What term describes a background that appears as a grainy, non smooth surface
#128. When you insert an Excel file into a Word document, the data are ______.
#129. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
#130. Which elements of worksheet can be protected from accidental modification
#131. Multiple calculations can be made in a single formula using
#132. An excel workbook is a collection of
#133. When you copy a formula
#134. Which of the following is a correct order of precedence in a formula calculation?
#135. Which of the following is not a worksheet design criterion?
#136. The default style for new data keyed in a new workbook is ?
#137. To copy formatting from one area in a worksheet and apply it to another area you would use:
#138. The chart wizard term data series refers to
#139. Excel probably considers the cell entry January 1, 2000 to be a
#140. What function displays row data in a column or column data in a row?
#141. you can use the formula palette to
#142. When integrating word and excel, word is usually the
#143. How do you insert a row?
#144. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
#145. Which of the following is not a worksheet design criterion?
#146. You can use drag-and-drop to embed excel worksheet data in a word document
#147. How we can view a cell comment?
#148. Which is used to perform what if analysis?
#149. All worksheet formula
#150. Concatenation of text can be done using
Finish
Results
Congratulations
Try