PPSC Microsoft Office Grand Quiz Mock Test 10 A.J. Bhatti October 21, 2020 Welcome to your PPSC Microsoft Office Grand Quiz Mock Test 10 Name Email Microsoft Office is (A) Desktop applications (B) Operating system (C) Command window (D) None of these 2. Microsoft Office is an office suite, for the (A) Microsoft Windows operating systems (B) Mac OS X operating systems (C) Both A and B are true (D) None is true 3. Microsoft Word, Microsoft Excel, and Microsoft PowerPoint are the part of (A) Microsoft Office Suite (B) Microsoft Windows (C) Mac OS X (D) None of these 4. The very first version of Microsoft Office was released for (A) Windows operating system (B) Apple Macintosh OS (C) Unix (D) None of these 5. The first version of MS Office to be released for the Microsoft Windows operating system is (A) Microsoft Office 3.0 (B) Microsoft Office 2003 (C) Microsoft Office 2007 (D) Microsoft Office XP 6. The word processor in MS office suite is (A) Microsoft Word (B) Microsoft Excel (C) Microsoft PowerPoint (D) None of these 7. Microsoft Word is a word processor that saves in its proprietary————format. (A) .doc (B) .pdf (C) .txt (D) None of these 8. Microsoft Office Suite spreadsheet program is (A) Microsoft Excel (B) Microsoft Word (C) Microsoft Powerpoint (D) None of these 9. A competitor to the dominant Lotus 1-2-3 is (A) Microsoft Excel (B) Microsoft Word (C) Microsoft PowerPoint (D) None of these 10. A personal information manager and e-mail communication software in MS Office is (A) Microsoft Outlook (B) Microsoft Word (C) Microsoft PowerPoint (D) None of these 11. A popular presentation program for Windows and Mac in Microsoft Office is (A) Microsoft Word (B) Microsoft PowerPoint (C) Microsoft Access (D) None of these 12. To create slideshows, composed of text, graphics, movies and other objects, which can be displayed on-screen and navigated through by the presenter or printed out on transparencies or slides one uses (A) Microsoft Word (B) Microsoft PowerPoint (C) Microsoft Access (D) None of these 13. For Database management one uses (A) Microsoft Access (B) Microsoft PowerPoint (C) Microsoft Access (D) None of these 14. It is software for creating newsletters, business cards, flyers, greeting cards or postcards. (A) Microsoft Publisher (B) Microsoft PowerPoint (C) Microsoft Access (D) None of these 15. It is a Note-taking software for use with tablet PCs or regular PCs. (A) Microsoft OneNote (B) Microsoft PowerPoint (C) Microsoft Access (D) None of these 16. Microsoft Office SharePoint Designer is used for (A) A WYSIWYG HTML editor and web design program for customizing SharePoint applications, it replaces Microsoft Office FrontPage (B) Project management software to keep track of events and to create network charts and Gantt charts (C) Diagram and flowcharting software (D) None of these 17. Microsoft Project is (A) A WYSIWYG HTML editor and web design program for customizing Share Point applications, it replaces Microsoft Office FrontPage (B) Project management software to keep track of events and to create network charts and Gantt charts (C) Diagram and flowcharting software (D) None of these 18. Microsoft Visio is a (A) A WYSIWYG HTML editor and web design program for customizing SharePoint applications, it replaces Microsoft Office FrontPage (B) Project management software to keep track of events and to create network charts and Gantt charts (C) Diagram and flowcharting software (D) None of these 19. Microsoft Office Accounting is (A) A tool for managing business finances (B) Project management software to keep track of events and to create network charts and Gantt charts (C) Diagram and flowcharting software (D) None of these 20. Microsoft Office Communicator is (A) Integrated communications client for conferences and meetings in real time (B) Project management software to keep track of events and to create network charts and Gantt charts (C) Diagram and flowcharting software (D) None of these 1. In Microsoft Word to cut something the following shortcut is used (A) CTRL+C (B) CTRL+X (C) CTRL+V (D) None of these In Microsoft Word shortcut CTRL+Z is for (A) Undo something (B) Delete something (C) Paste something (D) None of these 3. In Microsoft Word shortcut DELETE is for (A) Undo something (B) Delete something (C) Paste something (D) None of these 4. A program which helps to create written document and lets you go back and make corrections as necessary (A) Home row keys (B) Tool bar (C) Spreadsheet (D) Word processor 5. Graphics for word processor (A) Peripheral (B) Clip art (C) Highlight (D) Execute 6. What type of software is used for creating letters papers and other documents? (A) Database (B) Word Processor (C) Spreadsheet (D) Operating Program 7. What does the Ctrl + I shortcut key accomplish in Ms-Word? (A) It converts selected text into the next larger size of the same font (B) It adds a line break to the document (C) It makes the selected text bold (D) It applies Italic formatting t the selected text. 8. What is the file extension of Ms-Word972003 document? (A) Dot (B) Doc (C) Dom (D) Txt 9. Why are headers and footers used in document? (A) To enhance the overall appearance of the document (B) To mark the starting and ending of a page (C) To make large document more readable (D) To allow page headers and footers to appear on document when it is printed 10. Which of the following shortcut key is used to check spelling? (A) F1 (B) F2 (C) F7 (D) F9 11. What does Ctrl + B shortcut accomplish in Ms-Word? . (A) It converts selected text into the next larger size of the same font (B) It adds a line break to the document (C) It makes the selected text bold (D) It applies Italic formatting t the selected text 12. What is the minimum number of rows and columns that a word table can have? (A) Zero (B) 2 rows and 1 column (C) 2 rows and 2 column (D) 1 row and 1 column 13. In Microsoft Word shortcut key CTRL+R is used for (A) Open the Print dialog box (B) Update the current Web page (C) Close the current window (D) None of these 14. In Microsoft Word shortcut key CTRL+W is used for (A) Open the Print dialog box (B) Update the current Web page (C) Close the current window (D) None of these 15. In Microsoft Word system to copy something the following shortcut is used (A) CTRL+C (B) CTRL+X (C) CTRL+V (D) None of these 16. In Microsoft Word shortcut SHIFT+DELETE is used for (A) Delete the selected item permanently without placing the item in the Recycle Bin (B) Copy the selected item (C) Rename the selected item (D) Create a shortcut to the selected item 17. In Microsoft Word shortcut CTRL while dragging an item (A) Delete the selected item permanently without placing the item in the Recycle Bin (B) Copy the selected item (C) Rename the selected item (D) Create a shortcut to the selected item 18. In Microsoft Word shortcut CTRL+SHIFT while dragging an item (A) Delete the selected item permanently without placing the item in the Recycle Bin (B) Copy the selected item (C) Rename the selected item (D) Create a shortcut to the selected item 19. In Microsoft Word to delete the selected item permanently without placing the item in the Recycle Bin (A) Shortcut SHIFT+DELETE (B) Shortcut CTRL while dragging an item (C) Shortcut CTRL+SHIFT while dragging an item (D) None of these 20. In Microsoft Word move the insertion point to the beginning of the next word (A) Shortcut CTRL+RIGHT ARROW (B) Shortcut CTRL+LEFT ARROW (C) Shortcut CTRL+DOWN ARROW (D) None of these 21. In Microsoft Word using SHIFT with any of the arrow keys (A) Highlight a block of text (B) Delete something (C) Paste something (D) Select more than one item in a window or on the desktop, or select text in a document In Microsoft Word shortcut CTRL+A is to (A) Select all (B) Highlight a block of text (C) Delete something (D) Paste something In Microsoft Word shortcut for paste is (A) CTRL+C (B) CTRL+X (C) CTRL+V (D) None of these 24. In Microsoft Word shortcut for copy is (A) CTRL+C (B) CTRL+X (C) CTRL+V (D) None of these 25. In Microsoft Word to paste something after cutting the following shortcut is used (A) CTRL+C (B) CTRL+X (C) CTRL+V (D) None of these 1. In Excel default header for a worksheet is (A) Your name (B) The date and time (C) None (D) The sheet tab name 2. In Excel which of the following is not an option in the spelling dialog box (A) Edit (B) Ignore (C) Ignore all (D) Change 3. Excel uses the …. Function when creating a data table (A) Average (B) Count (C) Sum (D) Table 4. In Excel you can copy cell formats from one cell to another by using the (A) Backspace key (B) Default font (C) Format painter (D) Formatting toolbar 5. In Excel accounting style shows negative numbers in (A) Bold (B) Brackets (C) Parentheses (D) Quotes 6. In Excel you can use drag and drop to embed excel worksheet data in a word document (A) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key (B) By dragging a range of excel data to the Word button on the taskbar while pressing Shift key (C) By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key (D) (A) and (C) 7. In Excel the chart wizard (A) Can place a chart on a new chart sheet or on any sheet in the workbook (B) Can only place a chart on new chart sheet (C) Can only place a chart on a new blank worksheet (D) Can only be used to create embedded charts 8. In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004 (A) Workday (B) Date (C) Networkdays (D) All of the above 9. In Excel data marker on a chart are linked to data points in a worksheet, therefore, (A) You can automatically apply formatting to a data series (B) You can change the position of a data marker and automatically change the data point value in the worksheet (C) You can change a data print value and automatically are draw the chart (D) (A) and (B) 10. In Excel when you group worksheets (A) You can enter variable data on multiple worksheets at one time (B) You can print more than one worksheet at a time (C) You can enter common data, formats, and formulas on multiple worksheets at one time (D) (B) and (C) 11. In Excel 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 12. You cannot link Excel worksheet data to a Word document (A) With the right drag method (B) With a hyperlink (C) With the copy and paste special commands (D) With the copy and paste buttons on the standard toolbar 13. In Excel this type of software is similar to an accountant’s worksheet (A) Word processing (B) Database (C) Spreadsheets (D) Graphics 14. In Excel you can use the format painter multiple times before you turn it off by (A) You can use the format painter button only one time when you click it (B) Double clicking the format painter button (C) Pressing the Ctrl key and clicking the format painter button (D) Pressing Alt key and clicking the format painter button 15. In Excel default header for a worksheet is (A) Your name (B) The date and time (C) None (D) The sheet tab name 21. In Excel 3-D reference in a formula (A) Cannot be modified (B) Only appears on summary worksheets (C) Limits the formatting options (D) Spans worksheets 22. In Excel the auto calculate feature (A) Can only add values in a range of cells (B) Provides a quick way to view the results of an arithmetic operation on a range of cells (C) Automatically creates formulas and adds them to a worksheet (D) None of the above In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu (A) Edit (B) Format (C) Tools (D) Data In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu. (A) Edit (B) Insert (C) Format (D) Tools 25. In Excel which of the following is not a worksheet design criterionx (A) Efficiency (B) Auditability (C) Description (D) Clarity Correct Answer In Excel to copy cell contents using drag and drop, press the (A) End key (B) Shift key (C) Esc key (D) None of above In Excel if you press …….., the cell accepts your typing as its contents. (A) Enter (B) Ctrl + Enter (C) TAB (D) Insert In Excel the auto fill feature (A) Extends a sequential series of data (B) Automatically adds a range of cell values (C) Applies a boarder around selected cells (D) None of above In Excel the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells (A) F3 (B) F5 ( C) F7 (D) F11 In Excel you can use the formula palette to (A) Format cells containing numbers (B) Create and edit formulas containing functions (C) Entered assumptions data (D) Copy a range of cells 1. In Microsoft PowerPoint to add a header or footer to your handout, you can use (A) The title master (B) The slide master (C) The handout master (D) All of above 2. In Microsoft PowerPoint the following will not advance the slides in a slide show view (A) Esc key (B) The spacebar (C) The Enter key (D) The mouse button 3. In Microsoft PowerPoint to select all of the boxes of an organization chart (A) Clicking and edit and select all (B) Right click the chart background and then click select all (C) Press and hold the SHIFT key and click each box (D) All of above 4. In Microsoft PowerPoint what are lines, curve, freeform, and scribble (A) Emphasis effects that can be applied to animations (B) Types of custom motion paths (C) Predefined entrance and exit effects (D) All of the above 5. When using PowerPoint, to play a PowerPoint show for previewing the show, select (A) View, slide sorter (B) View, slide (C) View, slide show (D) View outline 6. In Microsoft PowerPoint in order to see all the slides on one screen use (A) View, slide sorter (B) View, slide (C) View, master (D) View, slide show 7. In Microsoft PowerPoint the best place to find animated images for your presentation (A) Microsoft online (B) Word clipart (C) PowerPoint tools and ins (D) All of the above 8. In Microsoft PowerPoint the easy way to apply varied animations to test on slides (A) Apply effects in the custom animation text pane (B) Apply an animation scheme (C) Customize bullets with animated clipart (D) All of above 9. In Microsoft PowerPoint using a custom animation effect, how do you make text appear on a slide by letter (A) Apply the animation scheme fade in one by one. (B) Apply an entrance effect, and then set it to by letter in the effect option dialog box* (C) Apply the fly in entrance to the text, and then set its speed to very slow. (D) All of above 10. In Microsoft PowerPoint to exit the PowerPoint application, you should (A) Click the application minimize button (B) Click the document close button (C) Double click the application control menu icon (D) Double click the document control menu icon 11. In Microsoft PowerPoint you can create a new presentation by completing all of the following except (A) Clicking the new button on the standard toolbar (B) Clicking file, new (C) Clicking file open (D) Pressing Ctrl + N 12. In Microsoft PowerPoint you have customized a design template in one presentation and you want to use it in another presentation. What the best way to do this? (A) Use the browse feature in the slide design task pane to find the file that has your design template and apply it to the current file. (B) Copy and paste the slide with the design template you want to include the new presentation; inserted slide will inherit the design (C) Save the presentation that has the design template with a new name, and then use a new file to your presentation (D) All of the above. 13. In Microsoft PowerPoint the following displays when an image is selected (A) Add clip art only if it relates to your topic (B) Be sure to place at least one clipart image per slide (C) Resize the image so it takes up as much space as your text (D) Both (A) and (B) 14. The Microsoft clip gallery allows you to (A) Add word art images to a slide (B) Spell check your presentation (C) Add clip art images to a slide or slides (D) Add slides to a presentation 15. In Microsoft PowerPoint the following command select all object at one time when selecting multiple objects to be deleted (A) Alt + A (B) Ctrl + A (C) Shift + Enter (D) Edit, Select All 21. In Microsoft PowerPoint the following is not an option when printing handouts (A) Six slides per page (B) Five slides per page (C) Three slides per page ( D) Two slides per page 22. In Microsoft PowerPoint the best way to design the layout for your slides (A) Create layouts for slides, handouts and notes using the Master Layout dialog box in slide master view (B) For each new slide, select a layout from the Slide Layout task pane (C) Apply templates from the Slide Design task pane (D) None of above 23. In Microsoft PowerPoint any and every command can be found on the (A) Drawing toolbar (B) Formatting toolbar (C) Standard toolbar (D) Menu bar 24. In Microsoft PowerPoint slide that is used to introduce a topic and set the tone for the presentation is called the (A) Table slide (B) Graph slide (C) Bullet slide (D) Title slide In Microsoft PowerPoint the following features should you use when typing in he notes text box (A) Slide shows (B) Insert (C) Slide master (D) Zoom In Microsoft PowerPoint following should be used when you want to add a slide to an existing presentation (A) File, add a new slide (B) Insert, new slide (C) File, open (D) File, new In Microsoft PowerPoint the following is the default page setup orientation for notes pages, outlines and handouts (A) Vertical (B) Landscape (C) Portrait (D) None of above In Microsoft PowerPoint the following is the default page setup orientation for slides in PowerPoint (A) Vertical (B) Landscape (C) Portrait (D) None of above In Microsoft PowerPoint are symbols used to identify items in a list (A) Icons (B) Markers (C) Bullets (D) Graphics In Microsoft PowerPoint toolbars that are displayed by default in the PowerPoint window includes (A) Menu bar, standard toolbar, formatting toolbar, drawing toolbar, status bar (B) Menu bar, standard toolbar, formatting toolbar, drawing toolbar, status bar (C) Standard toolbar, formatting toolbar, drawing toolbar, status bar (D) Menu bar, standard toolbar, status bar, drawing toolbar In Microsoft PowerPoint view that displays the slides on a presentation as miniature representations of the slides is called (A) Slide show (B) Slide sorter view (C) Notes page view (D) Outline view In Microsoft PowerPoint view that displays only text (title and bullets) is (A) Slide show (B) Slide sorter view (C) Notes page view (D) Outline view In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called (A) Animation (B) Slide transition (C) Custom animation (D) Preset animation In Microsoft PowerPoint the following presentation elements can you modify using the slide master (A) Slide comments (B) Slide transitions (C) Speaker note font and color (D) All of above In Microsoft PowerPoint the following provides a printed copy of your presentation (A) Outline (B) Speaker notes (C) Audience handouts (D) All of the above Related Author: A.J. Bhatti