citayctc

               

#1. CTOD stands for _________

#2. How many ways you can save a document?

#3. How are data organized in a spreadsheet?

#4. Extension of a Database table file is ________

#5. CD-ROM stands for______

#6. The slide that is used to introduce a topic and set the tone for the presentation is called the______

#7. Data can be arranged in ascending or descending order by using________

#8. Formatting a cell in Number format you can't set______

#9. Comments can be added to cells using________

#10. One can find "Merge & Center" option under________

#11. One of the Important components of first generation computer was________

#12. How many steps are there between Start and Finish in AutoContent Wizard?

#13. To change the Date format to British type________

#14. REPLACE command is used for________

#15. To create A New Database With The Same Structure______

#16. How many types of Page Orientation are there in MS-Word?

#17. Which of the following panes is NOT available in Task Pane?

#18. Closing a Database refers to which command?

#19. Endnote appears at________

#20. Default date format in visual FoxPro________

#21. DBF' stands for________

#22. In Microsoft PowerPoint two kinds of sound effects files that can be added to the presentation are________

#23. What is the term used when a clip art image changes the direction of faces?

#24. What feature will you use to apply motion effects in between a slide exits and another enters?

#25. Computer is an______device

#26. Databases store information in the form of________

#27. A Billionth of a second is defined as a______

#28. Portrait and Landscape are________

#29. How many different positions can you set for Drop Cap?

#30. What happens when you click on Insert --> Clip Art?

#31. 1 Nibble equals to______

#32. How many Tabs are there in a Ribbon of MS Word?

#33. Ellipse Motion is a predefined _________

#34. Create command creates________

#35. In slide layout panel how many layouts are available for text layout by default?

#36. How many types of Paragraph Alignment are there in MS Word?

#37. You can edit a cell by______

#38. How many sheets are there in Excel Workbook by default?

#39. The Name box on to the left of formula bar______

#40. Command used to tag the current record for deletion______

#41. How do you rearrange the data in ascending or descending order?

#42. Default font size in MS word is________

#43. How many types of Tab are available in MS-Word?

#44. The control unit of a microprocessor________

#45. DropCap is used on ?

#46. Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?

#47. One can find "Autosum" option under________

#48. End Key is used to________

#49. From which menu you can insert Header and Footer?

#50. Getting data from a cell located in a different sheet is called ________

#51. To insert a Drop Cap in one of the paragraphs, you should access________

#52. Changing the appearance of a document is called______

#53. To see the listing of the output come in a different Window the command________

#54. Getting data from a cell located in a different sheet is called?

#55. In MS-Word, By default we get _________ number of Columns

#56. Maximum number of fields in a table can be______

#57. For Sorting the data we use are________

#58. How many characters can be typed in a single cell in Excel?

#59. PowerPoint presentations are widely used as______

#60. Excel probably considers the cell entry January 1, 2000 to be a________

#61. Columns Dialog Box 2003 can be opened from________

#62. Predict the output of the following function: power(5,2)______

#63. To insert a hyperlink in a slide________

#64. What PowerPoint feature will you use to apply motion effects to different objects of a slide?

#65. Autotext is under______

#66. Memory Unit is a part of________

#67. Objects on the slide that hold text are called________

#68. Data Types available in Visual FoxPro are______

#69. Which was the computer conceived by Babbage?

#70. Central Processing Unit is a Combination of______

#71. 'Sorting' order relates to which of the following ?

#72. Format Painter copy

#73. How can you remove borders applied in cells?

#74. Check the odd term out________

#75. Command used to copy data from a Visual FoxPro table to a file in a different format______

#76. Extension of a label file in FoxPro________

#77. A Computer-assisted method for the Recording and Analyzing of existing or Hypothetical Systems is______

#78. Which can be used for quick access to commonly used commands and tools?

#79. Extension of Excel 2007 file________

#80. An Optical Input Device that interprets pencil marks on paper media is______

#81. How can the slide show be repeated continuously?

#82. How do you select an entire column?

#83. How many data types are there in visual FoxPro?

#84. How does a reference to a range appear in the Consolidate dialog box?

#85. Excel uniquely identifies cells within a worksheet with a cell name________

#86. Command used to copy data from a Visual FoxPro table to a file in a different format.________

#87. What is a motion path?

#88. By Formatting a cell in Currency format, you can specify?

#89. Which command brings you to the first slide in your presentation?

#90. In FoxPro, default date format is________

#91. To want a PowerPoint photo album slide show to play continuously______

#92. The selected design template can be applied________

#93. Copy and Xcopy are same in the sense________

#94. Which file starts MS Word?

#95. To open a particular database________

#96. DropCap means________

#97. FoxPro is a Kind of________

#98. 'List' Command shows________

#99. To hide status bar command is________

#100. To select all of the boxes of an organization chart________

finish

Results

Congratulations

Try

#1. In mail merge operation which of the following might represent the main document?

#2. What is the smallest width of a column?

#3. Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct.

#4. The _____ in the Resume Wizard dialog box indicates the wizard is ready to create the document.

#5. How many different positions can you set for drop cap?

#6. Which option in File pull-down menu is used to close a file in MS Word?

#7. By default, your document prints with:

#8. Which of the following is the second step in creating a macro?

#9. How can you increase the font size of selected text by one point every time?

#10. The word wrap creature

#11. Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.

#12. How many columns can you insert in a word document in maximum?

#13. What is the shortcut key for Spelling Check in document?

#14. When you click on File menu in Word 2010, it opens

#15. Ctrl + O

#16. Pressing F8 key for three times selects

#17. You need to jump to the next column breaking current column right at the cursor position. How can you break column?

#18. To move the cursor page to page of document

#19. Which of the following enables you to paste data multiple times?

#20. How can you access the font size tool on formatting toolbar?

#21. What does Ctrl + = key effect?

#22. When typing in a word field manually, what must you press to insert the code’s braces?

#23. How do you close a word document without closing Word window?

#24. What is the default font used in MS Word 2007 document?

#25. What is the short cut key to open the Open dialog box?

#26. A master document contains_________, each of which contains a pointer to a file on a disk?

#27. Ctrl + Z

#28. How can you make the selected character super scripted

#29. To switch between insert mode and over type mode, _____.

#30. Microsoft Office Word is a (n) _____.

#31. Which enables you to move directly to specific location in a document?

#32. In Word you can force a page break

#33. Ctrl + A

#34. The minimum number of rows and columns in MS Word document is

#35. Word is preset to use standard 8.5-by-11-inch paper with _____ margins.

#36. What is the maximum font size you can apply for any character

#37. Tabs stop position cannot be the following alignment

#38. With Word’s Auto Correct entries, to display an indifferent face ( ?? ) type _____.

#39. What is the shortcut key to “Insert Hyperlink” in a document?

#40. A feature of MS Word that saves the document automatically after certain interval is available on

#41. Which option is not available in Insert Table Auto fit behavior?

#42. What is the maximum number of lines you can set for lines to drop box?

#43. What does Ctrl + = key effect?

#44. A _____ contains buttons, boxes, and menus that allow tasks to be performed more quickly than using the menu bar.

#45. What is the default file extension for all Word documents?

#46. How to use Format Painter multiple times

#47. Which feature is used to replace straight quotes with smart quotes as you type?

#48. How many ways you can save a document?

#49. Ctrl + E

#50. What is the shortcut key to split a table?

#51. You cannot close MS Word application by

#52. What is the default left margin in Word 2003 document?

#53. When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:

#54. Which feature do you use to create a newspaper like document?

#55. Why the document you created at home displays with a different font at school?

#56. How will MS Word will respond in repeated word.

#57. In a document what is the maximum number of columns that can be inserted in MS Word Table?

#58. What is the shortcut key you can press to create a copyright symbol?

#59. What is the shortcut key for “Font” dialog box?

#60. When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that?

#61. What is the maximum scale percentage available in Scale drop down box?

#62. When a custom tab stop is set, Word _____.

#63. What is the shortcut key to “Center Align” the selected text?

#64. What is the shortcut key for “Find and Replace” dialog box?

#65. Which would you choose to save a document with a new name?

#66. What is the smallest and largest font size available in Font Size tool on formatting toolbar?

#67. How much space in minimum must be provided between columns?

#68. A letterhead should contain all of the following EXCEPT ____.

#69. What is the short cut key to open Font dialog box?

#70. Single spacing in MS-WORD document causes ____ point line spacing?

#71. Word includes a series of predefined graphics called _____ that can be inserted into a Word document.

#72. After typing header text, how can you quickly enter footer text?

#73. When three hyphens, underscores, equal signs, asterisks, or number signs are typed and then the enter key is pressed, the Auto Format feature _____.

#74. What is the default font size of a new Word document based on Normal template in Word 2003?

#75. Which of the following option is not available in Insert >> Picture ?

#76. Which of the following is not on Home ribbon?

#77. The Footnote Text style defines characters as _____.

#78. What is a Document Outline View?

#79. The spike

#80. The file type _____ indicates the file is a Word document.

#81. Which of the following button will allow you to add, delete, or change records in your Data Source?

#82. A (n) _____is a dot or other symbol positioned at the beginning of a paragraph.

#83. What is the shortcut key to Update Formula in a table?

#84. Ctrl + B

#85. If the number of columns is selected 1 and the line between check box is marked, where is the line drawn?

#86. What do you call ‘a collection of character and paragraph formatting commands’?

#87. To convert a hyperlink e-mail address to regular text, right-click the e-mail address and then click _____ on the shortcut menu.

#88. What is the shortcut key for “Subscript” the selected text?

#89. Which of the following is not a type of page margin?

#90. Which key is used to increase left indent?

#91. Which of the following command is not available in Tools menu?

#92. Word, by default, places a tab stop at every _____ mark on the ruler.

#93. What should you do if you require to paste the same format in many places?

#94. How many different documents you can open at one time?

#95. You can jump to the next column by

#96. Which of the following is not available in Font Spacing?

#97. 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?

finish

Results

Congratulations

Try

#1. To copy cell contents using drag and drop press the

#2. A function inside another function is called a ….. Function.

#3. Which of the following will not set text in selected cells to italics?

#4. Which of following is Not one of Excel’s what-if function?

#5. The chart wizard term data series refers to

#6. You can convert existing excel worksheet data an charts to an HTML document by using

#7. To view a cell comment

#8. The default style for new data keyed in a new workbook is ?

#9. The autofill feature

#10. You can copy data or formulas

#11. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

#12. When integrating Word and Excel, Word is usually the

#13. Which of the following formulas is not entered correctly?

#14. you can use the formula palette to

#15. To center worksheet titles across a range of cells, you must

#16. Which of the following is a popular DOS based spreadsheet package?

#17. The auto fill feature

#18. You can enter which types of data into worksheet cells?

#19. To activate the previous cell in a pre-selected range, press

#20. The Chart wizard term data categories refers to;

#21. You can select a single range of cells by

#22. You can activate a cell by

#23. Excel uniquely identifies cells within a worksheet with a cell name

#24. An excel workbook is a collection of

#25. Right clicking something in Excel:

#26. How can you delete a record?

#27. Files created with Lotus 1-2-3 have an extension

#28. You can edit existing Excel data by pressing the

#29. When you link data maintained in an excel workbook to a word document

#30. Each excel file is called a workbook because

#31. Which area in an excel window allows entering values and formulas

#32. On an excel sheet the active cell in indicated by ?

#33. If you press ___, the cell accepts your typing as its contents?

#34. Excel is a

#35. Which of the following formulas will Excel Not be able to calculate?

#36. How do you delete a column?

#37. You can use the drag and drop method to

#38. The number of rows in a worksheet is

#39. What does the VLOOKUP function do?

#40. Which of the following is a correct order of precedence in a formula calculation?

#41. Which of the following is the oldest spreadsheet package?

#42. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

#43. Getting data from a cell located in a different sheet is called

#44. A numeric value can be treated as a label value if it precedes with

#45. The auto calculate feature

#46. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu

#47. When you copy a formula

#48. Documentation should include

#49. Which of these will not select all the cells in a document?

#50. To create a formula, you can use:

#51. Which menu option can be sued to split windows into two

#52. Which of the following is not an example of a value?

#53. Your German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

#54. Which of the following is not information you can specify using the solver?

#55. You can edit a cell by

#56. “Qtr 1, Qtr 2, Qtr 3” is an example of a

#57. The name box

#58. Text formulas:

#59. You can use the horizontal and vertical scroll bars to

#60. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result.

#61. What term describes a background that appears as a grainy, non smooth surface

#62. You can print only an embedded chart by

#63. To create a formula, you first:

#64. Excel files have a default extension of

#65. When integrating word and excel, word is usually the

#66. When you insert an Excel file into a Word document, the data are ______.

#67. What Pivot Table toolbar button updates the data in a Pivot Table ?

#68. To copy formatting from one area in a worksheet and apply it to another area you would use:

#69. Status indicators are located on the

#70. Which of the following is a correct order of precedence in formula calculation?

#71. You can use the formula palette to

#72. You cannot link excel worksheet data to a word document

#73. A features that displays only the data in column (s) according to specified criteria

#74. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

#75. Which of the following methods can not be used to edit the contents of a cell?

#76. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

#77. Which elements of worksheet can be protected from accidental modification

#78. A worksheet range is a

#79. How are data organized in a spreadsheet?

#80. When you want to insert a blank embedded excel object in a word document you can

#81. All worksheet formula

#82. What symbol is used before a number to make it a label?

#83. To copy cell contents using drag and drop, press the

#84. It is acceptable to let long text flow into adjacent cells on a worksheet when

#85. How many characters can be typed in a single cell in Excel?

#86. To save a workbook, you:

#87. What function displays row data in a column or column data in a row?

#88. Which of the following options is not located in the Page Setup dialog box?

#89. The Paste Special command lets you copy and paste:

#90. How do you insert a row?

#91. Gridlines

#92. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

#93. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

#94. Excel probably considers the cell entry January 1, 2000 to be a

#95. How do you select an entire column?

#96. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

#97. When you insert an excel file into a word document. The data are

#98. 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 ….

#99. What term describes explanatory text attached to a cell?

#100. How can you print three copies of a workbook?

#101. You can open the consolidate dialog box byte choosing Consolidate from the ….. Menu.

#102. Which of the following is not a worksheet design criterion?

#103. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

#104. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

#105. When a label is too long to fit within a worksheet cell, you typically must

#106. To edit in an embedded excel worksheet object in a word document

#107. Each excel file is called a workbook because

#108. Which symbol must all formula begin with?

#109. You can use the format painter multiple times before you turn it off by

#110. Which is used to perform what if analysis?

#111. Which of the following is not a way to complete a cell entry?

#112. With which of the following all formulas in excel starts?

#113. Statistical calculations and preparation of tables and graphs can be done using

#114. When the formula bar is active, you can see

#115. Which of the following methods cannot be used to enter data in a cell?

#116. Comments put in cells are called

#117. Which of the following is not a valid data type in excel

#118. Macros are “run” or executed from the ….. Menu.

#119. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

#120. Which of the following methods cannot be used to edit the content of cell?

#121. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu

#122. Which types of charts can excel produce?

#123. How can you find specific information in a list?

#124. Tab scrolling button

#125. Which button do you click to add up a series of numbers?

#126. You can use drag-and-drop to embed excel worksheet data in a word document

#127. A circular reference is

#128. Multiple calculations can be made in a single formula using

#129. A typical worksheet has …. Number of columns

#130. Which of the following is the latest version of Excel

#131. Comments can be added to cells using

#132. To delete an embedded objects, first

#133. How we can view a cell comment?

#134. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

#135. The number of columns in a worksheet is

#136. In a worksheet you can select

#137. Which of the following is an absolute cell reference?

#138. Which of the following will not cut information?

#139. Which of the following is not a basic step in creating a worksheet?

#140. Hyperlinks can be

#141. Which of the following methods cannot be used to enter data in a cell

#142. Data can be arranged in a worksheet in a easy to understand manner using

#143. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

#144. What is an expression that tells how the numbers in a determined set of cells are to be calculated?

#145. Which of the following is not an option in the spelling dialog box?

#146. Concatenation of text can be done using

#147. Which of the following is not a worksheet design criterion?

#148. If you press …., the cell accepts your typing as its contents.

#149. Which function calculates your monthly mortgage payment?

#150. Rounding errors can occur

finish

Results

Congratulations

Try