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

Share your score!
Tweet your score!

#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