excel module 6 sam critical thinking project c

View SAM Project Answer Keys

View the correct answers for SAM projects.

• Click SAM assignments .

• Click the file under Solution File to download it to your computer.
• Open the solution file.

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.

Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.

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.

• Homework Q&A
• Become a Tutor

All Subjects

Mathematics

Programming

Health & Medical

Engineering

Computer Science

Foreign Languages

Access over 35 million academic & study documents

Module 6 sam critical thinking excel project activity paper.

Sign up to view the full document!

24/7 Study Help

Stuck on a study question? Our verified tutors can answer all questions, from basic  math  to advanced rocket science !

Similar Documents

working on a study question?

Studypool is powered by Microtutoring TM

Copyright © 2024. Studypool Inc.

Studypool is not sponsored or endorsed by any college or university.

Ongoing Conversations

Access over 35 million study documents through the notebank

Get on-demand Q&A study help from verified tutors

Read 1000s of rich book guides covering popular titles

Sign up with Google

Sign up with Facebook

Already have an account? Login

Login with Google

Login with Facebook

Don't have an account? Sign Up

New User? Register

Fill This Form To Receive Instant Help

Homework answers / 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

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

Share With -->

Shelly Cashman Excel 2019 | Module 6: SAM Critical Thinking Project 1c

City of Honu Point

CREATE, SORT, AND QUERY TABLES

• Open the file SC_EX19_CT6c_ FirstLastName _1.xlsx , available for download from the SAM website.
• 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.
• If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
• PROJECT STEPS
• 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.

• Sort the CurrentProjects table in ascending order by Funding values so that Dean can quickly identify the projects by their funding amount.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.

• 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.
• 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.
• 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.

Fill The Details Below To Receive Instant

Homework help, purchase a new answer, custom new solution created by our subject matter experts, get a quote, low cost option, download this past answer in few clicks, purchase solution.

Already member? Sign In

GET ANSWER TO THIS QUESTION

100% UNIQUE SOLUTION WITHIN FEW HOURS

Related Questions

• Shelly Cashman Excel2019 Module 5 Textbook Project
• Ethernet SwitchesquotPlease respond to the following 1Since switches are generally used within the local network configuration why would a network administrator configure port security on a switch Can you think of a reason based on your study this week Donrsquot just give the answer from the materials cite specific examples from real life
• Project 14 Customer Relations Schweizer Distribution specializes in distributing fresh produce to local restaurants in the Chicago area
• Illustrated Excel 2016 Module 2 SAM Project 1a Camilersquos Electronics working with formulas and functions GETTING STARTED Open the fileILEX162aFirstLastName1
• New Perspectives Excel 2016 Module 2 SAM Project 1a The Good Breeze Hotel FormatTING workbook text and data GETTING STARTED Open the file NPEX162aFirstLastName1
• 1 Cycle Price euro 200 each 2washing machine Price euro 800 each 3
• New Perspectives Excel 2019 Module 3 Textbook Project cameren jackson 1
• Shelly Cashman Excel 2016 Module 2 SAM Project 1a Rough Stitch Clothing formulas functions and formatting GETTING STARTED Open the file SCEX162aFirstLastName1
• IllustratedExcel 2013 Unit L SAM Project 1a Tylerrsquos Toys ANALYZING DATA WITH PIVOTTABLES PROJECT DESCRIPTION Tylerrsquos Toysis a small company that crafts specialty toys from sustainable products
• Illustrated Excel 2016 Module 4 SAM Project 1b Yummy Gelato Stores WORKING WITH CHARTS

Help in Homework

• 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