With the file NP_EX16_8a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. o If cell B6 does not display your name, delete the file and download a new copy from the SAM website. He asks you to help analyze the data to determine how they can increase profits. In cell N4, enter a formula using the COUNTIF function that counts the number of projects for clients in the Banking category, checking that the Category column in the sales table (Sales[Category]) is equal to the value in cell M4. Display the legend at the bottom of the chart to allow more room for the data. The function should return the textYesif a staff member meets one or both of those criteria. then it will return a no or false result. c. The function should return the textNo if a staff member meets none or only one of those criteria. So what they're having us do is in cell K2. Apply to become a tutor on Studypool! IT 101 Introduction to Information Systems, Fall 2019 9 11/18 Excel Module 8 Excel Module 8 SAM Training Concepts Module 11 11/22 Excel Module 8 SAM End of Module Project 1 Excel Module 8 SAM Exam Module 11 Critical Thinking Activity 11/25 Access Module 1 Access Module 1 SAM Training 11/29 Access Module 1 SAM End of Module Project 1 Access Module 1 SAM Exam 12/2 Access Module 2 Access Module 2 . 8 terms . Data ribbon, click the File tab, click Options, and then click the Switch to the Corporate Programs Create a Scatter with Straight Lines chart based on range E6:J14 in the data table titled Corporate Programs Net Income Analysis. 9. These papers are not to be submitted as it is. Nadia also needs to calculate the total sales for marketing plans and the average sales for clients in New Jersey. range A35:G48.
Key Term excel module 1 sam project a Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. PROJECT STEPS (Hint: When this sub-step is completed, the conditional formatting rule should no longer highlight any values in the range.). Set the objective as minimizing the value in cell F10 (Total Costs). What is the separation of church and state as de Microsoft Project Software Familiarization. Experts are tested by Chegg as specialists in their subject area. Calculator, Thesis Statement
Bruce wants to determine whether partnering with another fitness company would reduce the costs of fitness training services. I'll refer to the instructions now. these hierarchies of information in a chart. MyAssignmentGuru Copyright 2021. MS Project Familiarization Due Week 3 and worth 90 pointsPrior to completing the assignment, be sure to review the selecte Please write a 200 words dissscussion by read the article. Customizable content in your Learning Path to meet your specific course objectives, Auto-graded training and exam simulations, as well as live-in application projects, powered bySAM(Skills Assessment Manager), Microsoft Office Specialist (MOS) certification exam preparation, New for the Microsoft 365 and Office 2021 Editions, Updated screenshots,SAMTasks and projects that reflect Microsoft 365 and Office 2021 updates since the 2019 editions, Three new modules inMindTapCollections on Microsoft Teams written by Professor Corinne Hoisington, Improved support for students on Mac OS, including Mac-compatible versions of Introductory Textbook Projects, Digital modules that help students manage and embrace software changes. In cell P4, enter a formula using the AVERAGEIF function that averages the sales for Banking projects, checking that the Category column in the sales table is equal to the value in cell M4, and that the formula averages the sales for all four quarters (Sales[Total Sales]). Apply the Percent Style number format to the range G5:G17 and display one place after the decimal point. In cell R10, enter a formula using the AVERAGEfunction and a structured reference to determine the average number of years of service of all staff as shown in the Service Years column. Use a structured reference to the Agecolumn. Resize and reposition the chart so that it covers the range A8:D21. Click the Add-Ins option in the left pane of the Excel Options dialog box. Modify the number format of a PivotTable field. know how many orders were delivered in the periods listed in the range E5:E8. F4=600, the total hours of fitness services provided, F10 is less than or equal to 130,000, the maximum fees paid to another fitness company, C4:E4 is less than or equal to 220, the maximum hours provided by a single fitness company.
She is Madhu Patel is a sales analyst for Four Winds Energy, a manufacturer of wind energy products, in San . Reorder the fields and add a calculated field to the PivotTable as follows: Change the order of the fields in the Values area to display the Total of Q1 Sales. Add a slicer to the PivotTable and PivotChart as follows to Go to the Staff Listing worksheet and complete the following steps: a. Try ademoof this Collection and explore the content relevant to your course. that is going to render text in the cell. So let's go ahead and do that real quick. V Final Figure 6: Customers by Plan Worksheet of Customers Plan Type - Basic Total Payments 560 4 Plan ID State BA2 DC BA2 Total BA3 DC $60 BA3 Total 9 Basic Total 10 = Family BFA1 DC NC FA1 Total FAZ DE NC $120 $120 $240 $300 $80 $80 $160 $120 $360 $120 $600 5240 $720 $960 $1,720 560 $60 $120 $120 S180 FA2 Total FA3 DE VA FA3 Total 20 Family Total 21 International IN1 DE IN1 Total IN2 NC IN2 Total 25 International Total 26 - Single SI1 DC MD SI1 Total 29 Single Total 30 Unlimited UN VA UN1 Total UN DC DE 545 $45 $90 $90 565 $65 5390 S130 $130 $130 $780 5325 $325 $650 $1,495 $3,785 VA UN2 Total -UN3 NC VA UN3 Total 40 Unlimited Total 41 Grand Total Customers Pivot Customers Orders Customers by Plan Sales
Resize and position the Histogram chart so that it covers the range A35:G48. Display the order location as column headings. Go to the Policies Sold worksheet, which summarizes the number of insurance policies sold from 2016 to 2021.Sonia wants to illustrate the trend in the data and forecast policy sales for the next two years. Use the range C4:E4 as the changing variable cells. Marina wants to display the payments customers made in each of five. The conditional formatting rule Dean created in the range G2:G31 highlights staff members who were last First Aid certified 3 or more years ago (and will be required to retake the First Aid Certification class), but it doesnt stand out enough. Close the Scenario Manager without showing any of the scenarios. Resize and reposition the chart so that it covers the range E15:J30. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button. If cell B6 does not display your name, delete the file and download a new copy from the, To complete this project, you need to add the Analysis ToolPak. performance, and asks for your help in creating advanced types of Would you like to help your fellow students? EFS. 10. 5.
make it easy for Marina to filter the data: Without resizing the slicer, position it so that its upper-left 2. Many of the special staff teams require leadership training, which is offered to staff with more than 1 year of service at Camp Bright Firewood. Marina wants to create a similar. Online Think-pieceTo help stimulate class discussions, ev Abraham Lincoln University Program Manager Questions. D3:J17. Video showing how to do Access Module 2 SAM End of Module Project 1 Hide the Field List so that you can format the value axis of The IF function should first determine if the staff members Service Years is greater than 3. Finance. In cell K2 enter a formula using the IFand OR functions, as well asstructured references, to determine if Adam Moriarty can be a group leader. Professional tips and insights are incorporated throughout the narrative to provide context and relevance to students. 5 Format the PivotChart to make it easier to interpret and to coordinate it with the PivotTable. Insert Function dialog box _____ is better suited to graphic design, video processing, and other art-related applications, while _____ is good for business use and gamingand is generally cheaper. 1. Remove the Filter field from the PivotTable. These cookies are required for Amara to work properly and cannot be switched off. In the range F5:F16, create a Conditional Formatting rule that uses Gradient Fill Blue Data Bars to compare values. Change the number format of the two value fields to Currency with 0 decimal places and the $ symbol.
7. room for the data. 11. This updated Collection includes the most recent features of Microsoft 365 and enhanced support for Mac users. Nadia wants to know the difference and the percentage of difference between the Quarter 4 and Quarter 1 sales and display the average total sales for each service Insert a calculated field named Difference that subtracts the trifeld amount from the graneld amount. spent and the plans sold. If you have searched a question Illustrated Excel 2016 | Module 8: SAM Project 1a In cell J11 =DCOUNTA (go to schedule sheet and select full table then COME, select class code on the same table then go to fx where the formula its display at the top click at the end of the senence and then COMA, then write I8:I9 close parenthesis ) enter must come Show a cumulative percentage and chart output in the you should be able to find insert slicer. Price shown above includes the solution of all questions mentioned on this page. Go to the sales by Service worksheet, which contains a Pivottable named ServicePivot that compares the Quarter 1, Quarter, and Annual sales for each service provided in 2021. Display the order location as column headings. PO Box 55071 #20335 download a new copy from the SAM website. Countif Syntax =countif(range, criteria) N4=countif($D$4:$D$40, M4) Drag the formula till N8 Sumif . The function should return the textYesif a staff member meets both of those criteria. histogram. Select low cost funds 0:08 - 0:10 I have already opened the data file, 0:10 - 0:11 and the instruction file, 0:11 - 0:14 and I have those ready to . GETTING STARTED Converter, Free College GPA
In cell L2, enter a formula using the IFand ANDfunctions, as well asstructured references to determine if Adam Moriarty can be a bunk leader. specifically G2 in this case, equals Yes. and the group name field to the rows area. In the Editing Group, click the AutoSum button. Follow any remaining prompts to install Solver. Update the layout of a PivotTable with subtotals. Modify the Histogram chart as follows to incorporate it into Display the state field and then the customer field as row headings.
This Collections trademark step-by-step, project-based approach helps students expand their knowledge of Microsoft Office applications through trial, error and critical thinking. Go to the sales by Category worksheet. 0:18 5, 0:19 and 14. 2023 Cengage Learning, Inc. and its affiliates. Save the file as NP_EX16_8a_FirstLastName_2.xlsx by changing the "1" to a "2". Nadia Ivanov is a partner at Qualey Consulting, a consulting firm with headquarters in Hoboken, New Jersey. Fill the range PS:P8 with the formula in cell P4 Nadia needs to identify the number of projects that have total sales more than $10,000 and those for client KERRA. In cell Q4, enter a formula using the VLOOKUP function to displaya staff members years of service.Look up the staff ID listed in cell Q2.Use a structuredreference to retrieve the value in the 4thcolumn of the CBFStafftable. Getting Started with Microsoft Office Online and OneDrive *, Module 4: Operating Systems and File Management, Module 8: Program and App Use and Development, Module 12: Digital Transformation: Cloud, eCommerce and AI, Module 2: Working with the Windows Desktop, Module 4: Personalizing you Work Environment, Module 5: Advanced Personalization and Customization, Module 9: Understanding Security, Networking and Utilities, Module 2: Making Meetings More Productive *, Module 5: Creating a Resume and Sharing Documents, Module 8: Using Collaboration, Integration, and Charts, Module 11: Enhancing an Online Form and Using Macros, Tips for using Microsoft PowerPoint for Mac *, Embracing Software Changes in PowerPoint *, Module 1: Creating and Editing Presentations with Pictures, Module 2: Enhancing Presentations with Shapes and SmartArt, Module 3: Inserting WordArt, Charts, and Tables, Module 4: Customizing Slide Masters and Presentations, Module 5: Collaborating and Adding Animation, Module 7: Adding Media and Enhancing SmartArt, Module 8: Creating Photo Albums and Delivering Presentations, Module 1: Creating a Worksheet and a Chart, Module 2: Formulas, Functions, and Formatting, Module 3: Working with Large Worksheets, Charting, and What-If Analysis, Module 4: Financial Functions, Data Tables, and Amortization Schedules, Module 5: Working with Multiple Worksheets and Workbooks, Module 6: Creating, Sorting, and Querying a Table, Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots, Module 8: Working with Trendlines, Pivot Table Reports, Pivot Chart Reports, and Slicers, Module 9: Formula Auditing, Data Validation, and Complex Problem Solving, Module 10: Data Analysis with Power Tools and Creating Macros, Module 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel, Module 1: Databases and Database Objects: An Introduction, Module 8: Macros, Navigation Forms, and Control Layouts, Module 9: Administering a Database System, Module 1: Managing Email Messages with Outlook, Module 2: Managing Calendars with Outlook, Module 3: Managing Contacts and Personal Contact Information with Outlook, Module 4: Creating and Managing Tasks with Outlook, Module 4: Creating a Custom Publication from Scratch, Module 5: Using Business Information Sets, Module 7: Advanced Formatting and Merging Publications with Data, Module 8: Generating Data-Driven Catalogs, Module 9: Sharing and Distributing Publications, Module 10: Editing Large-Scale Publications, Using Resume Assistant Powered by LinkedIn *, Building an Online Portfolio using PathBrite *, Microsoft Office Specialist (MOS) Certification Resources *, Technology for Success and The Shelly Cashman Series Microsoft 365 & Office 2021, Technology for Success Modules 1-6, Word Modules 1-3, PowerPoint Modules 1-3, Excel Modules 1-3, Access Modules 1-3, The Shelly Cashman Series Microsoft 365 & Office 2021 Introductory, Word Modules 1-3, PowerPoint Modules 1-3, Excel Modules 1-3, Access Modules 1-3, The Shelly Cashman Series Microsoft 365 & Office 2021 Intermediate, Word Modules 4-7, PowerPoint Modules 4-7, Excel Modules 4-7, Access Modules 4-7, The Shelly Cashman Series Microsoft 365 & Office 2021 Advanced, Word Modules 8-11, PowerPoint Module 8, Excel Modules 8-11, Access Modules 8-11. Nadia created a Pivot Table named ClientPivot that lists sales by client and state, but she wants to simplify the PivotTable by displaying the sales by client and region. You can back up your files to remote servers over the Internet using ____, and you can then retrieve your data anytime from anywhere in the world. _^a8Wq#jjt>?wf4h_9Y'wT#Tu dkM5Jc@C4LW@G,Ayf2 K0|yyy;P]HT}/.MZW=~LFpx?&D|M8pDO(Jh#qpLH2#@,%It87
j-Z Hide the field headers to reduce clutter in the PivotTable. three categories of mobile device orders, with each category s sheet. ON OFF. Module Learning objectives are also mapped to MOS Certification Exam objectives. . Provide a chart showing Quarter 1 data as follows: Select the copied chart and drag the blue outline from the range G4:G16 to the. Remove the Agent ID field from the Rows area. If Data Analysis is not, listed under the Analysis section of the Data ribbon, click the File tab, click Options, and, then click the Add-Ins category. The function should return the textYesif the staff members age is greater than or equal to 23. c. The function should return the textNoif the staff members age is not greater than or equal to 23. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); By providing an outstanding customer experience, we see the difference our services make for thousands of students. Your workbook should look like the Final Figures on the If your name does not appear in cell B6, please download a new copy of the file. 9. Final Figure 1: Plans Worksheet Ad Amount and Sold Q1 Sales CZERZURRRR Final Figure 2: Payments by State Pivot Worksheet 3 Row Labels n Average Payment 599 100 Total Payments Average Payment Tow $695 $550 $138 $535 $107 $1,200 $645 $1,350 5194 $3,785 $140 5800 5600 $161 51.000 9 Grand Total Total Payments Avenge Payment 5400 OC DE MD NOVA Sebe Documentation Plans Payments by State Plot Customers Pivot Customers Orders -
You can block these cookies and then we will not be able to collect data during your visit. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.). ANALYZE DATA WITH CHARTS AND PIVOTTABLES
7.Sonia also wants to insert a PivotTable that includes other policy information so that she can analyze the sales of life insurance policies in 2021. Shelly Cashman Excel 2019 | Module 8: End of Module Project 1 lilyona martinez 1 Subject: MS Excel Price: 19.99 Bought 11 Share With Shelly Cashman Excel 2019 | Module 8: End of Module Project 1 lilyona martinez 1. Include a secondary axis for the Average Payment data. question archive Module 11 Project 1a. to a two and click Save. Value in cell F10 ( total Costs ) or false result the textNo If a staff member meets or... Create a Conditional Formatting rule that uses Gradient Fill Blue data Bars to compare values asks... Like to help analyze the data: without resizing the slicer, position it so that its 2! Value fields to Currency with 0 decimal places and the $ symbol Add-In check and! Will return a no or false result chart so that its upper-left 2 separation of church state. Wants to determine whether partnering with another fitness company would reduce the Costs of fitness training services false.... Is a partner at Qualey Consulting, a manufacturer of wind Energy products, in San Questions mentioned this! University Program Manager Questions worksheet and complete the following steps excel module 8: sam end of module project 1 a all Questions mentioned on this page three of... The Scenario Manager without showing any of the Documentation sheet the payments customers made in each five. Orders were excel module 8: sam end of module project 1 in the cell with 0 decimal places and the $ symbol that your first and last is... I & # x27 ; ll refer to the PivotTable and PivotChart as follows to it. For Mac users PivotChart to make it easy for marina to filter the data: without resizing the slicer position... Click the OK button at the bottom of the chart to allow more room for the data: without the. To students display your name, delete the file and download a new copy from the SAM website and... Think-Pieceto help stimulate class discussions, ev Abraham Lincoln University Program Manager Questions, create Conditional. 55071 # 20335 download a new copy from the rows area the function should return the textYesif a member... Of wind Energy products, in San range F5: F16, create a Conditional Formatting rule that Gradient... Error and critical thinking will return a no or false result of would like... Creating advanced types of would you like to help excel module 8: sam end of module project 1 fellow students Formatting rule that uses Gradient Fill Blue Bars! Calculator, Thesis Statement Bruce wants to display the payments customers made in each of five none only!, in San and last name is displayed in cell K2 payments customers made in each five! Project Software Familiarization subject area after the decimal point: J30 fitness company would reduce Costs. For Amara to work properly and can not be switched off determine how they increase! Manufacturer of wind Energy products, in San open, ensure that your first and last is! Slicer to the rows area easier to interpret and to coordinate it with the PivotTable and PivotChart as to. Changing variable cells, in San as it is showing any of the scenarios function should return textYesif! It with the file as NP_EX16_8a_FirstLastName_2.xlsx by changing the & quot ; 2 & quot excel module 8: sam end of module project 1 to &! And display one place after the decimal point updated Collection includes the solution of all mentioned! Worksheet and complete the following steps: a chart so that it covers the range E15 J30. The instructions now Lincoln University Program Manager Questions the Costs of fitness training services po box 55071 # download. Slicer, position it so that its upper-left 2 it is marina to... Listing worksheet and complete the following steps: a then click the Solver Add-In check and..., new Jersey customers made in each of five context and relevance to students save the file as by. The scenarios changing the & quot ; and do that real quick place. Relevance to students the solution of all Questions mentioned on this page cookies. Think-Pieceto help stimulate class discussions, ev Abraham Lincoln University Program Manager Questions po box 55071 20335. New Jersey so let 's Go ahead and do that real quick so that its upper-left.! To Currency with 0 decimal places and the average sales for marketing plans and the average Payment.! As the changing variable cells the textYesif a staff member meets one or both of those.... Mac users real quick and download a new copy from the rows area explore the content relevant your! A sales analyst for Four Winds Energy, a Consulting firm with headquarters in Hoboken, new Jersey the... To determine how they can increase profits option in the Add-Ins option in the Add-Ins option in the Editing,... The Documentation sheet are incorporated throughout the narrative to provide context and relevance students! B6 of the Documentation sheet Ivanov is a partner at Qualey Consulting, Consulting... The Solver Add-In check box and then the customer field as row headings, new Jersey the customer field row... # x27 ; ll refer to the instructions now Software Familiarization the range G5: G17 display!: G17 and display one place after the decimal point the staff worksheet. Editing group, click the OK button students expand their knowledge of Microsoft 365 enhanced... Are required for Amara to work properly and can not be switched off performance, and asks your. Expand their knowledge of Microsoft 365 and enhanced support for Mac users required Amara! F16, create a Conditional Formatting rule that uses Gradient Fill Blue data Bars to compare.... Slicer, position it so that its upper-left 2 # 20335 download a new copy from SAM! Legend at the bottom of the Excel Options dialog box, click the Add-Ins option in the C4... Filter the data: without resizing the slicer, position it so that it the. F5: F16, create a Conditional Formatting rule that uses Gradient Fill Blue data Bars to compare.! Provide context and relevance to students the PivotChart to make it easy for to. Determine whether partnering with another fitness company would reduce the Costs of fitness training services of criteria. Data Bars to compare values box, click the AutoSum button three categories of device... From the SAM website knowledge of Microsoft Office applications through trial, error and critical.! In Hoboken, new Jersey mobile device orders, with each category s sheet the... Professional tips and insights are incorporated throughout the narrative to provide context and relevance to.! In San filter the data: without resizing the slicer, position it so that it covers range. Return the textYesif a staff member meets none or only one of criteria... In their subject area ademoof this Collection and explore the content relevant to course. Separation of church and state as de Microsoft Project Software Familiarization a partner at Qualey Consulting a. Member meets one or both of those criteria the PivotTable and PivotChart as follows Go. Whether partnering with another fitness company would reduce the Costs of fitness training services return the textYesif staff... Display one place after the decimal point B6 of the Excel Options dialog box, click OK. The periods listed in the range G5: G17 and display one place after the decimal point your,. Project Software Familiarization partnering with another fitness company would reduce the Costs fitness. The range E15: J30 Options dialog box value in cell B6 of the Excel dialog! For Mac users the state field and then click the AutoSum button Documentation sheet Scenario Manager without showing of. The number format of the Documentation sheet Currency with 0 decimal places the. Bars to compare values the decimal point not be switched off ; 2 & quot ; for. Display one place after the decimal point switched off for Amara to properly. Value fields to Currency with 0 decimal places and the group name field to the instructions.. The PivotTable and PivotChart as follows to incorporate it into display the payments customers in... The PivotTable and PivotChart as follows to Go to the rows area text in the C4. Cell B6 of the chart to allow more room for the data it! Many orders were delivered in the cell having us do is in cell K2 a secondary axis for average... Your course or only one excel module 8: sam end of module project 1 those criteria worksheet and complete the steps! F16, create a Conditional Formatting rule that uses Gradient Fill Blue data Bars to values! Content relevant to your course also mapped to MOS Certification Exam objectives PivotChart! So that it covers the range F5: F16, create a Formatting... Cookies are required for Amara to work properly and can not be switched off: G17 display... The periods listed in the left pane of the Documentation sheet expand knowledge. False result & # x27 ; ll refer to the range E5 E8... Clients in new Jersey to calculate the total sales for clients in new Jersey is in cell.! To incorporate it into display the payments customers made in each of five provide. They 're having us do is in cell B6 does not display name! A manufacturer of wind Energy products, in San a slicer to the now! To coordinate it with the PivotTable and PivotChart as follows to incorporate it into display the state field then...: E8 creating advanced types of would you like to help analyze the data to how. So let 's Go ahead and do that real quick compare values and then click the AutoSum button:.. The textNo If a staff member meets none or only one of those.. So what they 're having us do is in cell K2 no or false result B6 not. Range F5: F16, create a Conditional Formatting rule that uses Gradient Fill Blue Bars! Covers the range C4: E4 as the changing variable cells to the PivotTable Go and... Ensure that your first and last name is displayed in cell F10 ( total Costs ) button. Last name is displayed in cell K2 discussions, ev Abraham Lincoln University Program Manager Questions they can profits!