Font size
WorksheetsBBBBB
Total questions: 91
Worksheet time: 23hrs 45mins
1. To correct a data error in a chart, which of the following should be done?
Edit the chart data
Enter the chart data
Change the chart style
Change the chart type
2. A continuous section break does which of the following?
Moves the insertion point to the next page
Moves the insertion point to the next column
Starts a new section on the next page
Starts a new section on the same page
3. To add recipient address information to a mail merge document, which of the following should be done?
Add an AddressBlock merge field.
Add a Greeting Line merge field.
Add electronic postage.
Create an envelope.
4. To copy a chart from one document and paste it in another document while retaining the original appearance, which of the following paste options should be selected?
Keep Text Only
Merge formatting
Keep Source Formatting & Embed Workbook
Use Destination Theme & Embed Workbook
5. To guarantee that the individual sending a document really is who he or she claims to be, which of the followir should be done?
Add a watermark.
Add a digital signature.
Add a header.
Check the document for accessibility.
6. To insert a section break that will start the new section on the next even page of the document, which of th following should be done?
Insert a next page section break
Insert a continuous section break
Insert an even page section break.
Insert an odd page section break
7. Jasmine wants to insert a text sidebar into a document. She should do which of the following?
Insert a preformatted text box
Insert a chart.
Insert WordArt
Insert SmartArt.
8. Aaron is working on a document that contains Exeel documents inserted as linked objects. He made a change to one of the Excel documents. To ensure the Word document reflects this change, he should do which of the following?
Update the linked objects.
Break the link
Change the link source
Move the source file.
9. To ensure a table of contents is up-to-date, which of the following should be done?
Change the Format setting.
Use hyperlinks instead of page numbers.
Toggle field codes.
Update the table of contents.
10. Calvin sent Ashley an edited copy of a document that she had also previously edited. When she compares the documents, how will she know where changes have been made?
Word shows the differences as tracked changes
Word inserts a comment to flag each change.
Word displays the documents side by side so you can find the changes.
Word uses a different text highlight color for each change.
11. To create a cycle diagram in a document, which of the following should be done?
Click SmartArt and select the desired option.
Click Chart and select the desired option.
Click Shapes and select the desired option.
Click Table and select the desired option.
12. Silvio inserted an inline picture and wants to move it to the upper-right corner of the page. What must he do before moving it?
Change it to a floating picture.
Align the picture with the top of the page.
Remove any picture effects.
Reduce the size of the picture.
13. Susie is creating a recipient list for a mail merge document. She has information that he wants stored in a field called "status". She should do which of the following?
Add a field called "Status".
Add an entry and enter "Status" in the first field
There is no way to create custom fields in Word
Insert a merge rule.
14. Katlyn needs to remove all tab characters from a document. Which of the following is the most efficient way for her to do so?
Use Go To to find the tab characters.
Manually locate tab characters by scrolling through the document.
Use the Find and Replace dialogue box to locate the tab characters.
Use the Styles pane to find the tab characters.
15. To prevent people from modifying the formatting of a document, which of the following should be done?
Enable document editing restrictions.
Enable document formatting restnictions.
Set the document macro security settings to disable all macros with notification.
Set the document macro security settings to disable all macros except digitally signed macros.
16. Aaron wants to change the background of every page to light turquoise. Which button should he click on the Design tab?
Colors
Watermark
Page Color
Page Background
17. To individually modify the results of a mail merge, which of the following options should be selected?
Edit individual documents.
Print documents.
Send email messages.
Merge to Adobe PDF
18. Chloe is experimenting with different layouts for a table. To try out different widths for a column, she should do which of the following?
Select Draw Table and modify the table as desired
Drag the celumn border to resize the width to an approximate value.
Select the column and press Delete.
Select the column and press Split Cells.
19. Dan is working on a newsletter for his neighborhood. He noticed it is fatiguing to read the document because the text spans across the entire length of the page. To make the document more readable, he should do which of the following?
Insert a first line indent.
Insert a page break.
Insert a section break.
Format the text in columns.
20. Which of the following merge fields should you use to insert an inside address in a mail merge document?
Date
Address Block
Inside Address
Greeting Line
21. To zoom a document so that you can see the left and right margins, which of the following should you do on the View tab?
Click the Page Width button in the Zoom group.
Click the 100% button in the Zoom group.
Click the Side to Side button in the Page Movement group.
Click the Read Mode button in the Views group.
22. To ensure that a document can be read by people with visual impairment, which of the following should be done?
Check the document for accessibility.
Check the document for spelling and grammar errors.
Inspect the document.
Check the document for compatibility.
23. Alexandra received a PDF from a collaborator. The PDF only contains text. Before distributing the PDF, she needs to correct a typo in the document. She should do which of the following?
Edit the PDF using Word
Print the PDF and correct the typo by hand
Leave the typo as is. There is no way to correct it.
Edit the PDF using a browser such as Edge.
24. Tanisha inserted SmartArt as a floating object at the bottom of a page that contains two paragraphs. How can she attach the SmartArt to the first paragraph instead of the second one?
Change the text wrapping setting to Through.
Unlink the SmartArt from the second paragraph.
Drag the rotation handle on the SmartArt.
Drag the anchor from the second paragraph to the first paragraph.
25. To calculate the number of words in a document, do which of the following?
Click the Word Count button.
Click the Thesaurus button.
Click the Translate button.
Click the Check Accessibility button.
26. Enrico wants to change the width of a table column to 3.25". Which of the following should he do after clicking in the column?
Click Distribute Rows.
Click the Table Column Width box and type 3.25
Click the Size box and type 3.25.b.
Autofit content in the columns.
27. If you want to share a document for others to view. and edit, which of the following should you do?
Save the document to OneDrive
Save the document as a webpage.
Present the document online
Export the document as a PDF.
28. To insert a PDF in a Word document and store the PDF data within the Word file, which of the following should be done?
Embed the PDF in the word document.
Create a link to the PDF in the Word document.
Take a screenshot of the PDF and paste it in the Word document.
Copy the text from the PDF and paste it in the Word document.
29. When you merge two table cells containing text, how does Word handle the text in each cell?
Word converts the text from each cell into a separate paragraph in the merged cell.
Word discards the text in the last cell before merging.
Word cuts all the text and saves it to the Clipboard.,Click the Split Cells button.
Word deletes the text from both cells.
30. Which of the following describes the purpose of changing the vertical alignment of the page?
Changing the vertical alignment of the page specifies how text is positioned relative to the top and bottom of the page.
Changing the vertical alignment of the page specifies how text is positioned relative to the left and right of the page.
Changing the vertical alignment of the page specifies whether the page has landscape or portrait orientation.
Changing the vertical alignment of the page specifies the size of the margins on a page.
31. Which of the following describes what happens when you preview a mail merge?
PDFs are generated from the mail merge document.
Word files are generated from the mail merge document.
The merge fields are populated with data in the header.
The merge fields are populated with data in the recipient list.
32. Jeremy created a form and does not want to let users change the styles or font colors. He should do which of the following?
Enable document editing restrictions.
Enable document formatting restrictions.
Set the document macro security settings to disable all macros with notification
Set the document macro security settings to disable all macros except digitally signed macros.
33. Caleb needs to create an outline with Roman numerals and uppercase letters. He should do which of the following?
Create a multilevel list.
Create a single-level bulleted list
Create a single-level numbered list.
Create a outline list.
34. Jamie needs to view a document as an outline. She should do which of the following?
Switch to Web Layout view.
Switch to Outline view
Switch to Read Mode.
Switch to Print Layout view.
35. To increase the distance between cells in a table, which of the following should be done?
Increase the spacing between cells
Increase the border weight
Increase the cell margin
Increase the width of cells
36. To increase the space between the contents of a cell and the border of the cell, which of the following should be done?
Increase the cell width
Decrease the cell width
Decrease the cell margins
Increase the cell margins
37/57. To transfer all data in a table to text separated by tabs, which of the following should be done?
Change the alignment of the table
Apply a table style to the table
Convert the table to text
Apply shading to the table
38. A ______ is reusable content that you create and then can insert into any document.
Theme
Templete
Style
Quick Part
39. To insert a document property in a header, click the ________ button, point to Document Property, then click a property.
Page Controls
Fields
Quick Parts
Properties
40. How can you add a drop shadow to a picture?
Apply a Picture Effect
Apply a Picture Border
Change the Picture Layout
Apply an Artistic Effect
41. To specify the right edge of a paragraph, which of the following should be done?
Drag the right indent marker
Drag the left indent marker
Drag the first line indent marker
Drag the hanging indent marker
42. To modify the tab leader settings for a table of contents, which of the following should be done?
Change the tab leader settings in the Table of Contents dialogue box
Change the show level settings in the Table of Contents dialogue box
Apply a character style to the table of contents
Apply a paragraph style to the table of contents
43. Malik needs the text in a title to fit on one line, but there is slightly too much text to fit on the line. He needs to retain the text's font and size. He should do which of the following?
Set the font spacing to Condensed.
Set the font spacing to Expanded
Apply superscript to the font
Apply subscript to the font
44. Terri needs each word in a paragraph to be capitalized. Which of the following is the simplest method to achieve this?
Delete the first character of each word and retype it as a capital letter
Change the font size
Click the Text Effects and Typography button and select the desired option.
Click the Change Case button and select Capitalize Each Word
45. To have text appear near a hyperlink when you move the pointer over the link, which of the following should you do?
Specify the display text of the link
Add an address to the link
Specify a Target Frame for the link
Add Screen Tip text to the link
46. Cameron needs to brighten and increase the contrast of a picture. He should do which of the following?
Click the Corrections button and select the desired option.
Click the Color button and select the desired option.
Click the Artistic Effects button and select the desired option.
Click the Change Picture button and select the desired option.
47. What can you do to the choices in a Drop-Down List control as you set the properties for the control?
Align the choices
Sort the choices in alphabetic order
Format the text for each choice
Move the choices in the list
48. To reduce the size of a document, which of the following should be done?
Compress the pictures in the document
Modify the document properties
Check the document for accessibility
Restrict document editing
49. Amanda wants to use styles she created in one document in another document. She should do which of the following?
Copy the styles to the other document using the Manage Styles command
Copy the styles to the other document using the Compare documents command
Copy text from the source document and paste it in the destination document using the Keep Source Formatting option
Copy text from the source document and paste it in the destination document using the Merge Formatting option
50. Andy wants to increase the thickness of the border line on a rounded rectangle in his document. Which of the following should he do?
Change the shape outline weight
Change the shape outline style
Change the shape outline color
Remove the shape outline
51. Samantha restricted a document to filling in forms. What content control property should she turn off so users can enter data?
Show as Bounding Box
Tag
Remove content control when contents are edited
Contents cannot be deleted
52. Kiara needs each column in a table to be 0.5 inches in width. She should do which of the following?
Specify a fixed width for the columns
Autofit content in the columns
Click Distribute Columns
Click Distribute Rows
53. To replace all italic text with bold-italic text, which of the following should be done?
Use the Smart Lookup tool
Use the Researcher tool
Find and replace by formatting
Find and replace by language
54. When you insert or edit a hyperlink, which of the following can you do using the Insert Hyperlink dialog box?
Change the font color of the hyperlink
Apply a character style to the hyperlink
Create a bookmark
Add a Screen Tip
55. Which of the following is a way to create a PDF file from a Word document?
Save the document as a Word file
Save the document as an Adobe file
Export the document as a browser file
Export the document as a PDF
56. One of the pictures in Destiny's document is covered up by another picture. To make the obscured picture visible, she should do which of the following?
Set the text wrapping of the obscured picture to In Front of Text
Set the text wrapping of the obscured picture to Behind Text
Send the obscured picture to the back
Bring the obscured picture to the front
57. Why would you use the Line and Paragraph Spacing arrow on the Home tab?
To indent paragraphs
To align paragraphs
To add or remove space between paragraphs
To change the font and font style of paragraphs
58. To resize a shape nonproportionally, which of the following should be done?
Click and drag the corner sizing handle
Lock the aspect ration and then change the Width value
Click and drag a middle sizing handle
ALT+SHIFT-Click and drag the comer sizing handle
59. Shannon needs WordArt in her document to be 3" wide and 2" tall. ow should she resize the WordArt?
Use the Height and Width boxes in the Size group
Use the alignment buttons in the Alignment group
Apply a Transform text effect
Apply a shape style
60. Which of the following describes the results of hiding text in Word?
The text is moved to the clipboard
The text is deleted from the document
The text does not appear in the document
The text is moved to a comment
61. To add the Greek letter pi to a document, which of the following should be done?
Insert the symbol using the Insert a Symbol button
Insert an icon using the Insert the Icons button
Insert WordArt using the Insert WordArt button
Insert SmartArt using the Insert SmartArt button
62. Sharron needs to create a letter envelope using Word. In order to ensure the envelope prints properly, she should do which of the following?
Change the document theme
Change the number of columns
Change the paper size
Add a tab stop
63. Tom clicked and dragged the rotation handle above a picture. This resulted in which of the following?
Flipped the shape vertically.
Flipped the shape horizontally
Rotated the shape to an exact value
Rotated the shape to an approximate value
64. Jasmine needs to increase the distance between columns in a document. She should do which of the following?
Change the column spacing
Change the column width
Change the number of columns
Insert a line between columns
65. To prevent a content control from being deleted, which of the following should be done?
Record a macro
Add formatting restrictions to the document
Modify the content control properties
Turn on track changes
66. Brandon has a document with a large amount of data separated by tab characters and paragraph characters.
He wants the information displaved in a table. He should do which of the following?
Select the data and then click Convert Text to Table
Copy the text into the document header
Create a table and then manually populate each cell with data
Create a table and then click Convert to Text
67. When a comment is no longer useful, you should do which of the following?
Edit the comment
Delete the comment
Reply to the comment
Reopen the comment
68. To ensure a document is free of typos, always do which of the following before publishing the document?
Check the document for accessibility by clicking the Check Accessibility button
Check the document for spelling and grammar errors by clicking the Spelling & Grammar button
Use Smart Lookup by clicking the Smart Lookup button
Check the document for compatibility by clicking the Check Compatibility button
69. To quickly change the color palette of a chart, which of the following should be done?
Click the Change Colors button
Click the Change Chart Type button
Click the Switch Row/Column button
Click the Switch Row/Column button
70. Daren needs to change the color of test in a WordArt object. He should do which of the following?
Change the shape fill color
Change the text fill color
Change the shape outline color
Change the shape style
71. Which of the following is not an element you can add to a chart?
Axes
Axis titles
Status bar
Error bars
72. In a formal, professional document, which of the following can you apply to make a word stand out?
italic formatting
preset text effect
paragraph style
page border
73. Which of the following is a security measure you can take to verify a document?
Picture compression
Digital signature
Recorded macro
Widow/Orphan control
74. To remove a horizontal series of cells from a table, which of the following should be done?
Delete a table row
Delete a table column
Delete a table cell
AutoFit a table row
75. James neods to cornet an error in a mail merge recipient list. He should do which of the following?
Preview results.
Select reciprents.
Edit the recipient list
Merge to Adobe PDF.
76. Rihanna wants to display document text so that it is easy to read on screen. Which of the following views should she use?
Read Mode
Print Layout
Web Layout
Outline View
77. If you are distributing a form containing confidential information, how can you prevent someone from changing the structure of the form?
Save the form as a macro-enabled document.
Enforce protection with a password.
Mark the document as final.
Distribute the document as read-only.
78. Jacki needs a SmartArt object to be 4" tall and 3" wide. She should do which of the following?
Enter the desired position in the absolute position text boxes.
Enter the desired dimensions in the width and height text boxes.
Drag the rotation handle.
Drag the sizing handle.
79. If you want to specify who can sign a document and include instructions for the signer, what should you do?
Inspect the document
Insert a digital signature line.
Check for authenticity.
Acquire a digital ID
80. To quickly change the appearance of a chart without changing the way information is represented, which of the following shouid be done?
Click the Change Colors button.
Click the Change Chart Type button.
Click the Switch Row/Column button.
Click the Customize Chart button.
81. Microsoft Access can best be described as ___ software.
spreadsheet
relationship
utility
Database
82. If you want to manage lists of data about customers and the products they order, use ____ software.
spreadsheet
relational database
tabular
communication
83. Use the ______ to exit Access.
Close button
Exit command in Backstage view
Exit & Repair button
Save button
84. What should you do when you are finished working with a database?
Open and then save each object in the database.
Close the Navigation Pane.
Sign out so other people can use the database.
Close the database.
89. A relational database can best be described as a collection of related ________ designed to minimize redundant data.
properties
links
tables
keys
90. Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.
linked tables
object dependencies
trusted folder
Database Documenter report
91. Compared to forms and datasheets, ______ give you more control over how data is arranged when printed.
queries
tables
records
reports
92. Which of the following tools can you use to create a query?
Choose Fields Wizard
Simple Query Wizard
query datasheet
Blank Query Wizard
93. When you use the_____, Access asks you for the information it needs to create a query.
Create Query Wizard
Form Wizard
Query Design command
Simple Query Wizard
94. How can you list the records in a query datasheet in A-Z order by CustomerName?
Click a value in the CustomerName field, and then click the Descending button.
Click a value in the CustomerName field, and then click the Ascending button.
Click the Advanced button, and then click Filter By Form
Click the CustomerName column heading.
95. What data type is most appropriate for a field named Square Feet?
Hyperlink
Attachment
Number
AutoNumber
