everyday excel assignment 4.1 answers

Everyday Excel, Part 1 Coursera Quiz Answers – Networking Funda

• In Computer Science Quiz
• In Everyday Excel Specialization
• On April 2, 2024

Table of Contents

Everyday excel, part 1 week 01 quiz answers.

Q1. What will happen in the following spreadsheet setup if we: 1) Press Enter , 2) copy the formula in cell B3 using Ctrl-C (or Copy ), and 3) paste the formula into cell A3 ?  What value will result in cell A3 ?

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!

• Highlight Rows 3 and 4
• Right-click on Rows 3 and 4 –> Cut
• Right-click on Row 2 –> Insert Cut Cells
• Highlight Row 2
• Right-click on Row 2 –> Cut
• Right-click on Row 5 –> Insert Cut Cells
• Select cells A2:B2
• Right-click –> Cut
• Right-click in cell A5 –> Insert Cut Cells
• Select cells A3:B4
• Right-click in cell A2 –> Insert Cut Cells

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.

Q4. If we wish to name a cell “Temp” so that we can use “Temp” as a variable name in a calculation and as an absolute reference, how do we do this? Multiple answers are possible, and all must be selected for credit.

• Just type it into the cell to the left of the cell that you want to name.
• Define a name using the Name Manager.
• Define a name using the Formula Bar.
• Hold down Ctrl-Shift-N then type in the name.
• Define a name in the Name Box.

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.

• Wednesday –> Thursday
• 3/4/20 –> 3/5/20
• Day 1 –> Day 2
• March –> April

Everyday Excel, Part 1 Week 02 Quiz Answers

Q1. Which of the following is correct syntax for writing out the following expression in Excel? Assume that the variable x has been named “ x ” in the Name Manager or Name Box .

• (5*1)+3/(7+x)
• =5*(1+3/(7+x))
• =5*1+3/(7+x)
• 5*(1+3)/(7+x)

Q2. What value will be displayed in cell A6 when the Enter key is pressed? Enter your answer as an integer (counting number, no decimals).

• Comment Down Correct 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).

• =ROUNDUP(B1/24,0)
• =CEILING(B1,24)
• =CEILING(B1,24)/24
• =MROUND(B1,24)/24

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.

• =PMT(0.05,120,5000,0)
• =PMT(0.05,10,5000,0)
• =PV(0.05,12,5000)
• =PMT(0.05/12,120,5000,0)
• =FV(0.05,12,5000)

Q2. Which of the following Excel formulas below could we place into cell G5 to calculate the maximum temperature on the day of the week that is input into cell G4 ? The formula should provide the maximum on that day of the week over the last two weeks (rows 3 through 16) and should automatically update if the day of the week in cell G4 is changed.

• =MAXIF(B3:B16=”Wednesday”,D3:D16,0)
• =MAX(D3:D16,G4)
• =MAXIF(B3:B16,G4,D3:D16)
• =MAX(IF(B3:B16=G4,D3:D16,0))
• =MAX(IF(B3:B16,G4,D3:D16))

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.

• =CONCAT(A1:A9)
• =CONCAT(A1:A2)&CONCAT(A4:A6)&CONCAT(A8:A9)
• =TEXTJOIN(A1:A9)
• =CONCATENATE(A1:A9)
• =TEXTJOIN(“”,TRUE,A1:A9)

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

Q5. Which of the following Excel formulas could we put into cell B8 to count the number of items in the range A1:D6 that are less than 50?

• =COUNTIF(A1:D6,”<50″)
• =SUMIF(A1:D6,”<50″)
• =COUNTIF(A1:D6,<50)
• =COUNTIF(A1:D6<50)
• =SUMIF(A1:D6<50)

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.

• Filters can be used only to filter out categorical data and not a range of values and dates. For example, filters cannot be used to select for numbers between 2 and 10.
• The VLOOKUP function will always look for the lookup value in the left-most column of the lookup array.
• The Go To Special tool can be used to identify all cells that have the value 100 in them.
• Excel Tables have built-in filters.
• The Remove Duplicates tool can only be used to remove duplicate values that show up in the left-most column of an array.

Q3. What word (proper spelling and no capitalization and no spaces) will be displayed in cell A13 when the Enter key is pressed?

• Comment Answers below if you found

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.

• We could select the chart then choose the Chart Design tab, then choose Select Data and add a new series.
• We would go to the green + sign to add a new data series.
• We could right click in the plot area and go to Select Data then add a new series.
• We could select the therms data for 2017, copy that data, then left click in the center of the plot and then paste the data.
• Any column of data input adjacent to previous data in Excel is automatically added to any preexisting plot .

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:

Which of the following formulas could we place in cell B9 that we could copy/paste over into the entire range B9:G9 to make the chart dynamically update when we change the year in cell A9 ? Select all that apply.

• =INDEX(B4:G7,MATCH($A$9,$A$4:$A$7))
• =VLOOKUP(A9,A4:A7,MATCH($A$9,$A$4:$A$7),FALSE)
• =INDEX(B4:B7,MATCH($A$9,$A$4:$A$7,0))
• =VLOOKUP($A$9,$A$4:$G$7,COLUMN(),FALSE)
• =SUMIF($A$4:$A$7,$A$9,B4:B7)

Q3. Which of the following statements are TRUE ?

• If we wished to plot the average fuel economy of cars in the United States as a function of year and we also wanted to plot the average fuel economy of cars in Norway as a function of year, we would need to add a secondary axis.
• You are preparing a PowerPoint presentation for someone else across the world and you will email them the file when you are finished. You decide to embed an Excel chart into the PowerPoint presentation and then you email them the file. However, you forget to email them the embedded .xlsx file. When they open up the PowerPoint file they will NOT be able to see the embedded chart.
• Excel objects can be linked to both Word documents and PowerPoint presentations, but in either case the linked .xlsx file must always be available (i.e., on the same computer) in order for the linked object to show up.
• You cannot add multiple series to a traditional pie chart.
• When printing off Excel worksheets, there is no way to display column and row headings, unfortunately.

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

Q5. We wish to plot the following energy usage as a function of time on a scatterplot. Columns B and C represent the natural gas usage (in therms) for 2015 and 2016, respectively. Column D represents electricity consumption (in kWh) for 2016. Which of the following plots properly shows how we can visualize this information?

Note: Answers may be subject to wrong/missing or not available, please contact us on telegram or comment below if you found correct answers to avoid wrong/misguidance. it will help other students .

Get All Course Quiz Answers of Everyday Excel Specialization

Everyday Excel, Part 1 Coursera Quiz Answers

Everyday Excel, Part 2 Coursera Quiz Answers

Team Networking Funda

We are Team Networking Funda, a group of passionate authors and networking enthusiasts committed to sharing our expertise and experiences in networking and team building. With backgrounds in Data Science, Information Technology, Health, and Business Marketing, we bring diverse perspectives and insights to help you navigate the challenges and opportunities of professional networking and teamwork.

Related Posts

Client Needs and Software Requirements Coursera Quiz Answers

• August 31, 2022

Introduction to Software Product Management Coursera Quiz Answers

Introduction to Test Driven Development (TDD) Quiz Answers

• August 30, 2022

One comment

Part 3 k solutions bi please

Leave a Reply Cancel Reply

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

I accept the Privacy Policy *

Post Comment

Trending now

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

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

cousera part 3 (project) #3

hanvith6 commented Aug 28, 2022

Himanshuu95 commented Feb 7, 2023

Sorry, something went wrong.

bdfd commented Feb 9, 2023

Gapkor commented Mar 7, 2023

• 👎 1 reaction

mounseflit commented Apr 6, 2023

• 👍 2 reactions

darshit-jayswal commented Apr 8, 2023

selim202020 commented May 20, 2023

Navaminifernando15 commented Jun 5, 2023

• 😕 1 reaction

DevilSkul commented Jul 31, 2023 • edited

Devilskul commented jul 31, 2023, hanvith6 commented aug 11, 2023 via email.

ashiksm989 commented Oct 21, 2023

• 👍 1 reaction

juppongata commented Apr 30, 2024

No branches or pull requests

• Login | Signup
• Art & Design
• Computer Science
• Data Science
• Engineering
• Health & Medicine
• Humanities & Social Science
• Mathematics
• Education & Teaching

Everyday Excel, Part 1

Course summary, key learning points.

• Learn Excel basics such as formatting, navigating, and entering data
• Discover how to use formulas and functions to perform calculations
• Practice creating charts and graphs to visualize data

Job Positions & Salaries of people who have taken this course might have

• USA: $28,000 - $41,000
• India: ₹180,000 - ₹500,000
• Spain: €15,000 - €22,000
• USA: $30,000 - $50,000
• India: ₹180,000 - ₹550,000
• Spain: €16,000 - €25,000
• USA: $50,000 - $87,000
• India: ₹360,000 - ₹1,200,000
• Spain: €22,000 - €40,000

Related Topics for further study

• Excel Basics
• Formulas and Functions
• Charts and Graphs
• Data Visualization

Learning Outcomes

• Master Excel basics such as formatting and navigating
• Learn how to perform calculations with formulas and functions
• Create charts and graphs to easily visualize data

Prerequisites or good to have knowledge before taking this course

• Access to Microsoft Excel
• Basic computer skills

Course Difficulty Level

Course format.

• Video lectures
• Practice exercises

Similar Courses

• Excel Skills for Business Essentials
• Data Analysis with Excel

Related Education Paths

• Microsoft Office Specialist Certification
• Data Analyst Certification

Notable People in This Field

• Mike Girvin

Related Books

• Excel 2019 Bible
• Excel Formulas and Functions for Dummies

Description

"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools.

This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

• Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.
• Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).
• Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).
• Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables).
• Navigating Excel
• Welcome to Everyday Excel!
• What will I learn in the course?
• How to Switch Sessions of the Course
• Week 1 preview
• Basic features of Excel
• Saving and opening files
• Sheets, cells, rows and columns: Part 1
• Sheets, cells, rows and columns: Part 2
• Moving around the worksheet
• Editing the worksheet
• Cell formatting and conditional formatting
• Auto Fill and Fill Series
• OPTIONAL Example: Gantt Chart
• Formats for numbers, dates, and times
• Cell addressing modes
• Naming cells and cell ranges
• Introduction to VBA macros
• Excel is smart! (Quick Analysis tool and Ideas tool)
• Setting preferences in Excel
• Customizing Excel to English formats
• Assignment 1 preview and instructions
• The power of Microsoft Excel
• The importance of a Course Certificate and the future of higher education
• Auditing the course vs. purchasing a Course Certificate
• For Mac users
• If an Assignment is not showing up for you
• Week 1 Excel files
• Quiz 1 solutions and explanations
• Assignment 1
• Week 2 Excel files
• Unlock quiz for Week 1 files
• Expression Entry and Common Excel Functions
• Week 2 preview
• Excel syntax and order of operations
• Troubleshooting Excel formulas
• Introduction to functions in Excel
• Counting, summing, and averaging in Excel, Part 1
• Counting, summing, and averaging in Excel, Part 2
• Rounding and remainders
• Examples: Rounding and remainders
• Random numbers, combinations, and permutations
• The CHOOSE function
• OPTIONAL: The CONVERT function (for engineers and scientists)
• Assignment 2 preview and instructions
• Quiz 2 solutions and explanations
• Assignment 2
• Week 3 Excel files
• Assignment 2 submission
• More Excel functions
• Week 3 preview
• Making named ranges dynamic
• Previewing compatibility with earlier versions
• IF, AND, and OR
• Advanced logical functions in Excel
• Flash Fill: Advantages and disadvantages
• Text functions in Excel, Part 1
• Text functions in Excel, Part 2
• Excel's financial functions
• Introduction to array formulas
• Introduction to VBA user-defined functions
• Assignment 3 preview and instructions
• Quiz 3 solutions and explanations
• Assignment 3
• Week 4 Excel files
• Assignment 3 submission
• Managing Data
• Week 4 preview
• Applying a filter
• Using the FILTER function (Office 365)
• Creating an Excel Table
• Data validation and drop-down lists
• Sorting data in Excel
• The SORT and SORTBY functions (Office 365)
• Example: Sorting by columns
• Cleaning your data
• Removing duplicates
• Consolidating data
• One-way lookup functions, Part 1
• One-way lookup functions, Part 2
• The XLOOKUP function
• Assignment 4 preview and instructions
• Quiz 4 solutions and explanations
• Assignment 4
• Week 5 Excel files
• Assignment 4 submission
• Plotting, Importing Data, and Converting to Other File Types
• Week 5 preview
• Scatter plots in Excel, Part 1
• Scatter plots in Excel, Part 2
• Column and pie charts in Excel
• Dynamic charts
• Introduction to Pivot Tables
• Sharing worksheets and charts in Word and PowerPoint
• Printing Excel worksheets
• Example: Sales invoice as PDF file
• For Fun: Importing Geographic information
• Assignment 5 preview and instructions
• Quiz 5 solutions and explanations
• Assignment 5
• Assignment 5 submission

Summary of User Reviews

Key aspect users liked about this course, pros from user reviews.

• Clear explanations and examples
• Great introduction to Excel
• Instructor is knowledgeable and engaging
• Assignments are relevant and practical
• Easy to follow along with

Cons from User Reviews

• Some users found the course to be too basic
• Course material can be repetitive
• Limited coverage of advanced Excel functions
• No interaction with other students
• No certificate of completion offered
• Design and Product

Charlie NuttelmanTop Instructor

Recommended for you.

HR Analytics using MS Excel for Human Resource Management

Use Excel for HR Analytics, calculate HR metrics, build HR dashboards &amp; ML models for Human Resource &amp; People Analytics After completing this course you will be able to:...

Mental Survival Guide

Coping and Managing Stress during the COVID-19 Pandemic (and beyond) The information is relevant during and after the pandemic for creating a stress resilient life....

Math behind Moneyball

Learn how probability, math, and statistics can be used to help baseball, football and basketball teams improve, player and lineup selection as well as in game strategy....

Bridging healthcare and society

In contemporary societies healthcare is a key social institute that addresses the issues of maintenance and improvement of citizens’ health. How can healthcare provision and society be bridged?...

• Choose list Add new list

Create lists to save and organize courses you are interested in.

New list added

Are you sure you want to delete this list? This action will cause all your notes inside the list to be lost

Are you sure you want to delete this course? This action will cause all your notes inside the course to be lost

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor.

All list -->

Most Courses are under $20, with over 1000 free courses available from top Universities

By creating an email alert, you agree to Coursary's Terms of Service and Privacy Policy . You can pause or unsubscribe from email alerts at any time.

View Answer Keys

View the correct answers for activities in the learning path.

This procedure is for activities that are not provided by an app in the toolbar.

Some MindTap courses contain only activities provided by apps.

• Click an activity in the learning path.

To assess your understanding of the material covered in the chapter, please complete the following assignments.

Although Excel is primarily used in business and scientific applications, you will find it useful in other areas of study as well. In these exercises, we will use Excel to create charts using historical, and health data.

Charting Historical Data (Comprehensive Review)

Download Data File: PR4 Data

Excel is an excellent tool for helping display historical data. In this exercise, we will be examining ways to display information on minimum mage data and life expectancy.

Task1 – National Minimum Wages Changes in The United States 2019-2020

Since the beginning of the previous century, the United States has set a minimum wage, in order to set a “floor” beneath which wages cannot fall. Most states have set their own minimum wages, but none are lower than the national minimum wage. Follow the below steps to insert a Map Chart outlining what the current minimum wage is per state.

 1.  Open the file named PR4 Data and then Save As PR4 Historical Data.

 2.  On the Minimum Wage worksheet, select the range B4:B55.  Press and hold the  CTRL  key and select D4:D55 .

 3.  Select the Insert tab, then the Map Chart tool in the Charts group.

 4.  Move the Chart as a New Sheet .  Rename the sheet Map .

 5.  Update the Chart Title to US Minimum Wage 2020.

 6.  From the Charts Element menu choose to display the Data Labels .

 7.  From the Charts Element menu, turn off the Legend .

 8.  Prepare the Minimum Wage  worksheet for printing by changing the scaling to  Fit Sheet on One Page .

 9.  Save your work.

Task 2 – Oregon: Projected Life Expectancy at Birth

In the past 40 years, between 1970 and 2010, life expectancy for Oregon men improved by 8.7 years and for women by 5.5 years. Oregon’s life expectancy has remained slightly higher than the U.S. average. The life expectancy will continue to improve for both men and women. However, the gain for men has been outpacing the gain for women. Consequently, the difference between men’s and women’s life expectancies has continued to shrink.

https://www.oregon.gov/das/OEA/Documents/OR_pop_trend2012.pdf

 1.  On the Life Expectancy  sheet, select A5:B11.

 2.  From the Insert tab choose Recommend Charts. Select the second option, Clustered Column chart.

 3.  Move the chart to a new sheet. Name the sheet Men.

4.  Repeat steps above to create a matching chart for Life Expectancy for Oregon Women,  by selecting A5:A11 .  Press and hold the CTRL key and select C5:C11 .

5.  Use the Recommended Charts and select the Clustered Column chart.

6.  Move the chart to a new sheet. Name the sheet Women .

7.  Notice on the men’s and women’s vertical axis the min and maximum bounds do not match.  To ensure data is comparable, adjust the min and max bounds of both the Mens and Womens chart to chart to match:

8.  Return to the Life Expectancy tab, select A5:D11.

9.  Use the Recommended Charts tool to create a simple line chart.

10.  Change the Chart Title to Oregon: Projected Life Expectancy at Birth .

11.  Leave the chart embedded in the worksheet. Move and resize it accordingly.

12.  The line across the bottom of the chart represents the difference between men’s and women’s life expectancy. It is not very helpful as it is.  Right-click on the line to open the pop-up menu. Select Format Data Series . In the Format Data Series pane, under the Series Options tab, select the radio button in front of Secondary Axis .

13.  Close the Format Data Series pane.

14.  Use the Chart Style s tools to change your chart to something a bit more dramatic.

15.  Preview the Life Expectancy worksheet in Print Preview and make any necessary changes. The solutions are shown in below in Figure 4.35.

16.  Check the spelling on all of the worksheets and make any necessary changes. Save the PR4 Historical Data  workbook.

17.  Submit the PR4 Historical Data workbook as directed by your instructor.

Attribution

“4.5 Chapter Practice” by Hallie Puncochar and Noreen Brown , Portland Community College is licensed under CC BY 4.0

Excel Fundamentals Copyright © by Julie Romey is licensed under a Creative Commons Attribution 4.0 International License , except where otherwise noted.