{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["P4C4-Answer_Key","P4C4-Answer_Key_Detail"],"not_rendered":{"charts":0,"images":3,"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":"P4C4-Answer_Key","index":0,"n_rows":268,"n_cols":6,"rows_kept":268,"cut":false,"hidden":false,"merged":[]}
["Sub_Region_Cod"," Country_Cod","Company","Period","Product_Ref","Sales"]
["EEU","CZE ","Zarigual","M5-2021","P01971",693.21]
["EEU","RUS ","Zarigual","M5-2021","P19157",5818.94]
["EEU","MDA ","Zarigual","M5-2021","P48998",1837.35]
["EEU","BGR ","Zarigual","M5-2021","P11497",8036.64]
["EEU"," MDA","Zarigual","M5-2021","P18685",3384.41]
["EEU","CZE ","Zarigual","M5-2021","P49444",3700.64]
["EEU"," UKR","Zarigual","M5-2021","P12683",6040.44]
["EEU","BGR ","Zarigual","M5-2021","P16494",1993.69]
["EEU","HUN ","Zarigual","M5-2021","P34221",305.47000000000003]
["EEU"," SVK","Zarigual","M5-2021","P01596",912.44]
["EEU","CZE ","Zarigual","M5-2021","P19008",4690.8999999999996]
["EEU","SVK ","Zarigual","M5-2021","P36531",5110.91]
["EEU","RUS ","Zarigual","M5-2021","P05232",4146.4399999999996]
["EEU"," ARM","Zarigual","M5-2021","P02043",5844.48]
["EEU","ROM ","Zarigual","M5-2021","P19289",5715.65]
["EEU"," CZE","Zarigual","M5-2021","P28325",7608.55]
["EEU"," ARM","Zarigual","M5-2021","P44966",3112.98]
["EEU","UKR ","Zarigual","M5-2021","P01132",4849.6899999999996]
["EEU"," ROM","Zarigual","M5-2021","P26267",6764.93]
["EEU","BLR ","Zarigual","M5-2021","P27840",1392.5]
["EEU"," BLR","Zarigual","M5-2021","P12467",9526.74]
["EEU"," BGR","Zarigual","M5-2021","P12057",7379.21]
["EEU","POL ","Zarigual","M5-2021","P23691",2397.4699999999998]
["EEU","RUS ","Zarigual","M5-2021","P00565",6944.71]
["EEU"," POL","Zarigual","M5-2021","P21339",4441.6499999999996]
["EEU","RUS ","Zarigual","M5-2021","P02266",4035.67]
["EEU","BLR ","Zarigual","M5-2021","P07850",4689.9799999999996]
["EEU"," SVK","Zarigual","M5-2021","P20074",4826.78]
["EEU","UKR ","Zarigual","M5-2021","P36337",3074.48]
["EEU","SVK ","Zarigual","M5-2021","P27142",9299.6]
["EEU","RUS ","Zarigual","M5-2021","P12106",4316.46]
["EEU","RUS ","Zarigual","M5-2021","P44966",1460.64]
["EEU"," ROM","Zarigual","M5-2021","P36154",6444.71]
["EEU"," SVK","Zarigual","M5-2021","P03666",9650.85]
["EEU"," BLR","Zarigual","M5-2021","P06469",5080.9799999999996]
["EEU"," HUN","Zarigual","M5-2021","P39042",3115.4]
["EEU"," POL","Zarigual","M5-2021","P19502",4729.3]
["EEU"," UKR","Zarigual","M5-2021","P36740",5267.93]
["EEU"," BLR","Zarigual","M5-2021","P37465",9167.58]
["EEU"," HUN","Zarigual","M5-2021","P10110",3702.13]
["EEU"," RUS","Zarigual","M5-2021","P29397",1097.8900000000001]
["EEU"," MDA","Zarigual","M5-2021","P29520",3859.82]
["EEU","MDA ","Zarigual","M5-2021","P09735",8519.36]
["EEU","SVK ","Zarigual","M5-2021","P46891",2716.94]
["EEU","BLR ","Zarigual","M5-2021","P12057",1612.25]
["EEU"," HUN","Zarigual","M5-2021","P26058",6726.71]
["EEU"," BGR","Zarigual","M5-2021","P09915",6267.38]
["EEU"," BLR","Zarigual","M5-2021","P40151",1903.62]
["EEU","POL ","Zarigual","M5-2021","P09735",4786.3900000000003]
["EEU"," ROM","Zarigual","M5-2021","P10332",3404.89]
["EEU"," BGR","Zarigual","M5-2021","P10718",2351.4]
["EEU","BLR ","Zarigual","M5-2021","P47427",6736.85]
["EEU"," SVK","Zarigual","M5-2021","P29939",5754.89]
["EEU"," RUS","Zarigual","M5-2021","P22166",9760.2000000000007]
["EEU"," RUS","Zarigual","M5-2021","P14013",2953.98]
["EEU"," UKR","Zarigual","M5-2021","P49448",2959.71]
["EEU"," SVK","Zarigual","M5-2021","P49225",617.62]
["EEU","CZE ","Zarigual","M5-2021","P45132",2929.86]
["EEU"," SVK","Zarigual","M5-2021","P07235",6962.45]
["EEU","BGR ","Zarigual","M5-2021","P26375",3934.55]
["EEU","BLR ","Zarigual","M5-2021","P33060",1748.6]
["EEU"," MDA","Zarigual","M5-2021","P21413",6061.51]
["EEU","BGR ","Zarigual","M5-2021","P45033",7952.86]
["EEU","RUS ","Zarigual","M5-2021","P18732",1097.25]
["EEU"," POL","Zarigual","M5-2021","P13351",5342.85]
["EEU","ROM ","Zarigual","M5-2021","P39042",3129.53]
["EEU"," BLR","Zarigual","M5-2021","P45754",3662.14]
["EEU","ARM ","Zarigual","M5-2021","P48998",3825.49]
["EEU","POL ","Zarigual","M5-2021","P28875",4297.12]
["EEU","HUN ","Zarigual","M5-2021","P38474",2087.14]
["EEU"," ARM","Zarigual","M5-2021","P43782",1570.94]
["EEU","BGR ","Zarigual","M5-2021","P25934",5019.93]
["EEU"," HUN","Zarigual","M5-2021","P01724",8148.27]
["EEU"," ROM","Zarigual","M5-2021","P26727",1833.69]
["EEU"," BGR","Zarigual","M5-2021","P13677",1971.52]
["EEU"," UKR","Zarigual","M5-2021","P31105",4700.72]
["EEU"," ARM","Zarigual","M5-2021","P04202",8547.7900000000009]
["EEU","ARM ","Zarigual","M5-2021","P35466",5792.66]
["EEU","UKR ","Zarigual","M5-2021","P40732",2117.7399999999998]
["EEU"," HUN","Zarigual","M5-2021","P40581",4945.6899999999996]
["EEU"," ROM","Zarigual","M5-2021","P25186",7291.66]
["EEU","HUN ","Zarigual","M5-2021","P04306",1940.2]
["EEU","POL ","Zarigual","M5-2021","P38474",8133.43]
["EEU","ARM ","Zarigual","M5-2021","P18784",2734.46]
["EEU"," BGR","Zarigual","M5-2021","P42296",8454.66]
["EEU","MDA ","Zarigual","M5-2021","P36154",2676.9]
["EEU"," ARM","Zarigual","M5-2021","P31053",8791.42]
["EEU","CZE ","Zarigual","M5-2021","P48978",7721.37]
["EEU","BGR ","Zarigual","M5-2021","P02043",5224.3999999999996]
["EEU","POL ","Zarigual","M5-2021","P49276",545.9]
["EEU"," ARM","Zarigual","M5-2021","P30848",8636.67]
["EEU","HUN ","Zarigual","M5-2021","P14013",16.52]
["EEU"," MDA","Zarigual","M5-2021","P16713",2491.89]
["EEU","RUS ","Zarigual","M5-2021","P45168",1586.55]
["EEU"," HUN","Zarigual","M5-2021","P20274",9509.8700000000008]
["EEU"," UKR","Zarigual","M5-2021","P01132",2858.27]
["EEU"," POL","Zarigual","M5-2021","P45132",7082.45]
["EEU","UKR ","Zarigual","M5-2021","P03666",3132.48]
["EEU","BLR ","Zarigual","M5-2021","P03974",143.44999999999999]
["EEU","CZE ","Zarigual","M5-2021","P42597",921.86]
["EEU","SVK ","Zarigual","M5-2021","P07136",6838.53]
["EEU"," UKR","Zarigual","M5-2021","P09915",4058.31]
["EEU","BGR ","Zarigual","M5-2021","P29397",5675.33]
["EEU","UKR ","Zarigual","M5-2021","P31105",4928.76]
["EEU"," MDA","Zarigual","M5-2021","P09514",7431.16]
["EEU"," POL","Zarigual","M5-2021","P47427",340.36]
["EEU"," SVK","Zarigual","M5-2021","P21878",8560.67]
["EEU","RUS ","Zarigual","M5-2021","P21574",4402.8100000000004]
["EEU"," HUN","Zarigual","M5-2021","P33288",7599.96]
["EEU"," HUN","Zarigual","M5-2021","P06804",2463.6799999999998]
["EEU","BLR ","Zarigual","M5-2021","P22419",8059.51]
["EEU","HUN ","Zarigual","M5-2021","P33264",3447.39]
["EEU","RUS ","Zarigual","M5-2021","P34501",1025.8599999999999]
["EEU"," CZE","Zarigual","M5-2021","P26118",3412.26]
["EEU"," HUN","Zarigual","M5-2021","P42336",4231.96]
["EEU"," ARM","Zarigual","M5-2021","P47218",7675.84]
["EEU"," MDA","Zarigual","M5-2021","P09301",7461.82]
["EEU"," HUN","Zarigual","M5-2021","P48563",4438.6400000000003]
["EEU","CZE ","Zarigual","M5-2021","P22281",7213.52]
["EEU","UKR ","Zarigual","M5-2021","P25725",5486.91]
["EEU","BGR ","Zarigual","M5-2021","P23810",5884.57]
["EEU","ROM ","Zarigual","M5-2021","P12684",3917.38]
["EEU","RUS ","Zarigual","M5-2021","P37634",368.28]
["EEU"," UKR","Zarigual","M5-2021","P39092",9502.7800000000007]
["EEU","RUS ","Zarigual","M5-2021","P12057",8669.67]
["EEU","BGR ","Zarigual","M5-2021","P37700",9467.58]
["EEU"," ARM","Zarigual","M5-2021","P26118",5565.34]
["EEU"," BGR","Zarigual","M5-2021","P14376",5409.92]
["EEU"," ROM","Zarigual","M5-2021","P38439",3163.37]
["EEU","SVK ","Zarigual","M5-2021","P41751",5416.45]
["EEU"," BGR","Zarigual","M5-2021","P01132",554.88]
["EEU","UKR ","Zarigual","M5-2021","P09301",5141.33]
["EEU"," SVK","Zarigual","M5-2021","P37069",9843.67]
["EEU","SVK ","Zarigual","M5-2021","P32994",7193.53]
["EEU"," UKR","Zarigual","M5-2021","P37104",8888.85]
["EEU"," ARM","Zarigual","M5-2021","P14031",9896.7999999999993]
["EEU"," UKR","Zarigual","M5-2021","P49785",1739.74]
["EEU"," SVK","Zarigual","M5-2021","P25081",5195.91]
["EEU","ARM ","Zarigual","M5-2021","P25081",6561.21]
["EEU","ROM ","Zarigual","M5-2021","P42950",3705.48]
["EEU","SVK ","Zarigual","M5-2021","P07187",5501.99]
["EEU","CZE ","Zarigual","M5-2021","P05032",4365.1099999999997]
["EEU"," POL","Zarigual","M5-2021","P04088",4.29]
["EEU","POL ","Zarigual","M5-2021","P18784",9252.73]
["EEU"," ARM","Zarigual","M5-2021","P32994",4838.3900000000003]
["EEU"," BLR","Zarigual","M5-2021","P42161",8734.7000000000007]
["EEU","BLR ","Zarigual","M5-2021","P41712",9408.84]
["EEU","BGR ","Zarigual","M5-2021","P25076",145.72]
["EEU","RUS ","Zarigual","M5-2021","P20063",5636.48]
["EEU"," ROM","Zarigual","M5-2021","P39306",4244.37]
["EEU"," UKR","Zarigual","M5-2021","P34416",5265.4]
["EEU","HUN ","Zarigual","M5-2021","P44737",5483.86]
["EEU","CZE ","Zarigual","M5-2021","P29220",382.81]
["EEU","ARM ","Zarigual","M5-2021","P49785",8017.69]
["EEU","ROM ","Zarigual","M5-2021","P04964",5145.2]
["EEU","ARM ","Zarigual","M5-2021","P30076",9437.51]
["EEU"," ROM","Zarigual","M5-2021","P34501",8023.55]
["EEU"," UKR","Zarigual","M5-2021","P03146",9635.3700000000008]
["EEU"," RUS","Zarigual","M5-2021","P17663",241.84]
["EEU","RUS ","Zarigual","M5-2021","P36222",3755.59]
["EEU"," CZE","Zarigual","M5-2021","P15184",6526.62]
["EEU"," BGR","Zarigual","M5-2021","P36531",756.94]
["EEU"," HUN","Zarigual","M5-2021","P46106",6777.23]
["EEU","ARM ","Zarigual","M5-2021","P45033",2075.5700000000002]
["EEU","ARM ","Zarigual","M5-2021","P37104",5606.88]
["EEU"," ROM","Zarigual","M5-2021","P43320",5722.6]
["EEU","CZE ","Zarigual","M5-2021","P41751",4858.1099999999997]
["EEU"," RUS","Zarigual","M5-2021","P04448",9675.16]
["EEU"," POL","Zarigual","M5-2021","P44963",8748.36]
["EEU"," RUS","Zarigual","M5-2021","P12955",8504.15]
["EEU"," BLR","Zarigual","M5-2021","P00249",507.35]
["EEU","ARM ","Zarigual","M5-2021","P20074",3315.88]
["EEU","BLR ","Zarigual","M5-2021","P42335",8869.11]
["EEU","POL ","Zarigual","M5-2021","P04306",4461.93]
["EEU"," CZE","Zarigual","M5-2021","P04448",5277.21]
["EEU","MDA ","Zarigual","M5-2021","P05232",2734.83]
["EEU"," CZE","Zarigual","M5-2021","P00626",617.41]
["EEU","ROM ","Zarigual","M5-2021","P42309",6927.37]
["EEU","BGR ","Zarigual","M5-2021","P12955",326.93]
["EEU"," CZE","Zarigual","M5-2021","P26375",5251.11]
["EEU"," ARM","Zarigual","M5-2021","P43320",6925.42]
["EEU"," MDA","Zarigual","M5-2021","P40595",6850.49]
["EEU"," ROM","Zarigual","M5-2021","P39503",5567.72]
["EEU"," ROM","Zarigual","M5-2021","P29746",690.72]
["EEU","UKR ","Zarigual","M5-2021","P10927",9452.61]
["EEU"," HUN","Zarigual","M5-2021","P32447",3285.84]
["EEU","CZE ","Zarigual","M5-2021","P20509",1368.79]
["EEU"," SVK","Zarigual","M5-2021","P09514",7010.42]
["EEU"," HUN","Zarigual","M5-2021","P04448",8173.37]
["EEU","POL ","Zarigual","M5-2021","P10507",9681.6200000000008]
["EEU"," CZE","Zarigual","M5-2021","P23379",299.67]
["EEU"," UKR","Zarigual","M5-2021","P07950",5588.45]
["EEU","HUN ","Zarigual","M5-2021","P32564",2035.96]
["EEU","BGR ","Zarigual","M5-2021","P06558",2787.83]
["EEU"," UKR","Zarigual","M5-2021","P23379",5253.56]
["EEU","CZE ","Zarigual","M5-2021","P25081",95.94]
["EEU"," SVK","Zarigual","M5-2021","P24661",549.5]
["EEU"," RUS","Zarigual","M5-2021","P41564",1631.45]
["EEU","RUS ","Zarigual","M5-2021","P31037",851.63]
["EEU","ROM ","Zarigual","M5-2021","P20287",2516.94]
["EEU","BLR ","Zarigual","M5-2021","P33199",9192.85]
["EEU"," POL","Zarigual","M5-2021","P41301",83.59]
["EEU","ROM ","Zarigual","M5-2021","P04032",56.46]
["EEU"," BGR","Zarigual","M5-2021","P03666",482.78]
["EEU","CZE ","Zarigual","M5-2021","P43965",7063.28]
["EEU"," BGR","Zarigual","M5-2021","P45754",3695.23]
["EEU","HUN ","Zarigual","M5-2021","P12684",6807.55]
["EEU","UKR ","Zarigual","M5-2021","P40581",8453.4]
["EEU"," BLR","Zarigual","M5-2021","P27773",783.17]
["EEU","ROM ","Zarigual","M5-2021","P14749",9184.7800000000007]
["EEU","SVK ","Zarigual","M5-2021","P25875",7746.25]
["EEU","ARM ","Zarigual","M5-2021","P18765",8047.84]
["EEU","SVK ","Zarigual","M5-2021","P34025",7951.46]
["EEU","UKR ","Zarigual","M5-2021","P37634",1734.71]
["EEU"," ARM","Zarigual","M5-2021","P26609",645.52]
["EEU","ARM ","Zarigual","M5-2021","P32123",3985.68]
["EEU","ROM ","Zarigual","M5-2021","P21534",2616.2199999999998]
["EEU","UKR ","Zarigual","M5-2021","P25610",7103.68]
["EEU"," ARM","Zarigual","M5-2021","P05336",6608.14]
["EEU"," MDA","Zarigual","M5-2021","P17663",5339.72]
["EEU","BGR ","Zarigual","M5-2021","P23810",1929.11]
["EEU"," ROM","Zarigual","M5-2021","P01048",1009.78]
["EEU"," RUS","Zarigual","M5-2021","P10185",4645.49]
["EEU"," BLR","Zarigual","M5-2021","P44737",416.59]
["EEU"," ROM","Zarigual","M5-2021","P37465",4016.7]
["EEU"," HUN","Zarigual","M5-2021","P06469",633.80999999999995]
["EEU"," ROM","Zarigual","M5-2021","P44570",3333.99]
["EEU","POL ","Zarigual","M5-2021","P34025",6871.95]
["EEU"," UKR","Zarigual","M5-2021","P33876",9035.89]
["EEU"," RUS","Zarigual","M5-2021","P36117",5771.48]
["EEU","ARM ","Zarigual","M5-2021","P48783",1365.27]
["EEU","BGR ","Zarigual","M5-2021","P49785",7257.1]
["EEU","CZE ","Zarigual","M5-2021","P49225",5594.58]
["EEU","POL ","Zarigual","M5-2021","P10927",7676.91]
["EEU","ROM ","Zarigual","M5-2021","P18054",6796.7]
["EEU","CZE ","Zarigual","M5-2021","P22873",3388.16]
["EEU","UKR ","Zarigual","M5-2021","P14251",5263.23]
["EEU","BLR ","Zarigual","M5-2021","P21726",7378.13]
["EEU"," SVK","Zarigual","M5-2021","P06356",4412.1899999999996]
["EEU","HUN ","Zarigual","M5-2021","P30841",9414.81]
["EEU","ARM ","Zarigual","M5-2021","P30270",1933.87]
["EEU","BLR ","Zarigual","M5-2021","P21419",1285.32]
["EEU"," POL","Zarigual","M5-2021","P35423",3082.88]
["EEU"," ROM","Zarigual","M5-2021","P31111",8897.84]
["EEU"," ARM","Zarigual","M5-2021","P21439",9387.42]
["EEU","CZE ","Zarigual","M5-2021","P31996",5905.55]
["EEU"," HUN","Zarigual","M5-2021","P44737",2914.11]
["EEU"," SVK","Zarigual","M5-2021","P44127",90.27]
["EEU","POL ","Zarigual","M5-2021","P35562",8707.2999999999993]
["EEU"," POL","Zarigual","M5-2021","P43320",7294.47]
["EEU"," MDA","Zarigual","M5-2021","P04751",4972.95]
["EEU","UKR ","Zarigual","M5-2021","P39654",2702.25]
["EEU"," UKR","Zarigual","M5-2021","P40346",2556.3000000000002]
["EEU"," SVK","Zarigual","M5-2021","P07235",2725.64]
["EEU","RUS ","Zarigual","M5-2021","P43965",3538.84]
["EEU","HUN ","Zarigual","M5-2021","P00565",7791.57]
["EEU","SVK ","Zarigual","M5-2021","P16535",9188.42]
["EEU","BGR ","Zarigual","M5-2021","P34416",1175.1400000000001]
["EEU","RUS ","Zarigual","M5-2021","P27120",4280.79]
["EEU"," UKR","Zarigual","M5-2021","P33357",1079.3]
["EEU"," MDA","Zarigual","M5-2021","P20063",1218.75]
["EEU","POL ","Zarigual","M5-2021","P42161",4971.57]
["EEU","BGR ","Zarigual","M5-2021","P06948",9679.74]
["EEU"," CZE","Zarigual","M5-2021","P09070",7883.28]
["EEU"," HUN","Zarigual","M5-2021","P24416",609.99]
["EEU","BGR ","Zarigual","M5-2021","P20074",3043.13]
["EEU","BGR ","Zarigual","M5-2021","P40590",198.1]

{"sheet":"P4C4-Answer_Key_Detail","index":1,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Answer key for the \"Perfect Your Excel Skills\" training exercise, Part 4, Chapter 3"]
[]
[null,"Create an Automatic Macro"]
[]
[null,"Step 1","\"Developer\" tab, click on the icon"]
[null,"Step 2","Enter the macro name \"Text_Format_Into_Number_Format\" and click \"OK\""]
[null,"Step 3","In G2, type the formula \"=VALUE(F2)\""]
[null,"Step 4","Double-click on the drag handle to copy the formula to the whole database"]
[null,"Step 5","Copy the data from column G"]
[null,"Step 6","Paste the value into F2"]
[null,"Step 7","Click on the icon to stop the macro recording"]
[]
[null,"Assign the Macro to a Button"]
[]
[null,"Step 1","Create a button by going to the \"Insert\" tab, then \"Shapes\""]
[null,"Step 2","Open the context menu and Select \"Assign Macro...\""]
[null,"Step 3","Select your macro and click on OK"]
[]
[null,"Changing Your Macro"]
[]
[null,"Step 1","You can read your macro code by opening the Visual Basic editor (Alt + F11)"]
[null,"Step 2","Here is the code:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 3","Replace \"268\" by \"1000\" in both locations."]
[null,"Step 4","Ta-da! Your macro can now be used with a 1000-row database! J"]