Loading...

Messages

Proposals

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

08/10/2021 Client: muhammad11 Deadline: 2 Day

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

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.

Step 1 Download start file

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

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.

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.

Step 2 Upload & Save

Step 3 Grade my Project

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

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

Custom Original Solution And Get A+ Grades

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

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

Custom Original Solution And Get A+ Grades

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

6 writers have sent their proposals to do this homework:

Assignment Solver
Financial Assignments
Engineering Solutions
Premium Solutions
Financial Solutions Provider
Professor Smith
Writer Writer Name Offer Chat
Assignment Solver

ONLINE

Assignment Solver

I have read and understood all your initial requirements, and I am very professional in this task.

$26 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

Give me a chance, i will do this with my best efforts

$26 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$23 Chat With Writer
Premium Solutions

ONLINE

Premium Solutions

I will cover all the points which you have mentioned in your project details.

$49 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$38 Chat With Writer
Professor Smith

ONLINE

Professor Smith

Give me a chance, i will do this with my best efforts

$49 Chat With Writer

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

Similar Homework Questions

Concentration of acetic acid in vinegar - Phosphoric acid plus magnesium hydroxide - Homework market become a tutor - 2pages with out references no plagiarism - Lottie stewart nursing home - Cisco ise policy sets - British columbia university psychology - Dual aspect definition accounting - Trouble in the truss construction shop critical thinking - Dimplex storage heater instructions - Pico della mirandola oration on the dignity of man pdf - Bullying presentation for parents - Assets are usually reported at their - Weather station model activity - The local chevrolet dealership has an increase - Jb hifi return policy - Rough Draft Literature Review - Retail store design and layout ppt - I know why the caged bird sings worksheet answers - Average rate of return tutor2u - Original greenstar display manual - Practical application of atwood's machine - Assignment 2: Practicum Journal Entry: Analyzing an Ethical Decision (Due in Week 4) - Middle passage robert hayden analysis - Skills approach to leadership northouse - Web browser forensics_6.1 - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Rajahmundry - Business Administration - Brothers and sisters troubled waters - Find a postcode in new zealand - Birthday party by harold pinter summary - “The Devil and Tom Walker” - How to memorize ions - I want to become a soldier essay - The freshest kids - Bindu menon asianet middle east - The outsiders characters physical descriptions - Team development interventions evidence based approaches for improving teamwork - The Thesis Statement & Annotated Bibliography Assignment - Ikea riyadh opening hours during ramadan - Case study - Heat treatment steel lab report - Lawyer derek and philosopher sissela - In the heart disease diagnosis case study, what was a benefit of the sipmes expert system? - HW1 - Macbeth act 3 questions - Naati intercultural competence test - 60 minutes stories list - Powder by tobias wolff guided reading answers - Evaporating dish scientific drawing - 3 p of business communication - Hydraulic theory of state formation - Celf 5 core language - British council eal resources - I need a discussion - Windows based embedded systems ppt - Direct mail and catalogue retailing are examples of _____ - A porsche accelerates from a stop light - Qs 5 11 perpetual inventory costing with lifo lo p1 - The co operative group head office - Profile essay - Fe nh4 2 so4 2 x 6h2o - CARIBBEAN RELIGION HISTORY - Michael verde memory bridge - Eba definition of forbearance - Charting examples for physical assessment - Understand how the brain copes from adverse childhood experience - The philadelphia sound was supplanted by which musical style - Usyd key dates 2016 - How is population density expressed - Who invented homework and why - Joseph mccarthy quotes on communism - The dressmaker soundtrack list - Phil 201 liberty university quiz 1 - Burke litwin change model - To what amount will the following investments accumulate - The repetition of initial consonant sounds - Key issue analysis - Frm exam dates 2016 - The girl who can by ama ata aidoo answers - Tai kang ning for withdrawal - Managerial accounting for managers edition mcgraw hill - Pets paradise glen waverley - Adjectives to describe katniss everdeen - Unit test part 2 polynomials - What is a samadhi - Time of useful consciousness faa - Porter's five forces paper industry - 1229 fern dr pocono summit pa 18346 - Accounts Management - Tsi 2 t score interpretation - A raisin in the sun act 2 scene 2 script - Hollowing out the middle chapter summaries - Perfume network of san ysidro california cosmetics & original cologne - Apply: SWOT Analysis - Journal Article Research(NCM) - Harvard business marketing simulation tips - Rcn on demand movies - 119 hayman road bentley - Interpersonal Communication Principles