what is the completion code for assignment 1

Book Appointment Now

Everyday Excel, Part 1 Coursera Quiz Answers – Networking Funda

• On January 26, 2022
• In Computer Science Quiz

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

Newsletter Updates

Enter your email address below and subscribe to our newsletter

I accept the Privacy Policy

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.

Post Comment

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

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 You must be signed in to change notification settings

Latest commit

File metadata and controls.

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 :).

• Understanding the Data

Assignment - Part 1

This page is currently being modified. This message will disappear when completed.

Used to record registration/enrollments into any service provided including courses, conferences, etc.  A Client can only have one Assignment record per course code.

Main Menu > Clients > Assignment

Applies To:    Enterprise    Plus    Basic

Field Details

The Client Assignment record is segmented into five panels. The Information panel can be modified to display fewer or more fields from the other panels using  Custom Field Displays .

Assignment Information Panel

• Course Code:  Full Course Code for client assignment.  Use the Show List button to view a list of Course Sections.
• Start Date: Date Client started activity.  Value defaults to start date of course when a new assignment record is created.
• End Date: Date Client ended activity.  Value defaults to end date of course when a new assignment record is created.
• Client Program:  If using Program Tracking, this select list for program enrollment will display.
• Enrollment Status: Assignment status of client.  Value defaults to Enrolled/Active when a new record is created.  Not a user defined list.  Roster reports include all values except "Applicants" and "Waiting List".  "Enrolled/Hold" is treated exactly the same as "Enrolled/Hold" for Rosters, Countbook, and any report including automatic enrollment counts.  The "Enrolled/Hold" value gives users a method to maintain an active Enrollment Status but flag the Assignment for some special purpose.
• Quantity:  The number of slots being registered.  This field only appears for Corporate clients or Course Sections with a Maximum Qty Purchase greater than 1.
• Status Code: User defined field for customizing internal Assignment enrollment status.  Uses the Status Code table.
• Completion Code: User defined field for customizing internal Assignment completion status.  Uses the Completion Code table.
• Purpose:  Reason or goal for taking course.  This is not a user defined list.  Note that the value “Private” is used to track in-house registrations and will restrict the assignment from displaying on the WebReg module MyAccount registrations page.
• Accepted Refund Policy:  Defaults to No.  Value will automatically update to Yes for WebReg registrations if the Force Refund Acceptance feature is enabled.
• Registration Date:  Date of client registration.  Value defaults to current date when a new record is created.
• Wait List Date and Time: Date and time client added to a waiting list.  Used to help determine order in which clients would be called if a registration opening occurs.  Use the Current Button to automatically add the current date and time.
• Wait List Contact: Status of enrollment after contacted from waiting list.  Not a user defined field.
• Vendor:  If registration is from a third party vendor, select the vendor name from the list.
• Company:  If the registration is for a specific Company, select for the list.  Some features that add multiple assignments may automatically record the Company in this field if the client is a Corporate client or the Company name was selected during the process..
• Registered By: Method client used to register for this activity.  Not a user defined list.
• Primary Member Link:  This field allows a user to link this Assignment to the client’s Primary Account Member, if applicable.  After 2/12/2013, this field autopopulates when using the OnHold feature from the Multiple Assignment function.  If this field has a value, the Primary Member can only see these course assignments in the member’s account when logged into the WebReg module.  Assignments not linked to the Primary Account cannot be only be viewed on the WebReg module in the MyAccount section by the registrant only.
• How Heard: How client heard about the course or activity.  List pulls from Marketing Source table.  This field differs from the "How Heard" in Client/Intake where "How Heard" refers to the overall program organization. 
• Marketing Source:  An open text field for recording a marketing code or catalog code related to a marketing campaign.  Maximum length is 15 characters.

Exit Info Panel

• Reason Left Class: Reason client is no longer active in the activity.  See Termination Reasons for this user defined field.
• Reason No Show: Reason client did not show for activity.  See Termination Reasons for this user defined field.
• Zero Balance Due: This checkbox is used to submit a flag to XenDirect functions and reports that no revenue is due for this course.  Check this field if the client has a no balance due yet based on refunds or other calculations, a balance due exists.  If checked, no balance will appear as due.  An example would be Client Assignments that have had partial or full refunds.
• Reenter Date: If client terminated from activity and then returned within the same program year, this is the date client returned to activity.  Set Enrollment Status back to Enrolled/Active and revise the end date.  Note:  A client cannot have two assignment records in the same course.
• Original Exit Date: If client terminated from activity and then returned within the same program year, this is the date client originally exited from the activity.  Set Enrollment Status back to Enrolled/Active and revise the end date.  Note:  A client cannot have two assignment records in the same course.
• Transferred To: If client left this activity and transferred to another activity, enter the Course Code for the new activity.

Grades and Outcomes Panel

• Grade: The final, overall grade for the activity.  Grade can be alpha or numeric characters.
• Grade Version:  Version of grade being used.
• Exam Grade: Final exam grade.
• Days Attended:  Number of days a client attended this course section.
• Hours Attended:  Number of hours a client attended this course section.
• Date Issued Certificate: Date client was issued a certificate for this activity.
• Earned Credits:  Number of credits earned for this course section.
• Credit Type: Type of Credit.  User defined list.
• Pass/Fail:  Pass = Yes and Fail = No
• Transfer Credits:  Number of credits transferred in.
• Repeat Course:  Check Yes if this course was taken again causing this assignment to be voided.
• Include on Transcript:  Check yes if this should be included in the transcript report.
• Transcript Status:  Status to display on transcript report.  This is not a user defined list.
• Transcript Credits:  Number of credits to display on transcript report if different than Earned Credits.
• Transcript Points:  Number of points to display on transcript report.

Other/Notes Panel

• Non-Traditional Enrollment: Is client's enrollment in this activity considered non-traditional based on gender?
• EPE: Is client's enrollment in this activity eligible for EPE or other contact hours based funding sources?
• CTEDS: Should the client's enrollment in this activity be included in the CTEDS reports?
• CTEDS Outcome:  Select as many of these outcomes as applicable.  This field covers Secondary CTEDS only.  The 'Survey' value is for internal use only and is not taken into account for the CTEDS report.
• CTEDS Status: If CTEDS = Yes, what is the CTEDS completion status for this activity.
• SIRS Status:  Select as many of these status values as applicable.
• Exclude From NRS:  Check this field if this Client's Assignment should NOT be included in the NRS report.  Only relevant to Basic Education and ESOL activities.
• Roster Notes: User notes.  Text entered here will print (optional) on some roster reports. 
• Special Needs: Does client have any special accommodation needs for this enrollment?
• Receipt Notes: User notes.  Text entered here will print (optional) on some receipt reports. 
• Other Notes: User notes.

Invoices Panel

• Non-Traditional Enrollment: Is the Client's enrollment in this activity considered non-traditional based on gender?