Question 1 Your users are calling the help desk, complaining that they are constantly losing work they have done on a document in Word. How can you alleviate this with certainty?
A. Instruct your users to save their work every 10 minutes.
B. Have them select “Save AutoRecover Information” every 10 minutes in Options.
C. Have them select the “AutoSave to file” every 10 minutes on the Review tab.
D. Have them select the “AutoSave to file” every 10 minutes in Options.
Question 2 of 40
Your brother is interested in using Apache OpenOffice as an office productivity suite. He asks you what the advantages are of this application. You list several of them except for which of the following?
A. It is free.
B. It can read Word Files.
C. It can edit Excel files.
D. It has a subscription service.
Question 3 The name of the company you work for has recently changed. Because of this, you will need to go through some of the company Word documents and change the name for every instance that the company appears within the document. What is the easiest way to do this?
A. Use the “Change Name” utility on the Reference tab ribbon.
B. Click the Search command on the Review tab ribbon.
C. Click the Search command on the Home tab ribbon.
D. Click the Replace command on the Home tab ribbon.
Question 4 What type of Microsoft Server serves as an email server?
A. SQL Server
C. Exchange 2013
D. Directory Services
Question 5 Your sister wants to purchase Microsoft Office 2013 for her new laptop. She doesn’t want to pay for a subscription and she wants to pay the least amount of money possible. The applications she plans on using are Word, Excel, and Outlook. Which version of Office do you recommend for her?
A. Office Home and Student
B. Office Home and Business
C. Office Professional
D. Office 365
Question 6 What is the purpose of an Automatic Reply?
A. To let email senders know that you are out-of-town
B. To alert spammers so that their emails will be rejected
C. To reply to senders of large attached files
D. To reply to senders who are attaching viruses
Question 7 Your boss is trying to modify a PDF file that he made a year ago. He asks you what he can use to do this. Which of the selections below will not allow him to edit this file?
A. Word 2010
B. Office 2013
C. Adobe Acrobat
D. Nuance PDF Converter
Question 8 What happens when you click “Reply All” for an email that you received?
A. A single email will be sent to the sender.
B. An email will be sent to everyone in your contacts.
C. An email will be sent to everyone on the email server.
D. An email will be sent to all recipients of the email.
Question 9 Your boss has asked you to edit a document she just created. You want to be able to make suggestions to the document without directly altering any of the text your boss has written. How do you do this?
A. Use the Spelling and Grammar function.
B. Insert comments into the document.
C. Use Microsoft OneNote.
D. Insert a screenshot into the document
Question 10 Someone calls you at the help desk and complains that his spell-checker isn’t working in real time as he types. How can you fix this problem?
A. Click the Review tab and check the box beside “Check Spelling as you Type.”
B. Click the Review tab and select Options and then check the box beside “Check Spelling as you Type.”
C. Click the File tab and check the box beside “Check Spelling as you Type.”
D. Click the File tab and select Options and then check the box beside “Check Spelling as you Type.”
Question 11 Your boss informs you that one of the employees you supervise is under review. She wants you to send him copies of all emails you send to them without them knowing. How do you do this?
A. Copy her on all emails to that employee.
B. Blind-copy her on all emails to that employee.
C. Insert your boss’s signature on all emails to that employee.
D. Attach an email copy on all emails to that employee
Question 12 Your sister asks you if it is possible to get an office productivity suite out there for free. What do you tell her?
A. Office Professional
B. Office Home and Student edition of Microsoft Office
D. Office 365
Question 13 A start-up company has hired you to implement an email strategy for its organization. The company wants all of its employees to have an enterprise-level email client and is considering Windows Live. They ask you if there are any limitations about this email solution. Which selection below is a major limitation?
A. Windows Live can’t insert signatures.
B. Windows Live can’t blind copy recipients.
C. Windows Live can’t use the IMAP protocol.
D. Windows Live has limited Exchange Server integration.
Question 14 What is the purpose of creating a PST file?
A. To document a antivirus pattern that continues to be sent to your mailbox
B. To insert as a Signature for all outgoing emails
C. To save your emails so that you can restore your mailbox if necessary
D. To create a file that deleted emails will be sent to for deletion
Question 15 You are writing up a contract agreement for a new work assignment you just got with a local business. You want to create the document so that when you send it to the client, the client can’t alter it. How can you do this?
A. Save it as a DOCX file.
B. Save it as a DOTM file.
C. Save it as a PDF file.
D. Save it as an RTF file.
Question 16 A user calls your help desk and says that he is trying to configure his Word document so that the text within his paragraphs is stretched from the left margin to the right margin. What is your advice?
A. Tell him to click the Align Left icon on the Home Ribbon.
B. Tell him to click the Align Right icon on the Home Ribbon.
C. Tell him to click the Justify icon on the Home Ribbon.
D. Tell him to click the Column Width icon on the Page Layout Ribbon.
Question 17 You are creating a document for your students at school using Word 2013. You are concerned that some of your students have older versions of Word. How can you ensure that your students can open up these Word files in older versions of Word?
A. Save them as a template.
B. Create the document with a template.
C. Save them as .doc files.
D. Save them as .docx files.
Question 18 Someone calls your help desk in a panic that she can’t find the document she was just working on after opening up a second document. How can you help her?
A. Tell her to click the “Show Documents” icon located in the View Ribbon.
B. Tell her to right-click anywhere inside the View Ribbon tab and select the document.
C. Tell her to hold the Windows key down and press the up/down arrow and select the document.
D. Tell her to right-click on the Word Icon in the task bar and select the document.
Question 19 You are considering upgrading your Office 2010 to Office 2013. Which of the selections below is not true of either Office 2010 or 2013?
A. Office 2013 can integrate directly with the cloud.
B. Word 2010 can edit PDF files.
C. Office 2010 is not touch-friendly.
D. Office 2013 is more supportive of multiple monitors.
Question 20 What is the purpose of using templates in PowerPoint?
A. Integrates animation and audio automatically
B. Inserts a consistent look and format to the entire presentation
C. Inserts the required formulas automatically into the presentation
D. Imports fonts and images from CSV files for the presentation
Question 21 You want to create a chart in Excel illustrating the sales growth of your company over the past 10 years. Which graph would be ideal for this?
A. Cell Chart
B. Bar Chart
C. Pie Chart
D. Worksheet Chart
Question 22 You create a formula that adds cells E4 through E19. Three of these cells are blank. What happens?
A. Excel alerts you that the formula cannot be performed.
B. Excel prompts you for data to input into the blank cells.
C. The formula will assign an average value to the blank cells.
D. The formula will assign a value of zero to the blank cells.
Question 23 Which formula below will add up all of the numbers in cells D1 through D5?
Question 24 How can you identify the Active Cell in Excel?
A. It is outlined in bold fashion.
B. The cell is filled in solid gray.
C. The data inside the cell is in red.
D. The data inside the cell is indented.
Question 25 You are the manager of an independent rental car company. Which application below can aid you in inventorying the cars in your rental fleet?
Question 26 What third-party application serves as an alternative to OneNote?
Question 27 You have created a slide for your PowerPoint presentation that you wish to simulate in all of the other slides. What is the easiest way to do this?
A. Right-click on the slide and select Copy.
B. Right-click on the slide and select “Create Template.”
C. Right-click on the slide and select “Export Slide.”
D. Right-click on the slide and select “Duplicate Slide.”
Question 28 What does the Screen Clipping function do in OneNote?
A. Creates a new blank OneNote file
B. Captures a screenshot of your computer screen
C. Captures a YouTube video for OneNote
D. Captures an audio file from Media Player for OneNote
Question 29 What is the danger of using too much animation in a PowerPoint presentation?
A. The files become too large.
B. The animated effects can overshadow the content.
C. The slides take too long to play out.
D. Animated slides may not be compatible with older versions of PowerPoint.
Question 30 Which type of file can be used to import data into a spreadsheet?
A. DB file
B. PPT file
C. CSV file
D. DBX file
Question 31 You create a formula in A8 that adds up the numbers listed in A1 through A7. You copy the formula and paste it into C8. What happens in C8?
A. The sum of cells A1 through A8 appears.
B. The sum of cells C1 through C8 appears.
C. The sum of cells A1 through B8 appears.
D. The sum of cells A1 through C8 appears.
Question 32 Which selection below represents an entry that would be seen in the active box?
Question 33 You press the “P” key during a PowerPoint presentation. What happens as a result?
A. The presentation stops.
B. The next slide is presented.
C. The first slide is presented.
D. The previous slide is presented.
Question 34 You want to play your entire PowerPoint presentation thus far. What key will start the presentation in its entirety?
Question 35 You are an inexperienced Excel user and don’t know how to create your own formulas. You want to use one of the preconfigured formulas but it doesn’t appear in the Formulas tab ribbon. What can you do?
A. Click the Insert Formula icon on the Formulas tab ribbon.
B. Click the Insert Formula icon on the Insert tab ribbon.
C. Click the Formula Generator icon on the Formulas tab ribbon.
D. Click the Formula Generator icon on the Insert tab ribbon.
Question 36 Which option below represents a task that can be conducted in Excel through sorting?
A. Showing all cells that have a number that ends with a 5
B. Showing all cells that have nothing in them
C. Showing all cells that have the word “Widget” in them
D. Displaying the cells from smallest to largest
Question 37 What does the COUNT function do in Excel?
A. Shows the number of cells contained within a worksheet
B. Shows the number of active cells contained within a worksheet
C. Shows the number of formulas contained within a spreadsheet
D. Shows the number of entries within a selected range of cells
Question 38 You want to create a relational database for your company. Which application below would assist you in doing this?
Question 39 Which formula below will add up the numbers in cells A1 and A8?
Preview of C10-intro-to-computer.docx