Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page break, so be sure that you have seen the entire question and all the answers before choosing an answer.

1. What Microsoft Office applications can you use to create a database mail merge?

A. Access
B. Excel, Word, and Access
C. Word and Excel
D. PowerPoint, Publisher, Excel, and Word

2. Computer user A wants the Excel worksheet in a Word document to automatically update when she makes changes to the Excel worksheet so she'll embed the worksheet into the Word document. Computer user B says to link the worksheet to the Word document. Which computer user is using the correct process?

A. Neither is correct.
B. Computer user A is correct.
C. Computer user B is correct.
D. Both are correct.

3. What feature or attribute will be applied if you select some text and click on the button shown above?

A. Boldface
B. Italic
C. Underscore
D. Center

4. How should you save the edited Excel worksheet that has been embedded in a Word document?

A. Click on Start, select Programs, and click the icon for the Excel program.
B. Click the Home tab, click on Select All, and press Alt + Shift + S.
C. Click the Save button in the upper-left corner of Word.
D. Press Alt and S at the same time.

5. What tells a database where to insert information in the main document?

A. Field
B. Placeholder
C. Object
D. Handle

6. All of the following operations will move you from cell A1 to cell B1 of an embedded worksheet except

A. clicking on cell B1.
B. pressing the Tab key.
C. pressing the Enter key.
D. pressing the Right Arrow key.

7. Robert just finished his Word document with an embedded spreadsheet. What is the easiest way to check the overall layout?

A. Use the Print Review
B. Zoom up to 100%
C. Under the View tab, switch to Normal View
D. Under the View tab, switch to Form View

8. The Mail Merge wizard is located in

A. Excel.
B. Word.
C. PowerPoint.
D. Access.

9. Lucy needs to insert a certain date format into her Word document. How do you insert an Automatic Date into a Word document with a certain date format?

A. Right-click on the Word document and select embed Excel worksheet.
B. Start typing the date, and Word automatically shows tooltip of full date.
C. Click Insert tab, click on Date & Time, choose a date format, and click OK.
D. Write a macro to your specifications for the Date & Time method.

10. Hank is working on his embedded Excel spreadsheet in a Word document. Before he can edit the worksheet that's embedded in his Word document, he must

A. recalculate the Excel spreadsheet.
B. save the Word document.
C. copy the Excel spreadsheet into Excel.
D. double-click on the embedded worksheet to activate Excel.

11. Robin has populated a database table in Access with customer names, addresses and phone numbers. She now needs to create a form to display the customer information. How does Robin create a Database Form in Microsoft Access?

A. Open Access and select the New icon.
B. Select the Form button, and click Create.
C. Select the Create tab in the Ribbon and then click the Form button.
D. Right-click the open Access database and select Form.

12. Brian has a list of customers that needs to be entered into a new database. Before Brian can begin entering records into a database, he must first

A. enter information into an Excel spreadsheet.
B. create a table.
C. create a form to display the customer's information.
D. create objects for the database.

13. Bobby just inputted annual costs for January (A1) thru December (L1) in his embedded Excel spreadsheet that's integrated into a Word document. Now he must make sure the inputted costs have the dollar symbol and have two decimals after each projected month. How can Bobby add the dollar symbol multiple times for January (A1) thru December's (L1) annual costs?

A. Select the Formula tab and click on the Accounting Number Format button.
B. Go to each cell A1 through L1 and click on the Accounting Number Format button.
C. Highlight A1 through L1, right-click, and select Dollar sign.
D. Select cells A1 through L1, click on cell A1, hold the Shift key down and drag to L1, and click on Accounting Number Format button.

14. What does the first field or column in an Access form or table do?

A. It identifies integrated files.
B. It updates changes in linked objects.
C. It assigns a number to each record in a database.
D. It sorts database records by selected fields.

15. When you're in the Mail Merge option dialog box, you have the ability to

A. create a list of addresses.
B. create a form.
C. rename the Word document.
D. create e-mails.

16. What are the steps to embed an Excel worksheet into a Word document?

A. Select the Insert tab, click Table, and select Excel Spreadsheet.
B. Right-click on the Word document and select embed Excel worksheet.
C. Select the Embed tab, and click on the Excel worksheet option.
D. Go into Excel Spread, create table, copy, and then paste into Word document.

17. What button in the Excel toolbar gives you the automatic sum of certain highlighted columns?

A. Select Formulas tab, and click on the Financial option menu.
B. On the main home menu, select the Greek symbol used for AutoSum.
C. Select Formulas tab, click on Math & Trig option, and select Sum.
D. Click on Show Formulas, under the Formulas tab.

18. To select the range of cells A2:D12, first click on cell A2. Then click on D12 while you hold the _______ key.
End of exam

A. Shift
B. Ctrl
C. Tab
D. Alt

19. If you wish to display your database file one record at a time, you should create a

A. datasheet.
B. form.
C. table.
D. frame.

20. Charles and Ann want to preview their letters merged with their mailing list. Charles will click Next: Preview Your Letters. Ann will click Next: Preview Your Letters and then click the double arrow in the Mail Merge pane. Who is correct?

A. Only Ann is correct.
B. Only Charles is correct.
C. Both are correct.
D. Neither is correct.

Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page break, so be sure that you have seen the entire question and all the answers before choosing an answer.

1. You want to add a fade effect in between slides in your PowerPoint presentation. Which tab should you click on to add this option?

A. Animations
B. Objects
C. Transitions
D. Layout

2. PowerPoint's default option when you create a video is to save it in which format?

A. MIDI
B. MP3
C. MPEG-4
D. WAV

3. Before you send out your presentation, you would like to inspect it to make sure there are no issues. Which of the following is not an option available from Check for Issues?

A. Check spelling and grammar
B. Objects that are off-slide
C. Document properties
D. Presentation notes

4. You're adding effects, such as fade in, to occur in between slides. What is this effect know as?

A. Manipulation
B. Conversion
C. Animation
D. Transition

5. You're going to e-mail a PowerPoint presentation to some colleagues. Before you e-mail the file, you want to make sure all the linked objects in the presentation are up to date and mirror the data currently in their source documents. What must you do?

A. Open the presentation, select Slide Sorter from PowerPoint's Slide Show, and then save and close the presentation.

B. Open the presentation, select Object from PowerPoint's Insert tab, enable (check) the Display as icon check box, and then
save and close the presentation.

C. Open the presentation, click Update Links in the dialog box that pops up, and then save and close the presentation.

D. Open the presentation, navigate one at a time to each slide containing a link, right-click on each link and select Hyperlink, and then save and close the presentation.

6. Which of the following formats is valid for a sound file used in a PowerPoint presentation?

A. .avi
B. .mov
C. .mp3
D. .rtf

7. Sounds can be added to a PowerPoint presentation using the

A. Office button.
B. Insert tab.
C. Home tab.
D. Slide Show tab.

8. On which tab/menu can you find the Hyperlink command?

A. View
B. Insert
C. Home
D. Animation

9. If you're preparing your presentation for online, the resolution should be set between _______ dpi.

A. 96-300
B. 300-400
C. 72-96
D. 56-72

10. Two IT technicians are discussing PowerPoint. Technician A says that the slides' contents and notes for a presentation can be sent from PowerPoint to Word. Technician B says that the outline for a presentation can be sent from Word to PowerPoint. Who is correct?

A. Only technician A is correct.
B. Neither technician is correct.
C. Only technician B is correct.
D. Both technicians are correct.

11. If you're preparing your presentation for print, the resolution should be set for _______ dpi.

A. 72
B. 96
C. 300
D. 400

12. To convert an entire PowerPoint presentation into a video, you should use the

A. Package command from the File button.
B. Slide Layout command from the File button.
C. Export command from the File button.
D. Video command from the File button.

13. Which of the following procedures should you use to resize an image embedded in a PowerPoint slide?

A. Select the Reset Picture tool, and type in the frame's new dimensions.
B. Right-click on the image, and select the Update Link option.
C. Select the image, select the Cropping tool, and drag one of the handles on the image's frame.
D. Select the image, and drag one of the handles on the image's frame.

14. What option on the Picture Tools can you use to trim away an amount of visible image in a piece of clip art?

A. Image Control
B. Line Style
C. Reset Picture
D. Crop

15. Avery and Dante want to add a shadow feature around a clip art image. Avery will begin by clicking Shape Effects in the Drawing group. Dante will begin by clicking Shadow Border in the Design group. Who is correct?

A. Only Avery is correct.
B. Neither is correct.
C. Both are correct.
D. Only Dante is correct.

16. Which of the following options would you not find under PowerPoint's Export menu?

A. Share to SkyDrive
B. Create PDF/XPS Document
C. Create a Video
D. Package Presentation for CD

17. If your organization asks you to save your presentation to SharePoint, it means they use a _______ management system.

A. content
B. software
C. document
D. cloud

18. Your mouse pointer appears as a four-point arrow while you're manipulating an image on a slide. You can then _______ the image.

A. crop
B. move
C. rotate
End of exam
D. resize

19. Two project managers are discussing the usefulness of the Internet to document progress on a project. Manager A says that they can share presentations on SkyDrive. Manager B says that saving the presentation to the Cloud allows the presentation to be viewed on a PC only. Who is correct?

A. Both managers are correct.
B. Only manager B is correct.
C. Neither manager is correct.
D. Only manager A is correct.

20. Hal and Casey are discussing linking and embedding objects. Hal says that when he makes a change to the object in the source file, the change will also be made in the embedded object. Casey says that to make a change in an embedded object, he can open the embedded object and make the change. Who is correct?

A. Neither is correct.
B. Only Hal is correct.
C. Only Casey is correct.
D. Both are correct.