Working with Data Navigate to the Working with Data Tutorials using this linkhttps://edu.gcfglobal.org/en/excel/(Links to an external site.). Follow the directions next to each tutorial title....

1 answer below »
Working with Data

Navigate to theWorking with DataTutorials using this linkhttps://edu.gcfglobal.org/en/excel/(Links to an external site.).Follow the directions next to each tutorial title. Remember, you may be quizzed on this material as well.Do not submit the assignment until all three files are attached. The documents you submit should look like the documents shown at the end of each Challenge.


18.. Freezing Panes and View Options - Review the tutorial.


19. Sorting Data - Save the Challenge! Practice Document as YourUsername_Sort and attach to assignment. (10 points)


20. Filtering Data - Save the Challenge! Practice Document as YourUsername_Filter and attach to assignment. (10 points)


21. Groups and Subtotals - Review the tutorial.


22. Tables - Review the tutorial.


23. Charts - Review the tutorial.


24. Conditional Formatting - After Step 7, Save the Challenge! Practice Document as YourUsername_Condition and attach to assignment. (10 points)








Free Excel Tutorial at GCFGlobal close search search menu Topics English expand_more expand_less Español Português Excel In this free Excel tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets. Go to YouTube Playlist close I want to... Get started with computers Learn Microsoft Office Apply for a job Improve my work skills Design nice-looking docs More... Microsoft Office 2019 | 2016 | 2013 Word Excel PowerPoint Access Excel Formulas More... Basic Skills Computers Smartphones & Tablets Typing Tutorial Windows More... Internet Skills Internet Online Safety Social Media Email Search Better More... Google Gmail Google Docs Google Sheets More... Work & Career Career Planning Resume Writing Cover Letters Job Search and Networking Business Communication More... Skills for Today Adapting to Change 3D Printing Wearables Freelance Work Personal Finance Sharing Economy Decision-Making More... Creativity & Design Graphic Design Creativity Photography Image Editing Photoshop More... Core Skills Math Reading Grammar Language Learning More... For Educators Translations Staff Picks All Topics search menu All Topics My Account About Us FAQ Contact Us EN ES PT search 5c096a7d77c050035472858c Excel Basics 1 Getting Started with Excel arrow_forward_ios ✓ Learn your way around the Excel environment. 2 Understanding OneDrive arrow_forward_ios ✓ Learn all about working with your Microsoft account and OneDrive. 3 Creating and Opening Workbooks arrow_forward_ios ✓ Learn how to create and open Excel workbooks. 4 Saving and Sharing Workbooks arrow_forward_ios ✓ Learn how to save and share Excel workbooks. Working with Cells and Sheets 5 Cell Basics arrow_forward_ios ✓ Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions. 6 Modifying Columns, Rows, and Cells arrow_forward_ios ✓ Learn how to modify rows, columns, and cells in Excel. 7 Formatting Cells arrow_forward_ios ✓ Learn all about formatting text in Excel. 8 Understanding Number Formats arrow_forward_ios ✓ Learn all about formatting numbers in Excel. 9 Working with Multiple Worksheets arrow_forward_ios ✓ Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets. 10 Using Find & Replace arrow_forward_ios ✓ Learn how to use Excel's Find and Replace features to search for specific data. 11 Checking Spelling arrow_forward_ios ✓ Learn how to use Excel's spell check feature. 12 Page Layout and Printing arrow_forward_ios ✓ Learn how to use Excel commands that let you control the way your content will appear on a printed page. Formulas and Functions 13 Intro to Formulas arrow_forward_ios ✓ Learn how to use cell references to create a simple formula in Excel. 14 Creating More Complex Formulas arrow_forward_ios ✓ Learn how to create a complex formula in Excel. 15 Relative and Absolute Cell References arrow_forward_ios ✓ Learn all about absolute and relative cell references and how they're used in Excel. 16 Functions arrow_forward_ios ✓ Learn the different parts of a function and how to create arguments to calculate values and cell references. Working with Data 17 Basic Tips for Working with Data arrow_forward_ios ✓ Learn these basic tips for working with data to help you organize it and find what you need. 18 Freezing Panes and View Options arrow_forward_ios ✓ Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet. 19 Sorting Data arrow_forward_ios ✓ Learn how to sort data to better view and organize the contents of your spreadsheet. 20 Filtering Data arrow_forward_ios ✓ Learn how to filter the data in your worksheet to display only the information you need. 21 Groups and Subtotals arrow_forward_ios ✓ Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet. 22 Tables arrow_forward_ios ✓ Learn how to use styles to format tables in Excel. 23 Charts arrow_forward_ios ✓ Learn how to insert and modify Excel charts to visualize comparisons in your data. 24 Conditional Formatting arrow_forward_ios ✓ Learn how to apply, modify, and delete conditional formatting rules in Excel. Doing More with Excel 25 Comments and Co-authoring arrow_forward_ios ✓ Learn how to use Excel's track changes and comments features when proofreading workbooks. 26 Inspecting and Protecting Workbooks arrow_forward_ios ✓ Learn how to inspect and protect your Excel workbook. 27 Intro to PivotTables arrow_forward_ios ✓ Learn how to use PivotTables in Excel for stronger data analysis. 28 Doing More with PivotTables arrow_forward_ios ✓ Learn how to do more with PivotTables to better summarize data. 29 What-if Analysis arrow_forward_ios ✓ Learn how to use what-if analysis to answer different types of questions. Extras 30 What is Office 365? arrow_forward_ios ✓ Learn what Office 365 has to offer in this free lesson. 31 New Features in Office 2019 arrow_forward_ios ✓ Discover some of the new features in Office 2019. 32 What are Reference Styles? arrow_forward_ios ✓ Learn all about using reference styles in Excel. 33 Office Intelligent Services arrow_forward_ios ✓ Learn more about the features available through Intelligent Services. 34 Using the Draw Tab arrow_forward_ios ✓ Learn how to use the features available on the Draw tab. 35 Working with Icons arrow_forward_ios ✓ Learn how to add and customize icons. Quiz 36 Excel Quiz arrow_forward_ios ✓ Test your knowledge of Excel by taking our quiz. keyboard_arrow_up keyboard_arrow_down About Us Who We Are Meet the Staff Who Uses Us + Our Partners Educators' Resources Teacher Guides Resources and Tools Help and Support FAQ Terms of Use Contact Us My Account ©1998-2020 Goodwill Community Foundation, Inc. All rights reserved. keyboard_arrow_up keyboard_arrow_down ©1998-2020 Goodwill Community Foundation, Inc. All rights reserved.
download-8-4n4mz1xz.html
Answered Same DaySep 15, 2021

Answer To: Working with Data Navigate to the Working with Data Tutorials using this...

Angel K answered on Sep 15 2021
141 Votes
excel_charts_practice.xlsx
Fiction Book Sales
        Genre        January        February        March        April        May
        Classics        $18,580        $49,225        $16,326        $10,017        $26,134
        Mystery        $78,970        $82,262        $48,640        $49,985        $73,428
        Romance        $24,236        $131,390        $79,022        $71,009        $81,474
        Sci-Fi & Fantasy        $16,730        $19,730        $12,109        $11,355        $17,686
        Young Adult        $35,358        $42,685        $20,893        $16,065        $21,388
Challenge
        Salesperson        September        October        November        December
        Watson        $124,192.00        $156,934.00        $110,239.00        $160,304.00
        Chang        $189,264.00        $204,718.00        $156,823.00        $210,472.00
        Hassan        $205,127.00        $198,323.00        $207,182.00        $159,827.00
        Krzywinksi        $103,284.00        $164,728.00        $189,317.00        $174,625.00
        Smith        $184,280.00        $102,847.00        $178,230.00        $201,842.00
Sheet1
September to December Sales
Watson    September    October    November    December    124192    156934    110239    160304    Chang    September    October    November    December    189264    204718    156823    210472    Hassan    September    October    November    December    205127    198323    207182    159827    Krzywinksi    September    October    November    December    103284    164728    189317    174625    Smith    September    October    November    December    184280    102847    178230    201842    
excel_conditionalformatting_practice.xlsx
Sales Data
        Westbrook Parker Sales Data
        Salesperson        May        June        July        August        September        October
        Albertson, Kathy        $3,799.00        $557.00        $3,863.00        $1,117.00        $8,237.00        $8,690.00
        Allenson, Carol        $18,930.00        $1,042.00        $9,355.00        $1,100.00        $10,185.00        $18,749.00
        Altman, Zoey        $5,725.00        $3,072.00        $6,702.00        $2,116.00        $13,452.00        $8,046.00
        Bittiman, William        $1,344.00        $3,755.00        $4,415.00        $1,089.00        $4,404.00        $20,114.00
        Brennan, Michael        $8,296.00        $3,152.00        $11,601.00        $1,122.00        $3,170.00        $10,733.00
        Carlson, David        $3,945.00        $4,056.00        $3,726.00        $1,135.00        $8,817.00        $18,524.00
        Collman, Harry        $8,337.00        $4,906.00        $9,007.00        $2,113.00        $13,090.00        $13,953.00
        Counts, Elizabeth        $3,742.00        $521.00        $4,505.00        $1,024.00        $3,528.00        $15,275.00
        David, Chloe        $7,605.00        $3,428.00        $3,973.00        $1,716.00        $4,839.00        $13,085.00
        Davis, William        $5,304.00        $1,562.00        $2,945.00        $1,176.00        $9,642.00        $13,714.00
        Dumlao, Richard        $9,333.00        $2,779.00        $7,549.00        $1,101.00        $5,850.00        $15,065.00
        Farmer, Kim        $1,103.00        $3,470.00        $3,862.00        $1,040.00        $10,024.00        $18,389.00
        Ferguson, Elizabeth        $1,333.00        $1,913.00        $4,596.00        $1,126.00        $5,503.00        $10,686.00
        Flores, Tia        $12,398.00        $2,883.00        $2,142.00        $2,014.00        $13,547.00        $21,983.00
        Ford, Victor        $3,251.00        $4,931.00        $8,283.00        $1,054.00        $9,543.00        $11,967.00
        Hodges, Melissa        $4,624.00        $4,798.00        $8,420.00        $1,389.00        $10,468.00        $12,677.00
        Jameson, Robinson        $2,552.00        $4,459.00        $2,248.00        $1,058.00        $6,267.00        $14,982.00
        Kellerman, Frances        $4,281.00        $4,172.00        $11,074.00        $1,282.00        $2,365.00        $9,380.00
Challenge
        First Quarter Grades
        Student Name        Unit 1 Quiz 1        Unit 1 Test        Unit 2 Quiz 1        Unit 2 Quiz 2        Unit 2 Test        Unit 3 Quiz 1        Unit 3 Test        1st Quarter Project        Midterm
        Jackson Love        70        75        88        90        72        69        75        93        85
        Priya Patel        97        100        92        95        96        68        95        92        93
        Sharia Clemmons        95        97        45        79        83        95        94        100        92
        Ming Lu        91        93        89        95        97        84        85        88        99
        Sadie Carter        86        84        93        89        94        77        88        87        86
        Jensen Howard        54        70        87        72        85        65        74        94        70
        Tyriq Hilton        77        85        76        90        68        72        78        94        87
        Maria Saldana        100        96        93        87        88        87        92        95        95
        Kyle Jacobs        90        89        91        93        94        88        95        88        95
        John Feinstein        89        67        84        87        85        80        90        93        95
        Carter Zhou        75        68        82        83        85        84        66        50        68
        Jose Marco Hernandez        93        87        86        91        93        95        82        99        85
        Betsy Michaels        90        95        80        73        76        71        88        85        77
        Dexter Cooper        62        71        76        84        80        85        87        93        68
        Quanisha Johnson        100        98        86        89        93        95        96        97        92
excel_filtering_practice.xlsx
Sheet1
        ID #        Type        Equipment Detail        Checked Out        Checked In        Checked Out By
        3000        Camera        Saris Lumina Digital Camera        12-May-15        15-May-15        Shannon Nguyen
        3005        Camera        Saris Zoom Z-60 Digital Camera        27-Jul-15        06-Aug-15        Sela Shepard
        1021        Laptop        15" EDI SmartPad L200-3 Laptop        15-Sep-15        01-Oct-15        Sofie Ragnar
        1022        Laptop        15" EDI SmartPad L200-3 Laptop        14-Aug-15        16-Aug-15        Hank Sorenson
        1023        Laptop        15" EDI SmartPad L200-3 Laptop        08-Aug-15        15-Aug-15        Jennifer Weiss
        3070        Camera        Omega PixL Digital Camcorder        06-Oct-15                Min Seung
        1025        Laptop        15" EDI SmartPad L200-4X        26-Sep-15        04-Oct-15        Min Seung
        1031        Laptop        17" Saris X-10 Laptop        04-Oct-15                Nick Ortiz
        1032        Laptop        17" Saris X-10 Laptop        19-Sep-15                Stanley Geyer
        1033        Laptop        17" Saris X-10 Laptop        24-Sep-15        26-Sep-15        George D'Agosta
        1034        Laptop        17" Saris X-10 Laptop        25-Aug-15        27-Aug-15        Jay Peralta
        2050        Other        EDI SmartBoard L500-1        05-Oct-15        06-Oct-15        Anthony Liddell
        2051        Other        EDI SmartBoard L500-1        01-Oct-15        05-Oct-15        Sofie Ragnar
        3800        Other        U-Go Saris DigiCam Printer II        04-Aug-15        05-Aug-15        Hank Sorenson
        3900        Other        U-Go Saris Label Maker        13-Jun-15        20-Jun-15        Clint Gosse
        4800        Other        7N Deluxe Camera Travel Bag        27-Jul-15        06-Aug-15        Sela Shepard
        4900        Other        7N Light Rolling Laptop Case        04-Oct-15                Jay Peralta
        4905        Other        7N Heavy Rolling Laptop Case        04-Oct-15                Nick Ortiz
        6100        Projector        Omega VisX 1.0        28-Sep-15        01-Oct-15        Win Armitage
        6101        Projector        Omega VisX 1.0        26-Sep-15        27-Sep-15        Michael Earley
        6102        Projector        Omega VisX 1.0        22-Aug-15        23-Aug-15        Jamila Kyle
        6200        Projector        Saris Lux T-80        01-Sep-15        04-Sep-15        Jolie Chaturvedi
        6301        Projector        Saris Lux T-81 Lite        10-Sep-15                Marques Herndon
        6302        Projector        Saris Lux T-81 Lite        08-Sep-15        15-Sep-15        Dean Sorenson
        1011        Tablet        Saris SlimPro        04-Oct-15                Jay Peralta
        1012        Tablet        Saris SlimPro        29-Sep-15                August Zorn
        5020        TV        32" Paragon 440 OLED TV        11-Aug-15        13-Aug-15        Marta Lao
        5022        TV        32" Paragon 440 OLED TV        17-Jul-15        17-Jul-15        Carl Langer
        5023        TV        50" Paragon 490L LED TV        01-Oct-15        01-Oct-15        Margaret Lisbon
Challenge
        ID#        Customer Last Name        Item Description        Item Type        Loan Amount        Deadline
        2549        Bullock        1975 Phillip Electric Guitar         Instrument        $400.00        12/15/15
        4732        Carter        50" LED Suzu Flat Screen TV        Electronics        $500.00        11/28/15
        3075        Li        Top Elite Complete Set Golf Clubs        Sporting Goods        $98.00        10/5/15
        1093        Assaf        5 Piece MDJS Metallic Drum Set        Instrument        $125.00        11/14/15
        1734        Hernandez        Intro to Biochemistry Hardcover 3rd Ed.        Books        $15.00        12/9/15
        2045        Smith        15" Suzu Laptop         Electronics        $150.00        1/24/16
        2975        Kokumi        7" 16 GB Sansei Tablet        Electronics        $75.00        9/13/15
        2368        Jensen        Fitness Stud Adjustable Kettlebell        Sporting Goods        $10.00        8/7/15
        3056        Chang        Michael Sparkler 3 Piece Suit Dark Grey        Clothing        $12.00        10/12/15
        3856        Benner        1st Ed. World of Geometry        Books        $50.00        12/13/15
        1839        Oluwatoke        Judy Boston Vintage Dress Red        Clothing        $38.00        2/25/16
        2965        Haley        Milano 4/4 Size Cello with Hard Case        Instrument        $200.00        1/18/16
        2345        Marquez-Jimenez        Sansei Portable Gaming System Black        Electronics        $100.00        2/2/16
        1945        Bullock        .75 Ct Rose Gold and Diamond Earrings        Jewelry        $125.00        12/9/15
        2968        Smith        12" 1TB Hard Drive Sansei Laptop        Electronics        $250.00        8/16/15
        3167        Huang        4th Ed. Hardcover Psychology 101        Books        $35.00        3/5/16
        1734        Flores        Freshwater Pearl Earring/Necklace Set        Jewelry        $45.00        9/24/15
        1056        Dwivedi        1950s Steel Lap Slide Guitar        Instrument        $175.00        4/26/16
        2754        Naik        Sansei Electronic Heart Monitor        Sporting Goods        $25.00        12/18/15
        4790        Fisher        EDX Black Amber Pro Driver        Sporting Goods        $15.00        2/3/16
        3047        Grant        1.5 Ct Princess Cut Engagement Ring        Jewelry        $2,000.00        3/9/16
        1648        Maxwell        8" 64 GB Sansei Tablet         Electronics        $175.00        7/6/15
        3890        Johnson        Tech Elite Sansei Blue Ray Player        Electronics        $55.00        11/15/15
        4956        Gorecki        15.6" 500 GB Sansei Laptop        Electronics        $205.00        1/1/16
        1034        Lopes        Ridgeback Luxe Mountain Bike        Sporting Goods        $165.00        2/24/16
        2376        Barnes        6 String Phillip Bass Guitar        Instrument        $500.00        9/16/15
        1274        LoFrese        2.5 Ct Teardrop Ruby Necklace        Jewelry        $175.00        1/14/16
        2876        Doan        Astronomy: Study the Stars 10 Ct Series        Books        $20.00        11/2/15
        4976        Plant        Set of 10 DVDs        Electronics        $10.00        1/3/16
        3487        Wilson        2014 BBCOR Bat        Sporting Goods        $20.00        2/14/16
        1579        Krzywinksi        5.5" Platinum Tennis Bracelet        Jewelry        $35.00        9/15/15
excel_freezepanes_practic.xlw
excel_freezepanes_practice.xlsx
2014-2015 Sales
        2014-2015 Sales Data
        Salesperson        Jan 2014        Feb 2014        Mar 2014        Apr 2014        May 2014        Jun 2014        Jul 2014        Aug 2014        Sep 2014        Oct 2014        Nov 2014        Dec 2014        Jan 2015        Feb 2015        Mar 2015        Apr 2015        May 2015        Jun 2015
        Albertson, Kathy        $3,799.00        $4,162.00        $10,491.00        $6,548.00        $3,947.00        $557.00        $3,863.00        $1,117.00        $8,237.00        $8,690.00        $10,776.00        $16,904.00        $15,367.00        $7,274.00        $8,624.00        $4,264.00        $11,627.00        $9,211.00
        Allenson,...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?