questionbank.pdf

Microsoft Word 1. How many different positions can you set for drop cap? a. 1 b. 2 c. 4 d. 6 2. How many ways you can save a document? a. 3 b. 4 c. 5 d. 6 3. What is the maximum number of lines you can set for lines to drop box? a. 3 b. 5 c. 10 d. 15 4. Single spacing in MS-WO...

Microsoft Word 1. How many different positions can you set for drop cap? a. 1 b. 2 c. 4 d. 6 2. How many ways you can save a document? a. 3 b. 4 c. 5 d. 6 3. What is the maximum number of lines you can set for lines to drop box? a. 3 b. 5 c. 10 d. 15 4. Single spacing in MS-WORD document causes ____ point line spacing? a. 10 b. 12 c. 14 d. 16 5. What is the maximum number of lines you can set for a drop cap? a. 3 b. 10 c. 15 d. 20 6. How many columns can you insert in a word document in maximum? a. 35 b. 45 c. 55 d. 65 7. In a document what is the maximum number of columns that can be inserted in MS Word Table? a. 35 b. 15 c. 63 d. 65 8. What is the maximum scale percentage available in Scale drop down box? a. 500 b. 200 c. 100 d. 90 9. What is the maximum font size you can apply for any character a. 163 b. 1638 c. 16038 d. None of above 10. What is the default file extension for all Word documents? a..txts b..word c..docs d..docx 11. The file type _____ indicates the file is a Word document. a..msw b..wor c..wrd d..doc 12. How much space in minimum must be provided between columns? a. 0" b. 0.5" c. 1" d. 1.5" 13. What is the smallest width of a column? a. 0" b. 0.5" c. 1" d. 1.5" 14. By default, your document prints with: a. 1 inch top and bottom margins b. a portrait orientation c. 1.25 inches left and right margins d. all of the above 15. What is the default left margin in Word 2003 document? a. 1" b. 1.25" c. 1.5" d. 2" 16. What is the smallest and largest font size available in Font Size tool on formatting toolbar? a. 8 and 72 b. 8 and 64 c. 12 and 72 d. None of above 17. What is the default font size of a new Word document based on Normal template in Word 2003? a. 10 pt b. 12 pt c. 14 pt d. None of above 18. The minimum number of rows and columns in MS Word document is a. 1 and 1 b. 2 and 1 c. 2 and 2 d. None of above 19. How will MS Word will respond in repeated word. a. A Red wavy line under the repeated word b. A Green wavy line under the repeated word c. A Blue wavy line under the repeated word d. None of the above 20. Pressing F8 key for three times selects a. a word b. a sentence c. a paragraph d. entire document 21. What is a Document Outline View? a. A preview in a full screen b. A preview with margins c. A View with a margins and gutter d. A view with a structure of heading at various levels 22. Ctrl + Z a. Undo the last Action b. Redo the last Action c. Add the new page d. Paste the contents from clipboard 23. What does Ctrl + = key effect? a. Superscript b. Subscript c. All Caps d. Shadow 24. The word wrap reature a. Automatically move text to the next line when necessary b. Appears at the bottom of the document c. Allows you to type over text d. is the short horizontal line 25. How can you make the selected character superscripted a. Ctrl + = b. Ctrl + Shift + = c. Alt + Ctrl + Shift + = d. None of above 26. What is the short cut key to open the Open dialog box? a. F12 b. Shift F12 c. Alt + F12 d. Ctrl + F12 27. What is the shortcut key to split a table? a. Ctrl + Alt + Enter b. Ctrl + Shift + Enter c. Alt + Shift + Enter d. Alt + Space + Enter 28. Which key is used to increase left indent? a. Ctrl+I b. Ctrl+M c. Alt+I d. F10 29. How many different documents you can open at one time? a. No more than three b. Only one c. As many as your computer memory will hold d. As many as your taskbar can display 30. When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is: a. unassigned b. located on the ten-key pad section of your keyboard. c. assigned to another task. d. from the same font family as the symbol. 31. Which of the following command is not available in Tools menu? a. Auto text b. Autocorrect c. Auto summarize d. Macro 32. Word has a list of predefined typing, spelling, capitalization, and grammar errors that _____ can detect and correct. a. AutoEntry b. AutoCorrect c. AutoAdd d. AutoSpell 33. Which option is not available in Insert Table Autofit behavior? a. Fixed Column Width b. AutoFit to Contents c. Autofit to Window d. Autofit to Column 34. When you click on File menu in Word 2010, it opens a. File menu b. File Commands c. Backstage View d. File Ribbon 35. Why the document you created at home displays with a different font at school? a. Because you have a different printer at school than at home b. Because you have a different monitor at school than at home c. Because the font you used at home is not installed on your school computer d. Because the version of Windows is different 36. Ctrl + B a. Search the selected text b. Paste the selected text c. Bold the selected text d. Open the specified file 37. A feature of MS Word that saves the document automatically after certain interval is available on a. Save tab on Options dialog box b. Save As dialog box c. Both of above d. None of above 38. To move the cursor page to page of document a. Ctrl+PgDn b. Ctrl+PgUp c. Both of above d. None of above 39. You can jump to the next column by a. Clicking with your mouse on the next column b. Press Alt + Down-arrow c. Both of above d. None of Above 40. Which of the following enables you to paste data multiple times? a. Windows Clipboard b. Office Clipboard c. Both Windows & Office Clipboard d. None of the all 41. In Word you can force a page break a. By positioning your cursor at the appropriate place and pressing the F1 key b. By using the Insert/Section break on the Insert tab c. By positioning your cursor at the appropriate place and pressing Ctrl+Enter d. By changing the font size of your document 42. How can you increase the font size of selected text by one point every time? a. By pressing Ctrl + ] b. By pressing Ctrl + [ c. By pressing Ctrl + } d. By pressing Ctrl + { 43. What is the default font used in MS Word 2007 document? a. Times New Roman b. Arial c. Calibri d. Preeti 44. Word includes a series of predefined graphics called _____ that can be inserted into a Word document. a. clip art b. hyperlinks c. captions d. bookmarks 45. Which of the following is not a type of page margin? a. Left b. Right c. Center d. Top 46. 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? a. Both are same. They are only two different ways of capitalize text. b. It is faster to convert from Change Case than from Font dialog box c. Change Case makes conversion permanent but All Caps on Font can always be reverted d. All Caps on Font dialog box makes the change permanent where Change Case can be always reverted 47. Ctrl + A a. Align Right b. Select All c. Change font d. Save document 48. Ctrl + E a. Exit Application b. Select All c. Clear All d. Align Center 49. When inserting Page number in footer it appeared 1 but you wish to show a. How can you do that? a. From format menu choose bullets and Numbering and configure necessary setting b. From Insert menu choose Page Number and specify necessary setting c. Click on Page Number Format tool and specify required setting d. All of above 50. How do you close a word document without closing Word window? a. Click on the Close button on the title bar b. Click on Xminimize button on the title bar c. Click on the Close command on Office menu d. Click Exit on the File menu 51. Which would you choose to save a document with a new name? a. Press Ctrl+S b. Click File, Save c. Click Tools, Options, Save d. Click File, Save As 52. Ctrl + O a. Save Document b. Print Document c. Close Document d. Open Document 53. Which feature do you use to create a newspaper like document? a. Bullets & numbering b. Tables c. Columns d. Tab stops 54. A _____ contains buttons, boxes, and menus that allow tasks to be performed more quickly than using the menu bar. a. format bar b. status bar c. command bar d. toolbar 55. What is the shortcut key you can press to create a copyright symbol? a. Alt+Ctrl+C b. Alt + C c. Ctrl + C d. Ctrl + Shift + C 56. What is the short cut key to open Font dialog box? a. Ctrl + F b. Alt + Ctrl + F c. Ctrl + D d. Ctrl + Shift + D 57. What is the shortcut key to "Center Align" the selected text? a. Ctrl + C b. Ctrl + E c. Ctrl + F d. None of above 58. What is the shortcut key for Spelling Check in document? a. F7 b. Shift + F7 c. Ctrl + F7 d. Alt + F7 59. What is the shortcut key for "Font" dialog box? a. Ctrl + F b. Ctrl + D c. Ctrl + G d. None of the above 60. What is the shortcut key for "Find and Replace" dialog box? a. Ctrl + F b. Ctrl + R c. Ctrl + H d. Ctrl + Shift + F 61. What is the shortcut key to "Insert Hyperlink" in a document? a. Ctrl + H b. Ctrl + L c. Ctrl + K d. None of above 62. How can you access the font size tool on formatting toolbar? a. Ctrl + S b. Ctrl + Shift + S c. Ctrl + P d. Ctrl + Shift + P 63. What is the shortcut key for "Subscript" the selected text? a. Ctrl + = b. Ctrl + - c. Ctrl + Shift + = d. Ctrl + Shift + - 64. What is the shortcut key for "Superscript" the selected text? a. Ctrl + = b. Ctrl + - c. Ctrl + Shift + = d. Ctrl + Shift + - 65. What is the shortcut key to Close Active Document in Microsoft Word? a. Ctrl + F4 b. Shift + F4 c. Ctrl + Shift + F4 d. None of above 66. What is the shortcut key to show font dialog box? a. Ctrl + D b. Ctrl + Shift + F c. Ctrl + Shift + P d. All of the above 67. How to remove all character formats? a. Shift + Spacebar b. Shift + Enter c. Ctrl + Spacebar d. Ctrl + Enter 68. What is the shortcut key to "Undo" the last action in a document? a. Ctrl + X b. Ctrl + Y c. Ctrl + Z d. None of above  Microsoft Excel 1. Which of the following methods can not be used to enter data in a cell a. Pressing an arrow key b. Pressing the Tab key c. Pressing the Esc key d. Clicking on the formula bar 2. Which of the following will not cut information? a. Pressing Ctrl + C b. Selecting Edit>Cut from the menu c. Clicking the Cut button on the standard d. Pressing Ctrl+X 3. You can activate a cell by a. Pressing the Tab key b. Clicking the cell c. Pressing an arrow key d. All of the above 4. How do you insert a row? a. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu b. Select the row heading where you want to insert the new row and select Edit >Row from the menu c. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar d. All of the above 5. Which of the following is not a basic step in creating a worksheet? a. Save workbook b. Modifiy the worksheet c. Enter text and data d. Copy the worksheet 6. How do you select an entire column? a. Select Edit > Select > Column from the menu b. Click the column heading letter c. Hold down the shift key as you click anywhere in the column. d. Hold down the Ctrl key as you click anywhere in the column 7. How can you print three copies of a workbook? a. Select File>Properties form the menu and type 3 in the Copies to print text box. b. Select File >Print from the menu and type 3 in the Number of copies text box. c. Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made d. Press Ctrl+P+3 8. To create a formula, you first: a. Select the cell you want to place the formula into b. Type the equals sign (=) to tell Excel that you’re about to enter a formula c. Enter the formula using any input values and the appropriate mathematical operators that make up your formula d. Choose the new command from the file menu 9. To center worksheet titles across a range of cells, you must a. Select the cells containing the title text plus the range over which the title text is to be centered b. Widen the columns c. Select the cells containing the title text plus the range over which the title text is to be enfettered d. Format the cells with the comma style 10. How do you delete a column? a. Select the column heading you want to delete and select the Delete Row button on the standard toolbar b. Select the column heading you want to delete and select Insert Delete from the menu c. Select the row heading you want to delete and select Edit>Delete from the menu d. Right click the column heading you want to delet and select delete from the shortcut menu 11. When a label is too long to fit within a worksheet cell, you typically must a. Shorten the label b. Increase the column width c. Decrease the column width d. Adjust the row height 12. The name box a. Shows the location of the previously active cell b. Appears to the left of the formula bar c. Appears below the status bar d. Appears below the menu bar 13. Comments put in cells are called a. Smart tip b. Cell tip c. Web tip d. Soft tip 14. You can use the horizontal and vertical scroll bars to a. Split a worksheet into two panes b. View different rows and columns edit the contents of a cell c. Edit the contents of a cell d. view different worksheets 15. Hyperlinks can be a. Text b. Drawing objects c. Pictures d. All of above 16. Which button do you click to add up a series of numbers? a. The autosum button b. The Formula button c. The quicktotal button d. The total button 17. To copy formatting from one area in a worksheet and apply it to another area you would use: a. The Edit>Copy Format and Edit>Paste Format commands form the menu. b. The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu. c. There is no way to copy and apply formatting in Excel – You have to do it manually d. The Format Painter button on the standard toolbar 18. In a worksheet you can select a. The entire worksheet b. Rows c. Columns d. All of the above 19. Which area in an excel window allows entering values and formulas a. Title bar b. Menu bar c. Formula bar d. Standard toolbar 20. To create a formula, you can use: a. Values but not cell references b. C ell references but not values c. Values or cell references although not both at the same time d. Value and cell references 21. Which of the following is the oldest spreadsheet package? a. VisiCalc b. Lotus 1-2-3 c. Excel d. StarCalc 22. You can copy data or formulas a. With the copy, paste and cut commands on the edit menu b. With commands on ta shortcut menu c. With buttons on the standard toolbars d. All of the above 23. An excel workbook is a collection of a. Workbooks b. Worksheets c. Charts d. Worksheets and charts 24. Excel files have a default extension of a. Xls b. Xlw c. Wk1 d. 123 25. When you insert an excel file into a word document. The data are a. Hyperlinked placed in a word table b. Linked c. Embedded d. Use the word menu bar and toolbars 26. Each excel file is called a workbook because a. It can contain text and data b. It can be modified c. It can contain many sheets including worksheets and chart sheets d. You have to work hard to create it 27. Excel probably considers the cell entry January 1, 2000 to be a a. Label b. Value c. Formula d. Text string 28. You can enter which types of data into worksheet cells? a. Labels, values, and formulas b. Labe3ls and values but not formulas c. Values and formulas but not labels d. Formulas only 29. The Paste Special command lets you copy and paste: a. Multiply the selection by a copied value b. Cell comments c. Formatting options d. The resulting values of a formula instead of the actual formula 30. Which of the following is not a valid data type in excel a. Number b. Character c. Label d. Date/time 31. Which of the following options is not located in the Page Setup dialog box? a. Page Break Preview. b. Page Orientation c. Margins d. Headers and Footers 32. You want to track the progress of the stock market on a daily basis. Which type of chart should you use? a. Pie chart b. Row chart c. Line chart d. Column chart 33. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? a. Press Ctrl +Home b. Press Home c. Press Shift + Home d. Press Alt + Home 34. Which of the following methods can not be used to edit the contents of a cell? a. Press the Alt key b. Clicking the formula bar c. Pressing the F2 key d. Double clicking the cell 35. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you: a. Press the Erase key b. Press Esc c. Press the Enter button d. Press the Edit Formula button 36. To save a workbook, you: a. Click the save button on the standard toolbar from the menu b. Press Ctrl+F5 c. Click Save on the Windows Start button d. Select Edit>Save 37. You can edit a cell by a. Clicking the formula button b. Double clicking the cell to edit it in-place c. Selecting Edit>Edit Cell from the menu d. None of above 38. You can use the drag and drop method to a. Copy cell contents b. Move cell contents c. Add cell contents d. a and b 39. How can you delete a record? a. Delete the column from the worksheet b. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button c. Select Data > Delete Record from the menu d. Click the Delete button on the Standard toolbar 40. Right clicking something in Excel: a. Deletes the object b. Nothing the right mouse button is there for left handed people c. Opens a shortcut menu listing everything you can do to the object d. Selects the object 41. To copy cell contents using drag and drop press the a. End key b. Shift key c. Ctrl key d. Esc key 42. The autofill feature a. extends a sequential series of data b. automatically adds range of cell values c. applies a boarder around the selected cells d. none of the above 43. Which menu option can be sued to split windows into two a. Format > window b. View > window > split c. Window > split d. View > split 44. Which of the following is an absolute cell reference? a. !A!1 b. $A$1 c. #a#1 d. A1 45. Which symbol must all formula begin with? a. = b. + c. ( d. @ 46. Which of the following formulas is not entered correctly? a. =10+50 b. =B7*B1 c. =B7+14 d. 10+50 47. Which of the following formulas will Excel Not be able to calculate? a. =SUM(Sales)-A3 b. =SUM(A1:A5)*.5 c. =SUM(A1:A5)/(10-10) d. =SUM(A1:A5)-10 48. A typical worksheet has …. Number of columns a. 128 b. 256 c. 512 d. 1024 49. How many characters can be typed in a single cell in Excel? a. 256 b. 1024 c. 32000 d. 65535 50. A worksheet can have a maximum of …. Number of rows a. 256 b. 1024 c. 32000 d. 65535 51. Which of the following is not an example of a value? a. 350 b. May 10, 2001 c. 0.57 d. Serial Number 50771 52. Getting data from a cell located in a different sheet is called a. Accessing b. Referencing c. Updating d. Functioning 53. Tab scrolling button a. Allow you to view a different worksheet b. Allow you to view additional worksheet rows down c. Allow you to view additional worksheet columns to the right d. Allow you to view additional sheets tabs 54. You can zoom a worksheet a. With the mouse pointer in Print Preview b. With the zoom button on the Print Preview toolbar c. With the Zoom command on the view menu d. All of the above 55. This type of software is similar to an accountant’s worksheet a. Word processing b. Database c. Spreadsheets d. Graphics 56. The default header for a worksheet is a. Your name b. The date and time c. None d. The sheet tab name