citayctc

               

#1. The two major types of computer chips are

#2. Data Types available in Visual FoxPro are______

#3. Check the odd term out________

#4. Central Processing Unit is a Combination of______

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

#6. One can find "Autosum" option under________

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

#8. DBF' stands for________

#9. Ellipse Motion is a predefined _________

#10. Format Painter copy

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

#12. DropCap is used on ?

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

#14. In FoxPro, default date format is________

#15. 1 Nibble equals to______

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

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

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

#19. How do you select an entire column?

#20. Extension of Excel 2007 file________

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

#22. Which file starts MS Word?

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

#24. Copy and Xcopy are same in the sense________

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

#26. 'List' Command shows________

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

#28. The control unit of a microprocessor________

#29. Columns Dialog Box 2003 can be opened from________

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

#31. CTOD stands for _________

#32. Changing the appearance of a document is called______

#33. Endnote appears at________

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

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

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

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

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

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

#40. Autotext is under______

#41. Comments can be added to cells using________

#42. PowerPoint presentations are widely used as______

#43. Which was the computer conceived by Babbage?

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

#45. Databases store information in the form of________

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

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

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

#49. Computer is an______device

#50. For Sorting the data we use are________

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

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

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

#54. REPLACE command is used for________

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

#56. Extension of a Database table file is ________

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

#58. Default font size in MS word is________

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

#60. Memory Unit is a part of________

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

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

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

#64. To change the Date format to British type________

#65. UNIVAC is

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

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

#68. DropCap means________

#69. End Key is used to________

#70. To hide status bar command is________

#71. CD-ROM stands for______

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

#73. What is a motion path?

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

#75. To insert a hyperlink in a slide________

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

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

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

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

#80. How are data organized in a spreadsheet?

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

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

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

#84. Create command creates________

#85. Extension of a label file in FoxPro________

#86. The basic operations performed by a computer are

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

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

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

#90. You can edit a cell by______

#91. Closing a Database refers to which command?

#92. FoxPro is a Kind of________

#93. The selected design template can be applied________

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

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

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

#97. Default date format in visual FoxPro________

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

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

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

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

#102. Portrait and Landscape are________

#103. To open a particular database________

Finish

Results

Congratulations

Try

#1. Ctrl + O

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

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

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

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

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

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

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

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

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

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

#12. Ctrl + E

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

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

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

#16. What is a Document Outline View?

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

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

#19. The word wrap creature

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

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

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

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

#24. Ctrl + Z

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

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

#27. The spike

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

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

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

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

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

#33. What does Ctrl + = key effect?

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

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

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

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

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

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

#40. By default, your document prints with:

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

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

#43. You can jump to the next column by

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

#45. Pressing F8 key for three times selects

#46. In Word you can force a page break

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

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

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

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

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

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

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

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

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

#56. Tabs stop position cannot be the following alignment

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

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

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

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

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

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

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

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

#65. How to use Format Painter multiple times

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

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

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

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

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

#71. You cannot close MS Word application by

#72. Ctrl + B

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

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

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

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

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

#78. What does Ctrl + = key effect?

#79. Ctrl + A

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Finish

Results

Congratulations

Try

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

#2. You can activate a cell by

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

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

#5. The number of rows in a worksheet is

#6. To save a workbook, you:

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

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

#9. Excel files have a default extension of

#10. Rounding errors can occur

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

#12. Excel is a

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

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

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

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

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

#18. How do you delete a column?

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

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

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

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

#23. In a worksheet you can select

#24. Which symbol must all formula begin with?

#25. An excel workbook is a collection of

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

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

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

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

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

#31. Gridlines

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

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

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

#35. Comments can be added to cells using

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

#37. How can you delete a record?

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

#39. All worksheet formula

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

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

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

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

#44. You can use the formula palette to

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

#46. How do you select an entire column?

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

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

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

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

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

#52. Each excel file is called a workbook because

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

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

#55. Documentation should include

#56. The number of columns in a worksheet is

#57. You can print only an embedded chart by

#58. Comments put in cells are called

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

#60. You can edit a cell by

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

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

#63. The auto fill feature

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

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

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

#67. How are data organized in a spreadsheet?

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

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

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

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

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

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

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

#75. A circular reference is

#76. What does the VLOOKUP function do?

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

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

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

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

#81. Which types of charts can excel produce?

#82. The name box

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

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

#85. Hyperlinks can be

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

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

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

#89. How do you insert a row?

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

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

#92. The autofill feature

#93. Which function calculates your monthly mortgage payment?

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

#95. A worksheet range is a

#96. To view a cell comment

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

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

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

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

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

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

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

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

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

#106. Text formulas:

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

#108. Concatenation of text can be done using

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

#110. When you copy a formula

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

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

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

#114. Each excel file is called a workbook because

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

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

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

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

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

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

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

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

#123. The chart wizard term data series refers to

#124. you can use the formula palette to

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

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

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

#128. Tab scrolling button

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

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

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

#132. You can copy data or formulas

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

#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. Which of the following is a popular DOS based spreadsheet package?

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

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

#138. Status indicators are located on the

#139. To delete an embedded objects, first

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

#141. To create a formula, you first:

#142. How we can view a cell comment?

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

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

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

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

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

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

#149. The auto calculate feature

#150. Right clicking something in Excel:

Finish

Results

Congratulations

Try

#1. CPU speed of a personal computer is

#2. Registers which are partially visible to users and used to hold conditional codes (bits set by the CPU hardware as the result of operations), are known as

#3. Intel corporation produces chips for which computers?

#4. Which of the following is not electro-mechanical computer?

#5. Reading data is performed in magnetic disk by

#6. Which of the following is not a class based on size?

#7. IBM 1401 is

#8. Which of the following storage devices can store maximum amount of data?

#9. Fifth generation computer is also known as

#10. When was Apple Macintosh II microcomputer introduced in the market?

#11. The purpose of vacuum tube was to NOT act like

#12. Hard disk is coated in both side with

#13. A computer has very low failure rate because it uses electronic components. It produc