{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Manual Method","Using Cell References","Use Paste Special","VBA","PRODUCT"],"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":"Manual Method","index":0,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,15,1,19]]}
[]
[null,"Multiply a Column Manually by a Number",null,null,null,null,null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022",null,null,null,null,null,null,null,null,null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022"]
[null,"Barry",2674,3672,6723,{"$f":"E5*3","v":20169},null,null,null,null,null,null,null,null,null,"Barry",2674,3672,6723]
[null,"Barbara",1278,4682,1537,{"$f":"E6*3","v":4611},null,null,null,null,null,null,null,null,null,"Barbara",1278,4682,1537]
[null,"Ben",4672,1278,5614,16842,null,null,null,null,null,null,null,null,null,"Ben",4672,1278,5614]
[null,"Bob",3863,9035,7835,23505,null,null,null,null,null,null,null,null,null,"Bob",3863,9035,7835]
[null,"Beatrice",1674,4562,2573,7719,null,null,null,null,null,null,null,null,null,"Beatrice",1674,4562,2573]
[null,"Peter",2856,7824,6734,20202,null,null,null,null,null,null,null,null,null,"Peter",2856,7824,6734]
[null,"Rebecca",8935,4517,1950,5850,null,null,null,null,null,null,null,null,null,"Rebecca",8935,4517,1950]
[null,"Eric",4582,3478,3578,10734,null,null,null,null,null,null,null,null,null,"Eric",4582,3478,3578]
[null,"Lee",4687,3762,2378,7134,null,null,null,null,null,null,null,null,null,"Lee",4687,3762,2378]
[null,"Nancy",3674,7835,4518,13554,null,null,null,null,null,null,null,null,null,"Nancy",3674,7835,4518]

{"sheet":"Using Cell References","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,9,1,13],[1,1,1,7]]}
[]
[null,"Using Cell References",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022",null,"Multilpying Factor",null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022"]
[null,"Barry",2674,3672,6723,{"$f":"E5*$H$5","v":20169},null,3,null,"Barry",2674,3672,6723]
[null,"Barbara",1278,4682,1537,{"$f":"E6*$H$5","v":4611},null,null,null,"Barbara",1278,4682,1537]
[null,"Ben",4672,1278,5614,16842,null,null,null,"Ben",4672,1278,5614]
[null,"Bob",3863,9035,7835,23505,null,null,null,"Bob",3863,9035,7835]
[null,"Beatrice",1674,4562,2573,7719,null,null,null,"Beatrice",1674,4562,2573]
[null,"Peter",2856,7824,6734,20202,null,null,null,"Peter",2856,7824,6734]
[null,"Rebecca",8935,4517,1950,5850,null,null,null,"Rebecca",8935,4517,1950]
[null,"Eric",4582,3478,3578,10734,null,null,null,"Eric",4582,3478,3578]
[null,"Lee",4687,3762,2378,7134,null,null,null,"Lee",4687,3762,2378]
[null,"Nancy",3674,7835,4518,13554,null,null,null,"Nancy",3674,7835,4518]

{"sheet":"Use Paste Special","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,13]]}
[]
[null,"Utilizing Paste Special Command",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022",null,"Multilpying Factor",null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022"]
[null,"Barry",2674,3672,6723,8022,null,3,null,"Barry",2674,3672,6723]
[null,"Barbara",1278,4682,1537,3834,null,null,null,"Barbara",1278,4682,1537]
[null,"Ben",4672,1278,5614,14016,null,null,null,"Ben",4672,1278,5614]
[null,"Bob",3863,9035,7835,11589,null,null,null,"Bob",3863,9035,7835]
[null,"Beatrice",1674,4562,2573,5022,null,null,null,"Beatrice",1674,4562,2573]
[null,"Peter",2856,7824,6734,8568,null,null,null,"Peter",2856,7824,6734]
[null,"Rebecca",8935,4517,1950,26805,null,null,null,"Rebecca",8935,4517,1950]
[null,"Eric",4582,3478,3578,13746,null,null,null,"Eric",4582,3478,3578]
[null,"Lee",4687,3762,2378,14061,null,null,null,"Lee",4687,3762,2378]
[null,"Nancy",3674,7835,4518,11022,null,null,null,"Nancy",3674,7835,4518]

{"sheet":"VBA","index":3,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,13]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022",null,"Multilpying Factor",null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022"]
[null,"Barry",2674,3672,6723,8022,null,3,null,"Barry",2674,3672,6723]
[null,"Barbara",1278,4682,1537,3834,null,null,null,"Barbara",1278,4682,1537]
[null,"Ben",4672,1278,5614,14016,null,null,null,"Ben",4672,1278,5614]
[null,"Bob",3863,9035,7835,11589,null,null,null,"Bob",3863,9035,7835]
[null,"Beatrice",1674,4562,2573,5022,null,null,null,"Beatrice",1674,4562,2573]
[null,"Peter",2856,7824,6734,8568,null,null,null,"Peter",2856,7824,6734]
[null,"Rebecca",8935,4517,1950,26805,null,null,null,"Rebecca",8935,4517,1950]
[null,"Eric",4582,3478,3578,13746,null,null,null,"Eric",4582,3478,3578]
[null,"Lee",4687,3762,2378,14061,null,null,null,"Lee",4687,3762,2378]
[null,"Nancy",3674,7835,4518,11022,null,null,null,"Nancy",3674,7835,4518]

{"sheet":"PRODUCT","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,13]]}
[]
[null,"Applying PRODUCT Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022",null,"Multilpying Factor",null,"Sales Person","Target 2019","Target 2020","Target 2021","Target 2022"]
[null,"Barry",2674,3672,6723,{"$f":"PRODUCT(C5,$H$5)","v":8022},null,3,null,"Barry",2674,3672,6723]
[null,"Barbara",1278,4682,1537,{"$f":"PRODUCT(C6,$H$5)","v":3834},null,null,null,"Barbara",1278,4682,1537]
[null,"Ben",4672,1278,5614,14016,null,null,null,"Ben",4672,1278,5614]
[null,"Bob",3863,9035,7835,11589,null,null,null,"Bob",3863,9035,7835]
[null,"Beatrice",1674,4562,2573,5022,null,null,null,"Beatrice",1674,4562,2573]
[null,"Peter",2856,7824,6734,8568,null,null,null,"Peter",2856,7824,6734]
[null,"Rebecca",8935,4517,1950,26805,null,null,null,"Rebecca",8935,4517,1950]
[null,"Eric",4582,3478,3578,13746,null,null,null,"Eric",4582,3478,3578]
[null,"Lee",4687,3762,2378,14061,null,null,null,"Lee",4687,3762,2378]
[null,"Nancy",3674,7835,4518,11022,null,null,null,"Nancy",3674,7835,4518]