Chat with us, powered by LiveChat USING MICROSOFT EXCEL 2016 Independent Project 6-5 (Mac 2016)  | Writedemy

USING MICROSOFT EXCEL 2016 Independent Project 6-5 (Mac 2016) 

23 Aug USING MICROSOFT EXCEL 2016 Independent Project 6-5 (Mac 2016) 

Posted at 07:26h in 1Academic Level by

USING MICROSOFT EXCEL 2016 Independent Project 6-5 (Mac 2016) 

 

Independent Project 6-5 (Mac 2016 Version)

Classic Gardens and Landscapes counts responses to mail promotions to determine effectiveness. You use SUMIFS and a nested IF formula to complete the summary. You also calculate insurance statistics and convert birth dates from text to dates. 

 

Skills Covered in This Project 

  • Nest MATCH and INDEX functions.
  • Create DSUM formulas.
  • Build an IFS function.

• Build SUMIFS formulas.
• Use DATEVALUE to convert text to

dates.

 

Step 1 

Download start file

  1. Open the ClassicGardens-06 start file. Click the Enable Editing button. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  2. Create a nested INDEX and MATCH function to display the number of responses from a city.
    1. Click the Mailings sheet tab and select and name cells A3:D28 as Responses
    2. Click the Mailing Stats sheet tab.
    3. Click cell B21 and type Carthage.
    4. Click cell C21, start an INDEX function, and select the first argument list option.
    5. Choose the Responses range for the Array argument.
    6. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and
      cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box
      and type 0.
    7. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function to
      look up cell D3 on the Mailings sheet in the lookup array A3:D3.
    8. Click the Match_type box and type 0 (Figure 6-105).
      Important: There is a known bug in Excel for Mac that places plus signs ( + ) instead of commas ( , ) between the arguments when using the Formula Builder. If this is the case in your Excel for Mac version, replace the plus signs with commas.

 

Excel 2016 Chapter 6 Exploring the Function Library Last Updated: 3/27/19 Page 1 

 

USING MICROSOFT EXCEL 2016 Independent Project 6-5 (Mac 2016) 

 

  1. Format the results to show zero decimal places.
  2. Type Smyrna in cell B21.
  3. Use DSUM to summarize mailing data.
    1. On the Mailings sheet, note that number sent is located in the third column and response data is in
      the fourth column.
    2. Click the Criteria sheet tab. Select cell B2 and type lan* to select data for the Landscape Design
      department.
    3. Click the Mailing Stats sheet tab and select cell B7.
    4. Use DSUM with the range name Responses as the Database argument. Type 3 for the Field
      argument, and use an absolute reference to cells B1:B2 on the Criteria sheet as the Criteria
      argument.
    5. Copy the formula to cell C7 and edit the Field argument to use the fourth column.
    6. Complete criteria for the two remaining departments on the Criteria sheet.
    7. Click the Mailing Stats sheet tab and select cell B8.
    8. Use DSUM in cells B8:C9 to calculate results for the two departments.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Writedemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Print page