{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","LEFT, TEXT and RIGHT","REPLACE, SEARCH and TEXT","Format Cells","User Defined Function","Caret Operator","Power Function","EXP Function","Exercise"],"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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Scientific Notation ","x10^3 Format"]
[null,5500," "]
[null,9670]
[null,1020]
[null,3.0000000000000001E-3]

{"sheet":"LEFT, TEXT and RIGHT","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining LEFT, TEXT and RIGHT Functions"]
[]
[null,"Scientific Notation ","x10^3 Format"]
[null,5500,{"$f":"LEFT(TEXT(B5,\"0.00E+0\"),3) & \"x10^\" & RIGHT(TEXT(B5,\"0.00E+0\"),2)","v":"5.5x10^+3"}]
[null,9670,{"$f":"LEFT(TEXT(B6,\"0.00E+0\"),3) & \"x10^\" & RIGHT(TEXT(B6,\"0.00E+0\"),2)","v":"9.6x10^+3"}]
[null,1020,"1.0x10^+3"]
[null,3.0000000000000001E-3,"3.0x10^-3"]

{"sheet":"REPLACE, SEARCH and TEXT","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying REPLACE, SEARCH and TEXT Functions"]
[]
[null,"Scientific Notation ","x10^3 Format"]
[null,5500,{"$f":"IF(B5>=1, REPLACE(TEXT(B5,\"0.0E+00\"), SEARCH(\"E\", TEXT(B5,\"0.0E+00\")), 2, \"x10^\"), REPLACE(TEXT(B5,\"0.0E+00\"), SEARCH(\"E\", TEXT(B5,\"0.0E+00\")), 1, \"x10^\"))","v":"5.5x10^03"}]
[null,9670,{"$f":"IF(B6>=1, REPLACE(TEXT(B6,\"0.0E+00\"), SEARCH(\"E\", TEXT(B6,\"0.0E+00\")), 2, \"x10^\"), REPLACE(TEXT(B6,\"0.0E+00\"), SEARCH(\"E\", TEXT(B6,\"0.0E+00\")), 1, \"x10^\"))","v":"9.7x10^03"}]
[null,1020,{"$f":"IF(B7>=1, REPLACE(TEXT(B7,\"0.0E+00\"), SEARCH(\"E\", TEXT(B7,\"0.0E+00\")), 2, \"x10^\"), REPLACE(TEXT(B7,\"0.0E+00\"), SEARCH(\"E\", TEXT(B7,\"0.0E+00\")), 1, \"x10^\"))","v":"1.0x10^03"}]
[null,3.0000000000000001E-3,{"$f":"IF(B8>=1, REPLACE(TEXT(B8,\"0.0E+00\"), SEARCH(\"E\", TEXT(B8,\"0.0E+00\")), 2, \"x10^\"), REPLACE(TEXT(B8,\"0.0E+00\"), SEARCH(\"E\", TEXT(B8,\"0.0E+00\")), 1, \"x10^\"))","v":"3.0x10^-03"}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"REPLACE(TEXT(B5,\"0.0E+00\"), SEARCH(\"E\", TEXT(B5,\"0.0E+00\")), 2, \"x10^\")","v":"5.5x10^03"}]
[]
[null,null,{"$f":"IF(B5>=1, REPLACE(TEXT(B5,\"0.0E+00\"), SEARCH(\"E\", TEXT(B5,\"0.0E+00\")), 2, \"x10^\"), REPLACE(TEXT(B5,\"0.0E+00\"), SEARCH(\"E\", TEXT(B5,\"0.0E+00\")), 1, \"x10^\"))","v":"5.5x10^03"}]
[null,null,null,null,{"$f":"REPLACE(TEXT(B5,\"0.0E+00\"), SEARCH(\"E\", TEXT(B5,\"0.0E+00\")), 1, \"x10^\")","v":"5.5x10^+03"}]
[null,null,null,null,500000]

{"sheet":"Format Cells","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying Format Cells"]
[]
[null,"Scientific Notation ","x10^3 Format"]
[null,5500,"5.50x103"]
[null,9670,"9.67x103"]
[null,1020,"1.02x103"]
[null,3.0000000000000001E-3,"3.00x10-3"]

{"sheet":"User Defined Function","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Inserting User Defined Function"]
[]
[null,"Scientific Notation ","x10^3 Format"]
[null,5500,{"$f":"Scientific(B5,3)","v":"5.50 * 10^ 3"}]
[null,9670,{"$f":"Scientific(B6,3)","v":"9.67 * 10^ 3"}]
[null,10200000,{"$f":"Scientific(B7,3)","v":"10200.00 * 10^ 3"}]
[null,300000,{"$f":"Scientific(B8,3)","v":"300.00 * 10^ 3"}]

{"sheet":"Caret Operator","index":5,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing Caret Operator"]
[]
[null,"Number","Power","Result"]
[null,2,3,{"$f":"B5^C5","v":8}]
[null,5,4,{"$f":"B6^C6","v":625}]
[null,10,5,100000]
[null,20,6,64000000]

{"sheet":"Power Function","index":6,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting Power Function"]
[]
[null,"Number","Power","Result"]
[null,2,3,{"$f":"POWER(B5,C5)","v":8}]
[null,5,4,{"$f":"POWER(B6,C6)","v":625}]
[null,10,5,100000]
[null,20,6,64000000]

{"sheet":"EXP Function","index":7,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,7,1]]}
[]
[null,"Applying EXP Function"]
[]
[null,"Number","Power","Result"]
[null,2.71828,3,{"$f":"EXP(C5)","v":20.085536923187668}]
[null,null,4,{"$f":"EXP(C6)","v":54.598150033144236}]
[null,null,5,148.4131591025766]
[null,null,6,403.42879349273511]

{"sheet":"Exercise","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Try Yourself"]
[]
[null,"Scientific Notation ","x10^3 Format"]
[null,5500]
[null,9670]
[null,1020]
[null,3.0000000000000001E-3]