CISM Practice Exam 2 Questions with Correct Answers

CISM Practice Exam 2 Questions with Correct Answers Use Consolidate to enter values in the selected cells by summing data from cells B3:D8 in the worksheets Uptown, Downtown, and City Center. Do not include links to the source data. - Answer-On the Data tab, in the Data Tools group, click the Consolidate button. Click in the Reference box and then click the Uptown worksheet tab. Click and drag to select B3:D8. Click the Add button. Click the Downtown worksheet tab. Click Add. Click the City Center worksheet tab. Click Add. Click OK. Use Consolidate to enter values in the selected cells by summing data from cells B3:D8 in the worksheets Telephone, Brick-n-Mortar, and Online. Include links to the source data to display subtotals. - Answer-On the Data tab, in the Data Tools group, click the Consolidate button. Click in the Reference box and then click the Telephone worksheet tab. Click and drag to select B3:D8. Click the Add button. Click the Brick-n-Mortar worksheet tab. Click Add. Click the Online worksheet tab. Click Add. Click the Create links to source data check box. Click OK. Add a hyperlink from the selected cell to link to cell A1 in the Inventory List worksheet. - Answer-On the Insert tab, in the Links group, click the Hyperlink button. Under Link to: click Place in this document. In the Or select a place in this document box, click Inventory List. Click OK. Insert a screenshot of the open Internet Explorer browser window showing employment statistics into this worksheet. Include a hyperlink with the image, but do not have Excel remember your choice. - Answer-On the Insert tab, click the Illustrations button to expand the Illustrations group. Click the Screenshot button. Click the first thumbnail in the gallery. Click Yes. Group together worksheets Q1-Q2 and Q3-Q4 so you can make changes to both at the same time. - Answer-Hold the Shift key and click the sheet tab labeled Q3-Q4. Remove the hyperlink from the selected cell. - Answer-Right-click and select Remove Hyperlink.