{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","ABS","IF","Conventional","PasteSpecial","FlashFill","Formatting","Find&Replace","Table5","PowerQuery","VBA"],"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":"Dataset","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Changing Negative to Positive"]
[]
[null,"Negative Number","Positive Number"]
[null,-5]
[null,-12]
[null,-0.5]
[null,-1.56]
[null,-100]

{"sheet":"ABS","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Applying ABS Function",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,null,null,null,null,null,null,"Negative Number","Positive Number"]
[null,-5,{"$f":"ABS(B5)","v":5},null,null,null,null,null,null,null,-5]
[null,-12,{"$f":"ABS(B6)","v":12},null,null,null,null,null,null,null,-12]
[null,-0.5,0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,100,null,null,null,null,null,null,null,-100]

{"sheet":"IF","index":2,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Using IF Function",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,null,null,null,null,null,null,"Negative Number","Positive Number"]
[null,-5,{"$f":"IF(B5<0,-B5,B5)","v":5},null,null,null,null,null,null,null,-5]
[null,-12,{"$f":"IF(B6<0,-B6,B6)","v":12},null,null,null,null,null,null,null,-12]
[null,-0.5,0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,100,null,null,null,null,null,null,null,-100]

{"sheet":"Conventional","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Utilizing Conventional Formula",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,null,null,null,null,null,null,"Negative Number","Positive Number"]
[null,-5,{"$f":"B5*(-1)","v":5},null,null,null,null,null,null,null,-5]
[null,-12,{"$f":"B6*(-1)","v":12},null,null,null,null,null,null,null,-12]
[null,-0.5,0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,100,null,null,null,null,null,null,null,-100]

{"sheet":"PasteSpecial","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Using Paste Special Feature",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,"Value",null,null,null,null,null,"Negative Number","Positive Number",null,"Value"]
[null,-5,5,null,-1,null,null,null,null,null,-5,null,null,-1]
[null,-12,12,null,null,null,null,null,null,null,-12]
[null,-0.5,0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,100,null,null,null,null,null,null,null,-100]

{"sheet":"FlashFill","index":5,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Applying Flash Fill Feature",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,null,null,null,null,null,null,"Negative Number","Positive Number"]
[null,-5,5,null,null,null,null,null,null,null,-5]
[null,-12,12,null,null,null,null,null,null,null,-12]
[null,-0.5,0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,100,null,null,null,null,null,null,null,-100]

{"sheet":"Formatting","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Setting Custom Cell Formatting",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,null,null,null,null,null,null,"Negative Number","Positive Number"]
[null,-5,-5,null,null,null,null,null,null,null,-5]
[null,-12,-12,null,null,null,null,null,null,null,-12]
[null,-0.5,-0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,-1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,-100,null,null,null,null,null,null,null,-100]

{"sheet":"Find&Replace","index":7,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Utilizing Find and Replace Feature",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,null,null,null,null,null,null,"Negative Number","Positive Number"]
[null,-5,5,null,null,null,null,null,null,null,-5]
[null,-12,12,null,null,null,null,null,null,null,-12]
[null,-0.5,0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,100,null,null,null,null,null,null,null,-100]

{"sheet":"Table5","index":8,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Value"]
[5]
[12]
[0.5]
[1.56]
[100]

{"sheet":"PowerQuery","index":9,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Power Query",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Value",null,null,null,null,null,null,null,null,"Value"]
[null,-5,null,null,null,null,null,null,null,null,-5]
[null,-12,null,null,null,null,null,null,null,null,-12]
[null,-0.5,null,null,null,null,null,null,null,null,-0.5]
[null,-1.56,null,null,null,null,null,null,null,null,-1.56]
[null,-100,null,null,null,null,null,null,null,null,-100]

{"sheet":"VBA","index":10,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Embedding VBA Code",null,null,null,null,null,null,null,null,">>> For Practice >>>"]
[]
[null,"Negative Number","Positive Number",null,null,null,null,null,null,null,"Negative Number","Positive Number"]
[null,-5,5,null,null,null,null,null,null,null,-5]
[null,-12,12,null,null,null,null,null,null,null,-12]
[null,-0.5,0.5,null,null,null,null,null,null,null,-0.5]
[null,-1.56,1.56,null,null,null,null,null,null,null,-1.56]
[null,-100,100,null,null,null,null,null,null,null,-100]