Exam (elaborations)
CISM Practice Exam 2 With Complete Solutions Latest Update
- Course
- Institution
CISM Practice Exam 2 With Complete Solutions Latest Update...
[Show more]
Content preview
CISM Practice Exam 2 With Complete SolutionsLatest Update
Use Consolidate to fill the selected cells by summing data from cells B3:D8 on the
Uptown, Downtown, and City Center worksheets Do not create links to the source data.
- ANSWER On the Data tab, in the Data Tools group, click the Consolidate button Click in
the Reference box 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 and Fill the selected cells with Values by summing up data from cells
B3:D8 in the works sheets Telephone, Brick-n-Mortar, and Online. Create 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. 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.
Insert a hyperlink from the active cell to cell A1 in the Inventory List worksheet.
ANSWER On the Insert tab, in the Links group, click the Hyperlink button. Beneath 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 the worksheets Q1-Q2 and Q3-Q4 so that you can make changes to both
simultaneously. - ANSWER Hold the Shift key and click the sheet tab labeled Q3-Q4.
Remove the hyperlink from the selected cell. - ANSWER Right-click and choose Remove
, Hyperlink.
Use Consolidate to create subtotals using the Sum function for values in the named
range ItemsOrdered. Both the top row and left column labels should be included. The
range of cells has been named ItemsOrdered for you. The consolidation should display
the subtotals only without showing the details. - ANSWER On the Data tab, in the Data
Tools group, click the Consolidate button. In the Reference box, type ItemsOrdered
Click the Top row check box. Click the Left column check box. Click OK.
Unhide the worksheets. - ANSWER Click the Estimates worksheet tab.
Click cell E7 and then insert a formula using DAVERAGE to determine the average
amount in the Total Spent column for those rows that satisfy the criteria placed in the
criteria range A1:G2. The database is established by the named range CustomersDB.
ANSWER Click the Insert Function button in the Function Library group on the Formulas
tab to open the Insert Function dialog box. In the Or select a category list, click
Database. Click DAVERAGE, then click OK. In the Database argument box, type
CustomersDB. In the Field argument box, type "Total Spent". In the Criteria argument
box, type A1:G2. Click OK.
In cell D6, write a formula using AND to return TRUE if the daily sales (cell C6) exceed
the overall average (cell C3) AND the daily sales (cell C6) exceed the employee's
average (cell C4). Use cell references and enter the arguments EXACTLY as written in
this problem. ANSWER On the Formulas tab, in the Function Library group, click the
Logical button. Click AND. In the Logical1 argument box, type C6>C3. In the Logical2
argument box, type C6>C4. Click OK.
In cell D6, using OR, in a formula that will return TRUE if the daily sales, cell C6 is
greater than the overall average in cell C3 or the daily sales, cell C6 is greater than
employee's average in cell C4. Use references to the cells and enter the arguments
exactly as written in this problem. ANSWER Click the Logical button in the Function
Library group on the Formulas tab. Click OR. In the Logical1 argument box, enter C6>C3
In the Logical2 argument box enter C6>C4 Click OK
Type a nested IF function in cell B8 to calculate the bonus amount. If the value in cell B6
is > 1500, the bonus amount is 2500. Use a nested IF formula in the Value_if_false
argument to return a draw amount of 500 if the value in cell B6 is > 1000 and 50 if it is
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.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now