microsoft mo-201 practice test
Microsoft Excel Expert (Excel and Excel 2019)
Question 1 Topic 6, Tailspin Toys
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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 New Products worksheet, create a Histogram chart that shows the Retail Price of the products in bins with widths
of $10.
The chart size and position do not matter.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Exhibit 6 (exhibit):
Answer:
See explanation below.
Explanation:
1. Select your data.
2. Click Insert > Insert Statistic Chart > Histogram.
3. Right-click the horizontal axis of the chart, click Format Axis, and then click Axis Options.
4. Use the information in the following table to decide which options you want to set in the Format Axis task pane.
Reference:
https://support.microsoft.com/en-us/office/create-a-histogram-85680173-064b-4024-b39d-80f17ff2f4e8
Question 2 Topic 6, Tailspin Toys
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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 Retail worksheet, display arrows that indicate the cell values that are dependent on the value in C4.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Exhibit 6 (exhibit):
Answer:
See explanation below.
Explanation:
Select the cell for which you want to identify the dependent cells.
2. To display a tracer arrow to each cell that is dependent on the active cell, on the Formulas tab, in the Formula Auditing
group, click Trace Dependents
Blue arrows show cells with no errors. Red arrows show cells that cause errors. If the selected cell is referenced by a cell on
another worksheet or workbook, a black arrow points from the selected cell to a worksheet icon
The other workbook must be open before Excel can trace these dependencies.
Reference:
https://support.microsoft.com/en-us/office/display-the-relationships-between-formulas-and-cells-a59bef2b-3701-46bf-8ff1-
d3518771d507
Question 3 Topic 6, Tailspin Toys
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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 Employees worksheet, in cell F4, enter a formula that returns the employees bonus from the Years of Service
Bonus table.
Adjust the formula and then copy it to cells F5:F19.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Exhibit 6 (exhibit):
Answer:
See explanation below.
Explanation:
Select cell F4.
Enter the following formula:=INDEX($I$2:$I$7,MATCH(B4,$H$2:$H$7,1),1) Press Enter.
Reference:
https://trumpexcel.com/index-match/
Question 4 Topic 6, Tailspin Toys
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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.
You are creating a product workbook for Tailspin Toys.
On the Inventory worksheet, use an Excel feature to remove the duplicate records from the Products cell range.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Exhibit 6 (exhibit):
Answer:
See explanation below.
Explanation:
1. Select the range of cells that has duplicate values you want to remove.
2. Click Data > Remove Duplicates.
3. Under Columns, check only the Products column.
4. Click OK.
Reference: https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-
66a552dc138d
Question 5 Topic 5, VanArsdel Limited
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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 Regional Sales worksheet, modify the PivotTable to display the Territory rows within each region.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Answer:
See explanation below.
Explanation:
Click anywhere in the PivotTable to display the Field List.
Check the box next to Territory, and it should be added to the Rows area by default. The PivotTable should now be
displaying Territory rows within each region.
Reference:
https://support.microsoft.com/en-us/office/use-the-field-list-to-arrange-fields-in-a-pivottable-43980e05-a585-4fcd-bd91-
80160adfebec
Topic 6, Tailspin Toys
Question 6 Topic 5, VanArsdel Limited
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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 Summary worksheet, create one chart that displays each representatives Total Sales as an Area chart and
the Grand Total Percentage as a secondary axis Line chart.
The chart size and position do not matter.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Answer:
See explanation below.
Explanation:
1. Select the range.
2. On the Insert tab, in the Charts group, click the Combo symbol.
3. Click Create Custom Combo Chart.
The Insert Chart dialog box appears.
4. For the Total Sales series, choose Area as the chart type.
5. For the Grand Total Percentage series, choose Line as the chart type.
6. Plot the Grand Total Percentage series on the secondary axis.
7. Click OK.
Reference: https://www.excel-easy.com/examples/combination-chart.html
Question 7 Topic 5, VanArsdel Limited
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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 Year-to-Date Sales worksheet, in cells L5:L15, enter a formula that returns the average Total Sales for the region
in cell J5 and the Representative in cell K5.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Answer:
See explanation below.
Explanation:
Click in Cell L5, and select Formulas from the ribbon.
Click on the arrow of the AutoSum button in the Function Library section, and select Average. Click on Cell H4, H5, H6, then
press Enter.The formula should look like this:=AVERAGE(H4,H5,H6)
Reference:
https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6
Question 8 Topic 5, VanArsdel Limited
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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 Conference worksheet, configure cells A4:A12 to allow only whole numbers from 1 to 9. Otherwise, display a
Stop error with the title Invalid and the message 1 to 9.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Answer:
See explanation below.
Explanation:
1. Select the cell(s) you want to create a rule for.
2. Select Data >Data Validation.
3. On the Settings tab, under Allow, select an option:
Whole Number - to restrict the cell to accept only whole numbers.
Decimal - to restrict the cell to accept only decimal numbers.
List - to pick data from the drop-down list.
Date - to restrict the cell to accept only date.
Time - to restrict the cell to accept only time.
Text Length - to restrict the length of the text.
Custom for custom formula.
4. Under Data, select a condition:
between not between equal to not equal to greater than less than
greater than or equal to less than or equal to
5. On the Settings tab, under Allow, select an option:
6. Set the other required values, based on what you chose for Allow and Data. For example, if you select between, then
select the Minimum: and Maximum: values for the cell(s).
7. Select the Ignore blank checkbox if you want to ignore blank spaces.
8. If you want to add a Title and message for your rule, select the Input Message tab, and then type a title and input
message.
9. Select the Show input message when cell is selected checkbox to display the message when the user selects or hovers
over the selected cell(s).
10. Select OK.Now, if the user tries to enter a value that is not valid, a pop-up appears with the message, This value doesnt
match the data validation restrictions for this cell.
Reference: https://support.microsoft.com/en-us/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-
eff3ce5f7249?ui=en-us&rs=en-us&ad=us
Question 9 Topic 5, VanArsdel Limited
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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.
You are creating a workbook for VanArsdel Limiteds annual sales meeting.
Require that users enter the password P@ssword before they can make structural changes to the workbook.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Exhibit 3 (exhibit):
Exhibit 4 (exhibit):
Exhibit 5 (exhibit):
Answer:
See explanation below.
Explanation:
1. Click Review > Protect Workbook.
2. Enter a password in the Password box.
3. Click OK, and retype the password to confirm it, and then click OK.
Reference:
https://support.microsoft.com/en-us/office/protect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517
Question 10 Topic 4, Ski Lessons
SIMULATION
Instructions
nvironment
nterface and Controls
The exam panel provides access to the project task(s). Each project has an associated file in which you will perform the
project tasks.
1. Project file
2. Split bar
3. Exam panel
You can modify the exam interface to fit your needs in the following ways:
To increase or decrease the exam panel font size, press Ctrl+Plus or Ctrl+Minus.
To change the height of the exam panel, drag the split bar between the project file and the exam panel.
To minimize the exam panel, click the Collapse Panel arrow
in the upper-left corner of the exam panel. The minimized
exam panel displays the Expand Panel button, the project number and name, the remaining time, and the Restart Project
and Submit Project buttons. To move between tasks, you must expand the exam panel. To restore the interface to the
default appearance, click the Restore button near the upper-right corner of the exam panel.
4. The Information bar at the top of the exam panel displays the current project and total number of projects, the remaining
exam time, and the following commands: Collapse Panel. Minimizes the exam panel to provide more space for the project
file.
Restart Project. Closes and reopens the current project file without saving your changes.
Submit Project. Saves your changes, submits the project file, and moves to the next project.
Calculator. A calculator is available in some exams. You are not required to use the calculator.
Restore. Restores the size and position of the project file and exam panel to the defaults. Help. Displays information about
the exam interface.
5. The Content area displays the task tabs and the current task description.
6. 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.
This project has only one task.
Configure Excel to automatically evaluate formulas only when a workbook is saved, and not each time data changes.
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):
Answer:
See explanation below.
Explanation:
1. Click File in the ribbon.
2. And then click Options.
3. In the Excel Options, choose the Formulas.
4. And then in the Calculation Options, check the option Manual.
5. Check the Recalculate workbook before saving option.
6. And then click OK in the window.
7. Next save the workbook.
Reference: https://www.datanumen.com/blogs/prevent-excel-auto-calculating-updating-data-workbook/
Topic 5, VanArsdel Limited