citayctc

               

#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

Results

Congratulations

Try

#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