Microsoft Excel Expert (Excel and Excel 2019)
https://killexams.com/pass4sure/exam-detail/MO-201
Questi
The Na
Prev Leave Mark Mark
on: 49
vigation area at the bottom of the exam panel contains the following commands.
ious Task/Next Task. Saves your response and moves to the previous or next task in the current project. feedback after exam. Flags the task to indicate that you want to leave feedback about it after the exam. for review. Flags the task to indicate that you want to return to it before you finish the exam.
as complete. Flags the task to indicate that you feel you have completed the task.
ects that contain multiple tasks, you can switch between tasks by clicking the task tab, Next Task button, Previous Task button.
he instructions.
he “Employees” worksheet, create a macro named “Header”. Store the macro in the current workbook. ure the macro to insert the “Sheet Name” in the left header cell of the active page and the “Page Numbe eader cell.
In proj or
End of t From t
Config r” in the
right h
On the F
Under Customize the Ribbon and under Main Tabs, select the Developer check box. Record a macro
Question: 50
The Navigation area at the bottom of the exam panel contains the following commands.
Previous Task/Next Task. Saves your response and moves to the previous or next task in the current project. Leave feedback after exam. Flags the task to indicate that you want to leave feedback about it after the exam.
Mark for review. Flags the task to indicate that you want to return to it before you finish the exam. Mark as complete. Flags the task to indicate that you feel you have completed the task.
In projects that contain multiple tasks, you can switch between tasks by clicking the task tab, Next Task button, or Previous Task button.
End of the instructions.
On the “Sales Analysis” worksheet, insert a slicer that allows users to filter the PivotTable by “Category”. Then use the slicer to display only “Psychology” books.
on: 51
vigation area at the bottom of the exam panel contains the following commands.
ious Task/Next Task. Saves your response and moves to the previous or next task in the current project. feedback after exam. Flags the task to indicate that you want to leave feedback about it after the exam. for review. Flags the task to indicate that you want to return to it before you finish the exam.
as complete. Flags the task to indicate that you feel you have completed the task.
ects that contain multiple tasks, you can switch between tasks by clicking the task tab, Next Task button, Previous Task button.
he instructions.
Plan Analysis” worksheet, modify the PivotTable to group the data by the values in the “Full Package Group the values in steps of 100 beginning at 0 and ending at 200.
The slicer size and position do not matter.
Prev Leave Mark Mark
In proj or
End of t
On the “ Price”
column.
In the Grouping box, select Starting at and Ending at checkboxes, and edit the values if needed. (0 and 200 respectively)
Under By, enter a number that specifies the interval for each group. (100) Select OK.
Question: 52
The Navigation area at the bottom of the exam panel contains the following commands.
Previous Task/Next Task. Saves your response and moves to the previous or next task in the current project. Leave feedback after exam. Flags the task to indicate that you want to leave feedback about it after the exam. Mark for review. Flags the task to indicate that you want to return to it before you finish the exam.
Mark as complete. Flags the task to indicate that you feel you have completed the task.
In projects that contain multiple tasks, you can switch between tasks by clicking the task tab, Next Task button, or Previous Task button.
End of the instructions.
Sales Analysis” worksheet, insert a slicer that allows users to filter the PivotTable by “Category”. Then display only “Psychology” books.
cer size and position do not matter.
on: 53
vigation area at the bottom of the exam panel contains the following commands.
ious Task/Next Task. Saves your response and moves to the previous or next task in the current project. feedback after exam. Flags the task to indicate that you want to leave feedback about it after the exam. for review. Flags the task to indicate that you want to return to it before you finish the exam.
as complete. Flags the task to indicate that you feel you have completed the task.
ects that contain multiple tasks, you can switch between tasks by clicking the task tab, Next Task button, Previous Task button.
he instructions.
ork for Lucerne Publishing. You are compiling sales and royalty data for authors the company represents ure Excel to disable all macros in the workbook without notification.
On the “ use the
slicer to
The sli
Prev Leave Mark Mark
In proj or
End of t
You w .
Config
Click Trust Center, and then click Trust Center Settings. In the Trust Center, click Macro Settings.
Select the Disable all macros without notification option.
Click OK.
Question: 54
Add a header and the date for each of the columns (assignments) in the range. Cell B2.
Text "Date".
22-Aug, 29-Aug,…12-Dec"
Click cell D2. Type the text: 29-Aug Click cell C2, then shift-click cell D2.
Copy until cell S2 (by dragging from cell D2 to cell S2).
on: 55
nditional formatting.
Cell Range C2: S2 Text: "
Step 2:
Step 3:
Step 3:
Step 4:
Questi
Add co
Color Scales: Green CWhite-Red Color Scale Midpoint: Percentile, "70"
Maximum: Number, "25"
Step 3: On the Home tab, under Format, choose Conditional Formatting, and choose New Rule…
In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.
Step 4:
Step 5: In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.
on: 56
the cell format to date. nge C2:S2
4-Mar
location): English (United States)
Press down the Shift key and click in cell S2.
Questi Modify Cell ra Type: 1 Locale (
Step 2:
Step 3:
Step 4: On the Home tab, under Format, choose Format Cells.
In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Cl
Step 5: ick OK.
Question: 57
Apply a cell style
Cell range A2:S2 Style 40% – Accent3
On the Home tab, under Format, scroll down until you see 40% . Accent3, and click on it.
on: 58
the cell alignment settings. nge B3:B25
ntal: Right (Indent)
Right-click somewhere in the B3-B25 cell range, and choose Format Cells from the context menu.
Step 3: Press down the Shift key and click in cell S2. Step 4:
Questi Modify Cell ra Horizo
Step 2:
Step 3:
In the Format Cells dialog box click the Alignment Tab, change Horizontal: to Right (Indent), change I and then click the OK button.
Step 4: ndent:
to 1,