{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Keyboard Shortcut","Go To Special","QAT","Filter Feature","VBA","Enter Formula in Visible Cells","Enter Formula for Filtered Cell"],"not_rendered":{"charts":0,"images":0,"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":"Dataset","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Report of ABC Technology"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","Amazon Fire HD 8",6,250,{"$f":"D6*E6","v":1500}]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP05","Sony WH-1000XM4",3,300,900]
[null,"TP06","Xiaomi Mi Smart Band 6",4,150,600]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP08","MacBook Pro M1",8,1600,12800]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]

{"sheet":"Keyboard Shortcut","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5]]}
[]
[null,"Using Keyboard Shortcut"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","Amazon Fire HD 8",6,250,{"$f":"D6*E6","v":1500}]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP05","Sony WH-1000XM4",3,300,900]
[null,"TP06","Xiaomi Mi Smart Band 6",4,150,600]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP08","MacBook Pro M1",8,1600,12800]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]
[]
[null,"Pasting Selected Visible Cells"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,2000]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]

{"sheet":"Go To Special","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5]]}
[]
[null,"Using Go To Special Feature"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","Amazon Fire HD 8",6,250,{"$f":"D6*E6","v":1500}]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP05","Sony WH-1000XM4",3,300,900]
[null,"TP06","Xiaomi Mi Smart Band 6",4,150,600]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP08","MacBook Pro M1",8,1600,12800]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]
[]
[null,"Pasting Selected Visible Cells"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,2000]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]

{"sheet":"QAT","index":3,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5]]}
[]
[null,"Utilizing Command from Quick Access Toolbar"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","Amazon Fire HD 8",6,250,{"$f":"D6*E6","v":1500}]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP05","Sony WH-1000XM4",3,300,900]
[null,"TP06","Xiaomi Mi Smart Band 6",4,150,600]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP08","MacBook Pro M1",8,1600,12800]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]
[]
[null,"Pasting Selected Visible Cells"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,2000]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]

{"sheet":"Filter Feature","index":4,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5]]}
[]
[null,"Using Filter Feature to Select Visible Cells"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","Amazon Fire HD 8",6,250,{"$f":"D6*E6","v":1500}]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP05","Sony WH-1000XM4",3,300,900]
[null,"TP06","Xiaomi Mi Smart Band 6",4,150,600]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP08","MacBook Pro M1",8,1600,12800]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]
[]
[null,"Pasting Selected Visible Cells"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP02","Amazon Fire HD 8",6,250,1500]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP05","Sony WH-1000XM4",3,300,900]
[null,"TP06","Xiaomi Mi Smart Band 6",4,150,600]
[null,"TP10","Jabra Elite 75t",6,155,930]

{"sheet":"VBA","index":5,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5]]}
[]
[null,"Applying VBA Code to Select Visible Cells"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","Amazon Fire HD 8",6,250,{"$f":"D6*E6","v":1500}]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP05","Sony WH-1000XM4",3,300,900]
[null,"TP06","Xiaomi Mi Smart Band 6",4,150,600]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP08","MacBook Pro M1",8,1600,12800]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]
[]
[null,"Pasting Selected Visible Cells"]
[]
[null,"Product ID","Product Name","Quantity","Unit Price","Sales"]
[null,"TP01","iPhone 13 Pro",2,1000,2000]
[null,"TP03","Dell Inspiron 15",7,350,2450]
[null,"TP04","Fitbit Inspire 2",9,100,900]
[null,"TP07","ASUS ROG Strix G15",5,1070,5350]
[null,"TP09","Google Nest Audio",2,255,510]
[null,"TP10","Jabra Elite 75t",6,155,930]

{"sheet":"Enter Formula in Visible Cells","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Selecting Visible Cells to Enter Formula"]
[]
[null,"Product ID","States","Quantity","Unit Price","Sales"]
[null,"TP01","New Jersey",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","New Mexico",6,250]
[null,"TP03","Montana",7,350,{"$f":"D7*E7","v":2450}]
[null,"TP04","New York",9,100,900]
[null,"TP05","Missouri",3,300]
[null,"TP06","New Jersey",4,150]
[null,"TP07","Montana",5,1070,{"$f":"D11*E11","v":5350}]
[null,"TP08","California",8,1600]
[null,"TP09","California",2,255,{"$f":"D13*E13","v":510}]
[null,"TP10","Missouri",6,155,930]

{"sheet":"Enter Formula for Filtered Cell","index":7,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,2]]}
[]
[null,"Selecting Only Filtered Cells to Enter Formula"]
[]
[null,"Product ID","States","Quantity","Unit Price","Sales"]
[null,"TP01","New Jersey",2,1000,{"$f":"D5*E5","v":2000}]
[null,"TP02","New Mexico",6,250,{"$f":"D6*E6","v":1500}]
[null,"TP03","Montana",7,350,{"$f":"D7*E7","v":2450}]
[null,"TP04","New York",9,100,900]
[null,"TP05","Missouri",3,300,900]
[null,"TP06","New Jersey",4,150,600]
[null,"TP07","Montana",5,1070,{"$f":"D11*E11","v":5350}]
[null,"TP08","California",8,1600,{"$f":"D12*E12","v":12800}]
[null,"TP09","California",2,255,{"$f":"D13*E13","v":510}]
[null,"TP10","Missouri",6,155,930]
[]
[null,"Average Sales",null,{"$f":"_xlfn.AGGREGATE(1,5,F5:F14)","v":3913.3333333333335}]