The 'member names' and 'membership information' tabs contain (fictitious) member information. For context, we distinguish members by their location (local to LA or non-local) and the sector in which they work (for profit or non-profit). In Sheet 1, please count (using a formula) the number of 'local' and 'non-local' members we have based on the 'membership information' tab, and enter a chart that shows the proportion of one to the other. Choose the chart type that you think is best suited. 2)Create another sheet named 'chart training' in which you explain to a colleague how to create a chart like the one you created from a similar list of membership information, so they could repeat the process independently later. 3)The 'member names' tab contains 500 names and corresponding member ID; 'membership information' contains the membership descriptor and birthdates for 250 of those members, also with corresponding IDs. In Sheet 2, please create a list that matches member names with their membership information & birthdates using the Membership IDs provided. 2)Leave the formulas you used intact in Sheet 2 and copy the information as values into Sheet 3. (There should be a list of 250 members with IDs, names, birthdate, and membership information in Sheet 3 when you are done). 3)Create another sheet named 'matching training' in which you explain to a colleague how to match based on ID like you did in sheet 3, so they could repeat the process independently later.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Can someone show me a screenshot of how the answer would look and where to install the formulas:

The following tasks are designed to test your resourcefulness and your communication skills. It was designed to take less than one hour. Please submit the assessment even if you did not fully complete it in the time allocated. If you were unable to fully complete it, please include a brief explanation of where you had the most difficulty/ what took the most time.

Please complete the following tasks within this worksheet and return the excel file to us via email within 1 hour.

1)The 'member names' and 'membership information' tabs contain (fictitious) member information. For context, we distinguish members by their location (local to LA or non-local) and the sector in which they work (for profit or non-profit).

In Sheet 1, please count (using a formula) the number of 'local' and 'non-local' members we have based on the 'membership information' tab, and enter a chart that shows the proportion of one to the other. Choose the chart type that you think is best suited.

2)Create another sheet named 'chart training' in which you explain to a colleague how to create a chart like the one you created from a similar list of membership information, so they could repeat the process independently later.

3)The 'member names' tab contains 500 names and corresponding member ID; 'membership information' contains the membership descriptor and birthdates for 250 of those members, also with corresponding IDs.

In Sheet 2, please create a list that matches member names with their membership information & birthdates using the Membership IDs provided.

2)Leave the formulas you used intact in Sheet 2 and copy the information as values into Sheet 3. (There should be a list of 250 members with IDs, names, birthdate, and membership information in Sheet 3 when you are done).

3)Create another sheet named 'matching training' in which you explain to a colleague how to match based on ID like you did in sheet 3, so they could repeat the process independently later.

Please note:

We expect you to use excel formulas to provide the most accurate result, but we do not expect you to know these formulas off the top of your head. You are encouraged to use online resources to find the formula to best provide the desired results. In your description of the process, please communicate as if the instructions are meant for a person with only basic excel skills.

SAVE

bookmark_border

Expert Solution

arrow_forward

Step 1

Please Refer the points below for your assignment, hope these answers will help you:

arrow_forward

Step 2

In Sheet 1, I would use the COUNTIF function to count the number of members who are local and the number who are non-local based on the membership information tab. I would then create a pie chart to show the proportion of local to non-local members. To create this chart, I would highlight the two cells with the COUNTIF formulas, click on the "Insert" tab, select "Pie chart" and adjust the chart as needed.

In Sheet 2, I would create a new sheet named "Chart Training". In this sheet, I would provide step-by-step instructions on how to create a chart like the one I created in Sheet 1. I would start by explaining how to use the COUNTIF function to count the number of local and non-local members, then explain how to create a pie chart using the data from the COUNTIF formulas. I would also include screenshots and images to help illustrate the process.

In Sheet 2, I would use the VLOOKUP function to match the member names with their membership information and birthdates using the Membership IDs provided. I would start by creating a new sheet, then in the first column, I would input the membership IDs. In the second column, I would use the VLOOKUP function to match the membership IDs with the member names in the 'member names' tab. In the third column, I would use the VLOOKUP function again to match the membership IDs with the membership information and birthdates in the 'membership information' tab. I would then adjust the column width and add a header row to make the data easy to read.
In sheet 3, I would select the data from sheet 2 and use paste special then select value to copy the data as values only.
In 'matching training' sheet, I would explain the process of using VLOOKUP function to match data based on a common ID and retrieve related information from another sheet. I would also provide an example and explain the syntax and usage of the VLOOKUP function for a better understanding.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.