Black Belt Exam questions and
answers already passed
Clear the selected Sparklines from the worksheet. - correct answer ✔✔ You pressed the Ctrl + C
keyboard shortcut. In the Design Ribbon Tab in the Group Ribbon Group, you clicked the Clear
button.
Enter a formula in cell E2 to calculate the absolute value of C2-D2. - correct answer ✔✔ In the
Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Math & Trig button.
In the Math & Trig menu, you clicked the ABS menu item. Inside the Function Arguments dialog,
you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell C3,
clicked cell C2. Inside the Function Arguments dialog, you typed C2- in the Number input. You
clicked cell D2. Inside the Function Arguments dialog, you clicked the OK button.
Add a timeline to the PivotTable to filter the data by values in the Date field. Use the timeline to
filter the PivotTable to show only dates in April. - correct answer ✔✔ In the Analyze Ribbon Tab
in the Filter Ribbon Group, you clicked the Insert Timeline button. Inside the Insert Timelines
dialog, you checked the Date check box, clicked the OK button. You clicked the April segment.
In cell B10, enter a formula using NPER to calculate how many payments will be due on the loan
if the monthly payment is increased to the amount in cell B8. Notice that the payment is already
expressed as a negative value. The annual interest rate is in cell B3. The current value of the
loan is in cell B2. Payments will be made at the beginning of every period. - correct answer ✔✔
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Financial
button. In the Financial menu, you clicked the NPER menu item. Inside the Function Arguments
dialog, you typed B3/12 in the Rate input, pressed the Tab key, typed B8 in the Pmt input, typed
B2 in the Pv input, pressed the Tab key, pressed Tab, pressed the Tab key, typed 1 in the Type
input, and pressed the Enter key.
Install the Solver add-in. - correct answer ✔✔ You opened the backstage view, clicked the
Options navigation button, clicked the Add-Ins tab, and clicked Cell 9x0. Inside the Excel Options
, dialog, you clicked the Go... button. Inside the Add-ins dialog from the Available Add-Ins list, you
selected Solver Add-in, selected Solver Add-in. Inside the Add-ins dialog, you checked the Solver
Add-in check box, clicked the OK button.
Modify this picture so a blind person using a screen reader will know that it is decorative only
and does not include important information. - correct answer ✔✔ You right-clicked the
undefined SmartArt. In the Format Ribbon Tab in the WordArt Styles Ribbon Group, you clicked
the Text Effects button, clicked the Text Outline button arrow. You right-clicked the undefined
SmartArt. In the SmartArt Right-Click menu, you clicked the Edit Alt Text... menu item. Inside the
Alt Text dialog, you checked the Mark as Decorative check box.
Display all the comments in this worksheet at once. - correct answer ✔✔ In the Review Ribbon
Tab in the Comments Ribbon Group, you clicked the Show Comments button.
The total row for each expense category uses a SUM function to total the costs. Create an
automatic outline from the rows in this data range. - correct answer ✔✔ In the Mini Toolbar,
you clicked the Group button arrow. In the Group menu, you clicked the Auto Outline menu
item.
Display the Accessibility Checker task pane. - correct answer ✔✔ You clicked cell E6. In the
Review Ribbon Tab in the Accessibility Ribbon Group, you clicked the Check Accessibility button.
Split the selected text into separate columns using tab as the delimiter. - correct answer ✔✔ In
the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Text To Columns button.
Inside the Convert Text to Columns Wizard dialog, you clicked the Next button, checked the Tab
check box, clicked the Next button, and clicked the Finish button.
Create a Forecast Sheet based on the selected data. Use a line chart and forecast values through
2025. - correct answer ✔✔ In the Data Ribbon Tab in the Forecast Ribbon Group, you clicked
the Forecast Sheet button. Inside the Create Forecast Worksheet dialog, you clicked the Create
button.
answers already passed
Clear the selected Sparklines from the worksheet. - correct answer ✔✔ You pressed the Ctrl + C
keyboard shortcut. In the Design Ribbon Tab in the Group Ribbon Group, you clicked the Clear
button.
Enter a formula in cell E2 to calculate the absolute value of C2-D2. - correct answer ✔✔ In the
Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Math & Trig button.
In the Math & Trig menu, you clicked the ABS menu item. Inside the Function Arguments dialog,
you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell C3,
clicked cell C2. Inside the Function Arguments dialog, you typed C2- in the Number input. You
clicked cell D2. Inside the Function Arguments dialog, you clicked the OK button.
Add a timeline to the PivotTable to filter the data by values in the Date field. Use the timeline to
filter the PivotTable to show only dates in April. - correct answer ✔✔ In the Analyze Ribbon Tab
in the Filter Ribbon Group, you clicked the Insert Timeline button. Inside the Insert Timelines
dialog, you checked the Date check box, clicked the OK button. You clicked the April segment.
In cell B10, enter a formula using NPER to calculate how many payments will be due on the loan
if the monthly payment is increased to the amount in cell B8. Notice that the payment is already
expressed as a negative value. The annual interest rate is in cell B3. The current value of the
loan is in cell B2. Payments will be made at the beginning of every period. - correct answer ✔✔
In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Financial
button. In the Financial menu, you clicked the NPER menu item. Inside the Function Arguments
dialog, you typed B3/12 in the Rate input, pressed the Tab key, typed B8 in the Pmt input, typed
B2 in the Pv input, pressed the Tab key, pressed Tab, pressed the Tab key, typed 1 in the Type
input, and pressed the Enter key.
Install the Solver add-in. - correct answer ✔✔ You opened the backstage view, clicked the
Options navigation button, clicked the Add-Ins tab, and clicked Cell 9x0. Inside the Excel Options
, dialog, you clicked the Go... button. Inside the Add-ins dialog from the Available Add-Ins list, you
selected Solver Add-in, selected Solver Add-in. Inside the Add-ins dialog, you checked the Solver
Add-in check box, clicked the OK button.
Modify this picture so a blind person using a screen reader will know that it is decorative only
and does not include important information. - correct answer ✔✔ You right-clicked the
undefined SmartArt. In the Format Ribbon Tab in the WordArt Styles Ribbon Group, you clicked
the Text Effects button, clicked the Text Outline button arrow. You right-clicked the undefined
SmartArt. In the SmartArt Right-Click menu, you clicked the Edit Alt Text... menu item. Inside the
Alt Text dialog, you checked the Mark as Decorative check box.
Display all the comments in this worksheet at once. - correct answer ✔✔ In the Review Ribbon
Tab in the Comments Ribbon Group, you clicked the Show Comments button.
The total row for each expense category uses a SUM function to total the costs. Create an
automatic outline from the rows in this data range. - correct answer ✔✔ In the Mini Toolbar,
you clicked the Group button arrow. In the Group menu, you clicked the Auto Outline menu
item.
Display the Accessibility Checker task pane. - correct answer ✔✔ You clicked cell E6. In the
Review Ribbon Tab in the Accessibility Ribbon Group, you clicked the Check Accessibility button.
Split the selected text into separate columns using tab as the delimiter. - correct answer ✔✔ In
the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Text To Columns button.
Inside the Convert Text to Columns Wizard dialog, you clicked the Next button, checked the Tab
check box, clicked the Next button, and clicked the Finish button.
Create a Forecast Sheet based on the selected data. Use a line chart and forecast values through
2025. - correct answer ✔✔ In the Data Ribbon Tab in the Forecast Ribbon Group, you clicked
the Forecast Sheet button. Inside the Create Forecast Worksheet dialog, you clicked the Create
button.
