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 module 8 review assignment

26/12/2020 Client: saad24vbs Deadline: 24 Hours

CIS-122L WEEK 8 ASSIGNMENTS


STARTS: Thursday, March 28, 2019


DUE: Midnight Wednesday, April 3, 2019


Part I: Textbook Microsoft Excel 2016


Read Module 8 – Working with Advanced Functions – pp. EX463-EX522 in your textbook.


In the buff colored sections of the textbook lesson you are to do the hands-on exercises along with the book.


The files you need to follow along with the books are in the Student Data Files—Excel 2016 folder in the Assignments area of the Blackboard course site.


In the Course Documents area locate the Additional Instructions & Corrections for Week 8. They contain corrections and add information to the textbook module.


Complete the 4 parts of the Week 8 assignments as listed below. Use the link provided on the Assignments page to upload your two completed files.


· Assignment #1 -- Pages EX463-EX522. Read Module 8 and complete the steps in the buff colored sections. Do not submit that workbook.


· Optional Assignment #2 -- Pages EX523. Review Exercise – Optionally complete steps 1 – 14. Do not submit that workbook. A solution will be posted in the Assignments section of Blackboard.


· Assignment #3 -- Page EX524-EX525. Case Problem 1 – Complete steps 1 – 13 in the textbook then complete the steps 14-16 below in the same workbook. Before starting, be sure to read the “Notes for Assignment #3” below.


14. Select J1:L2 and give those cells a range name of your first initial and last name.


15. Save the file with your name and Rickys Popcorn (e.g. SmithJ Rickys Popcorn).


16. Submit that file using the provided link on the Assignments page by the deadline.


Notes for Assignment #3 - Module 8 Case 1:


· Step #5 – In E16:E26, you do not create a list from the values in B33:E41, just the Input Message. Whoever fills out the form then types a flavor from the list in B33:E41 manually.


· Step #13 – When you have entered all of the data, you should get the results shown below.




Part II: Certification Skills


· Assignment #4 – Complete the 15 steps below:


1. Open the AdvancedFunctions.xlsx workbook.


2. On the OrderOfOperations sheet, in B50, type Completed by followed by your name.


3. Test your understanding of order of operations by completing the OrderOfOperations sheet.


4. On the Dollar Store sheet, calculate in D7 the Total for an order with 2 items. Select D7:D9 and drag the Fill Handle down to D21 to copy the formula into the remaining four rows. If the order with 27 items is not $23.10, try again as you did not get the order of operations right in D7.


5. On the Food Pantry sheet, calculate the Value Per Person in F6. Copy down to F9. Calculate the Average of the Value Per Person in F11. The value should be $14.28.


6. On the Absolute sheet, calculate the Credit Due in D7 by reducing the Sale Amount by the Restocking Fee in cell G2. You must use G2 in your formula; typing 17% or 0.17 in the formula will not get any credit. Copy down to D25. The value in D25 should be $199.30.


7. On the TotalInterest sheet, calculate the total interest cost in B5 by multiplying the Rate in B4 by the Loan Amount in A5 by the Period (years) in B2. However, since you wish to copy that formula to the remainder of the table, each of the three cell addresses in that formula will need either absolute or mixed addresses. Adjust the formula with dollar signs as needed. Remember the F4 key can do that for you. Finally copy down and then across (or vice-versa) to complete the data table. The final value in J23 should be $125,000.00. If it isn’t, you need to fix the dollar signs in B5 and re-copy.


8. On the COUNTIF sheet, in M2:M5, use the COUNTIF( ) function to calculate the number of students in each of the four grades (9th, 10th, 11th, and 12th). The grade for each student is in column I. Then sum the number of students in M6. The value in M6 should be 97.


NOTE: For this and the next five problems, do not use the entire column address inside the COUNTIF( ) function as in =COUNTIF(I:I,L2). Although it often works, it will cause problems if there is data further down the sheet.


9. On the COUNTIF sheet, use the COUNTIF( ) function to calculate the number of female and male students in M10:M11. The gender of each student is in column B. Then sum the number of students in M12. The value in M12 should be 97.


10. On the SUMIF sheet, in M2:M5, use the SUMIF( ) function to calculate the total club dues for the students in each of the four grades (9th, 10th, 11th, and 12th). The grade for each student is in column I. The Club Dues are in column J. Then sum the Total Dues in M6. The value in M6 should be 4542.


11. On the SUMIF sheet, use the SUMIF( ) function to calculate the total club dues for the female and male students in M10:M11. The gender of each student is in column B. The Club Dues are in column J. Then sum the Total Dues in M12. The value in M12 should be 4542.


12. On the AVERAGEIF sheet, in M2:M5, calculate the Average GPA for the students in each of the four grades (9th, 10th, 11th, and 12th). Format to 2 decimal places. You should get 2.96, 2.92, 2.98, and 2.97.


13. On the AVERAGEIF sheet, calculate the Average GPA for the students who do or don’t pay club dues in M10:M11. The Yes or No for whether they pay club dues is in column D. Format to 2 decimal places. You should get 2.97 and 2.94.


14. Save the file with your name and AdvancedFunctions (e.g. SmithJ AdvancedFunctions).


15. Submit this workbook using the provided link on the assignments page by the deadline.


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Top Essay Tutor
University Coursework Help
Helping Hand
Homework Guru
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$115 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$112 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$110 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$112 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

Writing a critique in apa format - Conflict resolution plan template - A scandal in bohemia comprehension questions - Tay sachs disease results from the malfuncion of - Activation energy calculator using slope - Repeaters inside communications satellites are known as - Townsendpress.net sign in - Interpreting and translation services common use arrangement - Builders warranty insurance victoria - Co teaching planning template - Adams coffs coast locksmiths - Electron configuration for lithium - Density and pressure physics - This is a partial adjusted trial balance of barone company - Perimeter of a rectilinear figure - Shaping psych - The apartment of 2 psychiatrists christmas carol - Quantitative non experimental research design - Archive org details malwaremuseum&tab collection - 0.83 repeating as a fraction - Sample article critique apa format - Moody bible institute course catalog - How do i make a brochure in word - Hemophilia pedigree with genotypes - Flemings trees top 10 - Is coffee a solution or mixture - Northern territory building certification - Calculating the cost of credit card purchases worksheet answers - Discussion A: Exploring Your Own Styles of Communication - Wsq conversational english competency level 3 - Https securepro prod energy siemens com securepro - Burning characteristics of cotton - How carders make money - Q & Q A7 - World War 2 - Charmate tex offset smoker review - Assume f&s offers a deal whereby - Discussion Question - How to change name on avaya phone 9608 - Benzil melting point range - How customers think gerald zaltman - Sonny's blues short story summary - Hpm sensor light reset - Functionalism conflict theory and symbolic interactionism - Acts of the apostles 2 1 13 - Health services Financial - Report on recent attack at office of Personnel Management - Swarm ai kentucky derby 2017 - 5 - Board game project rubric - Crosman 1077 co2 leak - What is the difference between excretion and egestion - Which of the following is an ineffective practice in a negotiation? - American Journal of Business Education - Ashley furniture strengths and weaknesses - Windshield survey example - Greg avery plumbing wee waa - Aci spinal cord injury - What about artistic expression is universal throughout human cultures - Marketing - Cinnamon oil protocol for lyme disease - 300 words - W8 - Rigor and relevance framework - How to write a position paper in apa format - Marriage medicine and modesty are examples of george murdock's - Evidence Table for the follwoing PICOTS questions - Old westbury computer science - Ritek custom roof panels - Verbal escalation continuum cpi - Autocount chapter 10 assignment 2 answer - Week 4 plagiarism free - Brickenden v london loan & savings co - Https www youtube com watch v evtxpuf4oz4 - Mini Research Paper - Absolute change vs relative change - Standards for registered training organisations 2015 - Standards of measurement worksheet answers section 2 - Jk to t flip flop conversion - Week 1 Discussion 1 - 500 word essay APA style - Rectory road clinic rushden - How to view xbrl balance sheet - Is the earth the telestial kingdom - Cis 6 - Editing celebrity social media answer key - Part 2 project paper - Short term liquid investment options - Engineering ethics charles b fleddermann pdf - Hazelwood school district losing accreditation - Fallen sports heroes media and celebrity culture - Project Management - 3 components of a total reward system - Go float electric boat - Logistics management assignment - Essay - Green mountain coffee roasters statement of cash flows 2019 - Global supply chain management simulation - 2.2 lbs to kg - Aca code of ethics apa citation