{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Go To","Fill Feature","Keyboard Shortcut","Quick Access Toolbar","Formula","VBA","Formatting","Practice Section"],"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":"Dataset","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Delivery Status of Ordered Products in XYZ Tech Store"]
[]
[null,"Order ID","Product","Qty Ordered","Price Each","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",4,3.84,"Delivered"]
[null,248152,"USB-C Charging Cable",2,11.95,"In Transit"]
[null,248153,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248154,"27in FHD Monitor",1,149.99,"Delivered"]
[null,248155,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248156,"34in Ultrawide Monitor",1,379.99,"Delivered"]
[null,248157,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248158,"Lightning Charging Cable",1,14.95,"In Transit"]
[null,248159,"Vareebadd Phone",1,400,"Pending"]
[null,248160,"Wired Headphones",1,11.99,"Delivered"]
[null,248161,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",3,2.99,"In Transit"]
[null,248163,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248164,"27in FHD Monitor",1,149.99,"In Transit"]

{"sheet":"Go To","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Go To Command"]
[]
[null,"Order ID","Product","Qty Ordered","Price Each","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",4,3.84,"Delivered"]
[null,248152,"USB-C Charging Cable",2,11.95,"Delivered"]
[null,248153,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248154,"27in FHD Monitor",1,149.99,"Delivered"]
[null,248155,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248156,"34in Ultrawide Monitor",1,379.99,"Delivered"]
[null,248157,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248158,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248159,"Vareebadd Phone",1,400,"Pending"]
[null,248160,"Wired Headphones",1,11.99,"Delivered"]
[null,248161,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",3,2.99,"Delivered"]
[null,248163,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248164,"27in FHD Monitor",1,149.99,"Delivered"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]

{"sheet":"Fill Feature","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Excel Fill Feature"]
[]
[null,"Order ID","Product","Shipment","Qty Ordered","Delivery Status"]
[null,248151,"AA Batteries (4-pack)","Delivered",4,"Delivered"]
[null,248152,"USB-C Charging Cable",null,2,"In Transit"]
[null,248153,"USB-C Charging Cable","Delivered",1,"Delivered"]
[null,248154,"27in FHD Monitor","Delivered",1,"Delivered"]
[null,248155,"USB-C Charging Cable",null,1,"Pending"]
[null,248156,"34in Ultrawide Monitor","Delivered",1,"Delivered"]
[null,248157,"Lightning Charging Cable","Delivered",1,"Delivered"]
[null,248158,"Lightning Charging Cable",null,1,"In Transit"]
[null,248159,"Vareebadd Phone",null,1,"Pending"]
[null,248160,"Wired Headphones","Delivered",1,"Delivered"]
[null,248161,"USB-C Charging Cable","Delivered",1,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",null,3,"In Transit"]
[null,248163,"USB-C Charging Cable",null,1,"Pending"]
[null,248164,"27in FHD Monitor",null,1,"In Transit"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]

{"sheet":"Keyboard Shortcut","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying Keyboard Shortcut"]
[]
[null,"Order ID","Product","Qty Ordered","Price Each","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",4,3.84,"Delivered"]
[null,248152,"USB-C Charging Cable",2,11.95,"Delivered"]
[null,248153,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248154,"27in FHD Monitor",1,149.99,"Delivered"]
[null,248155,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248156,"34in Ultrawide Monitor",1,379.99,"Delivered"]
[null,248157,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248158,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248159,"Vareebadd Phone",1,400,"Pending"]
[null,248160,"Wired Headphones",1,11.99,"Delivered"]
[null,248161,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",3,2.99,"Delivered"]
[null,248163,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248164,"27in FHD Monitor",1,149.99,"Delivered"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]

{"sheet":"Quick Access Toolbar","index":4,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Quick Access Toolbar"]
[]
[null,"Order ID","Product","Qty Ordered","Price Each","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",4,3.84,"Delivered"]
[null,248152,"USB-C Charging Cable",2,11.95,"Delivered"]
[null,248153,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248154,"27in FHD Monitor",1,149.99,"Delivered"]
[null,248155,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248156,"34in Ultrawide Monitor",1,379.99,"Delivered"]
[null,248157,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248158,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248159,"Vareebadd Phone",1,400,"Pending"]
[null,248160,"Wired Headphones",1,11.99,"Delivered"]
[null,248161,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",3,2.99,"Delivered"]
[null,248163,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248164,"27in FHD Monitor",1,149.99,"Delivered"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]

{"sheet":"Formula","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Simple Formula"]
[]
[null,"Order ID","Product","Shipment","Qty Ordered","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Delivered"},4,"Delivered"]
[null,248152,"USB-C Charging Cable",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"In Transit"},2,"In Transit"]
[null,248153,"USB-C Charging Cable",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248154,"27in FHD Monitor",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248155,"USB-C Charging Cable",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Pending"},1,"Pending"]
[null,248156,"34in Ultrawide Monitor",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248157,"Lightning Charging Cable",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248158,"Lightning Charging Cable",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"In Transit"},1,"In Transit"]
[null,248159,"Vareebadd Phone",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Pending"},1,"Pending"]
[null,248160,"Wired Headphones",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248161,"USB-C Charging Cable",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"In Transit"},3,"In Transit"]
[null,248163,"USB-C Charging Cable",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"Pending"},1,"Pending"]
[null,248164,"27in FHD Monitor",{"$f":"Table13568[[#This Row],[Delivery Status]]","v":"In Transit"},1,"In Transit"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]

{"sheet":"VBA","index":6,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Pasting into Visible Cells with Excel VBA"]
[]
[null,"Order ID","Product","Shipment","Qty Ordered","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",null,4,"Delivered"]
[null,248152,"USB-C Charging Cable","In Transit",2,"In Transit"]
[null,248153,"USB-C Charging Cable",null,1,"Delivered"]
[null,248154,"27in FHD Monitor",null,1,"Delivered"]
[null,248155,"USB-C Charging Cable",null,1,"Pending"]
[null,248156,"34in Ultrawide Monitor",null,1,"Delivered"]
[null,248157,"Lightning Charging Cable",null,1,"Delivered"]
[null,248158,"Lightning Charging Cable","In Transit",1,"In Transit"]
[null,248159,"Vareebadd Phone",null,1,"Pending"]
[null,248160,"Wired Headphones",null,1,"Delivered"]
[null,248161,"USB-C Charging Cable",null,1,"Delivered"]
[null,248162,"AAA Batteries (4-pack)","In Transit",3,"In Transit"]
[null,248163,"USB-C Charging Cable",null,1,"Pending"]
[null,248164,"27in FHD Monitor","In Transit",1,"In Transit"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]

{"sheet":"Formatting","index":7,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Pasting Formatting into Visible Cells Only"]
[]
[null,"Order ID","Product","Shipment","Qty Ordered","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Delivered"},4,"Delivered"]
[null,248152,"USB-C Charging Cable",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"In Transit"},null,"In Transit"]
[null,248153,"USB-C Charging Cable",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248154,"27in FHD Monitor",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248155,"USB-C Charging Cable",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Pending"},1,"Pending"]
[null,248156,"34in Ultrawide Monitor",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248157,"Lightning Charging Cable",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248158,"Lightning Charging Cable",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"In Transit"},null,"In Transit"]
[null,248159,"Vareebadd Phone",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Pending"},1,"Pending"]
[null,248160,"Wired Headphones",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248161,"USB-C Charging Cable",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Delivered"},1,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"In Transit"},null,"In Transit"]
[null,248163,"USB-C Charging Cable",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"Pending"},1,"Pending"]
[null,248164,"27in FHD Monitor",{"$f":"Table135684[[#This Row],[Delivery Status]]","v":"In Transit"},null,"In Transit"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]

{"sheet":"Practice Section","index":8,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Practice Section"]
[]
[null,"Order ID","Product","Qty Ordered","Price Each","Delivery Status"]
[null,248151,"AA Batteries (4-pack)",4,3.84,"Delivered"]
[null,248152,"USB-C Charging Cable",2,11.95,"In Transit"]
[null,248153,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248154,"27in FHD Monitor",1,149.99,"Delivered"]
[null,248155,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248156,"34in Ultrawide Monitor",1,379.99,"Delivered"]
[null,248157,"Lightning Charging Cable",1,14.95,"Delivered"]
[null,248158,"Lightning Charging Cable",1,14.95,"In Transit"]
[null,248159,"Vareebadd Phone",1,400,"Pending"]
[null,248160,"Wired Headphones",1,11.99,"Delivered"]
[null,248161,"USB-C Charging Cable",1,11.95,"Delivered"]
[null,248162,"AAA Batteries (4-pack)",3,2.99,"In Transit"]
[null,248163,"USB-C Charging Cable",1,11.95,"Pending"]
[null,248164,"27in FHD Monitor",1,149.99,"In Transit"]
[]
[null,"Delivery Status"]
[null,"Pending"]
[null,"In Transit"]
[null,"Delivered"]