Verified MO-200 dumps Q&As - 100% Pass from PrepAwayETE
Pass MO-200 Exam in First Attempt Guaranteed 2022 Dumps!
NEW QUESTION 17
On the ''Authors'' worksheet, in the ''Bonus'' column, use a function to display ''500'' if the ; Books Sold' is greater than 10,000. Otherwise, display ''100''.
Check the Solution below.
Answer:
Explanation:
=IF(books sold>10,000, "500", "100"). Select and drag to apply to other rows
NEW QUESTION 18
On the ''Prices'' worksheet, in the ''inventory Notice'' column, use a function to display ''Low'' if the '' inventory Level % is below 15%. Otherwise, leave the ''Inventory Notice'' blank.
Check the Solution below.
Answer:
Explanation:
=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
Topic 3, Class ScheduleCase Study
Exhibit.
NEW QUESTION 19
On the ''Last Semester'' worksheet, remove the table row that contains '' Agriculture'' data. Do not change outside the table.
Check the Solution below.
Answer:
Explanation:
On the home tab, click find and select and click find. Type agriculture and press find all. Select all and then delete them with the home tab by clicking delete sheet rows.
NEW QUESTION 20
On the ''Orders'' worksheet, filter the table data to display only the orders from ''Alpine SKI House.'' Check the Solution below.
Answer:
Explanation:
On the data tab, click filter. Display only alpine.
NEW QUESTION 21
On the ''Inventory' chart sheet, insert a chart title above the chart, at the top of the plot area. Display the percentage values as data labels to the right of each data bar.
Check the Solution below.
Answer:
Explanation:
Click chart, press layout, click chart title and add it. Press add chart element, data labels, more detailed options, uncheck value and check percentage.
NEW QUESTION 22
On the ''Enrollment Summary'' worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.
Check the Solution below.
Answer:
Explanation:
Click and press chart design. Press chart 7. Click change colors.
NEW QUESTION 23
On the 'Comparison' chart sheet, swap the data the axis.
Check the Solution below.
Answer:
Explanation:
Right click and open axis options. Check the box that says values in reverse order.
NEW QUESTION 24
On the ''New Policies'' worksheet, add a Total Row to the table. Configure the Total Row to display the number of new policies for each month and for the 6-month total.
Check the Solution below.
Answer:
Explanation:
Click design and press total row. Click and drag.
NEW QUESTION 25
On the ''Contact'' worksheet, in the ''Email Address'' column, use a functional to construct email addresses for each person using the first name and ''@humongousinsurance.com,'' Check the Solution below.
Answer:
Explanation:
=LOWER(LEFT(FIRST), LAST), "@domain.com"
NEW QUESTION 26
You are revising a sales summary report for Northwind Traders.
On the ''Summary'' worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ''$5,000,000.'' Check the Solution below.
Answer:
Explanation:
Conditional formatting, highlight cell rules, greater than and then pick the color.
Topic 2, Clothing Orders
Exhibit.
NEW QUESTION 27
On the ''Instructional Hours'' worksheet, adjust the width of columns B,G to exactly 12.
Check the Solution below.
Answer:
Explanation:
Home tab, cells group, click format. Click column width.
NEW QUESTION 28
On the ''Instructional Hours'' worksheet, modify the chart to display ''Hours'' as the Primary Vertical Axis Title.
Check the Solution below.
Answer:
Explanation:
Click on the green plus sign and press axis titles.
NEW QUESTION 29
You are updating the sales spreadsheet for an online clothing store.
On the "Quote'' worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.
Check the Solution below.
Answer:
Explanation:
Select and press delete on the home tab.
NEW QUESTION 30
......
One of the most important things that you need to know about the Microsoft MO-200 exam is that it consists of many topics that you need to learn. They are the following:
- Manage Worksheets & Workbooks: The first domain makes up 10-15% of the exam content. The subdomains include the details of the import of data into workbooks, navigation within workbooks, formatting of worksheets and workbooks, customization of options and views, as well as configuration of the content for collaboration;
- Manage Data Cells & Ranges: The next area constitutes 20-25% of the entire content. The information covered here include the manipulation of data in worksheets, formatting of cells and ranges, reference of named ranges, and summarization of data visually;
- Manage Charts: The last subject area makes up the remaining 20-25% of the exam questions. To successfully deal with it, you need to learn all about the ways of creating charts, modifying them, and formatting.
- Manage Tables & Table Data: As for this section, it makes up 15-20% of the exam content. It will evaluate your skills in creating, formatting, and modifying tables as well as filtering and sorting the table data;
- Perform Operations with the Use of Formulas & Functions: This objective makes up 20-25% of the whole content. It covers the insertion of references, calculation and transformation of data, as well as formatting and modification of text;
MO-200 Exam topics
Candidates must know the EPM topics before they start of preparation because it will really help them solving the problems. Our MO-200 practice test and CAU-305 practice exams will include the following topics. These are covered in our CAU-305 exam dumps.
Manage worksheets and workbooks (10-15%)
- Search for data within a workbook
- Navigate within workbooks
- Set a print area
- Import data from .csv files
- Configure print settings
- Format worksheets and workbooks
- Import data from .txt files
- Display formulas
- Modify page setup
- Navigate to named cells, ranges, or workbook elements
- Freeze worksheet rows and columns
- Customize headers and footers
- Inspect workbooks for issues
- Display and modify workbook content in different views
- Import data into workbooks
Manage data cells and ranges (20-25%)
- Merge and unmerge cells
- Insert and delete cells
- Insert Sparklines
- Remove conditional formatting
- Fill cells by using Auto Fill
- Define a named range
- Clear cell formatting
- Apply cell styles
- Manipulate data in worksheets
- Wrap text within cells
- Modify cell alignment, orientation, and indentation
- Name a table
- Apply cell formats from the Format Cells dialog box
- Summarize data visually
- Paste data by using special paste options
- Apply number formats
- Format cells by using Format Painter
- Format cells and ranges
Manage tables and table data (15-20%)
- Create and format tables
- Apply table styles
- Insert and configure total rows
- Sort data by multiple columns
- Create Excel tables from cell ranges
- Filter records
Perform operations by using formulas and functions (20-25%)
- Format text by using UPPER(), LOWER(), and LEN() functions
- Reference named ranges and named tables in formulas
- Calculate and transform datas
- Insert relative, absolute, and mixed references
- Format text by using the CONCAT() and TEXTJOIN() functions
- Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
- Insert references
- Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
- Format and modify text
- Format text by using RIGHT(), LEFT(), and MID() functions
Manage charts (20-25%)
- Apply chart styles
- Create charts
- Create chart sheets
- Switch between rows and columns in source data
- Add alternative text to charts for accessibility
MO-200 Dumps Full Questions - Exam Study Guide: https://www.prepawayete.com/Microsoft/MO-200-practice-exam-dumps.html