©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
CISM Practice Exam 1 Practice Questions and Answers (100% Pass)
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. -
Answer✔️✔️-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 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 to show just the subtotals. - Answer✔️✔️-Click the 2
outline symbol at the left of the column headings.
Use Goal Seek to find the value for cell D12 that will result in a value of $650,000
for cell B15. Accept the solution. - Answer✔️✔️-On the Data tab, in the Data Tools
group, click the What-If Analysis button, and click Goal Seek... Enter 650000 in
the To value box. Enter D12 in the By changing cell box. Click OK. Click OK.
Modify the number format so no decimal places are visible after the decimal point.
- Answer✔️✔️-On the Home tab, in the Number group, click the Decrease Decimal
button twice.
1
, ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
The 2016 data point in the Gross Profit data series has been selected. Change the
outline width to 2 1/4 pt. - Answer✔️✔️-On the Chart Tools Format tab, Shape
Styles group, click the Shape Outline button, point to Weight, and select 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 modify any of the column data formats. - Answer✔️✔️-Import
External Data - Text - StudentGPA - Okay - Okay
In cell E15, enter a formula to find the lowest line item cost this month (cells
E2:E14). - Answer✔️✔️-=MIN(Range)
Switch to the view that shows all the worksheet elements as they will print,
including headers and footers. - Answer✔️✔️-Page Layout mini button by Zoom
Slider
Modify the status bar so it displays the results of the MIN function for the selected
cells. - Answer✔️✔️-Right Click Status Bar (at bottom)
Cells D1:D6 have been cut. Insert them at the current worksheet location (cell C1).
- Answer✔️✔️-Home - Insert- Insert Cut Cells
2
CISM Practice Exam 1 Practice Questions and Answers (100% Pass)
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. -
Answer✔️✔️-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 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 to show just the subtotals. - Answer✔️✔️-Click the 2
outline symbol at the left of the column headings.
Use Goal Seek to find the value for cell D12 that will result in a value of $650,000
for cell B15. Accept the solution. - Answer✔️✔️-On the Data tab, in the Data Tools
group, click the What-If Analysis button, and click Goal Seek... Enter 650000 in
the To value box. Enter D12 in the By changing cell box. Click OK. Click OK.
Modify the number format so no decimal places are visible after the decimal point.
- Answer✔️✔️-On the Home tab, in the Number group, click the Decrease Decimal
button twice.
1
, ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
The 2016 data point in the Gross Profit data series has been selected. Change the
outline width to 2 1/4 pt. - Answer✔️✔️-On the Chart Tools Format tab, Shape
Styles group, click the Shape Outline button, point to Weight, and select 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 modify any of the column data formats. - Answer✔️✔️-Import
External Data - Text - StudentGPA - Okay - Okay
In cell E15, enter a formula to find the lowest line item cost this month (cells
E2:E14). - Answer✔️✔️-=MIN(Range)
Switch to the view that shows all the worksheet elements as they will print,
including headers and footers. - Answer✔️✔️-Page Layout mini button by Zoom
Slider
Modify the status bar so it displays the results of the MIN function for the selected
cells. - Answer✔️✔️-Right Click Status Bar (at bottom)
Cells D1:D6 have been cut. Insert them at the current worksheet location (cell C1).
- Answer✔️✔️-Home - Insert- Insert Cut Cells
2
