{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["SQRT Func.","SQRT ABS. Func.","Fraction Number","length of hypotenuse","Standard deviation","RMS VAlue","distance between points","POWER Func.","Exponent Formula","IF Func.","Nth Root","seriessum function","power query","Table1","VBA Code","square root symbol"],"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":"SQRT Func.","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Square Root in Excel"]
[]
[null,"Number","Square Root"]
[null,4,{"$f":"SQRT(B5)","v":2}]
[null,9,{"$f":"SQRT(B6)","v":3}]
[null,16,4]
[null,25,5]
[null,36,6]
[null,49,7]
[null,64,8]
[null,81,9]
[null,100,10]

{"sheet":"SQRT ABS. Func.","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of SQRT Function for a Negative Number"]
[]
[null,"Number","Square Root"]
[null,4,{"$f":"SQRT(ABS(B5))","v":2}]
[null,9,{"$f":"SQRT(ABS(B6))","v":3}]
[null,-16,4]
[null,25,5]
[null,-36,6]
[null,49,7]
[null,64,8]
[null,-81,9]
[null,100,10]

{"sheet":"Fraction Number","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of SQRT Function for a Fraction Number"]
[]
[null,"Fraction","Square Root"]
[null,0.25,{"$f":"SQRT(B5)","v":0.5}]
[null,0.45,{"$f":"SQRT(B6)","v":0.67082039324993692}]
[null,0.65,0.80622577482985502]
[null,0.75,0.8660254037844386]
[null,0.55000000000000004,0.74161984870956632]
[null,0.35,0.59160797830996159]
[null,0.75,0.8660254037844386]
[null,0.85,0.92195444572928875]
[null,0.25,0.5]

{"sheet":"length of hypotenuse","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Length of  Hypotenuse of a Right Angled Triangle"]
[]
[null,"Right Triangle","Opposite Side","Adjacent Side","Hypotenuse"]
[null,"T-1",3,4,{"$f":"SQRT(C5^2+D5^2 )","v":5}]
[null,"T-2",4,7,{"$f":"SQRT(C6^2+D6^2 )","v":8.0622577482985491}]
[null,"T-3",5,6,7.810249675906654]
[null,"T-4",8,9,12.041594578792296]
[null,"T-5",4,8,8.9442719099991592]
[null,"T-6",3,6,6.7082039324993694]
[null,"T-7",3,8,8.5440037453175304]

{"sheet":"Standard deviation","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Standard Deviation"]
[]
[null,"Name","Physics","Chemistry","Geography"]
[null,"Jim",75,90,80]
[null,"Robert",88,86,72]
[null,"Jill",69,63,65]
[null,"Maddison",77,75,70]
[null,"Linda",98,67,66]
[null,"John",65,83,88]
[]
[null,"Standard Deviation",{"$f":"STDEV(C5:C10)/SQRT(COUNT(C5:C10))","v":5.0243849817111474},{"$f":"STDEV(D5:D10)/SQRT(COUNT(D5:D10))","v":4.4171383395939952},3.6308860259354514]

{"sheet":"RMS VAlue","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Calculating the RMS (Root Means Square) Value"]
[]
[null,"Molecule","Velocity (m/s)"]
[null,"M-1",3]
[null,"M-2",4]
[null,"M-3",5]
[null,"M-4",8]
[null,"M-5",4]
[null,"M-6",3]
[null,"M-7",3]
[null,"RMS Velocity ",{"$f":"SQRT(AVERAGE(C5:C11))","v":2.0701966780270626}]

{"sheet":"distance between points","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,2,3,3],[3,4,3,5],[3,6,4,6],[3,1,4,1]]}
[]
[null,"Calculating Distance Between Two Points"]
[]
[null,"Length","Coordinate of Point 1",null,"Coordinate of Point 2",null,"Distance"]
[null,null,"Value of X","Value of Y","Value of X","Value of Y"]
[null,"L-1",5,8,4,3,{"$f":"SQRT((C6-E6)^2+(D6-F6)^2)","v":5.0990195135927845}]
[null,"L-2",6,9,7,1,{"$f":"SQRT((C7-E7)^2+(D7-F7)^2)","v":8.0622577482985491}]
[null,"L-3",3,9,6,3,6.7082039324993694]
[null,"L-4",4,8,4,2,6]
[null,"L-5",7,4,2,4,5]
[null,"L-6",9,9,1,5,8.9442719099991592]
[null,"L-7",4,3,1,2,3.1622776601683795]

{"sheet":"POWER Func.","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Power Function to Find Square Root"]
[]
[null,"Number","Square Root"]
[null,4,{"$f":"POWER(B5, 1/2)","v":2}]
[null,9,{"$f":"POWER(B6, 1/2)","v":3}]
[null,16,4]
[null,25,5]
[null,36,6]
[null,49,7]
[null,64,8]
[null,81,9]
[null,100,10]

{"sheet":"Exponent Formula","index":8,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Get Square Root Using Exponent Formula"]
[]
[null,"Number","Square Root"]
[null,4,{"$f":"B5^(1/2)","v":2}]
[null,9,{"$f":"B6^(1/2)","v":3}]
[null,16,4]
[null,25,5]
[null,36,6]
[null,49,7]
[null,64,8]
[null,81,9]
[null,100,10]

{"sheet":"IF Func.","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Find Square Root Using IF Function"]
[]
[null,"Number","Square Root"]
[null,4,{"$f":"IF(ISNUMBER(B5),B5^(1/2),\" \")","v":2}]
[null,9,{"$f":"IF(ISNUMBER(B6),B6^(1/2),\" \")","v":3}]
[null,16,4]
[null,"Text Value"," "]
[null,25,5]
[null,36,6]
[null,49,7]
[null,64,8]
[null,81,9]
[null,100,10]

{"sheet":"Nth Root","index":10,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Calculate Nth Root"]
[]
[null,"Number","Exponent Formula","Power Function"]
[null,4,{"$f":"B5^(1/4)","v":1.4142135623730949},{"$f":"POWER(B5,1/4)","v":1.4142135623730949}]
[null,9,{"$f":"B6^(1/4)","v":1.7320508075688774},{"$f":"POWER(B6,1/4)","v":1.7320508075688774}]
[null,16,2,2]
[null,25,2.2360679774997898,2.2360679774997898]
[null,36,2.4494897427831779,2.4494897427831779]
[null,49,2.6457513110645903,2.6457513110645903]
[null,64,2.8284271247461898,2.8284271247461898]
[null,81,3.0000000000000004,3.0000000000000004]
[null,100,3.1622776601683795,3.1622776601683795]

{"sheet":"seriessum function","index":11,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying SERIESSUM Function"]
[]
[null,"Number","Square Root"]
[null,4,{"$f":"SERIESSUM(B5,1/2,0,1)","v":2}]
[null,9,{"$f":"SERIESSUM(B6,1/2,0,1)","v":3}]
[null,16,{"$f":"SERIESSUM(B7,1/2,0,1)","v":4}]
[null,25,5]
[null,36,6]
[null,49,7]
[null,64,8]

{"sheet":"power query","index":12,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Power Query"]
[]
[null,"Number"]
[null,4]
[null,9]
[null,16]
[null,25]
[null,36]
[null,49]
[null,64]

{"sheet":"Table1","index":13,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Number","Square Root"]
[4,2]
[9,3]
[16,4]
[25,5]
[36,6]
[49,7]
[64,8]

{"sheet":"VBA Code","index":14,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Code"]
[]
[null,"Number","Square Root"]
[null,4,2]
[null,9,3]
[null,16,4]
[null,25,5]
[null,36,6]
[null,49,7]
[null,64,8]

{"sheet":"square root symbol","index":15,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null," Add Square Root Symbol"]
[]
[null,"Without Square Root Symbol","With Square Root Symbol"]
[null,4,{"$f":"_xlfn.UNICHAR(8730) & B5","v":"√4"}]
[null,9,{"$f":"_xlfn.UNICHAR(8730) & B6","v":"√9"}]
[null,16,"√16"]
[null,25,"√25"]
[null,36,"√36"]
[null,49,"√49"]
[null,64,"√64"]