Latest Microsoft MO-100 First Attempt, Exam real Dumps Updated [Sep-2021]
Get the superior quality MO-100 Dumps Questions from TestsDumps. Nobody can stop you from getting to your dreams now. Your bright future is just a click away!
NEW QUESTION 21
In the "Banking Fees" section, convert the tab-delimited text to a two-column table. Accept the default AutoFit behavior.
Answer:
Explanation:
Click the Insert tab and click Table in the Table section. Select Convert Text to Table from the drop-down menu.
On the Convert Text to Table dialog box, the Number of columns should already be set to 2 if you have only one tab between each item on each line. The Number of rows is automatically calculated.
Topic 5, City Power & Light



NEW QUESTION 22
Split the four paragraphs the picture into two columns with column spacing of '0.3'' (''0.8 cm'').
Answer:
Explanation:
On the Page Layout or Layout tab, click Columns. At the bottom of the list, choose More Columns.
In the Columns dialog box, adjust the settings under Width and spacing to choose your column width and the spacing between columns.
NEW QUESTION 23
SIMULATION
Project 1 of 7: Observation
Overview
You are a member of the Barstow College Observation Project committee. You are preparing the initial summary report for this year's count, but have not received all of the data you need to complete the report.
Introduction
The multi-departmental Wildlife Observation Project has completed its wildlife population counts for this year.
The counts were made between May 5 and May 7 for both the wilderness and cultivated land areas. This is in line with the count periods for all previous years. The species used for the counts have been identified as common for the region (central Missouri) in which the counts were taken. (Author, 2009) As in previous years, five observation blinds were set up two weeks before the counts were to take place.
Counters worked eight-hour shifts providing 24-hour coverage of the count areas for two days. Weather for both observation days was clear and mild (varying between 50-70 degrees F).
The results presented here are summary total results only, which counts from five and ten years ago provided for comparison. Detailed observation results will be available as soon as they are completed. We estimate that they will be available some time in the next two weeks.
Wilderness Summary
The wilderness observation area is a five-acre section of unimproved forest land. The most common trees in the area are maple, red oak, cedar, sweet gum, and hickory. The area also includes a small spring. The area is not enclosed by a fence or other man-made barrier.
The area is located eight miles from the nearest paved road and twelve miles from the nearest residence. Offroad vehicles were used to bring counters close to, but not entering, the count area. The nearest approach by off-road vehicles was one mile.
The table below lists the summary counts.
Though further research any analysis is needed, the drop in mourning dove and bobwhite quail counts could be significant. The detailed count data shows these numbers failing off each year.
Cultivated Land Summary
The cultivated land observation area is a five-acre section of cultivated land near the center of a 50-acre field.
The field is used to grow corn, wheat, soybeans, and clover, with the crop rotated annually. In the fifth year of the cycle, the field is left fallow.
The area is located two miles from the nearest paved road and one mile from the nearest residence. A storage barn is located at the southern border of the field.
The table below lists the summary counts.
Additional Notes
This project was initially scheduled to run for ten years, so we are currently in our last year. The committee needs to decide if it is worth the time and expense to continue the project. The landowners have experience that they would be happy to let us continue. Costs relating to the project is minimal and it does provide an opportunity to offer extra credit to students volunteering as counters.
A suggestion has been made by some committee members that we should increase the count frequency, counting on a quarterly schedule instead of an annual schedule. This would need to be coordinated with the owner of the cultivated field so that we do not interfere with planting or harvesting schedules.
Special Thanks
Once again, we would like to offer special thanks to:
We couldn't do this without you.
Add a table with eight rows and four columns in the "Cultivated Land Summary" section, below the text "The table below lists the summary counts."
Answer:
Explanation:
See the explanation below.
Explanation:
1. Click below the text "The table below lists the summary counts." where the table should be inserted.
2. Select Table from the Insert tab.
3. Drag through the grid to set eight rows and four columns (4x8 Table) as desired OR
1. Click below the text "The table below lists the summary counts." where the table should be inserted.
2. Select Table from the Insert tab.
3. Select Insert Table from the options provided below and type four columns and eight rows in the appropriate boxes, then select OK.
References:
https://support.office.com/en-us/article/Insert-a-table-A138F745-73EF-4879-B99A-2F3D38BE612A
NEW QUESTION 24
Apply the Intense Emphasis style to the paragraph after the picture.
Answer:
Explanation:
Select the text you want to format.
On the Home tab, point to a style to preview it.
Select a style.
NEW QUESTION 25
SIMULATION
Project 1 of 7: Observation
Overview
You are a member of the Barstow College Observation Project committee. You are preparing the initial summary report for this year's count, but have not received all of the data you need to complete the report.
Introduction
The multi-departmental Wildlife Observation Project has completed its wildlife population counts for this year.
The counts were made between May 5 and May 7 for both the wilderness and cultivated land areas. This is in line with the count periods for all previous years. The species used for the counts have been identified as common for the region (central Missouri) in which the counts were taken. (Author, 2009) As in previous years, five observation blinds were set up two weeks before the counts were to take place.
Counters worked eight-hour shifts providing 24-hour coverage of the count areas for two days. Weather for both observation days was clear and mild (varying between 50-70 degrees F).
The results presented here are summary total results only, which counts from five and ten years ago provided for comparison. Detailed observation results will be available as soon as they are completed. We estimate that they will be available some time in the next two weeks.
Wilderness Summary
The wilderness observation area is a five-acre section of unimproved forest land. The most common trees in the area are maple, red oak, cedar, sweet gum, and hickory. The area also includes a small spring. The area is not enclosed by a fence or other man-made barrier.
The area is located eight miles from the nearest paved road and twelve miles from the nearest residence. Offroad vehicles were used to bring counters close to, but not entering, the count area. The nearest approach by off-road vehicles was one mile.
The table below lists the summary counts.
Though further research any analysis is needed, the drop in mourning dove and bobwhite quail counts could be significant. The detailed count data shows these numbers failing off each year.
Cultivated Land Summary
The cultivated land observation area is a five-acre section of cultivated land near the center of a 50-acre field.
The field is used to grow corn, wheat, soybeans, and clover, with the crop rotated annually. In the fifth year of the cycle, the field is left fallow.
The area is located two miles from the nearest paved road and one mile from the nearest residence. A storage barn is located at the southern border of the field.
The table below lists the summary counts.
Additional Notes
This project was initially scheduled to run for ten years, so we are currently in our last year. The committee needs to decide if it is worth the time and expense to continue the project. The landowners have experience that they would be happy to let us continue. Costs relating to the project is minimal and it does provide an opportunity to offer extra credit to students volunteering as counters.
A suggestion has been made by some committee members that we should increase the count frequency, counting on a quarterly schedule instead of an annual schedule. This would need to be coordinated with the owner of the cultivated field so that we do not interfere with planting or harvesting schedules.
Special Thanks
Once again, we would like to offer special thanks to:
We couldn't do this without you.
The spacing between words in the first two paragraphs is off. View only the tab and space formatting symbols to troubleshoot the problem. You do not need to remove the extra tabs or spaces.
Answer:
Explanation:
See the explanation below.
Explanation:
1. On the Home tab in the Paragraph group is a space and formatting symbol which is the Show/Hide button.
2. To toggle it on and off you select the space and formatting symbol it would be shaded when turned on.
References:
https://support.office.com/en-us/article/Show-or-hide-formatting-marks-c2d8a607-5646-4165-8b08- bd68f9d172a0
NEW QUESTION 26
SIMULATION
Project 3 of 7: Service
Overview
You are an administrative assistant for Fabrikam, Inc.'s Field Service division. You are preparing the monthly newsletter to be sent out to field service engineers.
Remember that mileage reimbursement claims must be submitted by the 15th of each month. Save the mileage form as a PDF file and email it to your regional supervisor.
Bonuses are Changing
New Depot Return Process
All offices have received the new tracking form for repair depot returns. Complete the following tasks when returning parts for repair:
Complete all fields in the Field Service section of the form.
Remove the top copy and file it in your office.
Securely attach the form to the part.
Package the part for shipment.
Ship to the home office and clearly label the box "For depot return".
All returns must be shipped to the home office to receive credit. The regional depots will close in two months and will not be accepting return shipments.
Vice President's Corner
NOTE TO SELF: If the VP doesn't provide content by Wednesday, delete this section and put in something generic about customer satisfaction.
Quarterly Results
NOTE TO SELF: This is a placeholder charter. Update the chart after the actual results are available on Monday.
Use the Go To feature to navigate to the Bookmark "OldNews" and delete the paragraph at that location.
Answer:
Explanation:
See the explanation below.
Explanation:
1. Click Bookmark from the Insert tab.
2. Click Name, to sort the list of bookmarks in the document.
3. Select "OldNews" from the list of bookmarks in the document then click Delete.
4. If a hyperlink has been inserted to the bookmark, right-click on the linked text, then select Remove Hyperlink.
References:
https://support.office.com/en-us/article/Add-or-delete-bookmarks-in-a-Word-document-or-Outlook-messagef68d781f-
0150-4583-a90e-a4009d99c2a0
NEW QUESTION 27
You work for Tailspin Toys. You are creating an internal product announcement and training document.
In the file properties , add ''animals'' as a category.
Answer:
Explanation:
Click the File tab.
Click Info.
Click Properties at the top of the page, and then select Advanced Properties.
Click the Custom tab.
In the Name box, type a name for the custom property, or select a name from the list.
In the Type list, select the data type for the property that you want to add.
In the Value box, type a value for the property. The value that you type must match the selection in the Type list. For example, if you select Number in the Type list, you must type a number in the Value box. Values that don't match the property type are stored as text.
Click OK.
NEW QUESTION 28
SIMULATION
Project 4 of 7: Member
Overview
You are preparing a letter to museum members announcing a new exhibit and urging them to renew their membership.
Use a Word feature to replace each occurrence of the text "patrons" with "members".
Answer:
Explanation:
See the explanation below.
Explanation:
1. Choose Replace from the Home tab.
OR
1. Press Ctrl+H
2. Type "patrons" in the Find what box.
3. Type "members" in the Replace with box.
4. Choose Replace All since each occurrence is required to be changed.
References:
https://support.office.com/en-us/article/Find-and-replace-text-c6728c16-469e-43cd-afe4-7708c6c779b7
NEW QUESTION 29
SIMULATION
Project 1 of 7: Observation
Overview
You are a member of the Barstow College Observation Project committee. You are preparing the initial summary report for this year's count, but have not received all of the data you need to complete the report.
Introduction
The multi-departmental Wildlife Observation Project has completed its wildlife population counts for this year.
The counts were made between May 5 and May 7 for both the wilderness and cultivated land areas. This is in line with the count periods for all previous years. The species used for the counts have been identified as common for the region (central Missouri) in which the counts were taken. (Author, 2009) As in previous years, five observation blinds were set up two weeks before the counts were to take place.
Counters worked eight-hour shifts providing 24-hour coverage of the count areas for two days. Weather for both observation days was clear and mild (varying between 50-70 degrees F).
The results presented here are summary total results only, which counts from five and ten years ago provided for comparison. Detailed observation results will be available as soon as they are completed. We estimate that they will be available some time in the next two weeks.
Wilderness Summary
The wilderness observation area is a five-acre section of unimproved forest land. The most common trees in the area are maple, red oak, cedar, sweet gum, and hickory. The area also includes a small spring. The area is not enclosed by a fence or other man-made barrier.
The area is located eight miles from the nearest paved road and twelve miles from the nearest residence. Offroad vehicles were used to bring counters close to, but not entering, the count area. The nearest approach by off-road vehicles was one mile.
The table below lists the summary counts.
Though further research any analysis is needed, the drop in mourning dove and bobwhite quail counts could be significant. The detailed count data shows these numbers failing off each year.
Cultivated Land Summary
The cultivated land observation area is a five-acre section of cultivated land near the center of a 50-acre field.
The field is used to grow corn, wheat, soybeans, and clover, with the crop rotated annually. In the fifth year of the cycle, the field is left fallow.
The area is located two miles from the nearest paved road and one mile from the nearest residence. A storage barn is located at the southern border of the field.
The table below lists the summary counts.
Additional Notes
This project was initially scheduled to run for ten years, so we are currently in our last year. The committee needs to decide if it is worth the time and expense to continue the project. The landowners have experience that they would be happy to let us continue. Costs relating to the project is minimal and it does provide an opportunity to offer extra credit to students volunteering as counters.
A suggestion has been made by some committee members that we should increase the count frequency, counting on a quarterly schedule instead of an annual schedule. This would need to be coordinated with the owner of the cultivated field so that we do not interfere with planting or harvesting schedules.
Special Thanks
Once again, we would like to offer special thanks to:
We couldn't do this without you.
Add a Status of "Requires committee review" to the document properties.
Answer:
Explanation:
See the explanation below.
Explanation:
1. Select the File tab and select Info.
2. Click on Properties at the top of the page and then select Advanced Properties.
3. Select the Custom tab.
4. In the Name box, select or type a name for the custom property, in this case it would be "Status".
5. In the Type list, select "Text".
6. In the Value box, type "Requires committee review", then click OK.
References:
https://support.office.com/en-us/article/View-or-change-the-properties-for-an-Office-file-21D604C2-481E-4379-
8E54-1DD4622C6B75
NEW QUESTION 30
Inspect the document and remove all headers, footers, and watermarks that are found, Do not remove other information.
Answer:
Explanation:
From the Info pane, click on Check for Issues and then select Inspect Document from the pop-up menu. When the Document Inspector dialog box appears, uncheck all boxes except Headers, Footers, and Watermarks. Click on Inspect. Simply click on Remove All to delete all headers, footers and watermarks in your document
Topic 2, Tailspin Toys
Dinosaurs



Favorite dinosaurs
Kids who love dinosaurs may have a long list of their favorites. We recommend you be prepared with your own list. You can reality excite a child of your list includes some lesser known dinosaurs. Your list gives children a chance to team something new, or to tell you what they know.
Try to have fun when you make your list1.
NEW QUESTION 31
You work for Contoso Pharmaceuticals. You are creating a report that describes a new medicine.
Check the document for accessibility issues. Correct the table-related issue reporting in the inspection results by using the first recommended action.
Do not fix other reporting issues.
Answer:
Explanation:
Select File > Info.
Select the Check for Issues button.
NEW QUESTION 32
SIMULATION
Project 4 of 7: Member
Overview
You are preparing a letter to museum members announcing a new exhibit and urging them to renew their membership.
Apply the WordArt style Gradient Fill - Gray to the text "Dinosaurs, Dinosaurs" located at the top of the document. Align the WordArt to the center of the document.
Answer:
Explanation:
See the explanation below.
Explanation:
1. Select the text "Dinosaurs, Dinosaurs".
2. Click on Insert, then select WordArt.
3. Choose WordArt style Gradient Fill - Gray as desired.
References:
https://support.office.com/en-us/article/Insert-WordArt-C5070583-1EBE-4DC4-A41F-5E3729ADCE54
NEW QUESTION 33
In the ''Making moments last forever1'' section, convert the five paragraphs starting with ''Corporate events'' to a bulleted list.
Answer:
Explanation:
Select the text you want to change into a list.
Go to Home> Bullets or Home> Numbering.
NEW QUESTION 34
In the " Description" section, use the 3D Models feature to insert the PillPack model from the 3D objects folder into the blank paragraph.
Position the model in Line with Text.
Answer:
Explanation:
On the Insert tab, in the Illustrations group, click 3D Models > From a File.
Navigate to where your 3D object is, select it and click Insert.
NEW QUESTION 35
SIMULATION
Project 2 of 7: Bakery Letter
Overview
As the marketing manager for Liberty's Delightful Sinful Bakery and Cafe, you want to inform local businesses that you will now be providing catering services.
December 31, 2018
CATERING SERVICES ARE NOW AVAILABLE
Dear Business Owner:
Liberty's Delightful Sinful Bakery and Cafe would like to inform you that beginning next month, we will be providing catering and delivery services in your area. We invite you to look over our lunch catering menu below, and contact us to schedule your next business meeting lunch.
The menu above is a small sample of the options we have available. Liberty's Delightful Sinful Bakery will impress you with excellent service and great food at an affordable price.
We look forward to hearing from you to cater your next meeting.
Sincerely,
Steve Lasker
Owner
Remove all personal information from the document.
Answer:
Explanation:
See the explanation below.
Explanation:
1. Create a copy of your original document by clicking on the File tab, and then Save As.
2. In the copy of the original document, select the File tab, then click on Info.
3. Click on Check for Issues, and then select Inspect Document.
4. In the Document Inspector dialog box, check the boxes to select the types of hidden content you want to be inspected, in this case it would be personal information and then click Inspect.
5. Review the results, then click Remove All next to the inspection results.
References:
https://support.office.com/en-us/article/Remove-hidden-data-and-personal-information-by-inspectingdocuments- presentations-or-workbooks-356b7b5d-77af-44fe-a07f-9aa4d085966f
NEW QUESTION 36
SIMULATION
Project 1 of 7: Observation
Overview
You are a member of the Barstow College Observation Project committee. You are preparing the initial summary report for this year's count, but have not received all of the data you need to complete the report.
Introduction
The multi-departmental Wildlife Observation Project has completed its wildlife population counts for this year.
The counts were made between May 5 and May 7 for both the wilderness and cultivated land areas. This is in line with the count periods for all previous years. The species used for the counts have been identified as common for the region (central Missouri) in which the counts were taken. (Author, 2009) As in previous years, five observation blinds were set up two weeks before the counts were to take place.
Counters worked eight-hour shifts providing 24-hour coverage of the count areas for two days. Weather for both observation days was clear and mild (varying between 50-70 degrees F).
The results presented here are summary total results only, which counts from five and ten years ago provided for comparison. Detailed observation results will be available as soon as they are completed. We estimate that they will be available some time in the next two weeks.
Wilderness Summary
The wilderness observation area is a five-acre section of unimproved forest land. The most common trees in the area are maple, red oak, cedar, sweet gum, and hickory. The area also includes a small spring. The area is not enclosed by a fence or other man-made barrier.
The area is located eight miles from the nearest paved road and twelve miles from the nearest residence. Offroad vehicles were used to bring counters close to, but not entering, the count area. The nearest approach by off-road vehicles was one mile.
The table below lists the summary counts.
Though further research any analysis is needed, the drop in mourning dove and bobwhite quail counts could be significant. The detailed count data shows these numbers failing off each year.
Cultivated Land Summary
The cultivated land observation area is a five-acre section of cultivated land near the center of a 50-acre field.
The field is used to grow corn, wheat, soybeans, and clover, with the crop rotated annually. In the fifth year of the cycle, the field is left fallow.
The area is located two miles from the nearest paved road and one mile from the nearest residence. A storage barn is located at the southern border of the field.
The table below lists the summary counts.
Additional Notes
This project was initially scheduled to run for ten years, so we are currently in our last year. The committee needs to decide if it is worth the time and expense to continue the project. The landowners have experience that they would be happy to let us continue. Costs relating to the project is minimal and it does provide an opportunity to offer extra credit to students volunteering as counters.
A suggestion has been made by some committee members that we should increase the count frequency, counting on a quarterly schedule instead of an annual schedule. This would need to be coordinated with the owner of the cultivated field so that we do not interfere with planting or harvesting schedules.
Special Thanks
Once again, we would like to offer special thanks to:
We couldn't do this without you.
Merge all cells in the bottom row of the table below the "Wilderness Summary" heading into one cell.
Answer:
Explanation:
See the explanation below.
Explanation:
1. Select the cells in the bottom row of the table below the "Wilderness Summary" which you want to merge.
2. Under Table Tools, on the Layout tab, in the Merge group, select Merge Cells.
OR
1. Select the cells in the bottom row of the table below the "Wilderness Summary" which you want to merge.
2. Right click and select Merge Cells.
References:
https://support.office.com/en-us/article/Merge-or-split-cells-in-a-table-8B458DEB-0FC5-4C8D-8D94-
2D4DA98193F8
NEW QUESTION 37
In the ''Serving'' section, change the text wrapping for the picture to Square.
Answer:
Explanation:
Select the picture.
Select Layout Options.
Select the layout you want.
NEW QUESTION 38
In the ''Event Package'' section, insert a footnote to the right of the heading. Enter the footnote text ''Includes digital files.''
Answer:
Explanation:
Click where you want to reference to the footnote or endnote.
On the References tab, select Insert Footnote or Insert Endnote.
Enter what you want in the footnote or endnote.
Return to your place in the document by double-clicking the number or symbol at the beginning of the note.
NEW QUESTION 39
In the ''Depaning'' section, insert a thermometer symbol before the phrase ''The muffin tray will still be hot!''. Use the Webdings font and character code ''225'' ( the thermometer symbol).
Answer:
Explanation:
You might want to insert a degree symbol when you write about temperatures or measurements in Word. You can do this by using the Symbol drop-down menu or the keyboard shortcut, Alt + 0176
NEW QUESTION 40
In the " Fill Material" section, resize the table so that each column is "2.2" ('5.59 cm") wide.
Answer:
Explanation:
Select your table.
On the Layout tab, in the Cell Size group, Resize column "2.2" wide.
NEW QUESTION 41
Change the orientation of only page 3 to Landscape.
Answer:
Explanation:
Place your cursor at the very beginning of the page that you would like to flip to landscape. ( ...
Select "Layout" or "Page Layout" > "Breaks" > "Next Page" to create a section.
Select the "Page Layout" tab and select "Orientation" > "Landscape".
NEW QUESTION 42
SIMULATION
Project 5 of 7: Housekeeping
Overview
You are helping to write training program modules for Contoso Suites. You are editing the second module for housekeeping associates.
Start of Shift
The first thing you should do when you start your shift is check your schedule. The shift supervisor will provide you with a printed schedule listing the rooms for which you are responsible, and a recommended order for cleaning the rooms. Unless an early cleaning is requested by the guest, check-out rooms are given priority so that we can prepare them for the next guests.
Use the inventory checklist attached to your cleaning cart to make sure that your cart is fully stocked before you begin your rounds.
Room Cleaning
When you are ready to clean a room, knock and announce yourself as "Housekeeping." Give the guest sufficient time to respond (10 to 15 seconds). If the guest does not respond, let yourself into the room and begin cleaning.
Start by cleaning the common room and sleeping areas. It is best to follow consistent steps when cleaning rooms. This will help to prevent you from missing anything. In the common room and sleeping area:
Pick up and dispose of any trash.
Empty trash cans.
If the guest has checked out, replace the sheets on each bed with fresh sheets.
Make the bed.
Leave a "Contoso Special Treat" on each pillow.
Dust all wooden furniture.
Clean the coffee station (if necessary) and restock coffee, cups, and condiment packs.
Vacuum the common room and sleeping areas.
Do not open the courtesy bar. Checking and restocking the courtesy bar is the shift supervisor's responsibility.
It is important that you give special attention to the restrooms. The most common guest complaint is about restroom cleanliness. We recommend a "top-down" cleaning method for restrooms:
Clean all mirrors.
Clean countertops and sinks.
If damp, wipe down the shower and shower curtain.
If necessary, replace toilet paper.
Replace used towels and wash cloths.
Pick up any trash and empty trash cans.
Sweep the restroom floor and mop if necessary.
Final Check
Make a final check of the room before leaving.
Are the lights turned off?
Are the TV and coffee station turned off?
Is all trash picked up and disposed of?
Is the restroom door closed?
Close the door firmly and make sure that it locks behind you. Text your supervisor with the room number.
End-of-Shift
When you are finished, dispose of all trash in the large receptacles. Drop all sheets, towels, and other lines into the laundry carts. Restock your cart so that it is ready for the next shift.
If you have more than 30 minutes left after you have completed your assigned rooms, contact your supervisor for additional assignments.
Add the watermark DO NOT COPY 1 to all pages.
Answer:
Explanation:
See the explanation below.
Explanation:
1. Select Watermark from the Design tab.
2. Choose DO NOT COPY 1 watermark from the pre-configured watermarks.
References:
https://support.office.com/en-us/article/Insert-a-watermark-f90f26a5-2101-4a75-bbfef27ef05002de# ID0EABBAAA=Windows_-_newer
NEW QUESTION 43
......
Guaranteed Success with Valid Microsoft MO-100 Dumps: https://www.testsdumps.com/MO-100_real-exam-dumps.html
