CISM PRACTICE EXAM 2 STUDY QUESTIONS WITH CORRECT ANSWERS GUARANTEED PASS | RATED A+

CISM PRACTICE EXAM 2 STUDY QUESTIONS WITH CORRECT ANSWERS GUARANTEED PASS | RATED A+

Encrypt the workbook with this password: password - Answer>>> Click the File tab. Click the
Protect Workbook button. Click Encrypt with Password. Type password. Click OK. Type
password in the Confirm Password dialog. Click OK.
Add a slicer to the PivotTable for the State field and use the slicer to show only data where the
value is VA. - Answer>>> On the PivotTable Tools Analysis tab, in the Sort & Filter group,
click the Insert Slicer button. In the Insert Slicers dialog, click the check box for State. Click OK.
In the slicer, click VA.
Apply the Pivot Style Dark 2 Quick Style to the PivotTable. - Answer>>> On the PivotTable
Tools Design tab, in the PivotTable Styles group, click the More button to expand the Quick
Styles gallery, and select Pivot Style Dark 2.
Ungroup the worksheets. - Answer>>> Click the Estimates worksheet tab.
Enter a formula using DAVERAGE to calculate the average value in the Total Spent column for
rows that meet the criteria in the criteria range A1:G2. 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 DAVERAGE, and click OK. Enter CustomersDB in the Database
argument box. In the Field argument box, enter "Total Spent". In the Criteria argument box, enter
A1:G2. Click OK.
Enter a formula in cell D1 using AVERAGEIFS to calculate the average price (use the named
range JunePrices) where the value in the JunePOs named range is equal to the value in cell D1
and the value in the JuneCompanies named range is equal to the text string "DermoMagic". -
Answer>>> On the Formulas tab, in the Function Library group, click the More Functions
button. Under Statistical, click AVERAGEIFS. In the Average_range argument box, type
JunePrices. In the Criteria_range1 argument box, type JunePOs. In the Criteria1 argument box,
type D1. In the Criteria_range2 argument box, type JuneCompanies. In the Criteria2 argument
box, type "DermoMagic". Click OK.
In cell D6, enter a formula using AND to display TRUE if the daily sales (cell C6) is greater than
the overall average (cell C3) and the daily sales (cell C6) is greater than the employee's average
(cell C4). Use cell references and enter the arguments exactly as described in this question. -
Answer>>> On the Formulas tab, in the Function Library group, click the Logical button. Click
AND. In the Logical1 argument box, enter C6>C3. In the Logical2 argument box, enter C6>C4.
Click OK.