fix it 3.6 assignment

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 20 million homework & study documents

Ex2016 fixit 3 6 3.

Sign up to view the full document!

24/7 Homework Help

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

Similar Documents

working on a homework 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 20 million homework documents through the notebank

Get on-demand Q&A homework 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

• school Campus Bookshelves
• menu_book Bookshelves
• perm_media Learning Objects
• login Login
• how_to_reg Request Instructor Account
• hub Instructor Commons
• Download Page (PDF)
• Download Full Book (PDF)
• Periodic Table
• Physics Constants
• Scientific Calculator
• Reference & Cite
• Tools expand_more
• Readability

selected template will load here

This action is not available.

3.6: Assignments

• Last updated
• Save as PDF
• Page ID 45330

The assignments in this course are openly licensed, and are available as-is, or can be modified to suit your students’ needs. Answer keys are available to faculty who adopt Waymaker, OHM, or Candela courses with paid support from Lumen Learning. This approach helps us protect the academic integrity of these materials by ensuring they are shared only with authorized and institution-affiliated faculty and staff.

If you import this course into your learning management system (Blackboard, Canvas, etc.), the assignments will automatically be loaded into the assignment tool.

Salty Pawz Assignments and Discussions

Half of the written assignments and discussions (32 in total) are based on a case study, whose focus is a fictional dog-treats business called “Salty Pawz.” Many of these assignments take the form of asking students to give Wanda, the company’s inexperienced owner, advice about how she can run her business more effectively. Lighthearted in tone, the Salty Pawz case study and associated assignments create a common framework for applying knowledge and skills developed through the course, encouraging students to demonstrate mastery of the content through real-world tasks and work products.

Alternate Assignments and Discussions

The other half of the written assignments and discussions (32 in total) use a variety of approaches, depending on the subject and learning outcome being assessed; many ask students to go beyond course content to form connections between research topics and what they’ve learned in class.

Using Assignments

We recommend assigning one discussion OR one assignment per chapter , rather than all of them. Some instructors prefer to stick with the Salty Pawz theme throughout the course; others like to use some of the alternates along the way. You can view any assignments or discussions below or throughout the course.

Rubrics for Written Assignments and Discussion Posts

For faculty using the assignments or discussions included here, there are also sample rubrics to assist you in grading. Instructors may download and modify these guidelines or use their own.

Grading Rubric for Discussion Posts

Written Assignment Rubric

• Guidelines for Written Assignments

For faculty using the assignments included here, there is also a set of guidelines regarding length, formatting, and other mechanical submission requirements. Instructors may download and modify these guidelines or use their own.

Contributors and Attributions

• Assignments. Provided by : Lumen Learning. License : CC BY: Attribution
• Pencil Cup. Authored by : IconfactoryTeam. Provided by : Noun Project. Located at : https://thenounproject.com/term/pencil-cup/628840/ . License : CC BY: Attribution

Welcome to TutorsOnSpot.Com!

World's No. 1 Assignment Writing Market

Post your homework and get free proposals here!

Stuck in your homework and missing deadline get urgent help in $10/page with 24 hours deadline.

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel 2016 skills approach ch 3 fix it 3.6

Excel Assignment Return On Attached File- Instructions Attached

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

1 | Page Fix It 3.6 Last Updated 3/19/18

Fix It 3.6 In this project, you will correct function mistakes and other formula errors in a workbook designed for

planning a large party or event. Be sure to save your work often!

Skills needed to complete this project: • Checking Formulas for Errors

• Finding Errors Using Trace Precedents and Trace Dependents

• Displaying and Printing Formulas

• Creating Formulas Using Counting Functions

• Finding Minimum and Maximum Values

• Formatting Text Using Functions

• Using CONCAT to Combine Text

• Finding Data Using the VLOOKUP Function

• Using the Function Arguments Dialog to Enter Functions

• Using Formula AutoComplete to Enter Functions

• Calculating Averages

• Naming Ranges of Cells

• Working with Named Ranges

• Updating Named Ranges with the Name Manager

• Editing and Deleting Names with the Name Manager

• Using Date and Time Functions

• Using the Logical Function IF

• Creating Formulas Referencing Data from Other Worksheets

• Calculating Loan Payments Using the PMT Function

1. Open the start file EX2016-FixIt-3-6. The file will be renamed automatically to include your name.

Change the project file name if directed to do so by your instructor, and save it.

2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the

workbook so you can modify it.

3. On the GuestList sheet, check all the formulas. Cells to check are filled with the light orange color. Most of

them need to be corrected. Use error checking as needed and/or display the formulas on-screen for easy

a. In the Name Tag column, modify the formula to display the guest name in this format: BILL SMITH

Hint: There are multiple errors in this formula. Fix the formula in cell D10 and then copy it to the

other cells in the column.

b. Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column.

c. Correct the function used in cell A4 to count the number of values in the Street column.

d. Correct the function used in cell A5 to count the number of blank cells in the NumAttending column.

e. Correct the function used in cell A6 to display the largest value in the NumAttending column.

f. Correct the function used in cell A7 to display the average value in the NumAttending column.

Step 1 Download start file

2 | Page Fix It 3.6 Last Updated 3/19/18

4. On the Shopping List sheet, check all the formulas. Cells to check are filled with the light orange color. Most

of them need to be corrected. Many of the problems on this worksheet can be solved by creating named

ranges or using a name that already exists.

a. The formula in cell B2 uses the wrong function.

b. The formulas in cells A9:A23 reference a named range that doesn’t exist. There is more than one

correct way to fix this problem using the cell range A5:H18 on the Places to Shop worksheet. You can

create the named range referenced in the formulas, or you can change the function arguments to

reference the cell range instead.

c. The formula in cell H9 results in the correct value. However, the workbook author copied this

formula to the remaining cells in the column and those values are definitely not correct! Fix the

formula in cell H9 and copy it to cells H10:H23. Hint: Notice that cell H8 is named Tax.

5. If you’ve fixed the formulas in cells H9:H23 correctly, the formulas in cells I9:I23 and G5 should be

calculate properly now. However, the formulas in cells G2:G4 still have errors that need to be fixed. Hint:

Use error checking as needed and/or display the formulas on-screen for easy viewing.

a. Correct the function used in cell G2 to average value of the Cost column.

b. Correct the function used in cell G3 to display the largest value in the Cost column.

c. Correct the function used in cell G4 to display the smallest value in the Cost column.

6. On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light

orange color. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing.

a. Cell B2 should use a function that will update the date to the current date every time the workbook is opened.

b. Cell B4 references a named range that doesn’t exist. It should reference cell A4 on the Guest List sheet.

You can create the named range or edit the formula to reference the cell instead.

c. Cell B5 references a named range that doesn’t exist. It should reference cell A3 on the Guest List sheet.

d. Cell B8 is missing the formula to calculate whether or not the total Cost with tax on the Shopping

List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet is greater than

the available cash. The cell should display yes or no.

e. Add a formula to cell B9 to calculate the amount to borrow (total Cost with tax on the Shopping

List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet – the cash

available) if the value in cell B8 is yes. If the value in cell B8 is not yes, the cell should display 0.

f. Add a formula to cell B12 to calculate the monthly loan payment based on the information in

cells B9:B11. Use a negative number for the Pv argument.

7. Save and close the workbook.

8. Upload and save your project file.

9. Submit project for grading.

Step 2 Upload & Save

Step 3 Grade my Project

Homework is Completed By:

Order & get this solution within 3 hours in $25/page.

Custom Original Solution And Get A+ Grades

• 100% Plagiarism Free
• Proper APA/MLA/Harvard Referencing
• Delivery in 3 Hours After Placing Order
• Free Turnitin Report
• Unlimited Revisions
• Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

• Delivery in 6 Hours After Placing Order

Order & Get This Solution Within 12 Hours in $15/Page

• Delivery in 12 Hours After Placing Order

6 writers have sent their proposals to do this homework:

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

BUSI 201 Project Fix It 3.6 Assignment solutions complete answers

BUSI 201 Project Fix It 3.6 Assignment solutions complete answers    In this project, you will correct function mistakes and other formula errors in a workbook designed for planning a large party or event. Be sure to save your work often! Skills needed to complete this project: ·         Checking Formulas for Errors (Skill 3.18) ·         Finding Errors Using Trace Precedents and Trace Dependents (Skill 3.19) ·         Displaying and Printing Formulas (Skill 3.20) ·         Creating Formulas Using Counting Functions (Skill 3.6) ·         Finding Minimum and Maximum Values (Skill 3.4) ·         Formatting Text Using Functions (Skill 3.7) ·         Using CONCAT to Combine Text (Skill 3.8) ·         Finding Data Using the VLOOKUP Function (Skill 3.17) ·         Using the Function Arguments Dialog to Enter Functions (Skill 3.1) ·         Using Formula AutoComplete to Enter Functions (Skill 3.2) ·         Calculating Averages (Skill 3.3) ·         Naming Ranges of Cells (Skill 3.11) ·         Working with Named Ranges (Skill 3.12) ·         Updating Named Ranges with the Name Manager (Skill 3.13) ·         Editing and Deleting Names with the Name Manager (Skill 3.14) ·         Using Date and Time Functions (Skill 3.5) ·         Using the Logical Function IF (Skill 3.15) ·         Creating Formulas Referencing Data from Other Worksheets (Skill 3.10) ·         Calculating Loan Payments Using the PMT Function (Skill 3.16) 1.       Open the start file EX2019-FixIt-3-6. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2.       If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook. 3.     On the GuestList sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Use error checking as needed and/or display the formulas on-screen for easy viewing. a.       In the Name Tag column, modify the formula to display the guest name in this format: BILL SMITH Hint: There are multiple errors in this formula. Fix the formula in cell D10 and then copy it to the other cells in the column. b.      Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column. c.       Correct the function used in cell A4 to count the number of values in the Street column. d.      Correct the function used in cell A5 to count the number of blank cells in the NumAttending column. e.       Correct the function used in cell A6 to display the largest value in the NumAttending column. f.        Correct the function used in cell A7 to display the average value in the NumAttending column. 4.     On the Shopping List sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Many of the problems on this worksheet can be solved by creating named ranges or using a name that already exists. a.       The formula in cell B2 uses the wrong function. b.      The formulas in cells A9:A23 reference a named range that doesn’t exist. There is more than one correct way to fix this problem using the cell range A5:H18 on the Places to Shop worksheet. You can create the named range referenced in the formulas, or you can change the function arguments to reference the cell range instead. c.       The formula in cell H9 results in the correct value. However, the workbook author copied this formula to the remaining cells in the column and those values are definitely not correct! Fix the formula in cell H9 and copy it to cells H10:H23. Hint: Notice that cell H8 is named Tax. 5.     If you’ve fixed the formulas in cells H9:H23 correctly, the formulas in cells I9:I23 and G5 should calculate properly now. However, the formulas in cells G2:G4 still have errors that need to be fixed. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing. a.       Correct the function used in cell G2 to average value of the Cost column. b.      Correct the function used in cell G3 to display the largest value in the Cost column. c.       Correct the function used in cell G4 to display the smallest value in the Cost column. 6.     On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light purple color. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing. a.       Cell B2 should use a function that will update the date to the current date every time the workbook is opened. b.      Cell B4 references a named range that doesn’t exist. It should reference cell A4 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead. c.       Cell B5 references a named range that doesn’t exist. It should reference cell A3 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead. d.      Cell B8 is missing the formula to calculate whether or not the total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet is greater than the available cash. The cell should display yes or no. e.       Add a formula to cell B9 to calculate the amount to borrow (total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet – the cash available) if the value in cell B8 is yes. If the value in cell B8 is not yes, the cell should display 0. f.        Add a formula to cell B12 to calculate the monthly loan payment based on the information in cells B9:B11. Use a negative number for the Pv argument. 7.       Save and close the workbook. 8.       Upload and save your project file. 9.       Submit project for grading.    

Starting from: $8.90

More products

• Blogs by Topic

The WebStorm Blog

The JavaScript and TypeScript IDE

• Twitter Twitter
• Youtube Youtube

WebStorm 2023.3.6 Is Out!

The sixth bug-fix update for v2023.3 is here! 

You can update to this version from inside the IDE, using the Toolbox App , or via snaps, if you’re using Ubuntu. You can also download it directly from our website .

Important fix

There are reports that the latest update to macOS (Sonoma 14.4) on Apple silicon-based machines is causing crashes on certain software running on the JVM. Apple is already aware of the problem.

• WebStorm 2023.3.6 includes a workaround to reduce the probability of crashes caused by this issue as we wait for an official fix from the technology.

That’s all for today! For the full list of issues addressed in WebStorm 2023.3.6, please see the release notes .

Subscribe to WebStorm Blog updates

By submitting this form, I agree that JetBrains s.r.o. ("JetBrains") may use my name, email address, and location data to send me newsletters, including commercial communications, and to process my personal data for this purpose. I agree that JetBrains may process said data using third-party services for this purpose in accordance with the JetBrains Privacy Policy . I understand that I can revoke this consent at any time in my profile . In addition, an unsubscribe link is included in each email.

Thanks, we've got you!

Discover more

WebStorm 2023.3.5 Is Out!

WebStorm 2023.3.5 is now available with several fixes.

WebStorm 2023.3.4 Is Out!

WebStorm 2023.3.4 is now available with several fixes.

WebStorm 2023.2.6 Is Available!

WebStorm 2023.1.6 is here with an important security update.

WebStorm 2023.1.5 Is Available

WebStorm 2023.1.5 is here with an important security update.