View SAM Project Answer Keys
View the correct answers for SAM projects.
![excel module 6 sam critical thinking project c SAM](https://help.cengage.com/images/sam.png)
- Click SAM assignments .
![excel module 6 sam critical thinking project c preview](https://help.cengage.com/mindtap/mt-sam-instructor/sam/images/preview-icon.png)
- Click the file under Solution File to download it to your computer.
- Open the solution file.
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/marketing/post@2x.png)
Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/marketing/choose@2x.png)
Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/marketing/receive@2x.png)
Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/images/sp_logo@2x.png)
- Homework Q&A
- Become a Tutor
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/icons/topNavbar/all.png)
All Subjects
Mathematics
Programming
Health & Medical
Engineering
Computer Science
Foreign Languages
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/icons/topNavbar/bus.png)
![](http://cikl.online/777/templates/cheerup2/res/banner1.gif)
Access over 35 million academic & study documents
Module 6 sam critical thinking excel project activity paper.
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://sp-uploads.s3.amazonaws.com/uploads/services/1995218/20210809194402_611185828070b_np_ex19_ct6c_franklingeorge_report_1page0.png)
Sign up to view the full document!
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/SPAnimatedLoaders/loading-gif.png)
24/7 Study Help
Stuck on a study question? Our verified tutors can answer all questions, from basic math to advanced rocket science !
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://s3.amazonaws.com/screenshots.studypool.com/questions/2018101123/905767.jpg)
Similar Documents
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/services/icon-min.png)
working on a study question?
![excel module 6 sam critical thinking project c Studypool, Inc., Tutoring, Mountain View, CA](https://seal-sanjose.bbb.org/logo/ruhzbus/studypool-1075253.png)
Studypool is powered by Microtutoring TM
Copyright © 2024. Studypool Inc.
Studypool is not sponsored or endorsed by any college or university.
Ongoing Conversations
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/images/email_sent.png)
Access over 35 million study documents through the notebank
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/icons/su-1-min.png)
Get on-demand Q&A study help from verified tutors
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/icons/su-3-min.png)
Read 1000s of rich book guides covering popular titles
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/images/onboarding/warning@2x.png)
Sign up with Google
![excel module 6 sam critical thinking project c excel module 6 sam critical thinking project c](https://www.studypool.com/img/icons/f_logo_RGB-White_72.png)
Sign up with Facebook
Already have an account? Login
Login with Google
Login with Facebook
Don't have an account? Sign Up
![excel module 6 sam critical thinking project c header logo](https://studyhelpme.com/assets/web/images/logo-main.png)
question archive Shelly Cashman Excel 2019 | Module 6: SAM Critical Thinking Project 1c City of Honu Point CREATE, SORT, AND QUERY TABLES GETTING STARTED Open the file SC_EX19_CT6c_FirstLastName_1
![](http://cikl.online/777/templates/cheerup2/res/banner1.gif)
Shelly Cashman Excel 2019 | Module 6: SAM Critical Thinking Project 1c City of Honu Point CREATE, SORT, AND QUERY TABLES GETTING STARTED Open the file SC_EX19_CT6c_FirstLastName_1
Subject: MS Excel Price: Bought 3
Share With -->
Shelly Cashman Excel 2019 | Module 6: SAM Critical Thinking Project 1c City of Honu Point CREATE, SORT, AND QUERY TABLES GETTING STARTED Open the file SC_EX19_CT6c_ FirstLastName _1.xlsx , available for download from the SAM website. Save the file as SC_EX19_CT6c_ FirstLastName _2.xlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file SC_EX19_CT6c_ FirstLastName _2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Dean Yamaguchi is a development officer for the city of Honu Point in Hawaii. Dean is analyzing city development projects that have been completed, are in progress, and have been proposed. He asks for your help in using Excel tables to complete the analysis. Go to the Completed Projects worksheet, which lists the development projects that were completed in Honu Point in 2021. Create a table as follows so that Dean can summarize and filter the data and display projects with the highest funding amounts: Format the completed projects data as a table using the same style as the table on the Current Projects worksheet. Use CompletedProjects as the name of the table. Autofilter the table to display projects with a Funding value greater than $10,000. Go to the Current Projects worksheet, which contains the CurrentProjects table listing city development projects that are under review or in development. The city recently received a proposal for a new development project. Insert a blank row at the end of the CurrentProjects table. Add a new record containing the data shown in Table 1. Table 1: New Record for the CurrentProjects Table Project Name Orchid Drive Zoning Start Date 11/20/2021 Number of Days 30 Project Type Public Funding Type Loan Funding $2,000 Approved? No In Development? No Sort the CurrentProjects table in ascending order by Funding values so that Dean can quickly identify the projects by their funding amount. In a separate part of the worksheet, Dean wants to list the projects that are in development. Use an advanced filter as follows to list these projects in a new range: In the Projects in Development section, type Yes under the "In Development?" heading as the value to filter on in the criteria range. Create an advanced filter using the CurrentProjects table as the List range. Use the headings and data row below the "Projects in Development" heading as the criteria range. Copy the results to another location, starting with the second set of headings below the "Projects in Development" heading. As a contrast, Dean also wants to list the projects that are not in development. Filter the CurrentProjects table in place, and then use the filter arrows to limit the table display to projects that are not in development. Go to the Proposed Projects worksheet, which lists projects that were proposed in 2021. Dean suspects the ProposedProjects table has a duplicate record. Identify the duplicate as follows: Display all the records in the ProposedProjects table. In the Project Name column of the ProposedProjects table, use conditional formatting to highlight duplicate values using Light Red Fill and Dark Red Text. Delete the second instance of the duplicate record so that you can summarize the data accurately. The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. Add a column to the ProposedProjects table, and determine which projects meet the criteria as follows: Type Fast Track as the column heading to the right of the ProposedProjects table to add the new column. [ Hint : Use the existing blank column as the new column. Do not insert a column.] In the cell beneath the heading, use the AND function that includes structured references to display "TRUE" if a project has both the Mixed Use project type and the Loan funding type. [Hint: To avoid an #SPILL error, enable implicit intersection by placing the This Row specifier (@ character) in front of field names.] Fill the rest of the column with the new formula if Excel does not do so automatically. Add a total row to the ProposedProjects table, that automatically counts the number of Fast Track values. Using the total row, display the sum of the funding amounts. Dean asks you to identify the projects that require 120 days or more to complete, those that require 60 days or more to complete, and those that require fewer than 60 days to complete. In the Number of Days column, create a new Icon Set conditional formatting rule using the 3 Signs icons. Reverse the icon order. Display the red diamond icon in cells with a numerical value greater than or equal to 120. Display the yellow triangle icon in cells with a numerical value greater than or equal to 60. Display the green circle icon in cells with a numerical value less than 60. Dean also wants to compare the funding amounts visually. In the Funding column, create a new Data Bars conditional formatting rule using Orange Gradient Fill data bars. In the "Number Proposed" heading, wrap the text to display the complete contents of the cell. Dean wants to summarize the number of proposed projects by the project type and calculate their funding amounts and average funding amounts. Calculate this information for Dean as follows: Use the COUNTIF function to calculate the number of proposed Commercial projects. Use the values of the Project Type column in the ProposedProjects table (ProposedProjects[Project Type]) as the range and the Commercial project type (cell I2) as the criteria. Fill the rest of the column with the new count formula. Use the SUMIF function to calculate the total funding for proposed Commercial projects. Use the values of the Project Type column in the ProposedProjects table as the range, the Commercial project type as the criteria, and the values of the Funding column as the sum_range. Fill the rest of the column with the new sum formula. Use the AVERAGEIF function to calculate the average funding for proposed commercial projects. Use the values of the Project Type column in the ProposedProjects table as the range, the Commercial project type as the criteria, and the values of the Funding column as the average_range. Fill the rest of the column with the new average formula. In the range I8:L12, Dean needs to insert a summary of the city development projects from the previous year. Insert this data as a table as follows: Below the "2021 Summary" heading, enter the data shown in Table 2. Format the new data as a table, specifying that the data has headers. AutoFit the contents of columns I:L to display the complete cell contents. Apply the same table style as the ProposedProjects table on this worksheet to maintain a consistent style throughout the workbook. Table 2: Data for the New Table Project Type Started Completed Funding Commercial 5 3 45,500 Mixed Use 4 2 57,800 Public 4 3 33,750 Residential 3 3 41,325 Go to the Funding Totals worksheet, which lists all the current and proposed development projects. Dean wants to display the data by funding type and then list the projects by start date. Sort the data in the table in ascending order first by the Funding Type values and then by the Start Date values. Dean also wants to calculate subtotals for each funding type. ( Hint : You must complete all actions of this step correctly to receive full credit.) Calculate this information for Dean as follows: Convert the table to a range. Insert a subtotal at each change in the Funding Type value. Select the function that adds the values to calculate each subtotal. Add subtotals to the Funding values only. Include a summary below the data. Collapse the outline to display only the subtotals for each funding type and the grand total. Go to the Lookup worksheet, which lists project details, including the ID code that staff in the Development Division use to refer to the projects. Dean wants to find a simple way to look up a project name based on its ID. In the Project Information section, use a function to display the project name to the right of the corresponding label. Find the Project ID in the Lookup table, and return the product name from the second column using an exact match. Dean also wants to look up the start date of each project. Instead of using the VLOOKUP function, he suggests using the INDEX and MATCH functions, which are faster when working with large amounts of data. In the Project Information section, use functions to display the start date of a project to the right of the corresponding label. Use the Lookup table, MATCH function, and Start Date column for the INDEX function. Use the Project ID and ID columns for the MATCH function using an exact match. Dean also wants to identify the number of projects that have less than $5,000 of funding and calculate the average funding amount of commercial projects. Create formulas that provide this information as follows: Use the DCOUNT function in cell H8 to count the number of projects with funding amounts less than $5,000. Use the entire Lookup table (Lookup[#All]) as the database, Funding as the field, and the range G6:G7 as the criteria. Use the DAVERAGE function in cell H13 to average the funding amounts for commercial projects. Use the entire Lookup table as the database, Funding as the field, and the range G11:G12 as the criteria. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.
Receive Instant Help
Click Here to Ask Your Question
![excel module 6 sam critical thinking project c pur-new-sol](https://studyhelpme.com/assets/web/images/pur_new_sol.png)
Purchase A New Answer
Custom new solution created by our subject matter experts, get a quote, related questions.
- Shelly Cashman PowerPoint 2019 Module 8 SAM Project 1b Presentation for Pacific Gardeners USING ADVANCED FEATURES GETTING STARTED Open the file SCPPT198bFirstLastName1 ...
- New Perspectives Excel 2019 Modules 14 SAM Capstone Project 1a Tallridge Regional Medical Center Formatting Formulas and Charts GETTING STARTED Open the file NPEX19CS14aFirstLastName1 ...
- 1 Cycle Price euro 200 each 2washing machine Price euro 800 each 3 ...
- New Perspectives Excel 2019 Module 5 SAM Critical Thinking Project 1c Narbonne Suites GENERATING REPORTS FROM MULTIPLE WORKBOOKS GETTING STARTED Open the file NPEX19CT5cFirstLastName1 ...
- New Perspectives Excel 2019 Chapter 1Textbook Project Chapter 2Textbook Project Chapter 3 Textbook Project Chapter 4 Textbook Project Chapter 5Textbook Project Chapter 6Textbook Project Chapter 7Textbook Project Chapter 8Textbook Project Chapter 9Textbook Project Chapter 10Textbook Project Chapter 11 Textbook Project Chapter 12Textbook Project QC Inn To summarize two years of financial data on 24 QC Inn motels located in the NebraskaSouth Dakota region To analyze revenue and royalties from 24 QC Inn franchises in NebraskaSouth Dakota during 2021 Primrose Community Clinic To monitor the progress of the Primrose Community Clinic fundraising campaign Note This question only contains solution to chapter 11 and chapter 12 projects and cost total 39 ...
- Shelly Cashman Excel 2019 Module 8 SAM Project 1b Delgado Designs ANALYZE DATA WITH CHARTS AND PIVOTTABLES GETTING STARTED Open the file SCEX198b FirstLastName 1 ...
- Excel chapter 11grader project Collaboration and Workbook Distribution Project Description You are an assistant sales manager for a contractor who builds custom houses ...
- Shelly Cashman PowerPoint 2019 Module 7 End of Module Project 1 Investors Presentation for Snowbridge Resort WORKING WITH ADVANCED GRAPHICS AND MEDIA GETTING STARTED Open the file SCPPT19EOM71FirstLastName1 ...
- New Perspectives Excel 2019 Module 12 SAM Critical Thinking Project 1c Penta Insurance DEVELOP AN EXCEL APPLICATION GETTING STARTED Open the file NPEX19CT12cFirstLastName1 ...
- New Perspectives Excel 2013 Tutorials 58 SAM Capstone Project 1a 1 ...
![excel module 6 sam critical thinking project c Study Help Me](https://studyhelpme.com/assets/web/images/logo-main.png)
- Don't have an account? Register Now
- Forgot Password? Reset Password
Please enter your email address and we'll send you instructions on how to reset your password
- Already have an account? Log In
![](http://cikl.online/777/templates/cheerup2/res/banner1.gif)
IMAGES
VIDEO
COMMENTS
24 / 7 Live [email protected]+44-7309655268+91-9828671065Shelly Cashman Excel 2019 | Module 6: SAM Critical Thinking Project 1cCity of Honu P...
Use the Lookup table, MATCH function, and Start Date column for the INDEX function. Use the Project ID and ID columns for the MATCH function using an exact match. Shelly Cashman Excel 365/2021 | Module 6: SAM Critical Thinking Project 1c18. Dean also wants to identify the number of projects that have less than $5,
SAM. Project Answer Keys. View the correct answers for SAM projects. Click . Click SAM assignments. Locate a project assignment and click . Click the file under Solution File to download it to your computer. Open the solution file. View the correct answers for SAM projects.
Learn how to use advanced Excel features such as pivot tables, slicers, and charts in this Module 6 SAM Project tutorial.
About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright ...
New Perspectives Excel 365/2021 | Module 6: SAM Critical Thinking Project 1cCare. The Maternity department has more admission criteria than the other major divisions of the hospital. Donnie wants to summarize maternity admissions data using subtotals to show the relationships between admission type and number of patients.
Insert a table using the Quick Analysis Tool. Click and drag range ( A5:G15 ) click the quick analysis button, click tables tab. Click the table button. Insert a table. Click and drag range (A4:K18), click insert tab, then table button, create table is open and accept it and click okay. Apply a table style.
Shelly Cashman Excel 2019 | Module 6: SAM Project 1a City of Honu PointCREATE, SORT, AND QUERY TABLES GETTING STARTED · Open the file SC_EX19_6a_ FirstLastName Q&A Go to the Lookup worksheet, which lists project details, including the ID code that staff in the Development Division use to refer to the projects.
Shelly Cashman Excel 365/2021 | Module 6: SAM Critical Thinking Project 1c al Mixed Use 4 2 57,800 Public 4 3 33,750 Residentia l 3 3 41,325 14. Go to the Funding Totals worksheet, which lists all the current and proposed development projects. Dean wants to display the data by funding type and then list the projects by start date. Sort the data in the table in ascending order first by the ...
Shelly Cashman Excel 2019 | Module 6: SAM Critical Thinking Project 1c 12. Dean wants to summarize the number of proposed projects by the project type and calculate their funding amounts and average funding amounts. Calculate this information for Dean as follows: a. Use the COUNTIF function to calculate the number of proposed Commercial projects. Use the values of the Project Type column in ...
New Perspectives Excel 2019 | Module 7: SAM Critical Thinking Project 1c references to count the total number of students if they have been elected to offices in student organizations. 9. In the appropriate cell, use a function and structured references to determine the average number of post-secondary years for students who have been elected. 10.
New Perspectives Excel 365/2021 | Module 6: SAM Critical Thinking Project 1c. Care 8. The Maternity department has more admission criteria than the other major divisions of the hospital. Donnie wants to summarize maternity admissions data using subtotals to show the relationships between admission type and number of patients.
With the file SC_EX365_2021_CT2c_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet. If cell B6 does not display your name, delete the file and download a new copy. PROJECT STEPS. Shanice Traynor is the warehouse manager for the Roadrunner Online warehouse in Detroit, Michigan.
Assignment's new perspectives excel modules sam critical thinking capstone project 1c tallridge regional medical center formatting, formulas, and charts getting. Skip to document. University; High School. Books; Discovery. ... Modules 1-4: SAM Critical Thinking Capstone Project 1c7. Format the headings in the Staff table as follows:
Unformatted Attachment Preview. New Perspectives Excel 2019 | Module 6: SAM Critical Thinking Project 1c Franklin George SUBMISSION #1 | SCORE IS: 71 OUT OF 100 1. Donnie Cruz is a finance assistant for Oval Lake Hospital in south Florida. His current project is to format departmental data for the years 2021-2023 to make it easier to analyze.
Learn how to create a chart in Excel using functions, formulas, formatting tips and inserting a chart.
Shelly Cashman Excel 2019 | Module 6: SAM Critical Thinking Project 1c. City of Honu Point. CREATE, SORT, AND QUERY TABLES. GETTING STARTED. Open the file SC_EX19_CT6c_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as SC_EX19_CT6c_FirstLastName_2.xlsx by changing the "1" to a "2".
Shelly Cashman Excel 365/2021 | Modules 1-3: SAM Critical Thinking Capstone Project 1c6. Format the row of data under the cell containing "Project Status Report" to show that it contains column headings. Change "Description" to Service Description as the complete column heading.
New Perspectives Excel 2019 | Module 7: SAM Critical Thinking Project 1c references to count the total number of students if they have been elected to offices in student organizations. 9. In the appropriate cell, use a function and structured references to determine the average number of post-secondary years for students who have been elected. 10.
New Perspectives Excel 365/2021 | Module 3: SAM Critical Thinking Project 1c. Use a function to calculate the minimum manufacturing cost per unit in the appropriate cell. Use a similar function to calculate the minimum shipping cost per unit. Use a function in the appropriate cell to determine the best manufacturing candidate based on minimum cost.
View NP_EX365_2021_CT2c_GrantShimer_2.xlsx from EXCEL 365 at Liberty University. New Perspectives Excel 365/2021 | Module 2: SAM Critical Thinking Project 1c Author: Note: Do not edit this sheet. If