Exam (elaborations)
SIMNET- PRACTICE TEST 100% CORRECT!!
- Course
- Institution
SIMNET- PRACTICE TEST 100% CORRECT!!
[Show more]
Content preview
SIMNET-PRACTICE TEST
100% CORRECT!!
SIMNET
Evatee 10/16/24 SIMNET
,SIMNET- PRACTICE TEST 100% CORRECT!!
Set the print area Answer - Click the back button. On the Page Layout tab, in
the page Setup group, click the Print Area button. Click Set Print Area
Create a new scenario to reflect a change in cell B8 to a value of 0.09 Name the
scenario New Bonus Answer - On the Data tab, in the Forecast group, clcik the
What if- Analysis button, and then clcik scenario manager. Click the ADD
button. Type New Bonus in the scenario name box. Click OK. Type 0.09 in the
text box. Click ok
Convert the cell range to a table using table style Table Style Light 10 The table
should include headers. Answer - On the Home tab, in the styles group, click
the Format as table button
click Table Style Light 10 (Third style in second row under light styles)
Verify My table has headers checkbox is checked
click ok
Apply the Orange, Table Style Medium 3 Quick Style (third style in first row
under medium) to this table Answer - On the table design tab, in the table
styles group, clcik the quick styles button or clcik the more button to expand
the Table Styles gallery. Click Orange, Table Style Medium 3. It's the third style
in the first row under Medium styles
Insert a Clustered Column chart based on the first recommended chart type
Answer - Click the Quick Analysis Tool button, and then click the Charts tab.
Click Clustered Column
, Enter a formula using DSUM to calculate the total value in the Total Spent
column for rows that meet the criteria in the crteria range A1:62. 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 DSUM, and click OK.
Enter CustomersDB in the Database arqument box.
In the Field argument box, enter "Total Spent". In
the Criteria argument box, enter A1:G2. Click OK
Enable filtering Answer - on the home tab, in the editing group, click the sort
and filter button and select filter
Insert the current date in the selected cell. Do not include the current time
Answer - On the formulas tab, in the Function Library group, click the Date and
Time button. Click TODAY. Click ok
In cell H12 enter a formula to find the lowest percentage of items received in
the order (cells H2:H11) Answer - On the Formulas tab, in the Function Library
group, click the AutoSum arrow, and click Min. Press Enter.
Modify the visits field to use the average function instead of Sum function
Answer - On the PivotTable Tools Analyze tab, in the Active Field group, click
the Field Settings button. Select Average . Click OK.
Create a scenario summary report. Accept the recommended results cells
Answer - On the data tab, in the forecast group, click the What-if-analysis
button, and click scenario manager. Click the summary button. Click ok
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 EvaTee. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $22.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
83822 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now