working with cells and sheets Navigate to the Working with Cells and Sheets Tutorials using this linkhttps://edu.gcfglobal.org/en/excel/(Links to an external site.). Follow the directions next to each...

1 answer below »
working with cells and sheets

Navigate to theWorking with Cells and SheetsTutorials 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.


5. Cell Basics - Save the Challenge! Practice Document as YourUsername_CellBasics and attach to the assignment. (10 points)


6. Modifying Columns, Rows, and Cells - Save the Challenge! Practice Document as YourUsername_Modify and attach to the assignment. (10 points)


7. Formatting - Review the tutorial.


8. Understanding Number Formats - Save the Challenge! Practice Document as YourUsername_NumFormat and attach to the assignment. (10 points)


9. Working with Multiple Worksheets - Review the tutorial.


10. Using Find & Replace - Review the tutorial.


11. Checking Spelling - Review the tutorial.


12. Page Layout and Printing - Review the tutorial.


please no cut and pasting please read instructions








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. 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
Answered Same DaySep 15, 2021

Answer To: working with cells and sheets Navigate to the Working with Cells and Sheets Tutorials using this...

Angel K answered on Sep 15 2021
147 Votes
excel_multiplesheets_practice.xlsx
January
                January                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,935
                Power        $135                Bonus        $175                        74%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $300                Income        $2,625                Vacation 1/11-1/14
                Miscellaneous        $475                Expenses        $1,935
                Gym Membership        $40                Balance        $690
MONTHLY
BUDGET
February
                February                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,750
                Power        $125                Bonus        $175                        67%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $350                Income        $2,625
                Miscellaneous        $250                Expenses        $1,750
                Gym Membership        $40                Balance        $875
MONTHLY
BUDGET
March
                March                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,720
                Power        $135                Bonus        $175                        66%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $350                Income        $2,625
                Miscellaneous        $210                Expenses        $1,720
                Gym Membership        $40                Balance        $905
MONTHLY
BUDGET
Q1 Summary
April
                April                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,720
                Power        $135                Bonus        $175                        66%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $350                Income        $2,625
                Miscellaneous        $210                Expenses        $1,720
                Gym Membership        $40                Balance        $905
MONTHLY
BUDGET
May
                May                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,720
                Power        $135                Bonus        $175                    
    66%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $350                Income        $2,625
                Miscellaneous        $210                Expenses        $1,720
                Gym Membership        $40                Balance        $905
MONTHLY
BUDGET
June
                June                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,720
                Power        $135                Bonus        $175                        66%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $350                Income        $2,625
                Miscellaneous        $210                Expenses        $1,720
                Gym Membership        $40                Balance        $905
MONTHLY
BUDGET
July
                July                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,720
                Power        $135                Bonus        $175                        66%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $350                Income        $2,625
                Miscellaneous        $210                Expenses        $1,720
                Gym Membership        $40                Balance        $905
MONTHLY
BUDGET
August
                August                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $1,720
                Power        $135                Bonus        $175                        66%
                Water        $30                Freelance        $400
                Cable/Internet        $90                Other        $50
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries        $350                Income        $2,625
                Miscellaneous        $210                Expenses        $1,720
                Gym Membership        $40                Balance        $905
MONTHLY
BUDGET
September
                September                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $995
                Power                        Bonus                                50%
                Water                        Freelance
                Cable/Internet        $90                Other
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries                        Income        $2,000                        Rent increase
                Miscellaneous                        Expenses        $995                        Cancel gym membership
                Gym Membership        $40                Balance        $1,005
MONTHLY
BUDGET
October
                October                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $995
                Power                        Bonus                                50%
                Water                        Freelance
                Cable/Internet        $90                Other
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries                        Income        $2,000
                Miscellaneous                        Expenses        $995
                Gym Membership        $40                Balance        $1,005
MONTHLY
BUDGET
November
                November                                                2016
                MONTHLY EXPENSES                        MONTHLY INCOME                        % OF INCOME SPENT
                Item        Amount                Item        Amount
                Rent        $700                Salary        $2,000                        $995
                Power                        Bonus                                50%
                Water                        Freelance
                Cable/Internet        $90                Other
                Cell Phone        $90                                        NOTES
                Car Insurance        $75                SUMMARY
                Groceries                        Income        $2,000
                Miscellaneous                        Expenses        $995
                Gym Membership        $40                Balance        $1,005
MONTHLY
BUDGET
Expenses Summary (2)
                Expense Summary                                                2016
                ANNUAL EXPENSES (TO DATE)
                Item        Amount
                Rent        $7,700
                Power        $1,070
                Water        $240
                Cable / Internet        $990
                Cell Phone        $990
                Car Insurance        $825
                Groceries        $2,750
                Miscellaneous        $1,985
                Gym Membership        $440
Rent    Power    Water    Cable / Internet    Cell Phone    Car Insurance    Groceries    Miscellaneous    Gym Membership    7700    1070    240    990    990    825    2750    1985    440    
MONTHLY
BUDGET
Expenses Summary
                Expense Summary                                                2016
                ANNUAL EXPENSES (TO DATE)
                Item        Amount
                Rent        $7,700
                Power        $1,070
                Water        $240
                Cable / Internet        $990
                Cell Phone        $990
                Car Insurance        $825
                Groceries        $2,750
                Miscellaneous        $1,985
                Gym Membership        $440
Rent    Power    Water    Cable / Internet    Cell Phone    Car Insurance    Groceries    Miscellaneous    Gym Membership    7700    1070    240    990    990    825    2750    1985    440    
MONTHLY
BUDGET
excel_formattingcells_practice.xlsx
Fitness Progress
        FITNESS PROGRESS CHART
        Date        Weight        Chest        Waist        Hips        Forearm        Estimated Lean Body        Estimated Body Fat        Estimated Body Fat %
        5/3/13        140        32        31        40        11.5        103.8        36.2        0.259
        5/11/13        140        32        31        39.5        11.5        103.9        36.1        0.258
        5/19/13        139        32        31        39.5        11.5        103.2        35.8        0.258
        5/26/13        138        31        30        39        11        103.4        35.6        0.256
        6/1/13        138        31        30        39        11        103.4        35.6        0.256
Challenge
        Menu Plan for November
        Week of:        Sunday        Monday        Tuesday        Wednesday        Thursday        Friday         Saturday
        11/1 - 11/7        Turkey Tacos        Spaghetti Squash Casserole        Veggie Pizza        Leftovers        Chicken Tettrazini        Eat Out/Take Out        Chicken Stir Fry
        11/8 - 11/14        Steak and Veggies        Leftovers        Steak Tacos        Buffalo Chicken Casserole        Soup and Sandwiches        Eat Out/Take Out        Burrito Bowls
        11/15 - 11/21        Pad Thai        Grilled Chicken and Salad        Leftovers        Tomato Soup and Grilled Cheese        Beef Stroganoff        Eat Out/Take Out        Baked Ziti
        11/22 - 11/28        Chicken and Rice        Leftovers        Pork Chops        Hot dogs and hamburgers        Thanksgiving Dinner        Leftovers        Turkey Pot Pie
excel_findreplace_practice.xlsx
Sheet 1
                        Leadership Training
                        6 Part Series
        Department        First Name        Last Name        Username        Part 1        Part 2        Part 3        Part 4        Part 5        Part 6
        Sales        Walter        Rivera        wrivera        X        X        X
        Sales        Heidi        Lee        hlee        X        X
        Claims        Josie        Gates        jgates        X        X        X
        Accounting        Wendy        Crocker        wcrocker        X        X
        Accounting        Loretta        Johnson        ljohnson        X        X        X
        Claims        Misty        Whitfield        mwhitfield        X        On hold
        Marketing        Matilda        Lewis        mlewis        X        On hold
        Accounting        Elizabeth        Hicks        ehicks        X        X        X
        HR        Alvin        Rios        arios        X        X        X
        HR        Brian        Gaines        bgaines        X        X        X
        Sales        Megan        Bosworth        mbosworth        X        X        X
        Claims        Maria        Menzies        mmenzies        X        X        X
        Claims        Micheal        Russell        mrussell        X        X
Challenge
        +        Winston College First Responder Training
        Student Name        Gender        Major        CPR        First-Aid        AED
        Jackson Collier        M        Math        X                X
        Ming Li        F        Biomedical Engineering        X        X
        Sriya Patel        F        Women's Studies                X        X
        Sadie Locke        F        Engineering        X                X
        Maxine Germaine        F        Textiles        X        X
        John Carter        M        Math
        Porter Talia        M        Women's Studies        X                X
        Jessica Jimenez        F        English        X        X        X
        Joseph Lewis        M        Art                X        X
        Kelly Greene        F        Engineering        X        X        X
        Emerald D'Agostino        F        Biology                X
        Alyssa Jackson        F        Biology        X        X
        Tia Polero        F        Physical Science        X        X
        Richard Kim        M        Physical Science        X        X        X
        Quentin Cutter        M        Biology                X        X
        Joshua Brandt        M        Art        X                X
        Crystal Taylor        F        Textiles        X        X
        Portia Keller        F        Math        X        X
        Marques Quentin        M        Biomedical Engineering        X        X        X
        Asal Skasireddy        M        Physical Science        X
        Karen Greenwood        F        Women's Studies                X        X
        Jackie Cranston        F        Biology        X                X
        Martin Fuller        M        Physical Science                X
excel_checkspelling_practice.xlsx
Agenda Planner
                        Event:        Team-Building Retreat
                        Location:        Waverly Point Nature Preserve
                        Date:        Wednesday, August 10, 2016
                                        AGENDA PLANNER
        Start        End        Length        Item        Facilitator
        8:00 AM        9:00 AM        1:00        Breakfast, welcome        Exec team
        9:00 AM        9:30 AM        0:30        Introduction        Garth
        9:30 AM        10:30 AM        1:00        Work relationships exerecise        Garth, Dean, Liz
        10:30 AM        10:45 AM        0:15        Break
        10:45 AM        12:45 PM        2:00        Cady Falls hike (strategy game?)        Tyler
        12:45 PM        1:45 PM        1:00        Lunch (with strategy game team)
        1:45 PM        2:00 PM        0:15        Strategy debrief        Julia
        2:00 PM        3:00 PM        1:00        Getting to know your team        See Liz for info
        3:00 PM        4:00 PM        1:00        Strengths exercise
        4:00 PM        4:15 PM        0:15        Break/snack
        4:15 PM        5:00 PM        0:45        Redwoods hike        Dean
        5:00 PM        6:00 PM        1:00        Team-building exercise        Garth, exec team
        6:00 PM        8:00 PM        2:00        Dinner
        Total                12:00
Challenge
                CUSTOMER INVOICE Bad Llama Peruvian Coffee 2121 14th Avenue Circle Drive Raleigh, NC 27607                Invoice #: 40592 Date: 7/17/15
        ITEM DESCRIPTION        UNIT PRICE        QUANTITY        LINE TOTAL
        Cusco Dark Roast        $6.59        3        $19.77
        Amazon Amanecer Breakfast Roast        $6.89        8        $55.12
        Sacred Valley Medium Roast        $6.49        10        $64.90
        Machu Picchu Special Blend        $7.29        2        $14.58
                        TAX:        $11.58
                        TOTAL:        $165.95
Username_modify.xlsx
Sheet 1
        Customer Contact List
        COMPANY NAME        CONTACT NAME        SECONDARY CONTACT        BILLING ADDRESS        PHONE        EMAIL ADDRESS
        Adventure Outfitters        Jake Finn                1407 Dusty Fawn Ln Soaptown, SD 57696        605-555-6435        [email protected]
        Aria Real Estate        Katie Stark                971 Cinder Butterfly St Stoughton, NH 03204        603-555-2460        [email protected]
        Core Pharmaceuticals        Phillip Yuen                5108 Crystal Gate Blvd Twig City, KS 66208        913-555-5928        [email protected]
        Everly Publishing        Felicia Reyes                8544 Lazy Bluff Ave Whiskey Creek, KS 66689        316-555-3256        [email protected]
        Mass Airlines        Miranda Lawson                5316 Colonial Pkwy Esterhazy, NM 88431        575-555-9255        [email protected]
        Newhaven Traders        Rick Chaturvedi                2428 S Redding St #2 Bogg's Corner, WA 98175        360-555-5422        [email protected]
        Overlook Inn        Jill Torrance                3160 Amber Gate Rd Rodney Village, SD 57324        605-555-4495        [email protected]
        Knope Equestrian Center        Lil Sebastian                9060 Easy Evening Ln Walkinghood, ME 04126        207-555-7225        [email protected]
        Venture Brewing        Hank Dean                3034 Foggy Wharf Loop Bee Rock, NE 69823        308-555-1050        [email protected]
        Placerville Insurance        Chris Kinkade                1028 Quiet Dale Rd Homosassa, MD 21610        443-555-4942        [email protected]
        Archer Properties        Mallory Figgis                3520 Sleepy Hearth Dr Calendar, WA 99340        425-555-5370        [email protected]
Username_cellbasics.xlsx
Sheet 1
                        Leadership Training
                        6-Part Series
        Department        First Name        Last Name        User Name        Part 1        Part 2        Part 3
        Sales        Walter        Rivera        wrivera        X        X        X
        Sales        Heidi        Lee        hlee        X        X
        Claims        Josie        Gates                X        X        X
        Accounting        Wendy        Crocker                X        X
        Accounting        Loretta        Johnson                X        X        X
        Sales        Walter        Rivera                X        X        X
        Claims        Misty        Whitfield                X        X
        Marketing        Matilda        Lewis                X        X
        Accounting        Elizabeth        Hicks                X        X        X
        Claims        Micheal        Russell                X        X
        HR        Brian        Gaines                X        X
        Sales        Megan        Bosworth                X        X
        Claims        Maria        Menzies                X        X
excel_pagelayoutprint_practice.xlsx
Central
        NAME        JANUARY        FEBRUARY        MARCH        APRIL        MAY        JUNE        JULY        AUGUST        SEPTEMBER        OCTOBER        NOVEMBER        DECEMBER        TOTAL
        Gomez, Alexander        $ 5,110.00        $ 9,739.00        $ 6,861.00        $ 3,889.00        $ 6,292.00        $ 8,518.00        $ 5,110.00        $ 9,739.00        $ 6,861.00        $ 3,889.00        $ 6,292.00        $ 8,518.00        $ 80,818.00
        Stone, Jeremy        $ 9,935.00        $ 8,365.00        $ 7,639.00        $ 3,533.00        $ 9,665.00        $ 1,126.00        $ 9,935.00        $ 8,365.00        $ 7,639.00        $ 3,533.00        $ 9,665.00        $ 1,126.00        $ 80,526.00
        Petty, Cheyenne        $ 6,640.00        $ 4,046.00        $ 9,632.00        $ 7,803.00        $ 6,076.00        $ 5,130.00        $ 6,640.00        $ 4,046.00        $ 9,632.00        $ 7,803.00        $ 6,076.00        $ 5,130.00        $ 78,654.00
        Doyle, Quincy        $ 7,161.00        $ 577.00        $ 8,605.00        $ 4,046.00        $ 9,632.00        $ 7,803.00        $ 2,516.00        $ 7,565.00        $ 6,256.00        $ 7,703.00        $ 7,235.00        $ 7,619.00        $ 76,718.00
        Conrad, Alfonso        $ 4,108.00        $ 7,172.00        $ 6,964.00        $ 2,122.00        $ 9,542.00        $ 8,252.00        $ 4,108.00        $ 7,172.00        $ 6,964.00        $ 2,122.00        $ 9,542.00        $ 8,252.00        $ 76,320.00
        Good, Carlos        $ 6,759.00        $ 9,019.00        $ 5,144.00        $ 7,087.00        $ 1,568.00        $ 8,922.00        $ 358.00        $ 9,943.00        $ 4,964.00        $ 7,032.00        $ 6,255.00        $ 9,218.00        $ 76,269.00
        Rice, Ivy        $ 7,897.00        $ 1,544.00        $ 9,071.00        $ 8,210.00        $ 7,750.00        $ 4,275.00        $ 7,430.00        $ 7,882.00        $ 4,876.00        $ 3,052.00        $ 4,653.00        $ 9,474.00        $ 76,114.00
        Min, Wang        $ 4,046.00        $ 9,632.00        $ 7,803.00        $ 8,392.00        $ 745.00        $ 9,721.00        $ 9,442.00        $ 2,224.00        $ 1,968.00        $ 5,110.00        $ 9,739.00        $ 6,861.00        $ 75,683.00
        Alford, Lacota        $ 9,778.00        $ 737.00        $ 6,302.00        $ 8,430.00        $ 7,882.00        $ 4,876.00        $ 9,474.00        $ 8,517.00        $ 5,233.00        $ 4,267.00        $ 9,590.00        $ 257.00        $ 75,343.00
        Hogan, Abdul        $ 7,750.00        $ 4,275.00        $ 4,267.00        $ 6,759.00        $ 9,019.00        $ 5,144.00        $ 7,639.00        $ 3,533.00        $ 9,665.00        $ 3,052.00        $ 4,653.00        $ 9,474.00        $ 75,230.00
        Reeves, Savannah        $ 1,568.00        $ 8,922.00        $ 8,765.00        $ 4,653.00        $ 9,474.00        $ 8,517.00        $ 2,224.00        $ 1,968.00        $ 5,061.00        $ 7,032.00        $ 6,255.00        $ 9,218.00        $ 73,657.00
        Abbott, Raymond        $ 1,413.00        $ 6,759.00        $ 9,019.00        $ 5,144.00        $ 8,550.00        $ 5,731.00        $ 1,413.00        $ 6,759.00        $ 9,019.00        $ 5,144.00        $ 8,550.00        $ 5,731.00        $ 73,232.00
        Glass, Mufutau        $ 9,590.00        $ 257.00        $ 8,210.00        $ 9,293.00        $ 6,804.00        $ 1,492.00        $ 3,779.00        $ 9,405.00        $ 3,588.00        $ 6,640.00        $ 4,046.00        $ 9,632.00        $ 72,736.00
        Chambers, Bethany        $ 4,573.00        $ 605.00        $ 3,215.00        $ 8,517.00        $ 5,233.00        $ 1,650.00        $ 8,430.00        $ 7,882.00        $ 4,876.00        $ 9,935.00        $ 8,365.00        $ 7,639.00        $ 70,920.00
        Green, Buckminster        $ 8,765.00        $ 8,258.00        $ 636.00        $ 7,087.00        $ 1,568.00        $ 8,922.00        $ 8,765.00        $ 8,258.00        $ 636.00        $ 7,087.00        $ 1,568.00        $ 8,922.00        $ 70,472.00
        Evans, Marcia        $ 7,703.00        $ 7,235.00        $ 7,619.00        $ 2,410.00        $ 1,425.00        $ 8,732.00        $ 7,703.00        $ 7,235.00        $ 7,619.00        $ 2,410.00        $ 1,425.00        $ 8,732.00        $ 70,248.00
        Williams, Claire        $ 7,032.00        $ 6,255.00        $ 9,218.00        $ 5,106.00        $ 2,881.00        $ 4,462.00        $ 7,032.00        $ 6,255.00        $ 9,218.00        $ 5,106.00        $ 2,881.00        $ 4,462.00        $ 69,908.00
        Lucas, Basia        $ 5,233.00        $ 1,650.00        $ 3,052.00        $ 3,779.00        $ 9,405.00        $ 3,588.00        $ 677.00        $ 9,293.00        $ 6,804.00        $ 9,935.00        $ 8,365.00        $ 7,639.00        $ 69,420.00
        Day, Salvador        $ 627.00        $ 7,909.00        $ 3,204.00        $ 7,710.00        $ 7,161.00        $ 577.00        $ 8,365.00        $ 7,639.00        $ 3,533.00        $ 7,703.00        $ 7,235.00        $ 7,619.00        $ 69,282.00
        Fleming, Aaron        $ 1,885.00        $ 4,996.00        $ 6,925.00        $ 3,493.00        $ 2,469.00        $ 5,118.00        $ 9,019.00        $ 5,144.00        $ 8,550.00        $ 4,996.00        $ 8,430.00        $ 7,882.00        $ 68,907.00
        Ross, May        $ 4,267.00        $ 9,590.00        $ 257.00        $ 8,210.00        $ 7,750.00        $ 4,275.00        $ 4,267.00        $ 9,590.00        $ 257.00        $ 8,210.00        $ 7,750.00        $ 4,275.00        $ 68,698.00
        Hogan, Kalia        $ 4,996.00        $ 8,430.00        $ 7,882.00        $ 4,876.00        $ 885.00        $ 6,979.00        $ 4,996.00        $ 8,430.00        $ 7,882.00        $ 4,876.00        $ 885.00        $ 6,979.00        $ 68,096.00
        Clemons, Amela        $ 4,267.00        $ 9,590.00        $ 257.00        $ 8,210.00        $ 7,700.00        $ 4,000.00        $ 4,267.00        $ 9,590.00        $ 257.00        $ 8,210.00        $ 7,700.00        $ 4,000.00        $ 68,048.00
        Huff, Amy        $ 6,925.00        $ 7,430.00        $ 7,882.00        $ 4,876.00        $ 1,885.00        $ 4,996.00        $ 6,925.00        $ 7,430.00        $ 7,882.00        $ 4,876.00        $ 1,885.00        $ 4,996.00        $ 67,988.00
        Doyle, Lani        $ 8,789.00        $ 7,621.00        $ 3,435.00        $ 8,015.00        $ 5,248.00        $ 840.00        $ 8,789.00        $ 7,621.00        $ 3,435.00        $ 8,015.00        $ 5,248.00        $ 840.00        $ 67,896.00
        Molina, Zeus        $ 4,075.00        $ 1,240.00        $ 2,243.00        $ 4,383.00        $ 3,425.00        $ 5,545.00        $ 9,779.00        $ 7,042.00        $ 9,293.00        $ 9,779.00        $ 7,042.00        $ 3,373.00        $ 67,219.00
        Guthrie, Mona        $ 9,779.00        $ 7,042.00        $ 3,373.00        $ 4,383.00        $ 3,425.00        $ 5,545.00        $ 9,779.00        $ 7,042.00        $ 3,373.00        $ 4,383.00        $ 3,425.00        $ 5,545.00        $ 67,094.00
        Ellis, Breanna        $ 8,369.00        $ 1,645.00        $ 3,527.00        $ 7,430.00        $ 7,882.00        $ 4,876.00        $ 257.00        $ 8,210.00        $ 7,750.00        $ 6,302.00        $ 358.00        $ 9,943.00        $ 66,549.00
        Hernandez, Vivien        $ 5,288.00        $ 5,276.00        $ 8,031.00        $ 4,876.00        $ 1,885.00        $ 4,996.00        $ 619.00        $ 5,319.00        $ 8,891.00        $ 4,996.00        $ 8,430.00        $ 7,882.00        $ 66,489.00
        Murphy, Haviva        $ 9,665.00        $ 1,126.00        $ 9,935.00        $ 2,611.00        $ 4,106.00        $ 5,631.00        $ 9,632.00        $ 7,803.00        $ 6,076.00        $ 1,928.00        $ 6,595.00        $ 677.00        $ 65,785.00
        Lowe, Morgan        $ 6,516.00        $ 1,112.00        $ 2,516.00        $ 7,565.00        $ 6,256.00        $ 8,794.00        $ 6,516.00        $ 1,112.00        $ 2,516.00        $ 7,565.00        $ 6,256.00        $ 8,794.00        $ 65,518.00
        Parrish, Urielle        $ 3,052.00        $ 4,653.00        $ 9,474.00        $ 8,517.00        $ 5,233.00        $ 1,650.00        $ 3,052.00        $ 4,653.00        $ 9,474.00        $ 8,517.00        $ 5,233.00        $ 1,650.00        $ 65,158.00
        Brewer, Rachel        $ 619.00        $ 5,319.00        $ 8,891.00        $ 4,533.00        $ 7,752.00        $ 3,756.00        $ 9,739.00        $ 6,861.00        $ 3,889.00        $ 3,527.00        $ 5,575.00        $ 4,046.00        $ 64,507.00
        Larsen, Alden        $ 3,582.00        $ 2,286.00        $ 3,898.00        $ 7,565.00        $ 6,256.00        $ 8,794.00        $ 4,046.00        $ 9,632.00        $ 7,803.00        $ 4,548.00        $ 619.00        $ 5,319.00        $ 64,348.00
        Miller, Evangeline        $ 7,134.00        $ 7,595.00        $ 7,130.00        $ 619.00        $ 5,319.00        $ 8,891.00        $ 7,882.00        $ 4,876.00        $ 1,885.00        $ 666.00        $ 6,210.00        $ 5,994.00        $ 64,201.00
        Conrad, Channing        $ 6,302.00        $ 358.00        $ 9,943.00        $ 4,964.00        $ 9,778.00        $ 737.00        $ 6,302.00        $ 358.00        $ 9,943.00        $ 4,964.00        $ 9,778.00        $ 737.00        $ 64,164.00
        Fisher, Clio        $ 3,527.00        $ 5,575.00        $ 4,046.00        $ 8,910.00        $ 8,369.00        $ 1,645.00        $ 3,527.00        $ 5,575.00        $ 4,046.00        $ 8,910.00        $ 8,369.00        $ 1,645.00        $ 64,144.00
        O'Connor, Hayden        $ 4,707.00        $ 3,391.00        $ 5,556.00        $ 6,210.00        $ 5,994.00        $ 248.00        $ 9,943.00        $ 4,964.00        $ 9,778.00        $ 3,527.00        $ 5,575.00        $ 4,046.00        $ 63,939.00
        Ayala, Kendall        $ 9,385.00        $ 2,501.00        $ 3,609.00        $ 3,177.00        $ 7,134.00        $ 7,595.00        $ 7,235.00        $ 7,619.00        $ 2,410.00        $ 666.00        $ 6,210.00        $ 5,994.00        $ 63,535.00
        Curry, Emma        $ 885.00        $ 6,979.00        $ 4,996.00        $ 7,897.00        $ 1,544.00        $ 9,071.00        $ 9,405.00        $ 3,588.00        $ 1,912.00        $ 1,413.00        $ 6,759.00        $ 9,019.00        $ 63,468.00
        Long, Bert        $ 745.00        $ 9,721.00        $ 725.00        $ 7,235.00        $ 7,619.00        $ 2,410.00        $ 2,933.00        $ 3,177.00        $ 7,134.00        $ 5,110.00        $ 9,739.00        $ 6,861.00        $ 63,409.00
        Hooper, Aiko        $ 2,881.00        $ 4,462.00        $ 7,032.00        $ 8,365.00        $ 7,639.00        $ 3,533.00        $ 2,207.00        $ 7,710.00        $ 7,161.00        $ 562.00        $ 9,442.00        $ 2,224.00        $ 63,218.00
        Henry, Jordan        $ 2,849.00        $ 7,186.00        $ 666.00        $ 7,042.00        $ 3,373.00        $ 4,383.00        $ 7,882.00        $ 4,876.00        $ 885.00        $ 6,925.00        $ 7,430.00        $ 7,882.00        $ 61,379.00
        Glover, Chandler        $ 7,172.00        $ 6,964.00        $ 2,122.00        $ 4,876.00        $ 885.00        $ 6,979.00        $ 7,042.00        $ 3,373.00        $ 4,383.00        $ 1,413.00        $ 6,759.00        $ 9,019.00        $ 60,987.00
        O'Neil, Nicholas        $ 1,425.00        $ 8,732.00        $ 7,703.00        $ 2,356.00        $ 9,343.00        $ 2,228.00        $ 5,319.00        $ 8,891.00        $ 4,835.00        $ 6,516.00        $ 1,112.00        $ 2,516.00        $ 60,976.00
        Wilkerson, Dustin        $ 5,889.00        $ 9,385.00        $ 2,501.00        $ 3,609.00        $ 69.00        $ 8,831.00        $ 5,889.00        $ 9,385.00        $ 2,501.00        $ 3,609.00        $ 69.00        $ 8,831.00        $ 60,568.00
        Saunders, Ima        $ 5,812.00        $ 3,493.00        $ 2,469.00        $ 5,118.00        $ 3,509.00        $ 9,674.00        $ 5,812.00        $ 3,493.00        $ 2,469.00        $ 5,118.00        $ 3,509.00        $ 9,674.00        $ 60,150.00
        Sanford, Casey        $ 5,897.00        $ 2,356.00        $ 9,343.00        $ 2,228.00        $ 3,368.00        $ 6,782.00        $ 5,897.00        $ 2,356.00        $ 9,343.00        $ 2,228.00        $ 3,368.00        $ 6,782.00        $ 59,948.00
        Andrews, Yael        $ 4,533.00        $ 7,752.00        $ 3,756.00        $ 248.00        $ 2,849.00        $ 7,186.00        $ 1,112.00        $ 2,516.00        $ 7,565.00        $ 6,925.00        $ 7,430.00        $ 7,882.00        $ 59,754.00
        Lloyd, Danielle        $ 3,779.00        $ 9,405.00        $ 3,588.00        $ 5,106.00        $ 2,881.00        $ 4,462.00        $ 9,590.00        $ 257.00        $ 8,210.00        $ 562.00        $ 9,442.00        $ 2,224.00        $ 59,506.00
        Lowery, Martha        $ 3,394.00        $ 5,288.00        $ 5,276.00        $ 8,031.00        $ 3,732.00        $ 3,773.00        $ 3,394.00        $ 5,288.00        $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here