Level 4 Black Belt - Credential Exam - SIMnet | complete questions and correct answers | Score1 : 91.67% (55/60).

Excel 365/2025 - Level 4 Black Belt - Credential Exam - SIMnet https://odu.simnetonline.com/sp/assignments/simexams/results/9837343/1




Print Info

Student Name: FERRER, MARK

Student ID:

Username:




Level 4: Excel Black
Belt
Issued Feb 27, 2025

Click to Deleting
view full a
credential Refreshing credential
details. will send a from your
request to profile will
The
update remove the
assignment
the stored record
results are
info for from
currently
the Accredible.
private.
credential. You can
Click to
This will reclaim the
change
take time credential
this
to be later by
setting.
reflected going to
in the the
Student assignment
Portal. details
page.



Excel 365/2025 - Level 4 Black Belt - Credential Exam
COURSE NAME MBA 638 - Spreadsheet Modeling | Spring 2025 This page is printable


Submitted:02/27/202511:16 PMUS/Eastern


Score1 : 91.67% (55/60)
Attempt: 1
Questions: 60




# Question Points Correct? Submitted Answer


1 Add the Developer tab to the 1/1 You opened the backstage view, clicked the Options navigation
Ribbon. button, and clicked the Customize Ribbon tab. Inside the Excel
Options dialog, you checked the Developer check box, clicked the OK
button.


2 Use the Flash Fill command to 1/1 In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked
autofill the remaining cells in this the Flash Fill button.
column with the pattern from cell
F2.

, Excel 365/2025 - Level 4 Black Belt - Credential Exam - SIMnet https://odu.simnetonline.com/sp/assignments/simexams/results/9837343/1




# Question Points Correct? Submitted Answer


3 Enter a formula in cell H1 to 1/1 You clicked cell H1, typed in cell H1. In the Formulas Ribbon Tab in the
calculate the mean of the Function Library Ribbon Group, you clicked the Math & Trig button,
differences in cells E2:E13. clicked the More Functions button. You clicked cell H1, clicked the
H1 Cell Input. In the Formulas Ribbon Tab in the Function Library
Ribbon Group, you clicked the Math & Trig button, clicked the More
Functions button. In the More Functions menu in the Statistical menu,
you clicked the AVERAGE menu item. You selected the cell range
E2:E13. Inside the Function Arguments dialog, you clicked the OK
button.


4 Add a custom tab named Favorites 1/1 You opened the backstage view, clicked the Options navigation
to the Ribbon. Name the custom button, and clicked the Customize Ribbon tab. Inside the Excel
group Macros. Do not add an icon Options dialog, you clicked the New Tab button. Inside the Excel
for the group. Add the Options dialog from the Expression Elements Tree list, you collapsed
CreateQ1Chart macro to the new Favorites (Custom). Inside the Excel Options dialog, you clicked the
group. Rename... button. Inside the Rename dialog, you typed Favorites in
the Display name: input, clicked the OK button. Inside the Excel
Options dialog from the Expression Elements Tree list from the Icon List
list, you selected Macros (Custom). Inside the Excel Options dialog,
you clicked the Rename... button. Inside the Rename dialog, you
typed Macros in the Display name: input, clicked the OK button.
Inside the Excel Options dialog in the Macros drop-down, you selected
Macros. Inside the Excel Options dialog from the Expression Elements
Tree list from the Icon List list, you selected Macros (Custom). Inside
the Excel Options dialog from the Macros Options list, you selected
CreateQ1Chart. Inside the Excel Options dialog, you clicked the Add
>> button, clicked the OK button.


5 Use Goal Seek to find the value for 0/1 In the Data Ribbon Tab in the Forecast Ribbon Group, you clicked the
cell C2 that will result in a value of What-If Analysis button. In the What-If Analysis menu, you clicked
$550,000 for cell B15. Accept the the Goal Seek... menu item. Inside the Goal Seek dialog, you typed
solution. 500000 in the To value: input, pressed the Tab key, and pressed Tab.
You clicked cell C2. Inside the Goal Seek dialog, you typed c2 in the By
changing cell: input, pressed the Tab key, and clicked the OK button.
Inside the Goal Seek Status dialog, you clicked the OK button.


6 The Expenses data series has been 1/1 You launched the Chart Elements menu, launched the Chart
selected on this chart. Reset the Elements menu, and right clicked the Projections chart. In the Chart
data series line to match the chart Right-Click menu, you clicked the Reset to Match Style menu item.
style.


7 In cell B9, enter a formula using 1/1 In the Formulas Ribbon Tab in the Function Library Ribbon Group, you
NPV to calculate the present value clicked the Logical button, clicked the Financial button. In the
of a payment plan with variable Financial menu, you clicked the NPV menu item. Inside the Function
annual payments as shown in cells Arguments dialog, you typed b2 in the Rate input. You selected the
B11:B14. The interest rate is stored cell range B11:B14. Inside the Function Arguments dialog, you clicked
in cell B2. Use a cell range as a the OK button.
single Value argument.


8 Mark the workbook as final. 1/1 You opened the backstage view, clicked the Info navigation button,
and clicked the Protect Workbook button. In the Protect Workbook
menu, you clicked the Mark as Final menu item. Inside the Microsoft
Excel dialog, you clicked the OK button. Inside the Microsoft Excel
dialog, you clicked the OK button.