{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home tab","protect sheet","Format Cells","Go To special","VBA","protect workbook"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Home tab","index":0,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,6,1],[7,1,9,1],[10,1,11,1],[12,1,12,2],[1,8,1,11],[4,8,6,8],[7,8,9,8],[10,8,11,8],[12,8,12,9]]}
[]
[null,"Using Home Tab",null,null,null,null,null,null,"For Practice"]
[]
[null,"Items","Brand","Sales in 2021","Sales in 2022",null,null,null,"Items","Brand","Sales in 2021","Sales in 2022"]
[null,"Shampoo","L'Oréal",123,88,null,null,null,"Shampoo","L'Oréal",120,88]
[null,null,"Dove",100,50,null,null,null,null,"Dove",100,50]
[null,null,"Pantene",80,69,null,null,null,null,"Pantene",80,69]
[null,"Conditoner","L'Oréal",112,113,null,null,null,"Conditoner","L'Oréal",111,113]
[null,null,"Dove",200,114,null,null,null,null,"Dove",200,114]
[null,null,"Pantene",240,231,null,null,null,null,"Pantene",240,231]
[null,"Face Wash","Himalaya",300,200,null,null,null,"Face Wash","Himalaya",300,200]
[null,null,"Nivea",310,140,null,null,null,null,"Nivea",310,140]
[null,"Total Sales",null,{"$f":"SUM(D5:D12)","v":1465},{"$f":"SUM(E5:E12)","v":1005},null,null,null,"Total Sales",null,{"$f":"SUM(K5:K12)","v":1461},{"$f":"SUM(L5:L12)","v":1005}]

{"sheet":"protect sheet","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,11,1],[12,1,12,2],[1,1,1,4],[4,1,6,1],[7,1,9,1]]}
[]
[null,"Protect Sheet"]
[]
[null,"Items","Brand","Sales in 2021","Sales in 2022"]
[null,"Shampoo","L'Oréal",123,88]
[null,null,"Dove",100,50]
[null,null,"Pantene",80,69]
[null,"Conditoner","L'Oréal",112,113]
[null,null,"Dove",200,114]
[null,null,"Pantene",240,231]
[null,"Face Wash","Himalaya",300,200]
[null,null,"Nivea",310,140]
[null,"Total Sales",null,{"$f":"SUM(D5:D12)","v":1465},{"$f":"SUM(E5:E12)","v":1005}]

{"sheet":"Format Cells","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,8,11,8],[12,1,12,2],[12,8,12,9],[1,1,1,4],[1,8,1,11],[4,1,6,1],[4,8,6,8],[7,1,9,1],[7,8,9,8]]}
[]
[null,"Using Format Cells Feature",null,null,null,null,null,null,"For Practice"]
[]
[null,"Items","Brand","Sales in 2021","Sales in 2022",null,null,null,"Items","Brand","Sales in 2021","Sales in 2022"]
[null,"Shampoo","L'Oréal",120,88,null,null,null,"Shampoo","L'Oréal",120,88]
[null,null,"Dove",100,50,null,null,null,null,"Dove",100,50]
[null,null,"Pantene",80,69,null,null,null,null,"Pantene",80,69]
[null,"Conditoner","L'Oréal",111,113,null,null,null,"Conditoner","L'Oréal",111,113]
[null,null,"Dove",200,114,null,null,null,null,"Dove",200,114]
[null,null,"Pantene",240,231,null,null,null,null,"Pantene",240,231]
[null,"Face Wash","Himalaya",300,200,null,null,null,"Face Wash","Himalaya",300,200]
[null,null,"Nivea",310,140,null,null,null,null,"Nivea",310,140]
[null,"Total Sales",null,{"$f":"SUM(D5:D12)","v":1461},{"$f":"SUM(E5:E12)","v":1005},null,null,null,"Total Sales",null,{"$f":"SUM(K5:K12)","v":1461},{"$f":"SUM(L5:L12)","v":1005}]

{"sheet":"Go To special","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,8,11,8],[12,1,12,2],[12,8,12,9],[1,1,1,4],[1,8,1,11],[4,1,6,1],[4,8,6,8],[7,1,9,1],[7,8,9,8]]}
[]
[null,"Using Go To Special Command",null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in 2021","Sales in 2022",null,null,null,"Product","Brand","Sales in Jan","Sales in Feb"]
[null,"Shampoo","L'Oréal",120,88,null,null,null,"Shampoo","L'Oréal",120,88]
[null,null,"Dove",100,50,null,null,null,null,"Dove",100,50]
[null,null,"Pantene",80,69,null,null,null,null,"Pantene",80,69]
[null,"Conditoner","L'Oréal",111,67,null,null,null,"Conditoner","L'Oréal",111,113]
[null,null,"Dove",200,114,null,null,null,null,"Dove",200,114]
[null,null,"Pantene",240,231,null,null,null,null,"Pantene",240,231]
[null,"Face Wash","Himalaya",300,200,null,null,null,"Face Wash","Himalaya",300,200]
[null,null,"Nivea",310,140,null,null,null,null,"Nivea",310,140]
[null,"Total Sales",null,{"$f":"SUM(D5:D12)","v":1461},{"$f":"SUM(E5:E12)","v":959},null,null,null,"Total Sales",null,{"$f":"SUM(K5:K12)","v":1461},{"$f":"SUM(L5:L12)","v":1005}]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,8,11,8],[12,1,12,2],[12,8,12,9],[1,1,1,4],[1,8,1,11],[4,1,6,1],[4,8,6,8],[7,1,9,1],[7,8,9,8]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,"For Practice"]
[]
[null,"Product","Brand","Sales in 2021","Sales in 2022",null,null,null,"Product","Brand","Sales in Jan","Sales in Feb"]
[null,"Shampoo","L'Oréal",120,88,null,null,null,"Shampoo","L'Oréal",120,88]
[null,null,"Dove",100,50,null,null,null,null,"Dove",100,50]
[null,null,"Pantene",80,69,null,null,null,null,"Pantene",80,69]
[null,"Conditoner","L'Oréal",111,113,null,null,null,"Conditoner","L'Oréal",111,113]
[null,null,"Dove",200,114,null,null,null,null,"Dove",200,114]
[null,null,"Pantene",240,231,null,null,null,null,"Pantene",240,231]
[null,"Face Wash","Himalaya",300,200,null,null,null,"Face Wash","Himalaya",300,200]
[null,null,"Nivea",310,140,null,null,null,null,"Nivea",310,140]
[null,"Total Sales",null,{"$f":"SUM(D5:D12)","v":1461},{"$f":"SUM(E5:E12)","v":1005},null,null,null,"Total Sales",null,{"$f":"SUM(K5:K12)","v":1461},{"$f":"SUM(L5:L12)","v":1005}]

{"sheet":"protect workbook","index":5,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[4,1,6,1],[7,1,9,1],[10,1,11,1],[12,1,12,2]]}
[]
[null,"Protect Workbook"]
[]
[null,"Items","Brand","Sales in 2021","Sales in 2022"]
[null,"Shampoo","L'Oréal",123,88]
[null,null,"Dove",100,50]
[null,null,"Pantene",80,69]
[null,"Conditoner","L'Oréal",112,113]
[null,null,"Dove",200,114]
[null,null,"Pantene",240,231]
[null,"Face Wash","Himalaya",300,200]
[null,null,"Nivea",310,140]
[null,"Total Sales",null,{"$f":"SUM(D5:D12)","v":1465},{"$f":"SUM(E5:E12)","v":1005}]