{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Group Feature","Subtotal","Keyboard Shortcut","Auto Outline","Pivot Table","PivotTable","VBA","Collapse & Expand","Ungroup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Dataset","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,1,11,1],[8,6,11,6],[12,1,14,1],[12,6,14,6],[1,1,1,6],[4,1,7,1],[4,6,7,6]]}
[]
[null,"Dataset"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D5:F8)","v":1168}]
[null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D9:F12)","v":1512}]
[null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D13:F15)","v":2310}]
[null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100]

{"sheet":"Group Feature","index":1,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,14,1],[4,11,7,11],[8,11,11,11],[12,11,14,11],[1,1,1,6],[1,11,1,16],[4,6,7,6],[8,6,11,6],[12,6,14,6],[4,16,7,16],[8,16,11,16],[12,16,14,16],[4,1,7,1],[8,1,11,1]]}
[]
[null,"Use of Group Feature",null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales",null,null,null,null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D5:F8)","v":1168},null,null,null,null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(N5:P8)","v":1168}]
[null,null,"Dove",100,50,80,null,null,null,null,null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78,null,null,null,null,null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190,null,null,null,null,null,null,"Head and Shoulders",90,124,190]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D9:F12)","v":1512},null,null,null,null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(N9:P12)","v":1512}]
[null,null,"Dove",200,114,88,null,null,null,null,null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75,null,null,null,null,null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69,null,null,null,null,null,null,"Head and Shoulders",99,94,69]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D13:F15)","v":2310},null,null,null,null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(N13:P15)","v":2310}]
[null,null,"Nivea",310,140,310,null,null,null,null,null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100,null,null,null,null,null,null,"WOW",280,380,100]

{"sheet":"Subtotal","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,6],[5,1,8,1],[10,1,13,1],[15,1,17,1]]}
[]
[null,"Use of Subtotal Feature"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Product Total",null,{"$f":"SUBTOTAL(9,D4:D4)","v":0},{"$f":"SUBTOTAL(9,E4:E4)","v":0},{"$f":"SUBTOTAL(9,F4:F4)","v":0}]
[null,"Shampoo","L'Oréal",120,88,99]
[null,null,"Dove",100,50,80,{"$f":"SUM(D6:F9)","v":1168}]
[null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190]
[null,"Shampoo Total",null,{"$f":"SUBTOTAL(9,D6:D9)","v":390},{"$f":"SUBTOTAL(9,E6:E9)","v":331},{"$f":"SUBTOTAL(9,F6:F9)","v":447}]
[null,"Conditoner","L'Oréal",111,113,78]
[null,null,"Dove",200,114,88,{"$f":"SUM(D11:F14)","v":1512}]
[null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69]
[null,"Conditoner Total",null,{"$f":"SUBTOTAL(9,D11:D14)","v":650},{"$f":"SUBTOTAL(9,E11:E14)","v":552},{"$f":"SUBTOTAL(9,F11:F14)","v":310}]
[null,"Face Wash","Himalaya",300,200,290]
[null,null,"Nivea",310,140,310,{"$f":"SUM(D16:F18)","v":2310}]
[null,null,"WOW",280,380,100]
[null,"Face Wash Total",null,{"$f":"SUBTOTAL(9,D16:D18)","v":890},{"$f":"SUBTOTAL(9,E16:E18)","v":720},{"$f":"SUBTOTAL(9,F16:F18)","v":700}]
[]
[null,"Grand Total",null,{"$f":"SUBTOTAL(9,D3:D20)","v":1930},{"$f":"SUBTOTAL(9,E3:E20)","v":1603},{"$f":"SUBTOTAL(9,F3:F20)","v":1457}]

{"sheet":"Keyboard Shortcut","index":3,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,14,1],[4,11,7,11],[8,11,11,11],[12,11,14,11],[1,1,1,6],[1,11,1,16],[4,6,7,6],[8,6,11,6],[12,6,14,6],[4,16,7,16],[8,16,11,16],[12,16,14,16],[4,1,7,1],[8,1,11,1]]}
[]
[null,"Use of Keyboard Shortcut",null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales",null,null,null,null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D5:F8)","v":1168},null,null,null,null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(N5:P8)","v":1168}]
[null,null,"Dove",100,50,80,null,null,null,null,null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78,null,null,null,null,null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190,null,null,null,null,null,null,"Head and Shoulders",90,124,190]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D9:F12)","v":1512},null,null,null,null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(N9:P12)","v":1512}]
[null,null,"Dove",200,114,88,null,null,null,null,null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75,null,null,null,null,null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69,null,null,null,null,null,null,"Head and Shoulders",99,94,69]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D13:F15)","v":2310},null,null,null,null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(N13:P15)","v":2310}]
[null,null,"Nivea",310,140,310,null,null,null,null,null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100,null,null,null,null,null,null,"WOW",280,380,100]

{"sheet":"Auto Outline","index":4,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,5],[8,11,8,15],[13,11,13,15],[17,11,17,15],[14,1,16,1],[4,11,7,11],[9,11,12,11],[14,11,16,11],[8,1,8,5],[13,1,13,5],[1,1,1,6],[1,11,1,16],[4,6,7,6],[9,6,12,6],[14,6,16,6],[4,16,7,16],[9,16,12,16],[14,16,16,16],[4,1,7,1],[9,1,12,1]]}
[]
[null,"Use of Auto Outline Feature",null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales",null,null,null,null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D5:F8)","v":1168},null,null,null,null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(N5:P8)","v":1168}]
[null,null,"Dove",100,50,80,null,null,null,null,null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78,null,null,null,null,null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190,null,null,null,null,null,null,"Head and Shoulders",90,124,190]
[null,"Shampoo Total",null,null,null,null,{"$f":"SUM(D5:F8)","v":1168},null,null,null,null,"Shampoo Total",null,null,null,null,{"$f":"SUM(N5:P8)","v":1168}]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D10:F13)","v":1512},null,null,null,null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(N10:P13)","v":1512}]
[null,null,"Dove",200,114,88,null,null,null,null,null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75,null,null,null,null,null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69,null,null,null,null,null,null,"Head and Shoulders",99,94,69]
[null,"Conditoner Total",null,null,null,null,{"$f":"SUM(D10:F13)","v":1512},null,null,null,null,"Conditoner Total",null,null,null,null,{"$f":"SUM(N10:P13)","v":1512}]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D15:F17)","v":2310},null,null,null,null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(N15:P17)","v":2310}]
[null,null,"Nivea",310,140,310,null,null,null,null,null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100,null,null,null,null,null,null,"WOW",280,380,100]
[null,"Face Wash Total",null,null,null,null,{"$f":"SUM(D14:F17)","v":2310},null,null,null,null,"Face Wash Total",null,null,null,null,{"$f":"SUM(N14:P17)","v":2310}]

{"sheet":"Pivot Table","index":5,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,14,1],[4,11,7,11],[8,11,11,11],[12,11,14,11],[1,1,1,6],[1,11,1,16],[4,6,7,6],[8,6,11,6],[12,6,14,6],[4,16,7,16],[8,16,11,16],[12,16,14,16],[4,1,7,1],[8,1,11,1]]}
[]
[null,"Use of Pivot Table",null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales",null,null,null,null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D5:F8)","v":1168},null,null,null,null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(N5:P8)","v":1168}]
[null,null,"Dove",100,50,80,null,null,null,null,null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78,null,null,null,null,null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190,null,null,null,null,null,null,"Head and Shoulders",90,124,190]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D9:F12)","v":1512},null,null,null,null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(N9:P12)","v":1512}]
[null,null,"Dove",200,114,88,null,null,null,null,null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75,null,null,null,null,null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69,null,null,null,null,null,null,"Head and Shoulders",99,94,69]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D13:F15)","v":2310},null,null,null,null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(N13:P15)","v":2310}]
[null,null,"Nivea",310,140,310,null,null,null,null,null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100,null,null,null,null,null,null,"WOW",280,380,100]

{"sheet":"PivotTable","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Total Sales","Column Labels"]
["Row Labels","Conditoner","Face Wash","Shampoo","(blank)","Grand Total"]
["Dove"]
["Head and Shoulders"]
["Himalaya",null,2310,null,null,2310]
["L'Oréal",1512,null,1168,null,2680]
["Nivea"]
["Pantene"]
["WOW"]
["Grand Total",1512,2310,1168,null,4990]

{"sheet":"VBA","index":7,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,14,1],[4,11,7,11],[8,11,11,11],[12,11,14,11],[1,1,1,6],[1,11,1,16],[4,6,7,6],[8,6,11,6],[12,6,14,6],[4,16,7,16],[8,16,11,16],[12,16,14,16],[4,1,7,1],[8,1,11,1]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales",null,null,null,null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D5:F8)","v":1168},null,null,null,null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(N5:P8)","v":1168}]
[null,null,"Dove",100,50,80,null,null,null,null,null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78,null,null,null,null,null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190,null,null,null,null,null,null,"Head and Shoulders",90,124,190]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D9:F12)","v":1512},null,null,null,null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(N9:P12)","v":1512}]
[null,null,"Dove",200,114,88,null,null,null,null,null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75,null,null,null,null,null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69,null,null,null,null,null,null,"Head and Shoulders",99,94,69]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D13:F15)","v":2310},null,null,null,null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(N13:P15)","v":2310}]
[null,null,"Nivea",310,140,310,null,null,null,null,null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100,null,null,null,null,null,null,"WOW",280,380,100]

{"sheet":"Collapse & Expand","index":8,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,1,17,1],[5,11,8,11],[10,11,13,11],[15,11,17,11],[1,1,1,6],[1,11,1,16],[5,6,8,6],[10,6,13,6],[15,6,17,6],[5,16,8,16],[10,16,13,16],[15,16,17,16],[5,1,8,1],[10,1,13,1]]}
[]
[null,"Collapse & Expand",null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales",null,null,null,null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Product Total",null,{"$f":"SUBTOTAL(9,D4:D4)","v":0},{"$f":"SUBTOTAL(9,E4:E4)","v":0},{"$f":"SUBTOTAL(9,F4:F4)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,Q4:Q4)","v":0}]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D6:F9)","v":1168},null,null,null,null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(N6:P9)","v":1168}]
[null,null,"Dove",100,50,80,null,null,null,null,null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78,null,null,null,null,null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190,null,null,null,null,null,null,"Head and Shoulders",90,124,190]
[null,"Shampoo Total",null,{"$f":"SUBTOTAL(9,D6:D9)","v":390},{"$f":"SUBTOTAL(9,E6:E9)","v":331},{"$f":"SUBTOTAL(9,F6:F9)","v":447},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,Q6:Q9)","v":1168}]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D11:F14)","v":1512},null,null,null,null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(N11:P14)","v":1512}]
[null,null,"Dove",200,114,88,null,null,null,null,null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75,null,null,null,null,null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69,null,null,null,null,null,null,"Head and Shoulders",99,94,69]
[null,"Conditoner Total",null,{"$f":"SUBTOTAL(9,D11:D14)","v":650},{"$f":"SUBTOTAL(9,E11:E14)","v":552},{"$f":"SUBTOTAL(9,F11:F14)","v":310},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,Q11:Q14)","v":1512}]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D16:F18)","v":2310},null,null,null,null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(N16:P18)","v":2310}]
[null,null,"Nivea",310,140,310,null,null,null,null,null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100,null,null,null,null,null,null,"WOW",280,380,100]
[null,"Face Wash Total",null,{"$f":"SUBTOTAL(9,D16:D18)","v":890},{"$f":"SUBTOTAL(9,E16:E18)","v":720},{"$f":"SUBTOTAL(9,F16:F18)","v":700},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,Q16:Q18)","v":2310}]
[null,"Grand Total",null,{"$f":"SUBTOTAL(9,D3:D18)","v":1930},{"$f":"SUBTOTAL(9,E3:E18)","v":1603},{"$f":"SUBTOTAL(9,F3:F18)","v":1457},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,Q3:Q18)","v":4990}]

{"sheet":"Ungroup","index":9,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,1,14,1],[4,11,7,11],[8,11,11,11],[12,11,14,11],[1,1,1,6],[1,11,1,16],[4,6,7,6],[8,6,11,6],[12,6,14,6],[4,16,7,16],[8,16,11,16],[12,16,14,16],[4,1,7,1],[8,1,11,1]]}
[]
[null,"Ungroup Cells",null,null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales",null,null,null,null,"Product","Brand","Sales in Jan","Sales in Feb","Sales in Mar","Total Sales"]
[null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(D5:F8)","v":1168},null,null,null,null,"Shampoo","L'Oréal",120,88,99,{"$f":"SUM(N5:P8)","v":1168}]
[null,null,"Dove",100,50,80,null,null,null,null,null,null,"Dove",100,50,80]
[null,null,"Pantene",80,69,78,null,null,null,null,null,null,"Pantene",80,69,78]
[null,null,"Head and Shoulders",90,124,190,null,null,null,null,null,null,"Head and Shoulders",90,124,190]
[null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(D9:F12)","v":1512},null,null,null,null,"Conditoner","L'Oréal",111,113,78,{"$f":"SUM(N9:P12)","v":1512}]
[null,null,"Dove",200,114,88,null,null,null,null,null,null,"Dove",200,114,88]
[null,null,"Pantene",240,231,75,null,null,null,null,null,null,"Pantene",240,231,75]
[null,null,"Head and Shoulders",99,94,69,null,null,null,null,null,null,"Head and Shoulders",99,94,69]
[null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(D13:F15)","v":2310},null,null,null,null,"Face Wash","Himalaya",300,200,290,{"$f":"SUM(N13:P15)","v":2310}]
[null,null,"Nivea",310,140,310,null,null,null,null,null,null,"Nivea",310,140,310]
[null,null,"WOW",280,380,100,null,null,null,null,null,null,"WOW",280,380,100]