In this blog you will find the correct answer of the Coursera quiz Excel Skills for Business Essentials Coursera week 4 Quiz mixsaver always try to bring the best blogs and best coupon codes
 

 Coursera week 4 Quiz

1. You want to insert 3 columns. Which of the options below will help you to achieve that?

Multiple answers are possible. Partial credit will be awarded.

  • You select 3 columns, right-click and go to Insert
  • You select a column then click the Insert button on the Home tab 3 times
  • You right-click on the column header and go to Insert, then type the number 3

2. Sean has carefully set up some complicated Conditional Formatting to one of the columns in his worksheet. He now wants to apply the same rules to another column in his worksheet. What is the quickest way for him to do this?

  • He can use the Format Painter.
  • He can copy and paste the original column and then delete the content of the cells using the Clear tool.
  • There is only one way, he needs to select the next column and then set up the Conditional Formatting rules again.

3. Open the attached workbook. You will notice that some columns have been hidden. Unhide the columns. What is the Product Name for order 5023-1?

W04-Assessment.xlsx

Enter answer here

pencils

4. Order 5024-1 was cancelled. Delete row 11 (not just the data). What is the updated average in cell S1? (Please put the number only, no currency symbols)

Enter answer here

$1,156.53

5. You need to find out about the most recent shipment. Sort the data by Ship Date. What was the Ship Date for the most recent item? Enter using yyyy-mm-dd format.

Enter answer here

2017-02-08

6. You need to check the most recent furniture item. Sort the data by Product Category (A-Z) and then Order Date (Newest to Oldest). What is the Order Priority for the most recently ordered Furniture Item?

  • Critical
  • High
  • Medium
  • Low
  • Not Specified

7. You have been asked to find out about orders placed by the customer Cindy Chapman. Filter the data to show only her orders. How many orders had Tina Carlton as the Account Manager?

1 point
Enter answer here

6

8.Clear the previous filter. Use filters to find out how many orders were for Small Business customers, where the Account Manager is Natasha Song, with a High priority.

1 point
Enter answer here

7

9.
Question 9
Clear the previous filters. Use filters to find out how many orders were for Technology and had a Total over $20,000.

1 point
Enter answer here

10

10.
Question 10
Clear the previous filters. Apply a new filter to show the top 1% of orders by Total. What is the Average Quantity for the top 1% (cell M1043).

1 point
Enter answer here

46

11. Use the find tool to find order number 6044-1. What is the Priority for this order?

Enter answer here

Medium

12. Tina Carlton has recently married and has chosen to take her partner’s name. Start by clicking in cell A1. Use Find and Replace to replace all instances of Tina Carlton with Tina Shaw. Check the message — how many replacements were made?

On a Mac, go to the Edit menu > Find > Replace. Enter answer here

137

 

Important link:

Trustpilot