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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Chrisyuis. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.