©BRIGHTSTARS EXAM SOLUTIONS
10/23/2024 11:19 PM
SIMnet- Practice Test Questions And
Answers 100% Pass
Set the print area - answer✔Click the back button. On the Page Layout tab, in the page Setup group,
click the Print Area button. Click Set Print Area
Create a new scenario to reflect a change in cell B8 to a value of 0.09 Name the scenario New Bonus -
answer✔On the Data tab, in the Forecast group, clcik the What if- Analysis button, and then clcik
scenario manager. Click the ADD button. Type New Bonus in the scenario name box. Click OK. Type 0.09
in the text box. Click ok
Convert the cell range to a table using table style Table Style Light 10 The table should include headers. -
answer✔On the Home tab, in the styles group, click the Format as table button
click Table Style Light 10 (Third style in second row under light styles)
Verify My table has headers checkbox is checked
click ok
Apply the Orange, Table Style Medium 3 Quick Style (third style in first row under medium) to this table
- answer✔On the table design tab, in the table styles group, clcik the quick styles button or clcik the
more button to expand the Table Styles gallery. Click Orange, Table Style Medium 3. It's the third style in
the first row under Medium styles
Insert a Clustered Column chart based on the first recommended chart type - answer✔Click the Quick
Analysis Tool button, and then click the Charts tab. Click Clustered Column
Enter a formula using DSUM to calculate the total value in the Total Spent column for rows that meet
the criteria in the crteria range A1:62. The database is defined by
the named range CustomersDB. - answer✔On the Formulas tab, in the Function Library group,
click the Insert Function button to open the Insert
Function dialog. Expand the Or select a category list
and select Database. Select DSUM, and click OK.
Enter CustomersDB in the Database arqument box.
, ©BRIGHTSTARS EXAM SOLUTIONS
10/23/2024 11:19 PM
In the Field argument box, enter "Total Spent". In
the Criteria argument box, enter A1:G2. Click OK
Enable filtering - answer✔on the home tab, in the editing group, click the sort and filter button and
select filter
Insert the current date in the selected cell. Do not include the current time - answer✔On the formulas
tab, in the Function Library group, click the Date and Time button. Click TODAY. Click ok
In cell H12 enter a formula to find the lowest percentage of items received in the order (cells H2:H11) -
answer✔On the Formulas tab, in the Function Library group, click the AutoSum arrow, and click Min.
Press Enter.
Modify the visits field to use the average function instead of Sum function - answer✔On the PivotTable
Tools Analyze tab, in the Active Field group, click the Field Settings button. Select Average . Click OK.
Create a scenario summary report. Accept the recommended results cells - answer✔On the data tab, in
the forecast group, click the What-if-analysis button, and click scenario manager. Click the summary
button. Click ok
Add another data series to the chart to represent the number of items ordered. Use the value of cell B1
as the series name and Cells b2:b4 as the series values. Do not rebuild the chart from scratch -
answer✔On the Chart Tools Design tab, in the Data group, click the Select Data button. In the Select
Data Source dialog, click the Add button. Click cell B1 to enter it in the Series name box. Click in the
Series values box and delete the default entry. Click and drag cells B2:B4. Click OK to add the new series.
Click OK to accept the change to the chart data source.
This worksheet does not include any total rows, and there are blank rows between groups if data.
Manually create groups of rows that can be expanded or collapsed as needed. Starter with the group of
selected cells - answer✔On the Data tab, in the Outline group, click the
Group button. In the Group dialog, Rows Is
selected by default. Click OK
Apply the Data bars conditional formatting option to the selected cells from the Quick Analysis tool -
answer✔Click the quick analysis tool button at the lower-right corner of the selection. On the formatting
tab, click the Data Bars button
Apply the conditioning formatting to the selected cells so cells with a value greater than 10 are
formatting using a yellow fill with dark yellow text - answer✔On the Home tab, in the styles group, click
the conditional formatting button. Point to Highlight Cells Rules, and click Greater Than.. type 10 in the
format cells that are greater than box. Expand the format selector box and select yellow fill with dark
yellow text. Click ok
, ©BRIGHTSTARS EXAM SOLUTIONS
10/23/2024 11:19 PM
Move the selected chart to a new chart sheet - answer✔On the chart tools design tab, in the location
group, click the Move Chart button click the New Sheet radio button then click ok
Filter the state column so only rows with MD are shown - answer✔On the Home tab, in the editing
group, clcik the sort and filter button and select filtter
click the arrows at the top of State column; click the (select all) check box to remove all checkmarks.
Click the check box in front of MD then click OK
Insert a Left Arrow block arrow shape to the right of the Jan column in the chart - answer✔On the insert
tab, click the illustrations button to open the Illustrations group
click the shapes button and select left arrow shape from the Blocks arrow section.
the cursor changes to a cross hair. click on the chart to the right of the Jan column
apply the colorful pallet 4 color scheme to the chart - answer✔On the Chart Tools Design tab, in the
Chart Styles group, click the Change Colors button. Click Colorful Palette 4, it is the fourth option in the
Colorful section.
Select the Items Received data series and apply the Intense Effect - Gold, Accent 4 shape style (the third
style from the right in the last row) - answer✔Click any data point in the Items Received series to select
the series. On the Chart Tools Format tab, Shape Styles group, click the More button to expand the
Shape Styles gallery. Select Intense Effect - Gold, Accent 4 shape style (the third style from the right in
the last row).
Sort the data so cells with 100% solid fill circle icon in the quantity in stock column appear on top -
answer✔On the Data tab, in the Sort & Filter group, click the Filter button to display the AutoFilter
arrows at the top of each column. Click the AutoFilter arrow at the top of the column. Point to Sort by
Color and click the solid fill circle icon
Add the DEVELOPER tab to the ribbon - answer✔Click File tab. Click Options to open the Excel Options
dialog. Click Customize Ribbon. At the right side of the Customize the Ribbon window, the Customize the
Ribbon list shows all the tab and groups available. Click the Developer check box to add the Developer
tab to the Ribbon. Click OKk
Apply the Sparkline Style Colorful #2 Quick Style to the selected Sparkline group. It is the second option
in the last row of the gallery.
Font Sizeuick Style to the selected Spark - answer✔On the Sparkline Tools Design tab, in the Style group,
click the More button. Click the second option in the last row of the gallery.
Change the color of the sheet tab for the November worksheet to Purple (the last option at the right in
the row of standard colors).
10/23/2024 11:19 PM
SIMnet- Practice Test Questions And
Answers 100% Pass
Set the print area - answer✔Click the back button. On the Page Layout tab, in the page Setup group,
click the Print Area button. Click Set Print Area
Create a new scenario to reflect a change in cell B8 to a value of 0.09 Name the scenario New Bonus -
answer✔On the Data tab, in the Forecast group, clcik the What if- Analysis button, and then clcik
scenario manager. Click the ADD button. Type New Bonus in the scenario name box. Click OK. Type 0.09
in the text box. Click ok
Convert the cell range to a table using table style Table Style Light 10 The table should include headers. -
answer✔On the Home tab, in the styles group, click the Format as table button
click Table Style Light 10 (Third style in second row under light styles)
Verify My table has headers checkbox is checked
click ok
Apply the Orange, Table Style Medium 3 Quick Style (third style in first row under medium) to this table
- answer✔On the table design tab, in the table styles group, clcik the quick styles button or clcik the
more button to expand the Table Styles gallery. Click Orange, Table Style Medium 3. It's the third style in
the first row under Medium styles
Insert a Clustered Column chart based on the first recommended chart type - answer✔Click the Quick
Analysis Tool button, and then click the Charts tab. Click Clustered Column
Enter a formula using DSUM to calculate the total value in the Total Spent column for rows that meet
the criteria in the crteria range A1:62. The database is defined by
the named range CustomersDB. - answer✔On the Formulas tab, in the Function Library group,
click the Insert Function button to open the Insert
Function dialog. Expand the Or select a category list
and select Database. Select DSUM, and click OK.
Enter CustomersDB in the Database arqument box.
, ©BRIGHTSTARS EXAM SOLUTIONS
10/23/2024 11:19 PM
In the Field argument box, enter "Total Spent". In
the Criteria argument box, enter A1:G2. Click OK
Enable filtering - answer✔on the home tab, in the editing group, click the sort and filter button and
select filter
Insert the current date in the selected cell. Do not include the current time - answer✔On the formulas
tab, in the Function Library group, click the Date and Time button. Click TODAY. Click ok
In cell H12 enter a formula to find the lowest percentage of items received in the order (cells H2:H11) -
answer✔On the Formulas tab, in the Function Library group, click the AutoSum arrow, and click Min.
Press Enter.
Modify the visits field to use the average function instead of Sum function - answer✔On the PivotTable
Tools Analyze tab, in the Active Field group, click the Field Settings button. Select Average . Click OK.
Create a scenario summary report. Accept the recommended results cells - answer✔On the data tab, in
the forecast group, click the What-if-analysis button, and click scenario manager. Click the summary
button. Click ok
Add another data series to the chart to represent the number of items ordered. Use the value of cell B1
as the series name and Cells b2:b4 as the series values. Do not rebuild the chart from scratch -
answer✔On the Chart Tools Design tab, in the Data group, click the Select Data button. In the Select
Data Source dialog, click the Add button. Click cell B1 to enter it in the Series name box. Click in the
Series values box and delete the default entry. Click and drag cells B2:B4. Click OK to add the new series.
Click OK to accept the change to the chart data source.
This worksheet does not include any total rows, and there are blank rows between groups if data.
Manually create groups of rows that can be expanded or collapsed as needed. Starter with the group of
selected cells - answer✔On the Data tab, in the Outline group, click the
Group button. In the Group dialog, Rows Is
selected by default. Click OK
Apply the Data bars conditional formatting option to the selected cells from the Quick Analysis tool -
answer✔Click the quick analysis tool button at the lower-right corner of the selection. On the formatting
tab, click the Data Bars button
Apply the conditioning formatting to the selected cells so cells with a value greater than 10 are
formatting using a yellow fill with dark yellow text - answer✔On the Home tab, in the styles group, click
the conditional formatting button. Point to Highlight Cells Rules, and click Greater Than.. type 10 in the
format cells that are greater than box. Expand the format selector box and select yellow fill with dark
yellow text. Click ok
, ©BRIGHTSTARS EXAM SOLUTIONS
10/23/2024 11:19 PM
Move the selected chart to a new chart sheet - answer✔On the chart tools design tab, in the location
group, click the Move Chart button click the New Sheet radio button then click ok
Filter the state column so only rows with MD are shown - answer✔On the Home tab, in the editing
group, clcik the sort and filter button and select filtter
click the arrows at the top of State column; click the (select all) check box to remove all checkmarks.
Click the check box in front of MD then click OK
Insert a Left Arrow block arrow shape to the right of the Jan column in the chart - answer✔On the insert
tab, click the illustrations button to open the Illustrations group
click the shapes button and select left arrow shape from the Blocks arrow section.
the cursor changes to a cross hair. click on the chart to the right of the Jan column
apply the colorful pallet 4 color scheme to the chart - answer✔On the Chart Tools Design tab, in the
Chart Styles group, click the Change Colors button. Click Colorful Palette 4, it is the fourth option in the
Colorful section.
Select the Items Received data series and apply the Intense Effect - Gold, Accent 4 shape style (the third
style from the right in the last row) - answer✔Click any data point in the Items Received series to select
the series. On the Chart Tools Format tab, Shape Styles group, click the More button to expand the
Shape Styles gallery. Select Intense Effect - Gold, Accent 4 shape style (the third style from the right in
the last row).
Sort the data so cells with 100% solid fill circle icon in the quantity in stock column appear on top -
answer✔On the Data tab, in the Sort & Filter group, click the Filter button to display the AutoFilter
arrows at the top of each column. Click the AutoFilter arrow at the top of the column. Point to Sort by
Color and click the solid fill circle icon
Add the DEVELOPER tab to the ribbon - answer✔Click File tab. Click Options to open the Excel Options
dialog. Click Customize Ribbon. At the right side of the Customize the Ribbon window, the Customize the
Ribbon list shows all the tab and groups available. Click the Developer check box to add the Developer
tab to the Ribbon. Click OKk
Apply the Sparkline Style Colorful #2 Quick Style to the selected Sparkline group. It is the second option
in the last row of the gallery.
Font Sizeuick Style to the selected Spark - answer✔On the Sparkline Tools Design tab, in the Style group,
click the More button. Click the second option in the last row of the gallery.
Change the color of the sheet tab for the November worksheet to Purple (the last option at the right in
the row of standard colors).
