Question 10 You've been asked to order branded shirts for all the employees in your company. You've been given a spreadsheet that contains everyone's preferred shirt size and their employee ID. Before you complete the order by filling in the last tab titled `Order Details` you need to check you have the correct information. Have all the employees provided a preferred shirt size? and are their employee ID's valid? Complete the following tasks: 1. On the Company Employees tab, use a function to identify the employees that haven't provided their preferred size 2. On the Survey Results tab, use a function to identify if there are any employee IDs that are not on the Company Employee tab. 3. Using either a function, pivot table, or chart, identify how many of each shirt you need to order to complete the table in the Order Details tab View Spreadsheet
Question 10 You've been asked to order branded shirts for all the employees in your company. You've been given a spreadsheet that contains everyone's preferred shirt size and their employee ID. Before you complete the order by filling in the last tab titled `Order Details` you need to check you have the correct information. Have all the employees provided a preferred shirt size? and are their employee ID's valid? Complete the following tasks: 1. On the Company Employees tab, use a function to identify the employees that haven't provided their preferred size 2. On the Survey Results tab, use a function to identify if there are any employee IDs that are not on the Company Employee tab. 3. Using either a function, pivot table, or chart, identify how many of each shirt you need to order to complete the table in the Order Details tab View Spreadsheet
Essentials Of Business Analytics
1st Edition
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Camm, Jeff.
Chapter6: Data Mining
Section: Chapter Questions
Problem 7P
Related questions
Question
Transcribed Image Text:Question 10
You've been asked to order branded shirts for all the employees in your company. You've been given
a spreadsheet that contains everyone's preferred shirt size and their employee ID. Before you
complete the order by filling in the last tab titled `Order Details` you need to check you have the
correct information. Have all the employees provided a preferred shirt size? and are their employee
ID's valid?
Complete the following tasks:
1. On the Company Employees tab, use a function to identify the employees that haven't provided
their preferred size
2. On the Survey Results tab, use a function to identify if there are any employee IDs that are not on
the Company Employee tab.
3. Using either a function, pivot table, or chart, identify how many of each shirt you need to order to
complete the table in the Order Details tab
View Spreadsheet
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage