Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

  1. 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."
  2. 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.
  3. Apply the ability to sort data on each column of the spreadsheet, so that you can sort by employee #, hire date, role, etc.
  4. 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).
  5. Sort the spreadsheet by region.
  6. Employ the subtotal feature to subtotal the salary for each region, with a grand total for the company.
  7. Format the entire spreadsheet to print, so that the columns fit on the pages, and Row 1 repeats on each page.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
\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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Active Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

2nd Edition

0130674842, 978-0130674845

Students also viewed these Economics questions