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

24/11/2021 Client: muhammad11 Deadline: 2 Day

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.

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:

Quick N Quality
George M.
Smart Homework Helper
Calculation Master
Engineering Solutions
24/7 Assignment Help
Writer Writer Name Offer Chat
Quick N Quality

ONLINE

Quick N Quality

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$23 Chat With Writer
George M.

ONLINE

George M.

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$38 Chat With Writer
Smart Homework Helper

ONLINE

Smart Homework Helper

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$19 Chat With Writer
Calculation Master

ONLINE

Calculation Master

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$42 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$15 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

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

Situation audit - CLoud Computing Questions - Second step program research - Explain the research process in detail - 7 leita court ngunnawal - WEEK 2 DISCUSSION BUSINESS ETHICS - Ethical and Cultural Perspectives of Inquiry Paper - What was an underlying cause of the great depression - Cost of Capital - Discussion 4 CISS 301 - Biomes in sri lanka - La trobe university academic referencing tool - Advantages of reverse phase chromatography - Dat inc needs to develop an aggregate plan - Pestle and swot ananlysis - 6.9 1.6 worksheet answer broadband questions answers - Why is atomic mass not a whole number - Example of informative descriptive paragraph - The tub of a washer goes into - Guide vanes in francis turbine - Exam questions on alternative dispute resolution - Literary periods in the philippines - Buchholz relay operation pdf - On course skip downing 2nd edition pdf - Gainsborough's blue boy is an example of the - Magnitude and phase of transfer function - Commercial manager job description - Is supportive therapy evidence based - Employability skills 2000 quiz - Add user to microsoft volume licensing service center - Trichologist sydney david salinger - How to calculate wave speed - 1 4 9 16 and 25 are all triangular numbers - The bet anton chekhov setting - Wish you wood toy store - Order 2313888: Their eyes were watching god - Transhipment problem using excel solver - Leadership - 3/4-5 acme thread dimensions - How can businesses benefit from a strong company culture? - The benefits of change management mgt 362 - Field Experience - Ithaca double barrel shotgun serial number location - Bright sun family day care - Macroeconomics principles and policy edition answers - Aviation hw help - Summerise - Homework computer - Conversion of amps to watts - Adelaide school of languages japanese - Legal env - Lascia ch io pianga - Discussion Board - Nsw health internal vacancies - Bugsy malone female characters - Miscellaneous equipment crossword clue - Answer book reading power2 exercises unit 1 answers - Explain town matrix and portfolio matrix - Anderson plug solder or crimp - Wrightmarshall co uk tarporley - Dulux all metal primer - Advancement in science and technology essay - Coaching centre near me - Cell size is limited by - Practicing counseling without an explicit theoretical rationale is somewhat like - A traditional metalpoint ground recipe calls for a mixture of - Sociology - Zitkala sa impressions of an indian childhood - Matterhorn health simulation answers - For all work solver - Volar by judith ortiz cofer central idea - Macon controls produces three different - HS 2200 Social Welfare/Discussion - Www professor garfield com - Inflation is always and everywhere a monetary phenomenon - Community Health Case 3 - Do a bit of research on-line. Find a criminal case that involved Digital Forensics. - Walsall college goal login - Lion king hamlet similarities - The thousand and second tale of scheherazade analysis - Systems analysis and design 8th edition shelly rosenblatt - MARISSA JONES ONLY!!!! - How to spell antenna plural - How to find molarity of naoh from titration with khp - How to encrypt a file using 7zip - How to write an analytical commentary - Sociocultural influences on marketing - Structure of the book thief - Joe calleja apex steel - Passion by kathleen raine - 50 years later war on poverty is a mixed bag - Professional writing sky marsen pdf - Cisco 8841 speed dial - College athletes should not be paid speech outline - Who invented multitrack recording - 879 duncans creek road woolomin - Impact of components of social system on population - How to use revtex - Moodle ubss - Difference between prose and drama