ANWSER
Question1: From which menu can you insert Header and Footer?
Answer: A) Insert Menu
Question2: To get to the Symbol dialog box, click on the menu and choose Symbol.
Answer: A) Insert
Question3: Which option from clipboard is used to move data from one place to another in a document?
Answer: B) Cut & Paste
Question4: Which is an option in Font Group?
Answer: A) Strikethrough
Question5: Name the button in the picture?
Answer: D) Highlighter tool
Question6: Shortcut for document views toolbar is situated in ______ bar.
Answer: B) Status bar
Question7: Bullets and Numbering is in ______ tab.
Answer: A) Home tab
Question8: To open an existing document, click on the ______ and then select Open.
Answer: A) MS Office button
Question9: Cut, Copy and Paste is in ______ Group in the Home tab.
Answer: C) Clipboard
Question10: ______ is used to convert from upper case to lower case and vice versa.
Answer: A) Toggle case
Question11: Pressing F8 key for three times selects
Answer: B) A sentence
Question12: What is the shortcut key you can press to create a copyright symbol?
Answer: A) Alt+Ctrl+C
Question13: What is the smallest and largest font size available in Font Size tool on formatting toolbar?
Answer: A) 8 and 72
Question14: Which of the following is graphics solution for Word Processors?
Answer: D) All of above
Question15: The keystrokes Ctrl + I is used to
Answer: D) Applies italic format to selected text
Question16: A character that is raised and smaller above the baseline is known as
Answer: C) Superscript
Question17: Thesaurus tool in MS Word is used for
Answer: C) Synonyms and Antonyms words
Question18: Why Drop Caps are used in document?
Answer: C) To begin a paragraph with a large dropped initial capital letter
Question19: A bookmark is an item or location in document that you identify as a name for future reference. Which of the following task is accomplished by using bookmarks?
Answer: C) To quickly jump to specific location in document
Question20: Which of the following is not valid version of MS Office?
Answer: B) Office Vista
Question21: You cannot close MS Word application by
Answer: D) From File menu choose Close submenu
Question22: The key F12 opens a
Answer: A) Save As dialog box
Question23: What is the short cut key to open the Open dialog box?
Answer: D) Ctrl + F12
Question24: A feature of MS Word that saves the document automatically after certain interval is available on
Answer: A) Save tab on Options dialog box
Question25: Which of the following is not available on the Ruler of MS Word screen?
Answer: D) Center Indent
Question26: Which file starts MS Word?
Answer: A) Winword.exe
Question27: If you want to keep track of different editions of a document which features will you use?
Answer: B) Versions
Question28: Background color or effects applied on a document is not visible in
Answer: D) Print Preview
Question29: What is a portion of a document in which you set certain page formatting options?
Answer: C) Section
Question30: Borders can be applied to
Answer: D) All of above
Question31: Which of the following is not a type of page margin?
Answer: C) Center
Question32: What is the default left margin in Word 2003 document?
Answer: B) 1.25″
Question33: Portrait and Landscape are
Answer: A) Page Orientation
Question34: If you need to change the typeface of a document, which menu will you choose?
Answer: C) Format
Question35: Which of the following is not a font style?
Answer: D) Superscript
Question36: What happens when you click on Insert >> Picture >> Clip Art
Answer: C) It opens Clip Art taskbar
Question37: Which option is not available in Insert Table Autofit behavior?
Answer: D) Autofit to Column
Question38: To autofit the width of column
Answer: A) Double click the right border of column
Question39: Which of the following statement is false?
Answer: D) You can set different header and footer for last page of a section
Question40: Where can you change the vertical alignment?
Answer: C) Page Setup dialog box
Question41: AutoCorrect was originally designed to replace ______ words as you type.
Answer: C) Misspelled
Question42: Which of the following is the second step in creating a macro?
Answer: B) Using your mouse or keyboard, perform the task you want to automate
Question43: In Word, the mailing list is known as the ______.
Answer: C) Data source
Question44: Which of the following is not one of the three ‘Mail Merge Helper’ steps?
Answer: C) Set the mailing list parameters
Question45: Which of the following button will allow you to add, delete, or change records in your Data Source?
Answer: C) ‘Edit Data Source’ button
Question46: It is possible to ______ a data source before performing a merge.
Answer: D) all of the above
Question47: Comments can be added to cells using …..
Answer: B) Insert -> Comment
Question48: Which of the following is not a valid Zoom percentage in Excel?
Answer: D) 500
Question49: The spelling tool is placed on ______ toolbar
Answer: D) Reviewing
Question50: Which of the following is not a valid data type in Excel?
Answer: A) Number
Question51: Comments put in cells are called …..
Answer: B) Cell Tip
Question52: Which menu option can be used to split windows into two?
Answer: C) Window -> Split
Question53: You can activate a cell by
Answer: D) All of above
Question54: When you use the fill effects in the format data series dialog box, you can not
Answer: A) rotate text on the chart
Question55: To insert three columns between columns D and E you would
Answer: B) Select column E
Question56: Hyperlinks cannot be
Answer: D) All can be hyperlinks
Question57: You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Answer: D) Picture
Question58: To drag a selected range of data to another worksheet in the same workbook, use the
Answer: D) Ctrl key
Question59: When you print preview a worksheet
Answer: D) a, b and c
Question60: You can open the Sort dialog box by choosing Sort from the ….. menu
Answer: D) Data
Question61: When working in the page break preview, you can
Answer: D) all of above
Question62: Which of the following is not a valid Zoom percentage in Excel?
Answer: D) 500
Question63: The spelling tool is placed on ______ toolbar
Answer: A) Standard
Question64: Formatting a cell in Currency, you can specify
Answer: C) Both of above
Question65: What is entered by the function =today()
Answer: A) The date value for the day according to system clock
Question66: Which function will you use to enter current time in a worksheet cell?
Answer: B) =now()
Question67: Merge cells option can be applied from
Answer: A) Format Cells dialog box Alignment Tab
Question68: Which of the following format you can decide to apply or not in AutoFormat dialog box?
Answer: D) All of above
Question69: How can you remove borders applied in cells?
Answer: C) Both of above
Question70: You can set Page Border in Excel from
Answer: D) You can not set page border in Excel
Question71: You can check the conditions against ______ when applying conditional formatting
Answer: C) Both of above
Question72: When a range is selected, how can you activate the previous cell?
Answer: D) None of above
Question73: Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Answer: D) data sheet
Question74: Which of the following Excel screen components can NOT be turned on or off?
Answer: D) None of above
Question75: Which of the following option is not available in Paste Special dialog box?
Answer: D) SQRT
Question76: Which of the cell pointer indicates that you can fill series?
Answer: C) Mouse Pointer with anchor at the tip
Question77: Which of the following is an absolute cell reference?
Answer: b) $A$1
Question78: Which symbol must all formula begin with?
Answer: a) =
Question79: Which of the following formulas is not entered correctly?
Answer: d) 10+50
Question80: Which of the following formulas will Excel Not be able to calculate?
Answer: a) =SUM(Sales)-A3
Question81: A worksheet range is a
Answer: c) A group of cells
Question82: The auto calculate feature
Answer: b) Provides a quick way to view the result of an arithmetic operation on a range of cells
Question83: Excel uniquely identifies cells within a worksheet with a cell name
Answer: c) Column letters and row numbers
Question84: To drag a selected range of data to another worksheet in the same workbook, use the
Answer: d) Ctrl key
Question85: Hyperlinks can be
Answer: d) All of above
Question86: To activate the previous cell in a pre-selected range, press
Answer: d) None of the above
Question87: Which button do you click to add up a series of numbers?
Answer: a) The autosum button
Question88: When the formula bar is active, you can see
Answer: d) All of the above
Question89: In a worksheet you can select
Answer: d) All of the above
Question90: Which area in an excel window allows entering values and formulas
Answer: c) Formula bar
Question91: To edit in an embedded excel worksheet object in a word document
Answer: a) Use the excel menu bar and toolbars inside the word application
Question92: To create a formula, you can use:
Answer: d) Value and cell references
Question93: Status indicators are located on the
Answer: c) Formula bar
Question94: An excel workbook is a collection of
Answer: d) Worksheets and charts
Question95: Excel files have a default extension of
Answer: a) Xls
Question96: Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
Answer: a) IF
Question97: Macros are “run” or executed from the ….. menu.
Answer: c) Tools
Question98: You can open the consolidate dialog box by choosing Consolidate from the ….. menu.
Answer: d) Data
Question99: How are data organized in a spreadsheet?
Answer: c) Rows and columns
Question100: Gridlines
Answer: d) a, b and c
Question101: A function inside another function is called a ….. function.
Answer: a) Nested
Question102: Which function calculates your monthly mortgage payment?
Answer: a) PMT (payments)
Question103: To drag a selected range of data to another worksheet in the same workbook, use the
Answer: d) Ctrl key
Question104: When the formula bar is activated, you can see
Answer: d) All of above
Question105: Which file format can be added to a PowerPoint show?
Answer: d) All of the above
Question106: Material consisting of text and numbers is best presented as
Answer: a) A table slide
Question107: In order to edit a chart, you can
Answer: c) Double click the chart object
Question108: To exit the PowerPoint
Answer: c) double click the applications control menu icon
Question109: To select one hyperlink after another during a slide presentation, what do you press?
Answer: a) Tab
Question110: Special effects used to introduce slides in a presentation are called
Answer: c) transitions
Question111: What is the term used when you press and hold the left mouse key and move the mouse around the slide?
Answer: b) Dragging
Question112: To give a PowerPoint presentation to a large audience, you:
Answer: a) Set up your computer in a large auditorium, and click large, auditorium, OK
Question113: Which of the following can you use to add times to the slides in a presentation
Answer: b) Rehearse timing button
Question114: Which of the following is not one of PowerPoint’s views?
Answer: c) Presentation view
Question115: Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?
Answer: D) Slide Show Menu
Question116: In which menu can you find features like Slide Design, Slide Layout etc.?
Answer: B) Format Menu
Question117: The selected design template can be applied
Answer: D) All of above
Question118: What feature will you use to apply motion effects in between a slide exits and another enters?
Answer: A) Slide Transition
Question119: What PowerPoint feature will you use to apply motion effects to different objects of a slide?
Answer: D) Animation Scheme
Question120: Which command will you use in PowerPoint if you need to change the color of different objects without changing content?
Answer: B) Color Scheme
Question121: Which short cut key inserts a new slide in current presentation?
Answer: B) Ctrl+M
Question122: To start slide show of a presentation
Answer: D) Both a & b
Question123: If you select Insert >> Picture >> From File
Answer: C) You can insert pictures only
Question124: Which of the following font effect is not available in PowerPoint Font dialog box?
Answer: D) Strikethrough
Question125: To insert a hyperlink in a slide
Answer: D) Both a & b
Question126: In a PowerPoint presentation
Answer: D) Both can be inserted
Question127: To insert slide numbers
Answer: C) Choose Insert >> Slide Number
Question128: What are the three options available in Insert >> Picture menu?
Answer: C) Clipart, From Files, AutoShapes
Question129: From which menu you can access Picture, Text Box, Chart etc?
Answer: C) Insert
Question130: Which of the following is not a part of Slide Design?
Answer: D) Slide Layout
Question131: What is the term used when a clip art image changes the direction of faces?
Answer: c) Rotate
Question132: The slide that is used to introduce a topic and set the tone for the presentation is called the
Answer: d) title slide
Question133: Which of the following features should you use when typing in the notes text box?
Answer: d) Zoom
Question134: Which command brings you to the first slide in your presentation?
Answer: c) Ctrl + Home
Question135: You can show the shortcut menu during the slide show by
Answer: b) Right clicking the current slide
Question136: Auto clipart is a feature that
Answer: d) All of above
Question137: The view that displays the slides on a presentation as miniature representations of the slides is called
Answer: b) slide sorter view
Question138: Which of the following provides a printed copy of your presentation?
Answer: c) Audience handouts