{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Datasheet","Double click","CTRL+ENTER","Shortcut key","Name Box","Fill","Format as Table","Table","Power Query","Table4","Dynamic array","VBA","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Datasheet","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"\"X\" Company"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price"]
[null,"Orange","Michael",2721,1386]
[null,"Apple","Howard",2172,1461]
[null,"Watermelon","Jefferson",2958,1779]
[null,"Walnut","Lara",3405,1459]
[null,"Jackfruit","Katherine",2154,1116]
[null,"Banana","Peter",2580,1733]
[null,"Cherry","Smith",4316,1160]
[null,"Blackberry","Sheldon",4815,1711]
[null,"Tomato","John",4792,1314]
[null,"Strawberry","Jacob",3914,1826]
[null,"Raspberry","Emily",4980,1365]

{"sheet":"Double click","index":1,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Double Click"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"D4-E4","v":1335}]
[null,"Apple","Howard",2172,1461,{"$f":"D5-E5","v":711}]
[null,"Watermelon","Jefferson",2958,1779,1179]
[null,"Walnut","Lara",3405,1459,1946]
[null,"Jackfruit","Katherine",2154,1116,1038]
[null,"Banana","Peter",2580,1733,847]
[null,"Cherry","Smith",4316,1160,3156]
[null,"Blackberry","Sheldon",4815,1711,3104]
[null,"Tomato","John",4792,1314,3478]
[null,"Strawberry","Jacob",3914,1826,2088]
[null,"Raspberry","Emily",4980,1365,3615]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"CTRL+ENTER","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Entering Formula for all cells at a time"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"D4-E4","v":1335}]
[null,"Apple","Howard",2172,1461,711]
[null,"Watermelon","Jefferson",2958,1779,1179]
[null,"Walnut","Lara",3405,1459,1946]
[null,"Jackfruit","Katherine",2154,1116,1038]
[null,"Banana","Peter",2580,1733,847]
[null,"Cherry","Smith",4316,1160,3156]
[null,"Blackberry","Sheldon",4815,1711,3104]
[null,"Tomato","John",4792,1314,3478]
[null,"Strawberry","Jacob",3914,1826,2088]
[null,"Raspberry","Emily",4980,1365,3615]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Shortcut key","index":3,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Shortcut key"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"D4-E4","v":1335}]
[null,"Apple","Howard",2172,1461,{"$f":"D5-E5","v":711}]
[null,"Watermelon","Jefferson",2958,1779,1179]
[null,"Walnut","Lara",3405,1459,1946]
[null,"Jackfruit","Katherine",2154,1116,1038]
[null,"Banana","Peter",2580,1733,847]
[null,"Cherry","Smith",4316,1160,3156]
[null,"Blackberry","Sheldon",4815,1711,3104]
[null,"Tomato","John",4792,1314,3478]
[null,"Strawberry","Jacob",3914,1826,2088]
[null,"Raspberry","Emily",4980,1365,3615]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Name Box","index":4,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Name Box"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"D4-E4","v":1335}]
[null,"Apple","Howard",2172,1461,{"$f":"D5-E5","v":711}]
[null,"Watermelon","Jefferson",2958,1779,1179]
[null,"Walnut","Lara",3405,1459,1946]
[null,"Jackfruit","Katherine",2154,1116,1038]
[null,"Banana","Peter",2580,1733,847]
[null,"Cherry","Smith",4316,1160,3156]
[null,"Blackberry","Sheldon",4815,1711,3104]
[null,"Tomato","John",4792,1314,3478]
[null,"Strawberry","Jacob",3914,1826,2088]
[null,"Raspberry","Emily",4980,1365,3615]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Fill","index":5,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Fill Option"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"D4-E4","v":1335}]
[null,"Apple","Howard",2172,1461,{"$f":"D5-E5","v":711}]
[null,"Watermelon","Jefferson",2958,1779,1179]
[null,"Walnut","Lara",3405,1459,1946]
[null,"Jackfruit","Katherine",2154,1116,1038]
[null,"Banana","Peter",2580,1733,847]
[null,"Cherry","Smith",4316,1160,3156]
[null,"Blackberry","Sheldon",4815,1711,3104]
[null,"Tomato","John",4792,1314,3478]
[null,"Strawberry","Jacob",3914,1826,2088]
[null,"Raspberry","Emily",4980,1365,3615]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Format as Table","index":6,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Format as Table Option"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":1335}]
[null,"Apple","Howard",2172,1461,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":711}]
[null,"Watermelon","Jefferson",2958,1779,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":1179}]
[null,"Walnut","Lara",3405,1459,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":1946}]
[null,"Jackfruit","Katherine",2154,1116,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":1038}]
[null,"Banana","Peter",2580,1733,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":847}]
[null,"Cherry","Smith",4316,1160,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":3156}]
[null,"Blackberry","Sheldon",4815,1711,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":3104}]
[null,"Tomato","John",4792,1314,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":3478}]
[null,"Strawberry","Jacob",3914,1826,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":2088}]
[null,"Raspberry","Emily",4980,1365,{"$f":"Table1[[#This Row],[Selling Price]]-Table1[[#This Row],[Cost Price]]","v":3615}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Table","index":7,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Table Option"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":1335}]
[null,"Apple","Howard",2172,1461,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":711}]
[null,"Watermelon","Jefferson",2958,1779,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":1179}]
[null,"Walnut","Lara",3405,1459,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":1946}]
[null,"Jackfruit","Katherine",2154,1116,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":1038}]
[null,"Banana","Peter",2580,1733,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":847}]
[null,"Cherry","Smith",4316,1160,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":3156}]
[null,"Blackberry","Sheldon",4815,1711,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":3104}]
[null,"Tomato","John",4792,1314,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":3478}]
[null,"Strawberry","Jacob",3914,1826,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":2088}]
[null,"Raspberry","Emily",4980,1365,{"$f":"Table3[[#This Row],[Selling Price]]-Table3[[#This Row],[Cost Price]]","v":3615}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Power Query","index":8,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Power Query"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price"]
[null,"Orange","Michael",2721,1386]
[null,"Apple","Howard",2172,1461]
[null,"Watermelon","Jefferson",2958,1779]
[null,"Walnut","Lara",3405,1459]
[null,"Jackfruit","Katherine",2154,1116]
[null,"Banana","Peter",2580,1733]
[null,"Cherry","Smith",4316,1160]
[null,"Blackberry","Sheldon",4815,1711]
[null,"Tomato","John",4792,1314]
[null,"Strawberry","Jacob",3914,1826]
[null,"Raspberry","Emily",4980,1365]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Table4","index":9,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Product","SalesPerson","Selling Price","Cost Price","Profit"]
["Orange","Michael",2721,1386,1335]
["Apple","Howard",2172,1461,711]
["Watermelon","Jefferson",2958,1779,1179]
["Walnut","Lara",3405,1459,1946]
["Jackfruit","Katherine",2154,1116,1038]
["Banana","Peter",2580,1733,847]
["Cherry","Smith",4316,1160,3156]
["Blackberry","Sheldon",4815,1711,3104]
["Tomato","John",4792,1314,3478]
["Strawberry","Jacob",3914,1826,2088]
["Raspberry","Emily",4980,1365,3615]

{"sheet":"Dynamic array","index":10,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using Dynamic Array"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,{"$f":"(D4:D14)-(E4:E14)","v":1335}]
[null,"Apple","Howard",2172,1461,711]
[null,"Watermelon","Jefferson",2958,1779,1179]
[null,"Walnut","Lara",3405,1459,1946]
[null,"Jackfruit","Katherine",2154,1116,1038]
[null,"Banana","Peter",2580,1733,847]
[null,"Cherry","Smith",4316,1160,3156]
[null,"Blackberry","Sheldon",4815,1711,3104]
[null,"Tomato","John",4792,1314,3478]
[null,"Strawberry","Jacob",3914,1826,2088]
[null,"Raspberry","Emily",4980,1365,3615]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":11,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"Using VBA Code"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price","Profit"]
[null,"Orange","Michael",2721,1386,1335]
[null,"Apple","Howard",2172,1461,711]
[null,"Watermelon","Jefferson",2958,1779,1179]
[null,"Walnut","Lara",3405,1459,1946]
[null,"Jackfruit","Katherine",2154,1116,1038]
[null,"Banana","Peter",2580,1733,847]
[null,"Cherry","Smith",4316,1160,3156]
[null,"Blackberry","Sheldon",4815,1711,3104]
[null,"Tomato","John",4792,1314,3478]
[null,"Strawberry","Jacob",3914,1826,2088]
[null,"Raspberry","Emily",4980,1365,3615]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Practice","index":12,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Practice"]
[]
[null,"Product","SalesPerson","Selling Price","Cost Price"]
[null,"Orange","Michael",2721,1386]
[null,"Apple","Howard",2172,1461]
[null,"Watermelon","Jefferson",2958,1779]
[null,"Walnut","Lara",3405,1459]
[null,"Jackfruit","Katherine",2154,1116]
[null,"Banana","Peter",2580,1733]
[null,"Cherry","Smith",4316,1160]
[null,"Blackberry","Sheldon",4815,1711]
[null,"Tomato","John",4792,1314]
[null,"Strawberry","Jacob",3914,1826]
[null,"Raspberry","Emily",4980,1365]