everyday excel part 2 assignment answers

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications You must be signed in to change notification settings

Quizzes & Assignment Solutions for Everyday Excel Specialization on Coursera. Also included a few resources on side that I found helpful.

demoncorpse2/Everyday-Excel-Specialization

Folders and files.

Repository files navigation

Everyday Excel Specialization(Coursera)

About this course/certificate.

About This workshop and the materials in this repo are for anyone who is interested in working with Data Science to produce high quality, working style! Check out follow course link if you think it is interested.

Course Link: Everyday Excel Specialization

Course Learn Path

The courses enlisted as follows:

• C1-Everyday Excel, Part 1
• C2-Everyday Excel, Part 2
• C3-Everyday Excel, Part 3(Project)

Course Description: 3 Course

This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.

Applied Learning Project

Tools: Excel

Course Certificate

Total Hours: ~64 Hrs

Thanks For Watch This Repositories!

Keep awesome & stay cool, feel free to fork and report if you find any issue :).

Everyday Excel, Part 1 Coursera Quiz Answers – Networking Funda

Table of contents, everyday excel, part 1 week 01 quiz answers.

Q2. Which of the following sets of “moves” will take the initial worksheet setup and result in the final worksheet setup? Multiple correct answers possible, and all must be selected!

Q3. In the spreadsheet setup shown below, which of the following formulas could we place into cell B4 that we could copy/paste (or drag down) to cells B5:B7  so that we could multiple a (the constant value in cell B1 ) by the x-values in cells A4:A7 ?  Multiple answers may be correct.

Q5. Which of the following numbers, text strings, or dates on the left side of each arrow could we put into a single cell and drag down and Auto Fill would convert the next cell down to that on the right side of the arrow? Multiple answers correct, and all must be selected for credit.

Everyday Excel, Part 1 Week 02 Quiz Answers

Q3. We would like to set up a simple Excel worksheet to calculate the number of 24-packs of tiles that we need for a certain tiling job. Tiles are only sold in packs of 24, and we must round up to the nearest multiple of 24 tiles. For example, if we need 155 tiles, then we’d need to round up and purchase 7 x 24-packs (6 x 24-packs would only be 144 tiles, so we need 7 of them).

Q4. What will the value in cell B4 be when the Enter key is pressed? Leave your answer as an integer (counting number) with no decimals.

Q5. Whose name will appear in cell A1 when Enter is pressed? The name “ dwarves ” refers to cells A3:A6 .

Everyday Excel, Part 1 Week 03 Quiz Answers

Q1. Which formula shown below could you use to determine the monthly payment on a $5,000 loan if you want to pay it off in 10 years? The annual interest rate is 5% and interest is compounded monthly.

Q3. Which of the following formulas could be placed into cell B4 to provide the result shown? Multiple correct answers, and all must be selected for credit.

Q4. Which range of cells on the following worksheet are being referenced to by the following Excel formula?

Everyday Excel, Part 1 Week 04 Quiz Answers

Q1. Which of the following shows how the Custom Sort tool was filled completed to accomplish this sort?

Q2. Which of the following are TRUE statements about material learned in Week 4? Select all that apply.

Everyday Excel, Part 1 Week 05 Quiz Answers

Q1. The plot shown below depicts natural gas consumption (in therms) as a function of time for a particular home.

Q2. This is a cumulative question that uses some things that you have learned not just in Week 5 but throughout the entire course! We have annual expense data as a function of year for several different categories:

Q4. Which of the following correctly shows how we dragged and dropped the various fields into the Pivot Table tool?

Get All Course Quiz Answers of Everyday Excel Specialization

Everyday Excel, Part 2 Coursera Quiz Answers

Newsletter Updates

One comment, leave a reply cancel reply, related posts, client needs and software requirements coursera quiz answers, introduction to software product management coursera quiz answers, introduction to test driven development (tdd) quiz answers, trending now.

Snapsolve any problem by taking a picture. Try it in the Numerade app?

Skip to Content

Other ways to search:

• Events Calendar

Everyday Excel Specialization

Course Preview

Sharpen your Microsoft Excel skills in this online business specialization. You will learn the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. You will also complete several "real-world" guided projects.

By completing this specialization, you will be able to:

• Use a variety of Excel tools, techniques, and functions
• Apply Excel tools to real-world projects
• Navigate Excel by editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting
• Use expression entry and common Excel formulas (including logical functions, text functions, and financial functions)
• Perform data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups)
• Everyday Excel, Part 1
• Everyday Excel, Part 2
• Everyday Excel, Part 3

Discover the Top 75 Free Courses for August

Udemy Announces Layoffs Without Saying ‘Layoffs’

Udemy’s latest ‘Strategic Business Update’ uses corporate euphemisms to signal job cuts while pivoting to enterprise clients.

• 9 Best Kubernetes Courses for 2024
• [2024] 300+ Free Google Certifications
• 10 Best Free Programming Courses for 2024
• 7 Best Reverse Engineering Courses for 2024
• 10 Best Organic Chemistry Courses for 2024

600 Free Google Certifications

Most common

• computer science

Popular subjects

Cybersecurity

Artificial Intelligence

Communication Skills

Popular courses

Industrial Pharmacy-I

Matrix Algebra for Engineers

Mathematical Economics

Organize and share your learning with Class Central Lists.

View our Lists Showcase

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Everyday Excel, Part 1

University of Colorado Boulder via Coursera Help

• Navigating Excel
• In Week 1, you will learn basic worksheet navigation, how to open and save Excel files, and all about worksheets and workbooks. You will learn the difference between cells, columns, and rows in Excel, as well as cell references. You will learn how to move around the worksheet effectively using shortcut key combinations, and you will learn how to edit the worksheet. You will also learn how to format cells, conditionally format cells, and how to change between number, text, date, currency, and other cell formatting options. There will be particular emphasis on relative vs. absolute cell addressing modes and you will learn how to name cells and cell ranges. You will be introduced to basic macro recording using VBA and you will learn how to set personal preferences in Excel. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. The Week 2 material will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!
• Expression Entry and Common Excel Functions
• In Week 2 you will learn about how to properly write Excel syntax. You will learn the order of operations, how to input mathematical formulas into Excel, and how to troubleshoot when things don't go as expected. You will be introduced to just a few of the thousands of built in functions in Excel. The functions that you will learn about in this module relate to summing, counting, averaging, how to round numbers and calculate remainders, random number generation, and combinations and permutations. Week 2 concludes with a quiz and an on-computer, in-application assignment. Upon successful completion of these items, the Week 3 material will be unlocked. Good luck and have fun!
• More Excel functions
• In Week 3, you will learn more advanced functions in Excel. These include logical functions (IF, AND, OR) and advanced logical functions (SUMIF, COUNTIF, AVERAGEIF). You will learn how to effectively use Auto Fill and Fill Series but then I explain how to use text functions, which overcome some of the limitations of the Auto Fill feature. You will be introduced to Excel's financial functions (many more financial functions will be covered in Part 2 of the course), and you will learn how to use array formulas in Excel. Finally, I show how you can create your own user-defined function in VBA. Week 3 concludes with a quiz and on-computer, in-application assignment. When completed successfully, the Week 4 material will be released. Good luck!
• Managing Data
• Week 4 really gets at the heart of why Excel is so great for managing data. You will learn how to apply a filter, how to create an Excel Table, and how to validate data (for example, by only allowing items in a drop-down list). You will learn how to sort data, how to clean up data prior to using, how to remove duplicates in your data, and how to consolidate data from multiple sources. Finally you will learn how to use one-way lookup functions in Excel (VLOOKUP and the INDEX/MATCH combination). Quiz 4 and the on-computer, in-application Assignment 4 will test your understanding of the material in Week 4. Once you've completed these assessments, the Week 5 material will be unlocked. Good luck and have fun!
• Plotting, Importing Data, and Converting to Other File Types
• Week 5 is all about data visualization. You will learn the differences between and how to use scatter plots, column charts, and pie charts. You will be introduced to Pivot Tables, Slicers, and Sparklines, which all represent different and exciting ways to visualize your data. I will show you how to share data (embed vs. linking) with Word and PowerPoint as well as how to print your worksheets and how to convert them to .pdf documents. Like the other modules, Week 5 concludes with a quiz and an on-computer, in-application assignment. When you've completed those assessments, you will earn the Course Certificate! Good luck!

Charlie Nuttelman

• united states

Related Courses

Everyday excel, part 2, excel/vba for creative problem solving, part 1, excel/vba for creative problem solving, part 2, excel skills for business: essentials, excel fundamentals, everyday excel, part 3 (projects), related articles, 10 best microsoft excel courses for beginners, 1700 coursera courses that are still completely free, 250 top free coursera courses of all time, massive list of mooc-based microcredentials.

4.7 rating at Coursera based on 3369 ratings

Select rating

Start your review of Everyday Excel, Part 1

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.