Assignment:
Part 1- Integrating Word with Access and Excel
1. If you wish to display your database file one record at a time, you should create a
A. frame.
B. form.
C. table.
D. datasheet.
2. Which shortcut-key combination helps you quickly select text from cursor selection to the end of the row?
A. Ctrl+Alt+Delete
B. Shift+F2
C. Shift+End
D. Ctrl+C
3. How can you add a chart into a Word document?
A. Use the Page Layout feature.
B. Use the Chart template.
C. Draw it in Word.
D. Use the Insert tab.
4. 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 Charles is correct.
B. Only Ann is correct.
C. Both are correct.
D. Neither is correct.
5. Sandrelle is working in a Word document in which she's going to insert a merge field for a greeting. What is the placeholder that will appear in the document?
A. [[GREETING]]
B. <>
C. INSERTGreetingEND
D. &PersonalizedGreetingHere&
6. 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. double-click on the embedded worksheet to activate Excel.
B. recalculate the Excel spreadsheet.
C. save the Word document.
D. copy the Excel spreadsheet into Excel.
7. 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. Highlight A1 through L1, right-click, and select Dollar sign.
B. Select the Formula tab and click on the Accounting Number Format button.
C. 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.
D. Go to each cell A1 through L1 and click on the Accounting Number Format button.
8. What is the best way to check the overall layout of an integrated document?
A. Switch to Form View.
B. Select Normal from the View menu.
C. Set the Zoom Control to 100%.
D. Use Print Preview.
9. 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. Right-click the open Access database and select Form.
B. Select the Form button, and click Create.
C. Select the Create tab in the Ribbon and then click the Form button.
D. Open Access and select the New icon.
10. How do you modify an Excel worksheet that's embedded in a Word document?
A. You must select all the cells in the embedded Excel spreadsheet.
B. You first must double-click the Excel spreadsheet.
C. You first must save the document.
D. You must rename the document to gain access into the embedded Excel spreadsheet.
11. When you embed a blank worksheet in a Word document, which Office applications are integrated?
A. Excel and PowerPoint
B. Word and Excel
C. Excel and Access
D. Word and Access
12. When you click on Save in the File menu, the Save As dialog box will appear if
A. the file has been altered.
B. more than one file is open.
C. the file contains a linked or embedded object.
D. the file hasn't been saved before.
13. Jean and Les are discussing linked and embedded files. Jean says that the file that's embedded in a ocument is the source file. Les says the embedded file is the destination file. Who is correct?
A. Both are correct.
B. Only Les is correct.
C. Only Jean is correct.
D. Neither is correct.
14. How should you save the edited Excel worksheet that has been embedded in a Word document?
A. Click the Save button in the upper-left corner of Word.
B. Press Alt and S at the same time.
C. Click the Home tab, click on Select All, and press Alt + Shift + S.
D. Click on Start, select Programs, and click the icon for the Excel program.
15. When you're in the Mail Merge option dialog box, you have the ability to
A. create a form.
B. create a list of addresses.
C. create e-mails.
D. rename the Word document.
16. What button on the Excel toolbar should you use to add a dollar sign?
A. Omega Greek Symbol Auto Sum
B. The Percent Symbol
C. Format Option
D. Accounting Number Format
17. 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. Write a macro to your specifications for the Date & Time method.
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. Right-click on the Word document and select embed Excel worksheet.
18. You're working in a Word document in which you've inserted a merge field to instruct Word to pull addresses from your data source. What will the placeholder look like?
A. <>
B. INSERTAddressBlockEND
C. &AddressBlock&
D. [[ADDRESS]]
19. How do you create a Chart within the embedded Excel spreadsheet table?
A. Right-click on embedded Excel spreadsheet, and select chart.
B. Click the Charts tab, and select a chart.
C. Click the Insert tab, click the Charts icon, and select a chart.
D. Click the Insert tab, select an icon in the Charts group, and click it.
20. The Save As command is useful if you want to copy an open document and
A. link it to the original document.
B. give the copy a new name.
C. delete the original document.
D. remain in the original document.
Part 2- Integrated Projects for Presentations
1. 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 Dante is correct.
B. Neither is correct.
C. Both are correct.
D. Only Avery is correct.
2. 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.
3. Sounds can be added to a PowerPoint presentation using the
A. Insert tab.
B. Slide Show tab.
C. Office button.
D. Home tab.
4. Although you want a sound to accompany a particular slide, you don't want the speaker icon visible on the slide during the slide show. What should you do?
A. Drag the icon off the area of the slide that will appear in the slide show and into the border surrounding the slide.
B. Select the icon, press Ctrl + X, drop the mouse cursor in the slide's Notes field, and press Ctrl + A.
C. Right-click the icon, select Edit Sound Object, and click OK.
D. Right-click the icon, select Custom Animation, and click OK.
5. If you're preparing your presentation for online, the resolution should be set between _______ dpi.
A. 96-300
B. 72-96
C. 56-72
D. 300-400
6. 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. Video command from the File button.
D. Export command from the File button.
7. If you're preparing your presentation for print, the resolution should be set for _______ dpi.
A. 96
B. 400
C. 72
D. 300
8. 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. Document properties
C. Presentation notes
D. Objects that are off-slide
9. Which of the following procedures would you use to embed or link to an Excel chart in a PowerPoint slide?
A. Select the chart in Excel, click Cut in Excel's Edit menu, navigate to the PowerPoint slide in which you want the chart to appear, and click Hyperlink.
B. Select the chart in Excel, navigate to the PowerPoint slide in which you want the chart to appear, and click Copy in PowerPoint's Home tab.
C. Navigate to the PowerPoint slide in which you want the chart to appear, click Hyperlink, browse to the Excel document that contains the chart, and click OK.
D. Select the chart in Excel, press Ctrl+C, navigate to the PowerPoint slide in which you want the chart to appear, and click Paste Special in PowerPoint's Home tab.
10. PowerPoint's default option when you create a video is to save it in which format?
A. MP3
B. MPEG-4
C. WAV
D. MIDI
11. 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.
12. What option on the Picture Tools can you use to trim away an amount of visible image in a piece of clip art?
A. Line Style
B. Crop
C. Image Control
D. Reset Picture
13. If your organization asks you to save your presentation to SharePoint, it means they use a _______ management system.
A. software
B. document
C. cloud
D. content
14. Which of the following procedures should you use to open the source of a linked object in PowerPoint?
A. Click Open linked object from the File button.
B. Double-click the linked object.
C. Right-click on the linked object, and select Update Link.
D. Pass the mouse cursor over the linked object.
15. Roland wants to add a security password to his presentation and make it read-only. Which of the following options will Roland use?
A. Protect Presentation
B. Check for Issues
C. Secure Presentation
D. Optimize Compatibility
16. You're adding effects, such as fade in, to occur in between slides. What is this effect know as?
A. Manipulation
B. Transition
C. Animation
D. Conversion
17. If you're saving a presentation to SkyDrive and sharing it with others, you're saving it to
A. Google Docs.
B. the Sky.
C. the Cloud.
D. SharePoint.
18. Which of the following formats is valid for a sound file used in a PowerPoint presentation?
A. .rtf
B. .mov
C. .mp3
D. .avi
19. Which of the following procedures should you use to resize an image embedded in a PowerPoint slide?
A. Select the image, select the Cropping tool, and drag one of the handles on the image's frame.
B. Select the Reset Picture tool, and type in the frame's new dimensions.
C. Right-click on the image, and select the Update Link option.
D. Select the image, and drag one of the handles on the image's frame.
20. 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 Object from PowerPoint's Insert tab, enable (check) the Display as icon check box, and then save and close the presentation.
B. Open the presentation, click Update Links in the dialog box that pops up, and then save and close the presentation.
C. Open the presentation, select Slide Sorter from PowerPoint's Slide Show, 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.