2025-2026 CISM Practice Exam 1 With
Complete Solutions
The Anne Cole data point has been selected for you. Rotate the pie chart exactly 200° so
this data point appears at the left side of the chart near the legend. - SOLUTION On the
Chart Tools Format tab, in the Current Selection group, click the Format Selection
button to open the Format Data Point task pane. In the Angle of first slice box, type the
200 and press Enter.
Convert the table back to a normal range. - ANSWER On the Table Tools Design tab, in
the Tools group, click the Convert to Range button. Click Yes.
Collapse the entire outline so that just the subtotals appear. - ANSWER Click the 2
outline symbol at the left of the column headings.
Goal Seek - Use Goal Seek to determine what value needs to be in cell D12 to make the
value in cell B15 equal to $650,000. Accept the solution. ANSWER On the Data tab, in
the Data Tools group, click the What-If Analysis button and click Goal Seek. In the To
value box, enter 650000 In the By changing cell box, enter D12 Click OK Click OK.
Change the number format to display no decimal places to the right of the decimal point.
ANSWER On the Home tab, in the Number group, click Decrease Decimal twice.
The data point for 2016 in the Gross Profit series is selected. Apply a 2 1/4 pt outline
width. - ANSWER On the Chart Tools Format tab, Shape Styles group click the Shape
Outline button then under Weight click 2 1/4 pt.
Import data from the text file StudentGPA into the selected cell in the current worksheet.
Data in the file are delimited by commas, and the file does include a header row. Do not
change any of the column data formats. ANSWER Import External Data - Text -
StudentGPA - OK - OK
Complete Solutions
The Anne Cole data point has been selected for you. Rotate the pie chart exactly 200° so
this data point appears at the left side of the chart near the legend. - SOLUTION On the
Chart Tools Format tab, in the Current Selection group, click the Format Selection
button to open the Format Data Point task pane. In the Angle of first slice box, type the
200 and press Enter.
Convert the table back to a normal range. - ANSWER On the Table Tools Design tab, in
the Tools group, click the Convert to Range button. Click Yes.
Collapse the entire outline so that just the subtotals appear. - ANSWER Click the 2
outline symbol at the left of the column headings.
Goal Seek - Use Goal Seek to determine what value needs to be in cell D12 to make the
value in cell B15 equal to $650,000. Accept the solution. ANSWER On the Data tab, in
the Data Tools group, click the What-If Analysis button and click Goal Seek. In the To
value box, enter 650000 In the By changing cell box, enter D12 Click OK Click OK.
Change the number format to display no decimal places to the right of the decimal point.
ANSWER On the Home tab, in the Number group, click Decrease Decimal twice.
The data point for 2016 in the Gross Profit series is selected. Apply a 2 1/4 pt outline
width. - ANSWER On the Chart Tools Format tab, Shape Styles group click the Shape
Outline button then under Weight click 2 1/4 pt.
Import data from the text file StudentGPA into the selected cell in the current worksheet.
Data in the file are delimited by commas, and the file does include a header row. Do not
change any of the column data formats. ANSWER Import External Data - Text -
StudentGPA - OK - OK
