I have done step 1 I am confused on the steps that follow I have pasted section 2 and 3 of the spreadsheet for reference I need help getting past step 2 to continue Begin by following the steps in the How to Copy Excel 2010 Sheet to Another Sheet provided below This will allow you to retain your work for Steps 2 through 7 Place the sheet at the end of the workbook and title the tab Sorted Data Delete all rows containing Section 2 and Section 3 work Be sure to leave the section in cells F417 I422, as this section is referenced for the Vlookup function populating the region otherwise, you will get a N A or REF Error in the column for region Apply the ability to sort data on each column of the spreadsheet, so that you can sort by employee , hire date, role, etc Experiment with the filter funnel, sorting the data by various columns For example, try sorting by employee number from smallest to largest Try sorting by role in ascending order (A Z) Sort the spreadsheet by region Employ the subtotal feature to subtotal the salary for each region, with a grand total for the company Format the entire spreadsheet to print, so that the columns fit on the pages, and Row 1 repeats on each page fLee Counn Wis Fr 2004 216 CFO Hapanic 3007 COO HAS5471 iT HET 1 Gender Advirig 1 800 401 IT Stall 12 HS 14 Mick 2065410 210 1 Married Muching 154 Shape Admin Excel Summary Sets Graph Chats Hologram Santed Date Sorted DriAAAAAAAAAA Projected SalmLan Caunn Win Win Controller 1 1547406 37 1547141 400 1592018 3017 Sho My 1 Chailr 10 411 Burch 412 Miching Admin 15 17 Region C Plain 431 Saned Date Sorted DRINAAAAAAAAA Projected Salma PLOCOLing Column Win Communi Section 1 Complete Descriptive Statistics I'm were to indode the correct ante where applicable for the summary ifathin below Salary Hirig Rue Frequency Table by Clary SALIM 30800 4 Variance 41 50 1 FEE 12 415 101 14 111 17 438 Years numbers are correct but they do not them comet information 171 1M Is Mode made it the number chat in reported the most Show me $34 in the hourly rica 101 14 Add haadar Level Summary Such Graph Chats Hologram Soned Date Sorted DELAAAAAAAAAA Proceed Salm

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 30, 2024

I have done step 1. I am confused on the steps that follow. I have pasted section 2 and 3 of the spreadsheet for reference.

I have done step 1. I am confused on the steps that follow. I have pasted section 2 and 3 of the spreadsheet for reference. I need help getting past step 2 to continue.

Begin by following the steps in the "How to Copy Excel 2010 Sheet to Another Sheet" provided below. This will allow you to retain your work for Steps 2 through 7. Place the sheet at the end of the workbook and title the tab "Sorted Data."
Delete all rows containing Section 2 and Section 3 work. Be sure to leave the section in cells F417:I422, as this section is referenced for the Vlookup function populating the region; otherwise, you will get a #N/A or #REF! Error in the column for region.
Apply the ability to sort data on each column of the spreadsheet, so that you can sort by employee #, hire date, role, etc.
Experiment with the filter funnel, sorting the data by various columns. For example, try sorting by employee number from smallest to largest. Try sorting by role in ascending order (A-Z).
Sort the spreadsheet by region.
Employ the subtotal feature to subtotal the salary for each region, with a grand total for the company.
Format the entire spreadsheet to print, so that the columns fit on the pages, and Row 1 repeats on each page.

\fLee Counn Wis Fr 2004 216 CFO Hapanic 3007 COO HAS5471 iT HET 1 Gender Advirig 1 800 401 IT Stall 12 HS 14 & Mick 2065410 210 1 Married Muching 154 Shape Admin Excel Summary Sets Graph Chats Hologram Santed Date Sorted DriAAAAAAAAAA Projected SalmLan Caunn Win Win Controller 1 1547406 37 1547141 400 1592018 3017 Sho My 1 Chailr #10 411 Burch 412 Miching Admin #15 #17 Region C.Plain 431 Saned Date Sorted DRINAAAAAAAAA Projected Salma PLOCOLing Column Win Communi Section 1: Complete Descriptive Statistics I'm were to indode the correct ante where applicable for the summary ifathin below Salary Hirig Rue Frequency Table by Clary SALIM 30800 4 Variance 41-50 1 FEE 12 415 101-14 111-17 438 Years numbers are correct but they do not them comet information 171-1M Is Mode.- made it the number chat in reported the most. Show me $34 in the hourly rica 101-14 Add haadar Level Summary Such Graph Chats Hologram Soned Date Sorted DELAAAAAAAAAA Proceed Salm