CISM 2024/2025 PRACTICE EXAM 2 STUDY QUESTIONS
WITH CORRECT ANSWERS GUARANTEED PASS |
RATED A+
Use Consolidate to enter values in the selected cells by
... [Show More] 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.
Use Consolidate to create subtotals using the Sum function for values in the named range
ItemsOrdered. Include both the top row and left column labels. The named range ItemsOrdered
has been defined for you. The consolidation should show the subtotals only and not the details. -
Answer>>> On the Data tab, in the Data Tools group, click the Consolidate button. Type
ItemsOrdered in the Reference box. Click the Top row check box. Click the Left column check
box. Click OK.
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.
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. [Show Less]
