{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["User_Info","TOC","Ch2-Instructions (Windows)","Ch2-Sales_Report (Win)","Hidden 1","Hidden 2","Ch2-Instructions (Mac)","Ch2-Sales_Report (Mac)","Ch3-Instructions","Ch3-Sales_Report","Ch4-Instructions","Ch4-Sales Data","Ch5-Instructions","Ch5-Sales Report","Ch5-Payroll Data","Ch6-Instructions","Ch6-Sales_by_Product_Line","Audit"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User_Info","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name"," "]
[null,"Banner ID",855855855,null,null,null," "]
[null,"Course #"," "]
[null,"Course Name"," "]
[null,"Professor Name"," ",null," "]
[]
[null,null,false,"I affirm that the work I am submitting is my own and represents my original effort. I have not used unauthorized assistance, nor have I engaged in any form of cheating to complete this assignment. I understand that the use of AI platforms is permitted as an aide or tutor to enhance my understanding and learning. I acknowledge that the final work submitted is my independent creation, and I am solely responsible for its content."]
[null,null,null,null," "]
[null,null,false,"I understand that I must complete ALL required inputs including formulas and save the file as an .xlsm each time. "]
[]
[null,null,false,"I have watched the introductory video."]

{"sheet":"TOC","index":1,"n_rows":60,"n_cols":20,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,5,2,7]]}
[null,"Chapter","Topic","Video link",null,null,"Topic","Video link",null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2025-01-22T12:49:29.770"}]
[]
[null,"Operating System ","Windows ",null,null,"Mac "]
[null,null,null,null,null,null,"Office 365 Installation for Mac ","https://www.youtube.com/watch?v=3cMISRm8CEk"]
[null,null,null,null,null,null,"Office 365 (WPU Wiki Page) ","https://itwiki.wpunj.edu/index.php/Microsoft_Office_365#Downloading_Office_on_a_Student%27s_Personal_Machine"]
[]
[null,null,"Setting up Excel (REQUIRED)","video here",null,null,"Setting up Excel (REQUIRED)","video here"]
[]
[]
[null,"Workbooks"]
[null,2.1,"Document Properties ","https://youtu.be/y_P0jx7i5OI",null,2.1,"Document Properties (Mac)","https://youtu.be/fkEVrfKVti8"]
[null,2.2000000000000002,"Inspect Workbook","https://youtu.be/5lFwXkr5ZwU",null,2.2000000000000002,"Inspect Workbook (Mac)","https://youtu.be/oLOJz7XnnGk"]
[null,2.2999999999999998,"Insert Notes and Comments","https://youtu.be/4I1vbwlyq6U",null,2.2999999999999998,"Insert Notes and Comments (Mac)","https://youtu.be/oiKLrvnoPDs"]
[null,2.4,"Page Layout","https://youtu.be/j6vz-vUdSLU",null,2.4,"Page Layout (Mac)","https://youtu.be/RfSEhfGBH4c"]
[null,2.5,"Show Formulas","https://youtu.be/qjR8-mBmJiU",null,2.5,"Show Formulas (Mac)","https://youtu.be/O5u8ZxOgyHs"]
[null,2.6,"Headers and Footers","https://youtu.be/fufRvmuCUWM",null,2.6,"Headers and Footers (Mac)","https://youtu.be/DdYwCWCCbiY"]
[null,2.7,"Quick Access Toolbar","https://youtu.be/g2vYGLQ032E",null,2.7,"Quick Access Toolbar (Mac)","https://youtu.be/hbjeQLMZRaY"]
[null,2.8,"Change Workbook Views","https://youtu.be/dI4ElyluMsQ",null,2.8,"Change Workbook Views (Mac)","https://youtu.be/yqF-rp5AD5I"]
[null,2.9,"Importing Data","https://youtu.be/IZ4Q6hf40x0",null,2.9,"Importing Data (Mac)","https://youtu.be/ZNEzf2GTX3Q"]
[null,"Cells and Ranges"]
[null,3.1,"Merge and Center","https://youtu.be/tBqnBrkqMxk"]
[null,3.2,"Formatting Cells","https://youtu.be/zo0SsbmW9ow"]
[null,3.3,"Name Ranges","https://youtu.be/tHDZrZX-I5o",null,null,null,null,null,null,null,null," "]
[null,3.4,"Reference Formulas","https://youtu.be/j__64J0s9k4"]
[null,3.5,"Styles and Headings","https://youtu.be/nes1DUaA9Xs"]
[null,3.6,"Conditional Formatting","https://youtu.be/5W8kOdkWzs8"]
[null,3.7,"Sparklines","https://youtu.be/wNsk4mUUymE"]
[null,"Tables"]
[null,4.0999999999999996,"Creating a Table","https://youtu.be/uivOZ5eaico"]
[null,4.2,"Remove Columns, Name Tables","https://youtu.be/wOMfhh9PMMQ"]
[null,4.3,"Filter by Criteria","https://youtu.be/Nih8g3tRMEc"]
[null,4.4000000000000004,"Adding a Total Row","https://youtu.be/AylEEIrop6g"]
[null,4.5,"Removing Table Functionality","https://youtu.be/8I4UtIkMP1M"]
[null,"Functions"]
[null,5.0999999999999996,"Using the UPPER Function","https://youtu.be/Skz4S2Gk_To"]
[null,5.2,"Using an Absolute Reference ","https://youtu.be/ipnPGPQ9lS4"]
[null,5.3,"Using the TEXTJOIN Function","https://youtu.be/BF3TmkzNrVo"]
[null,5.4,"Using the IF Function","https://youtu.be/ajlrX2IQ8eU"]
[null,5.5,"Using the AVERAGE Function ","https://youtu.be/zimny1mcyt0"]
[null,5.6,"Using the UNIQUE Function ","https://youtu.be/_kOMwDqlGnU"]
[null,"Charting"]
[null,6.1,"Column Chart, Filters, Layouts","https://youtu.be/NdvCTjbpJ-8"]
[null,6.2,"Chart Styles, Data Labels, Swap Data","https://youtu.be/BHHmtCPwxm0"]
[null,6.3,"Charting, Add Data, Add Elements","https://youtu.be/N0GVpN0UKQM"]
[null,6.4,"Add Trendline","https://youtu.be/k1H0K74VqQY"]
[null,6.5,"Alt Text, Moving Charts","https://youtu.be/X2F_g_f9y-w"]
[null," "]
[null,"Add-ons"]
[null,"*There are no excel sheets associated with these videos"]
[null,null,"VLOOKUP","https://youtu.be/fyrClf9wiO8"]
[null,null,"XLOOKUP","https://youtu.be/8IbtMXqR17c"]
[null,null,"SORT","https://youtu.be/KjkCg5FCHVQ"]
[null,null,"FILTER","https://youtu.be/4ZaMuU1jSjY"]
[null,null,"INDEX MATCH","https://youtu.be/VoW8j9KE0IA"]
[null,null,"Data Validation","https://youtu.be/E_DNvR5wMJU"]
[]
[null,"AI Tools","These tools are not required. They are meant to aide your "]
[null,null,"Claude canned prompts for Excel","Excel formula expert - Anthropic"]
[null,null,"Google AI assistant","https://aistudio.google.com/live"]
[null,null,"OpenAI ChatGPT tutor","https://chatgpt.com/g/g-677ee4761d6481918eb96dd7f96be923-excel-associate-mo-210-tutor"]

{"sheet":"Ch2-Instructions (Windows)","index":2,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[[25,0,25,4],[26,0,26,4],[27,0,27,4],[0,0,0,6],[1,0,1,6],[2,0,2,6],[4,0,4,6]]}
["Formulas"]
["Excel 365 Associate Exam"]
["Instructions"]
[]
["For Internal Use Only"]
[]
["Document Properties "]
["1. Author: Enter your name"]
["2. Title: Superstore Sales Report "]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D11)","v":"https://youtu.be/y_P0jx7i5OI"}]
[]
["Inspect Workbook Options "]
["1. Check for Accessibility issues. Enter alt text \"Image of a Sales Report\" to "]
["    graphic, if needed."]
["2. Remove any hidden worksheets from the workbook."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D12)","v":"https://youtu.be/5lFwXkr5ZwU"}]
[]
["Insert Notes and Comments"]
["1. Insert a Note with the current street address that states, "]
["    \"Please update with new address\"."]
["2. Convert the Note to a Comment."]
["3. Change the Comment to be a Directed Comment to Joe (@joe)."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D13)","v":"https://youtu.be/4I1vbwlyq6U"}]
[]
["Page Layout"]
["1. Set all Margins to 2.0\"."]
["2. Configure document to print Landscape."]
["3. Set the \"Segment Sales Report\" as a Print Area"]
["4. Set the Repeat the column headings on each printed page. "]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D14)","v":"https://youtu.be/j6vz-vUdSLU"}]
[]
["How to Show Formulas"]
["1. Display formulas in the worksheet."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D15)","v":"https://youtu.be/qjR8-mBmJiU"}]
[]
["Editing the Headers and Footers"]
["1. Insert the current date as a right-aligned header."]
["2. Insert a footer that displays the worksheet name on the left, "]
["    \"Internal Use Only\" in the center, and the page number on the right."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D16)","v":"https://youtu.be/fufRvmuCUWM"}]
[]
["Quick Access Toolbar"]
["1. Add Quick Print and New File to the Quick Access Toolbar."]
["2. Display the Quick Access Toolbar below the Ribbon."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D17)","v":"https://youtu.be/g2vYGLQ032E"}]
[]
["Change Workbook Views"]
["1. Change the View so you can see both the top and bottom of the worksheet."]
["2. Configure the worksheet to always display rows 1-9 and column B "]
["    while scrolling."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D18)","v":"https://youtu.be/dI4ElyluMsQ"}]
[]
["Import Data "]
["1. In cell O9, insert the TXT file given to you called \"Import _Data\". "]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D19)","v":"https://youtu.be/IZ4Q6hf40x0"}]

{"sheet":"Ch2-Sales_Report (Win)","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Superstore "]
[null,"Segment Sales Report"]
[null,"123 56th Road"]
[null,"San Diego, CA 22434"]
[null,"(123) 456-7890"]
[null,"For Internal Use Only"]
[]
[null,"Salesperson","Date","City","Customer type","Gender","Product line","Unit price","Quantity","Subtotal"]
[null,"Joespeh Smith","2024-01-01","Yangon","Normal","Male","Sports and travel",72.61,6,{"$f":"H10*I10","v":435.65999999999997}]
[null,"Joespeh Smith","2024-01-01","Yangon","Member","Male","Home and lifestyle",47.59,8,{"$f":"H11*I11","v":380.72}]
[null,"Joespeh Smith","2024-01-01","Mandalay","Normal","Female","Electronic accessories",74.709999999999994,6,448.26]
[null,"Joespeh Smith","2024-01-01","Naypyitaw","Member","Female","Sports and travel",36.979999999999997,10,369.79999999999995]
[null,"Joespeh Smith","2024-01-01","Naypyitaw","Normal","Female","Electronic accessories",63.22,2,126.44]
[null,"Joespeh Smith","2024-01-01","Naypyitaw","Normal","Male","Health and beauty",62.87,2,125.74]
[null,"Abby Willison","2024-01-01","Yangon","Normal","Female","Fashion accessories",65.739999999999995,9,591.66]
[null,"Abby Willison","2024-01-01","Yangon","Member","Female","Sports and travel",27.04,4,108.16]
[null,"Abby Willison","2024-01-01","Yangon","Member","Female","Electronic accessories",74.22,10,742.2]
[null,"Abby Willison","2024-01-01","Naypyitaw","Member","Female","Sports and travel",29.22,6,175.32]
[null,"Abby Willison","2024-01-01","Mandalay","Normal","Male","Food and beverages",21.12,8,168.96]
[null,"Joespeh Smith","2024-01-01","Mandalay","Member","Female","Food and beverages",84.63,10,846.3]
[null,"Joespeh Smith","2024-01-02","Yangon","Normal","Male","Sports and travel",42.47,1,42.47]
[null,"Joespeh Smith","2024-01-02","Naypyitaw","Normal","Male","Fashion accessories",99.82,2,199.64]
[null,"Joespeh Smith","2024-01-02","Mandalay","Normal","Female","Health and beauty",34.21,10,342.1]
[null,"Abby Willison","2024-01-02","Mandalay","Member","Male","Fashion accessories",40.61,9,365.49]
[null,"Joespeh Smith","2024-01-02","Mandalay","Normal","Male","Electronic accessories",22.01,6,132.06]
[null,"Joespeh Smith","2024-01-02","Yangon","Member","Male","Food and beverages",41.66,6,249.95999999999998]
[null,"Joespeh Smith","2024-01-02","Naypyitaw","Member","Female","Sports and travel",31.67,8,253.36]
[null,"Joespeh Smith","2024-01-02","Mandalay","Normal","Male","Sports and travel",44.63,6,267.78000000000003]

{"sheet":"Hidden 1","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["This is hidden worksheet 1 "]

{"sheet":"Hidden 2","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["This is hidden worksheet 1 "]

{"sheet":"Ch2-Instructions (Mac)","index":6,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[[27,0,27,4],[0,0,0,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[25,0,25,4],[26,0,26,4]]}
["Formulas"]
["Excel 365 Associate Exam"]
["Instructions"]
[]
["For Internal Use Only"]
[]
["Document Properties "]
["1. Author: Enter your name"]
["2. Title: Superstore Sales Report "]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H11)","v":"https://youtu.be/fkEVrfKVti8"}]
[]
["Inspect Workbook Options "]
["1. Check for Accessibility issues. Enter alt text \"Image of a Sales Report\" to "]
["    graphic, if needed."]
["2. Remove any hidden worksheets from the workbook."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H12)","v":"https://youtu.be/oLOJz7XnnGk"}]
[]
["Insert Notes and Comments"]
["1. Insert a Note with the current street address that states, "]
["    \"Please update with new address\"."]
["2. Convert the Note to a Comment."]
["3. Change the Comment to be a Directed Comment to Joe (@joe)."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H13)","v":"https://youtu.be/oiKLrvnoPDs"}]
[]
["Page Layout"]
["1. Set all Margins to 2.0\"."]
["2. Configure document to print Landscape."]
["3. Set the \"Segment Sales Report\" as a Print Area"]
["4. Set the Repeat the column headings on each printed page. "]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H14)","v":"https://youtu.be/RfSEhfGBH4c"}]
[]
["How to Show Formulas"]
["1. Display formulas in the worksheet."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H15)","v":"https://youtu.be/O5u8ZxOgyHs"}]
[]
["Editing the Headers and Footers"]
["1. Insert the current date as a right-aligned header."]
["2. Insert a footer that displays the worksheet name on the left, "]
["    \"Internal Use Only\" in the center, and the page number on the right."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H16)","v":"https://youtu.be/DdYwCWCCbiY"}]
[]
["Quick Access Toolbar"]
["1. Add Quick Print and New File to the Quick Access Toolbar."]
["2. Display the Quick Access Toolbar below the Ribbon."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H18)","v":"https://youtu.be/yqF-rp5AD5I"}]
[]
["Change Workbook Views"]
["1. Change the View so you can see both the top and bottom of the worksheet."]
["2. Configure the worksheet to always display rows 1-9 and column B "]
["    while scrolling."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H18)","v":"https://youtu.be/yqF-rp5AD5I"}]
[]
["Import Data "]
["1. In cell O9, insert the TXT file given to you called \"Import _Data\". "]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!H19)","v":"https://youtu.be/ZNEzf2GTX3Q"}]

{"sheet":"Ch2-Sales_Report (Mac)","index":7,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,1,6,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9]]}
[]
[null,"Superstore "]
[null,"Segment Sales Report"]
[null,"123 56th Road"]
[null,"San Diego, CA 22434"]
[null,"(123) 456-7890"]
[null,"For Internal Use Only"]
[]
[null,"Salesperson","Date","City","Customer type","Gender","Product line","Unit price","Quantity","Subtotal"]
[null,"Joespeh Smith","2024-01-01","Yangon","Normal","Male","Sports and travel",72.61,6,{"$f":"H10*I10","v":435.65999999999997}]
[null,"Joespeh Smith","2024-01-01","Yangon","Member","Male","Home and lifestyle",47.59,8,{"$f":"H11*I11","v":380.72}]
[null,"Joespeh Smith","2024-01-01","Mandalay","Normal","Female","Electronic accessories",74.709999999999994,6,448.26]
[null,"Joespeh Smith","2024-01-01","Naypyitaw","Member","Female","Sports and travel",36.979999999999997,10,369.79999999999995]
[null,"Joespeh Smith","2024-01-01","Naypyitaw","Normal","Female","Electronic accessories",63.22,2,126.44]
[null,"Joespeh Smith","2024-01-01","Naypyitaw","Normal","Male","Health and beauty",62.87,2,125.74]
[null,"Abby Willison","2024-01-01","Yangon","Normal","Female","Fashion accessories",65.739999999999995,9,591.66]
[null,"Abby Willison","2024-01-01","Yangon","Member","Female","Sports and travel",27.04,4,108.16]
[null,"Abby Willison","2024-01-01","Yangon","Member","Female","Electronic accessories",74.22,10,742.2]
[null,"Abby Willison","2024-01-01","Naypyitaw","Member","Female","Sports and travel",29.22,6,175.32]
[null,"Abby Willison","2024-01-01","Mandalay","Normal","Male","Food and beverages",21.12,8,168.96]
[null,"Joespeh Smith","2024-01-01","Mandalay","Member","Female","Food and beverages",84.63,10,846.3]
[null,"Joespeh Smith","2024-01-02","Yangon","Normal","Male","Sports and travel",42.47,1,42.47]
[null,"Joespeh Smith","2024-01-02","Naypyitaw","Normal","Male","Fashion accessories",99.82,2,199.64]
[null,"Joespeh Smith","2024-01-02","Mandalay","Normal","Female","Health and beauty",34.21,10,342.1]
[null,"Abby Willison","2024-01-02","Mandalay","Member","Male","Fashion accessories",40.61,9,365.49]
[null,"Joespeh Smith","2024-01-02","Mandalay","Normal","Male","Electronic accessories",22.01,6,132.06]
[null,"Joespeh Smith","2024-01-02","Yangon","Member","Male","Food and beverages",41.66,6,249.95999999999998]
[null,"Joespeh Smith","2024-01-02","Naypyitaw","Member","Female","Sports and travel",31.67,8,253.36]
[null,"Joespeh Smith","2024-01-02","Mandalay","Normal","Male","Sports and travel",44.63,6,267.78000000000003]

{"sheet":"Ch3-Instructions","index":8,"n_rows":92,"n_cols":5,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["Named Ranges and Formatting"]
["Excel 365 Associate Exam"]
["Instructions"]
[]
[]
["Merge  "]
["1. Select the cells E1:L1"]
["2. Click the Merge & Center button under the Alignment section"]
["Alternatively: "]
["1. Select cells E2:L2 "]
["2. Type Ctrl+1"]
["3. Select the alignment tab"]
["4. Under the horizontal dropdown, select \"Center Across Selection\" "]
["5. Click OK  "]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D21)","v":"https://youtu.be/tBqnBrkqMxk"}]
[]
["Format Cells  "]
["1. Select the data for January through December (D11:O16)  "]
["2. Under the Number menu, click the drop down at the top and select Currency  "]
["3. Under the Font section click the drop down for Boarders and click more Boarders "]
["4. Click the drop-down menu for Color and select Green  "]
["5. Click the Outline and Inside buttons under Presets  "]
["6. Click OK  "]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D22)","v":"https://youtu.be/zo0SsbmW9ow"}]
[]
["Named Range  "]
["1. Select all the sales under January  (D11:D17)"]
["2. Click the Name Box in the top left and type “January_Sales”  "]
["3. Hit enter "]
["4. Select all the sales for Electronic Accessories  D11:O11"]
["5. Click the Name Box on the left-hand side and type “Electronic_Accessories”  "]
["6. Hit enter "]
["To check your named ranges: "]
["1. Under the formulas tab on the ribbon, click \"Name Manager\" in the Defined Names menu "]
["2. You can view all named ranges here "]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D23)","v":"https://youtu.be/tHDZrZX-I5o"}]
[]
["Reference Formula  "]
["1. Select all grand total sales (D17:O17)"]
["2. Right click on any of the selected cells "]
["3. Select \"Clear Contents\""]
["4. Click in cell D17  "]
["5. Type =sum and tab to step into the function"]
["6. Type January_Sales and tab to step into the function"]
["7. Close your parenthesis and hit enter  "]
["*Complete formula will look like this =SUM(January_Sales)*  "]
["8. In cell F11 type \"=sum\" and tab to enter the function"]
["9. Type \"Electronic_Sales\" and tab"]
["10. Close parathesis and hit enter"]
["*Complete formula will look like this =SUM(Electronic_Sales)*  "]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D24)","v":"https://youtu.be/j__64J0s9k4"}]
[]
["Change Column Width  "]
["1. Highlight cells C10:C17  "]
["2. Click Wrap Text under the Alignment group in the Home tab "]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D25)","v":"https://youtu.be/nes1DUaA9Xs"}]
[]
[]
["Heading Styles  "]
["1. Select all product names  (C10:C17) "]
["2. Click Cell Styles under the Styles section  "]
["3. Select Heading 4 under the Titles and Headings section"]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D25)","v":"https://youtu.be/nes1DUaA9Xs"}]
[]
[]
["Display Top Amounts  "]
["1. Select all January Sales or use the named range January_Sales  "]
["2. Under the Cell Styles section click Conditional Formatting  "]
["3. Click Top/Bottom Rules  "]
["4. Click Top 10 Items...  "]
["5. Change 10 to 3  "]
["6. Change to Red Text  "]
["7. Click OK  "]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D26)","v":"https://youtu.be/5W8kOdkWzs8"}]
[]
[]
["Line Graph  "]
["1. Click in P11  "]
["2. Click the Insert tab in the ribbon"]
["3. Click Line under the Sparklines section  "]
["4.Type \"Electronic_accessories\" to use as the Data Range  or select cells D11:O11"]
["5. Click OK  "]
["Video Link:",null,{"$f":"HYPERLINK(C89:E89)","v":"https://youtu.be/wNsk4mUUymE"},"",""]
[]
[]
["Remove Row  "]
["1. Click on Row 3  "]
["2. Right click and select delete  or select row and type Ctrl-"]
["Video Link:",null,{"$f":"HYPERLINK(TOC!D27)","v":"https://youtu.be/wNsk4mUUymE"}]
[]
[]
["When you have completed all tasks, please save and close the workbook "]

{"sheet":"Ch3-Sales_Report","index":9,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Superstore"]
[null,null,null,null,"Segment Sales Report"]
[null,null,null,null,"123 56th Road"]
[null,null,null,null,"San Diego, CA 22434"]
[null,null,null,null,"(123)-456-7890"]
[null,null,null,null,"For Internal Use Only"]
[]
[]
[null,null,"Sum of Gross Profit","Q1"," "," ","Q2"," "," ","Q3"," "," ","Q4"," "," "]
[null,null,"Product Line","January","February","March","April","May","June","July","August","September","October","November","December"]
[null,null,"Electronic accessories",896.72800000000007,826.80500000000018,863.96850000000018,1650.5910750000014,2785.6158750000013,2476.9867500000028,2054.1648750000022,2791.8717750000023,2193.177000000001,1739.8437000000019,2398.4541000000027,2446.9546500000024]
[null,null,"Fashion accessories",921.19600000000014,905.2315000000001,759.56750000000022,1883.3440500000029,2464.1137500000009,2585.3409750000019,2082.2308500000026,2712.6135750000017,2228.8843500000025,2397.3342750000029,3161.1499500000014,1941.2783250000018]
[null,null,"Food and beverages",931.92999999999984,952.39800000000037,789.23599999999999,1944.8819250000015,2883.7630500000023,2527.9311750000015,2630.0006250000015,2264.8305750000022,1971.1319250000022,2142.2362500000013,2340.4169250000018,2104.6284000000023]
[null,null,"Health and beauty",780.15099999999939,695.34550000000002,867.06250000000011,1639.3419000000022,2155.8416250000018,2461.388475000002,2012.1354750000023,1812.4013250000019,2166.7947000000017,2176.834275000002,1960.3694250000024,1752.3581250000016]
[null,null,"Home and lifestyle",975.93999999999971,592.11350000000039,996.79949999999985,1821.0160500000013,1719.0421500000023,2595.6504000000023,2306.9697000000024,1712.4066750000011,2803.412850000002,2355.0912000000035,1411.9113750000017,2424.982350000002]
[null,null,"Sports and travel",1031.7629999999999,657.60050000000001,935.53300000000013,2019.395175000001,2154.7296750000023,2197.4625750000023,2447.0922000000019,1841.7714000000024,1938.1950000000008,3159.4678500000032,2207.4438750000018,1722.6168750000024]
[null,null,"Grand Total"]
[]
[null,null," "]

{"sheet":"Ch4-Instructions","index":10,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[4,0,4,8]]}
["Tables"]
["Excel 365 Associate Exam"]
["Instructions"]
[]
["For Internal Use Only"]
[]
["Create a Table  ",null," "," "," "," "," "]
["1. Click in A9 use the keyboard short CTRL + SHIFT Right Arrow then Down Arrow (the whole range should be A9:Q40)  "]
["2. Click the Insert tab in the ribbon",null,null,null,null,null," "]
["3. Click Table under the Tables section *Could also use CTRL+T*  "]
["4. Make sure My table has headers is checked  ",null,null,null,null,null," "]
["5. Click OK  "]
["Video Link:"," ",{"$f":"HYPERLINK(TOC!D29)","v":"https://youtu.be/uivOZ5eaico"}," "," "," "," "]
[]
["Table Styles  ",null," "," "," "," "," "]
["1. Click in any cell on the Table  ",null,null,null,null,null," "]
["2. Click Table Design tab in the ribbon",null,null,null,null,null," "]
["3. Click the drop-down under the Table Styles section  ",null,null,null,null,null," "]
["4. Click the Light Green Table Style Light 14"]
["Video Link:",null,{"$f":"HYPERLINK(C13)","v":"https://youtu.be/uivOZ5eaico"},null,null," "," "]
[]
["Remove Columns  ",null,null," "," "," "," "]
["1. Click Column Q ",null,null,null,null,null," "]
["2. Right click and click delete ",null,null,null,null,null," "]
["Video Link:"," ",{"$f":"HYPERLINK(TOC!D30)","v":"https://youtu.be/wOMfhh9PMMQ"}," "," "," "," "]
[]
["Name a Table  ",null," "," "," "," "," "]
["1. Click in any cell on the Table  ",null,null,null,null,null," "]
["2. Click Table Design tab at the top ",null,null,null,null,null," "]
["3. Under the Properties section type “Sales_Report” in the Table Name box  "]
["Video Link:"," ",{"$f":"HYPERLINK(TOC!D30)","v":"https://youtu.be/wOMfhh9PMMQ"}," "," "," "," "]
[]
["Display Lowest to Highest  ",null,null," "," "," "," "]
["1. Click the drop-down menu under \"Gross Profit\" (Column P)"]
["2. Click Sort Smallest to Largest  ",null,null,null,null,null," "]
["Video Link:"," ",{"$f":"HYPERLINK(C31)","v":"https://youtu.be/wOMfhh9PMMQ"},null," "," "," "]
[]
["Add a Total Row"]
["1. Click any cell in the table"]
["2. In the Table Design Tab, check off the box lablled \"total row\" "]
[]
[]
["Display by Criteria  ",null,null," "," "," "," "]
["1. Click the drop-down menu under Payment ",null,null,null,null,null," "]
["2. Click (Select All) to deselect all the selections  ",null,null,null,null,null," "]
["3. Check off Cash and Ewallet  ",null,null,null,null,null," "]
["4. Click OK  ",null,null,null,null,null," "]
["5. Click in any cell on the Table  ",null,null,null,null,null," "]
["6. Click Table Design tab at the top  ",null,null,null,null,null," "]
["7. Under the Table Style Options and check off Total Row  ",null,null,null,null,null," "]
["8. At the bottom cell under Gross Profit click the drop down menu in cell P40  "]
["9. Click Average  ",null,null,null,null,null," "]
["Video Link:"," ",{"$f":"HYPERLINK(TOC!D31)","v":"https://youtu.be/Nih8g3tRMEc"}," "," "," "," "]
[]
["Remove Table Functionality but Retain All Formatting  ",null,null,null,null,null," "]
["1. Click in any cell on the Table  ",null,null,null,null,null," "]
["2. Click Table Design tab in the ribbon",null,null,null,null,null," "]
["3. Click Convert to Range under the Tools section  ",null,null,null,null,null," "]
["4. Click Yes ",null,null,null,null,null," "]
["Video Link:"," ",{"$f":"HYPERLINK(TOC!D33)","v":"https://youtu.be/8I4UtIkMP1M"}," "," "," "," "]

{"sheet":"Ch4-Sales Data","index":11,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,2,5,10],[0,2,0,10],[1,2,1,10],[2,2,2,10],[3,2,3,10],[4,2,4,10]]}
[null,null,"Superstore "]
[null,null,"Sales Report"]
[null,null,"123 56th Road"]
[null,null,"San Diego, CA 22434"]
[null,null,"(123) 456-7890"]
[null,null,"For Internal Use Only"]
[]
[]
["Date","Time","Invoice ID","Payment","Branch","City","Customer type","Gender","Product line","Unit price","Quantity","Subtotal","Tax 5%","Total","COGS","Gross Profit","Rating",null," ",null,null,null,null,null,0.05]
["2024-01-05","13:08:00","750-67-8428","Ewallet","A","Yangon","Member","Female","Health and beauty",74.69,7,522.83000000000004,26.14,548.97,{"$f":"N10*((RIGHT(User_Info!$C$3,2)*0.01))","v":301.93350000000004},26.14,9.1]
["2024-03-08","10:29:00","226-31-3081","Cash","C","Naypyitaw","Normal","Female","Electronic accessories",15.28,5,76.400000000000006,3.82,80.22,{"$f":"N11*((RIGHT(User_Info!$C$3,2)*0.01))","v":44.121000000000002},3.82,9.6]
["2024-03-03","13:23:00","631-41-3108","Credit card","A","Yangon","Normal","Male","Home and lifestyle",46.33,7,324.31,16.22,340.53,{"$f":"N12*((RIGHT(User_Info!$C$3,2)*0.01))","v":187.29150000000001},16.22,7.4]
["2024-01-27","20:33:00","123-19-1176","Ewallet","A","Yangon","Member","Male","Health and beauty",58.22,8,465.76,23.29,489.05,{"$f":"N13*((RIGHT(User_Info!$C$3,2)*0.01))","v":268.97750000000002},23.29,8.4]
["2024-02-08","10:37:00","373-73-7910","Ewallet","A","Yangon","Normal","Male","Sports and travel",86.31,7,604.16999999999996,30.21,634.38,{"$f":"N14*((RIGHT(User_Info!$C$3,2)*0.01))","v":348.90900000000005},30.21,5.3]
["2024-03-25","18:30:00","699-14-3026","Ewallet","C","Naypyitaw","Normal","Male","Electronic accessories",85.39,7,597.73,29.89,627.62,{"$f":"N15*((RIGHT(User_Info!$C$3,2)*0.01))","v":345.19100000000003},29.89,4.0999999999999996]
["2024-02-25","14:36:00","355-53-5943","Ewallet","A","Yangon","Member","Female","Electronic accessories",68.84,6,413.04,20.65,433.69,{"$f":"N16*((RIGHT(User_Info!$C$3,2)*0.01))","v":238.52950000000001},20.65,5.8]
["2024-02-24","11:38:00","315-22-5665","Ewallet","C","Naypyitaw","Normal","Female","Home and lifestyle",73.56,10,735.6,36.78,772.38,{"$f":"N17*((RIGHT(User_Info!$C$3,2)*0.01))","v":424.80900000000003},36.78,8]
["2024-01-10","17:15:00","665-32-9167","Credit card","A","Yangon","Member","Female","Health and beauty",36.26,2,72.52,3.63,76.150000000000006,{"$f":"N18*((RIGHT(User_Info!$C$3,2)*0.01))","v":41.882500000000007},3.63,7.2]
["2024-02-20","13:27:00","692-92-5582","Credit card","B","Mandalay","Member","Female","Food and beverages",54.84,3,164.52,8.23,172.75,{"$f":"N19*((RIGHT(User_Info!$C$3,2)*0.01))","v":95.012500000000003},8.23,5.9]
["2024-02-06","18:07:00","351-62-0822","Ewallet","B","Mandalay","Member","Female","Fashion accessories",14.48,4,57.92,2.9,60.82,{"$f":"N20*((RIGHT(User_Info!$C$3,2)*0.01))","v":33.451000000000001},2.9,4.5]
["2024-03-09","17:03:00","529-56-3974","Cash","B","Mandalay","Member","Male","Electronic accessories",25.51,4,102.04,5.0999999999999996,107.14,{"$f":"N21*((RIGHT(User_Info!$C$3,2)*0.01))","v":58.927000000000007},5.0999999999999996,6.8]
["2024-02-12","10:25:00","365-64-0515","Ewallet","A","Yangon","Normal","Female","Electronic accessories",46.95,5,234.75,11.74,246.49,{"$f":"N22*((RIGHT(User_Info!$C$3,2)*0.01))","v":135.56950000000001},11.74,7.1]
["2024-02-07","16:48:00","252-56-2699","Ewallet","A","Yangon","Normal","Male","Food and beverages",43.19,10,431.9,21.6,453.5,{"$f":"N23*((RIGHT(User_Info!$C$3,2)*0.01))","v":249.42500000000001},21.6,8.1999999999999993]
["2024-03-29","19:21:00","829-34-3910","Cash","A","Yangon","Normal","Female","Health and beauty",71.38,10,713.8,35.69,749.49,{"$f":"N24*((RIGHT(User_Info!$C$3,2)*0.01))","v":412.21950000000004},35.69,5.7]
["2024-01-15","16:19:00","299-46-1805","Cash","B","Mandalay","Member","Female","Sports and travel",93.72,6,562.32000000000005,28.12,590.44000000000005,{"$f":"N25*((RIGHT(User_Info!$C$3,2)*0.01))","v":324.74200000000008},28.12,4.5]
["2024-03-11","11:03:00","656-95-9349","Credit card","A","Yangon","Member","Female","Health and beauty",68.930000000000007,7,482.51,24.13,506.64,{"$f":"N26*((RIGHT(User_Info!$C$3,2)*0.01))","v":278.65199999999999},24.13,4.5999999999999996]
["2024-01-01","10:39:00","765-26-6951","Credit card","A","Yangon","Normal","Male","Sports and travel",72.61,6,435.66,21.78,457.44,{"$f":"N27*((RIGHT(User_Info!$C$3,2)*0.01))","v":251.59200000000001},21.78,6.9]
["2024-01-21","18:00:00","329-62-1586","Credit card","A","Yangon","Normal","Male","Food and beverages",54.67,3,164.01,8.1999999999999993,172.21,{"$f":"N28*((RIGHT(User_Info!$C$3,2)*0.01))","v":94.715500000000006},8.1999999999999993,8.6]
["2024-03-11","15:30:00","319-50-3348","Ewallet","B","Mandalay","Normal","Female","Home and lifestyle",40.299999999999997,2,80.599999999999994,4.03,84.63,{"$f":"N29*((RIGHT(User_Info!$C$3,2)*0.01))","v":46.546500000000002},4.03,4.4000000000000004]
["2024-02-25","11:24:00","300-71-4605","Ewallet","C","Naypyitaw","Member","Male","Electronic accessories",86.04,5,430.2,21.51,451.71,{"$f":"N30*((RIGHT(User_Info!$C$3,2)*0.01))","v":248.44050000000001},21.51,4.8]
["2024-03-05","10:40:00","371-85-5789","Ewallet","B","Mandalay","Normal","Male","Health and beauty",87.98,3,263.94,13.2,277.14,{"$f":"N31*((RIGHT(User_Info!$C$3,2)*0.01))","v":152.42699999999999},13.2,5.0999999999999996]
["2024-03-15","12:20:00","273-16-6619","Credit card","B","Mandalay","Normal","Male","Home and lifestyle",33.200000000000003,2,66.400000000000006,3.32,69.72,{"$f":"N32*((RIGHT(User_Info!$C$3,2)*0.01))","v":38.346000000000004},3.32,4.4000000000000004]
["2024-02-17","11:15:00","636-48-8204","Ewallet","A","Yangon","Normal","Male","Electronic accessories",34.56,5,172.8,8.64,181.44,{"$f":"N33*((RIGHT(User_Info!$C$3,2)*0.01))","v":99.792000000000002},8.64,9.9]
["2024-03-02","17:36:00","549-59-1358","Ewallet","A","Yangon","Member","Male","Sports and travel",88.63,3,265.89,13.29,279.18,{"$f":"N34*((RIGHT(User_Info!$C$3,2)*0.01))","v":153.54900000000001},13.29,6]
["2024-03-22","19:20:00","227-03-5010","Credit card","A","Yangon","Member","Female","Home and lifestyle",52.59,8,420.72,21.04,441.76,{"$f":"N35*((RIGHT(User_Info!$C$3,2)*0.01))","v":242.96800000000002},21.04,8.5]
["2024-02-08","15:31:00","649-29-6775","Cash","B","Mandalay","Normal","Male","Fashion accessories",33.520000000000003,1,33.520000000000003,1.68,35.200000000000003,{"$f":"N36*((RIGHT(User_Info!$C$3,2)*0.01))","v":19.360000000000003},1.68,6.7]
["2024-03-10","12:17:00","189-17-4241","Credit card","A","Yangon","Normal","Female","Fashion accessories",87.67,2,175.34,8.77,184.11,{"$f":"N37*((RIGHT(User_Info!$C$3,2)*0.01))","v":101.26050000000002},8.77,7.7]
["2024-01-25","19:48:00","145-94-9061","Cash","B","Mandalay","Normal","Female","Food and beverages",88.36,5,441.8,22.09,463.89,{"$f":"N38*((RIGHT(User_Info!$C$3,2)*0.01))","v":255.13950000000003},22.09,9.6]
["2024-03-15","15:36:00","848-62-7243","Cash","A","Yangon","Normal","Male","Health and beauty",24.89,9,224.01,11.2,235.21,{"$f":"N39*((RIGHT(User_Info!$C$3,2)*0.01))","v":129.36550000000003},11.2,7.4]

{"sheet":"Ch5-Instructions","index":12,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,0,4,6],[0,0,0,6],[1,0,1,6],[2,0,2,6]]}
["Formulas"]
["Excel 365 Associate Exam"]
["Instructions"]
[]
["For Internal Use Only"]
[]
["Using the UPPER Function"]
["1. Beginning in cell O11, format all Cities in all capital letters."]
["2. Replace the current City data with the newly formatted data. "]
[" "]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D35)","v":"https://youtu.be/Skz4S2Gk_To"}]
[]
["Using an Absolute Reference "]
["1.  Beginning in cell L11, calculate the Sales Tax for each Order.  "]
["2.  Beginning in cell M11, calculate the Order Amount and Tax for each Order."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D36)","v":"https://youtu.be/ipnPGPQ9lS4"}]
[]
["Using the TEXTJOIN Function"]
["1. Beginning in cell G11, join the City, followed by a hyphen (-) and the\t"]
["     Customer number for all Customers."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D37)","v":"https://youtu.be/BF3TmkzNrVo"}]
[]
["Using the IF Function"]
["1. Beginning in cell K11, display \"Yes\" if the employee has Medical for benefits, "]
["     otherwise display \"No\"."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D38)","v":"https://youtu.be/ajlrX2IQ8eU"}]
[]
["Using the AVERAGE Function "]
["1. In cell O10, determine the average Benefit Cost for all Employees."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D39)","v":"https://youtu.be/zimny1mcyt0"}]
[]
["Using the UNIQUE Function "]
["1. Beginning in Q11, create a list of Departments, listing each Department only once."]
["Video Link: ",null,{"$f":"HYPERLINK(TOC!D40)","v":"https://youtu.be/_kOMwDqlGnU"}]

{"sheet":"Ch5-Sales Report","index":13,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,1,8,10],[1,1,1,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,10],[6,1,6,10]]}
[]
[null,"Superstore "]
[null,"Segment Sales Report"]
[null,"123 56th Road"]
[null,"San Diego, CA 22434"]
[null,"(123) 456-7890"]
[null,"For Internal Use Only"]
[]
[null,"Superstore Internet Orders for Q1",null,null,null,null,null,null,null,null,null,"Sales Tax",0.06]
[null,"Order Date","Invoice ID","City","Payment Type ","Customer #","City and Customer #","Product line","Unit Price","Quantity","Order Amount","Tax","Total Order Amount"]
[null,"2024-03-09","219-22-9386","MANDALAY","Credit card","YXT989",null,"Sports and travel",99.96,9,{"$f":"I11*J11","v":899.64}]
[null,"2024-03-13","336-78-2147","NAYPYITAW","Credit card","YMD139",null,"Home and lifestyle",63.91,8,511.28]
[null,"2024-03-09","268-27-6179","MANDALAY","Ewallet","RRK660",null,"Fashion accessories",56.47,8,451.76]
[null,"2024-03-10","668-90-8900","YANGON","Credit card","LBZ036",null,"Home and lifestyle",93.69,7,655.82999999999993]
[null,"2024-01-27","870-54-3162","YANGON","Cash","XQR615",null,"Sports and travel",32.25,5,161.25]
[null,"2024-01-08","189-08-9157","NAYPYITAW","Credit card","RBZ029",null,"Fashion accessories",31.73,9,285.57]
[null,"2024-01-08","663-86-9076","NAYPYITAW","Ewallet","FWF661",null,"Food and beverages",68.540000000000006,8,548.32000000000005]
[null,"2024-02-08","549-84-7482","MANDALAY","Ewallet","EQE183",null,"Sports and travel",90.28,9,812.52]
[null,"2024-01-25","191-10-6171","MANDALAY","Cash","UDL363",null,"Fashion accessories",39.619999999999997,7,277.33999999999997]
[null,"2024-03-06","802-70-5316","YANGON","Cash","JGS356",null,"Sports and travel",92.13,6,552.78]
[null,"2024-02-10","695-51-0018","MANDALAY","Cash","JZS431",null,"Sports and travel",34.840000000000003,4,139.36000000000001]
[null,"2024-02-17","590-83-4591","MANDALAY","Credit card","VIW105",null,"Electronic accessories",87.45,6,524.70000000000005]
[null,"2024-03-08","483-71-1164","NAYPYITAW","Ewallet","JRK776",null,"Health and beauty",81.3,6,487.79999999999995]
[null,"2024-02-18","597-78-7908","NAYPYITAW","Cash","GKA523",null,"Fashion accessories",90.22,3,270.65999999999997]
[null,"2024-01-18","700-81-1757","YANGON","Credit card","ENA016",null,"Electronic accessories",26.31,5,131.54999999999998]
[null,"2024-02-18","354-39-5160","YANGON","Cash","HHU346",null,"Home and lifestyle",34.42,6,206.52]
[null,"2024-02-16","241-72-9525","MANDALAY","Cash","WPL902",null,"Sports and travel",51.91,10,519.09999999999991]
[null,"2024-03-16","575-30-8091","YANGON","Ewallet","AYL922",null,"Sports and travel",72.5,8,580]
[null,"2024-01-23","731-81-9469","NAYPYITAW","Credit card","EPD316",null,"Sports and travel",89.8,10,898]
[null,"2024-01-25","280-17-4359","NAYPYITAW","Cash","FRO952",null,"Health and beauty",90.5,10,905]

{"sheet":"Ch5-Payroll Data","index":14,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,1,8,10],[9,12,9,13],[1,1,1,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,10],[6,1,6,10]]}
[]
[null,"Superstore "]
[null,"Segment Sales Report"]
[null,"123 56th Road"]
[null,"San Diego, CA 22434"]
[null,"(123) 456-7890"]
[null,"For Internal Use Only"]
[]
[null,"Payroll for June 2023"]
[null,"DEPARTMENT","EMPLOYEE NUMBER","FIRST NAME","LAST NAME","DATE OF HIRE","BENEFITS","BENEFIT COST","HOURS","HOURLY RATE","MEDICAL",null,"Average Benefit Cost:",null,null,null,"Departments"]
[null,"Receiving","DXS617","John","Smith","10/20/2023","Dental",50,23,43.76]
[null,"Sales","CVM702","Emily","Johnson","02/07/2014","Medical",100,19,35.25]
[null,"Receiving","KCL634","Michael","Williams","05/21/2018","Vision",200,17,48.73]
[null,"Sales","BAB252","Sarah","Brown","05/21/2016","Medical",100,36,47.91]
[null,"HR","KRV992","David","Jones","03/08/2011","Dental",110,4,30.04]
[null,"Sales","PWW863","Jessica","Garcia","11/20/2014","Medical",150,21,46.95]
[null,"Shipping","FZM837","James","Miller","03/17/2018","Vision",80,8,30.22]
[null,"Shipping","QVT993","Sophia","Davis","01/16/2018","Dental",100,23,39.86]
[null,"Shipping","EYW948","Daniel","Rodriguez","06/01/2021","Medical",220,28,44.66]
[null,"Shipping","ORO173","Olivia","Martinez","04/19/2010","Vision",100,22,36.659999999999997]
[null,"Shipping","ACJ292","William","Hernandez","08/17/2022","Medical",220,7,44.39]
[null,"Marketing","TUE642","Emma","Lopez","08/22/2023","Medical",100,36,34.68]
[null,"HR","TNK260","Noah","Gonzalez","10/31/2019","Medical",140,9,36.15]
[null,"Shipping","TKM859","Ava","Wilson","11/26/2012","Medical",100,38,46.03]
[null,"Sales","CUN323","Liam","Anderson","09/23/2014","Vision",100,5,49.07]
[null,"HR","VDJ917","Mia","Thomas","08/25/2014","Vision",210,22,39.9]
[null,"HR","VEQ942","Benjamin","Taylor","05/06/2011","Dental",60,28,34.51]
[null,"Receiving","EWJ123","Isabella","Moore","05/21/2020","Medical",100,17,32.630000000000003]
[null,"Marketing","WJK976","Lucas","Jackson","01/30/2018","Dental",50,39,37.11]
[null,"Receiving","AOS909","Amelia","Lee","12/23/2010","Dental",50,21,48.09]

{"sheet":"Ch6-Instructions","index":15,"n_rows":97,"n_cols":7,"rows_kept":97,"cut":false,"hidden":false,"merged":[[4,0,4,6]]}
["Charting"]
["Excel 365 Associate Exam"]
["Instructions"]
[]
["For Internal Use Only"]
[]
[]
["Create a Clustered Column Chart",null,null,null," "," "," "]
["1. Select just the data for January, February, and March (Cells D10:G16)  "]
["2. Click the Insert tab at the top  ",null,null,null,null,null," "]
["3. Under the Charts section click columns  ",null,null,null,null,null," "]
["4. Click on the Clustered Column Chart option  ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D42)","v":"https://youtu.be/NdvCTjbpJ-8"}," "," "," "," "]
[]
["Filter the Chart  ",null," "," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. On the right-hand side click the filter button  ",null,null,null,null,null," "]
["3. Under the Categories section click the (Select All) button to deselect everything  "]
["4. Check off Electronic Accessories and Sports and Travel ",null,null,null,null,null," "]
["5. Click Apply  ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D42)","v":"https://youtu.be/NdvCTjbpJ-8"}," "," "," "," "]
[]
["Apply Quick Layout  ",null,null," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click on the Chart Design tab at the top  ",null,null,null,null,null," "]
["3. Click Quick Layout under Chart Layouts  ",null,null,null,null,null," "]
["4. Click Quick Layout 9 ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D42)","v":"https://youtu.be/NdvCTjbpJ-8"}," "," "," "," "]
[]
["Apply Chart Style  ",null,null," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click on the Chart Design tab at the top ",null,null,null,null,null," "]
["3. Click the drop-down arrow under the Chart Styles section  "]
["4. Click Style 7  ",null,null,null,null,null," "]
["Video Linkss:"," ",{"$f":"HYPERLINK(TOC!D43)","v":"https://youtu.be/BHHmtCPwxm0"}," "," "," "," "]
[]
["Add Data Labels  ",null," "," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click on the Chart Design tab at the top  ",null,null,null,null,null," "]
["3. Click Add Chart Element under Chart Layouts ",null,null,null,null,null," "]
["4. Click Data Labels  ",null,null,null,null,null," "]
["5. Click Outside End  ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D43)","v":"https://youtu.be/BHHmtCPwxm0"}," "," "," "," "]
[]
["Swap Data Over Axis  ",null,null," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click on the Chart Design tab at the top ",null,null,null,null,null," "]
["3. Click Switch Row/Column under the Data section  ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D43)","v":"https://youtu.be/BHHmtCPwxm0"}," "," "," "," "]
[]
["Add Data  ",null," "," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click on the Chart Design tab at the top  ",null,null,null,null,null," "]
["3. Click Select Data under the Data section  ",null,null,null,null,null," "]
["4. Reselect the date to include the whole table (D10:J16)  ",null,null,null,null,null," "]
["5. Click OK  ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D44)","v":"https://youtu.be/N0GVpN0UKQM"}," "," "," "," "]
[]
["Add Chart Elements  ",null,null," "," "," "," "]
["Chart Title  ",null,null,null,null,null," "]
["1. Click on the Chart Title on the top  ",null,null,null,null,null," "]
["2. Type “Segment Sales Report Q1 and Q2” and hit enter  ",null,null,null,null,null," "]
["3. The title will automatically change and you can see it changing in the formula bar  "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D44)","v":"https://youtu.be/N0GVpN0UKQM"}," "," "," "," "]
[]
["Add Chart Elements  ",null,null," "," "," "," "]
["Vertical Axis Title  ",null,null,null,null,null," "]
["1. Type “Sales” and hit enter  ",null,null,null,null,null," "]
["2. The title will automatically change and you can see it changing in the formula bar "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D44)","v":"https://youtu.be/N0GVpN0UKQM"}," "," "," "," "]
[]
["Add Chart Elements  ",null,null," "," "," "," "]
["Linear Trendline  ",null,null,null,null,null," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click on the Chart Design tab at the top  ",null,null,null,null,null," "]
["3. Click Add Chart Element under Chart Layouts ",null,null,null,null,null," "]
["4. Click Trendline  ",null,null,null,null,null," "]
["5. Click Linear  ",null,null,null,null,null," "]
["6. Click Food and Beverage ",null,null,null,null,null," "]
["7. Click OK  ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D45)","v":"https://youtu.be/k1H0K74VqQY"}," "," "," "," "]
[]
["Add ALT Text  ",null," "," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click the Format tab at the top  ",null,null,null,null,null," "]
["3. Click Alt Text under the Accessibility Section  ",null,null,null,null,null," "]
["4. In the box on the right paste or type the text “Sales Report by Segment for Q1 and Q2”  "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D46)","v":"https://youtu.be/X2F_g_f9y-w"}," "," "," "," "]
[]
["Move Chart  ",null," "," "," "," "," "]
["1. Click on the chart  ",null,null,null,null,null," "]
["2. Click on the Chart Design tab at the top ",null,null,null,null,null," "]
["3. Click Move Chart under the Location section  ",null,null,null,null,null," "]
["4. In the dialogue box click New Sheet  ",null,null,null,null,null," "]
["5. Type “Segment Sales Q1 and Q2” as the name  ",null,null,null,null,null," "]
["6. Click OK  ",null,null,null,null,null," "]
["Video Links",null,{"$f":"HYPERLINK(TOC!D46)","v":"https://youtu.be/X2F_g_f9y-w"}," "," "," "," "]

{"sheet":"Ch6-Sales_by_Product_Line","index":16,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,2,5,10],[0,2,0,10],[1,2,1,10],[2,2,2,10],[3,2,3,10],[4,2,4,10]]}
[null,null,"Superstore "]
[null,null,"Segment Sales Report"]
[null,null,"123 56th Road"]
[null,null,"San Diego, CA 22434"]
[null,null,"(123) 456-7890"]
[null,null,"For Internal Use Only"]
[]
[]
[null,null,null,null,"Q1",null,null,"Q2"]
[null,null,null,"Product Line","January","February","March","April","May","June","Total"]
[null,null,null,"Electronic Accessories",17935,16536,17279,31440,53059,47181,{"$f":"SUM(E11:J11)","v":183430}]
[null,null,null,"Fashion Accessories",18424,18105,15191,35873,46936,49245,{"$f":"SUM(E12:J12)","v":183774}]
[null,null,null,"Food and Beverages",18639,19048,15785,37045,54929,48151,{"$f":"SUM(E13:J13)","v":193597}]
[null,null,null,"Health and Beauty",15603,13907,17341,31226,41064,46884,166025]
[null,null,null,"Home and Lifestyle",19936,11842,19936,34686,32744,49441,168585]
[null,null,null,"Sports and Travel",18711,13152,18711,38465,41042,41856,171937]

{"sheet":"Audit","index":17,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Timestamp","Sheet Name","Cell","Previous Value","New Value"]
["File closed","caiazzop","2025-01-07T15:11:49"]
["Cell changed","caiazzop","2025-01-16T16:37:15","Ch6-Sales_by_Product_Line","$A$37"]
["File closed","caiazzop","2025-01-16T16:37:32"]
["File opened","caiazzop","2025-01-22T12:47:45"]
["Cell changed","caiazzop","2025-01-22T12:48:01","User_Info","$D$15"]
["Cell changed","caiazzop","2025-01-22T12:48:01","User_Info","$D$16"]
["Cell changed","caiazzop","2025-01-22T12:48:01","User_Info","$D$17"]
["Cell changed","caiazzop","2025-01-22T12:48:01","User_Info","$D$18"]
["Cell changed","caiazzop","2025-01-22T12:48:01","User_Info","$D$19"]
["Cell changed","caiazzop","2025-01-22T12:48:01","User_Info","$D$20"]
["File closed","caiazzop","2025-01-22T12:49:29"]