{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["index","n10","n100","n1000","mixed","1dp","2dp"],"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":"index","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"ROUNDING"]
[1,"Rounding to the nearest 10"]
[2,"Rounding to the nearest 100"]
[3,"Rounding to the nearest 1000"]
[4,"Rounding to the nearest 10, 100 or 1000"]
[5,"Rounding to one decimal place"]
[6,"Rounding to two decimal places"]
[null,"© Copyright 2005 S.A.Lomax, M.J.Nixon.  All Rights Reserved."]

{"sheet":"n10","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,11,8],[3,3,9,7]]}
[]
[null,null,null,"Round to the nearest 10:"]
[]
[null,null,null,{"$f":"ROUND(RAND()*1000,0)","v":861}]
[]
[]
[]
[]
[]
[]
[]
["Answer:",null,null,null,null,{"$f":"ROUND(D4,-1)","v":860}]

{"sheet":"n100","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,11,8],[3,3,9,7]]}
[]
[null,null,null,"Round to the nearest 100:"]
[]
[null,null,null,{"$f":"ROUND(RAND()*10000,0)","v":5514}]
[]
[]
[]
[]
[]
[]
[]
["Answer:",null,null,null,null,{"$f":"ROUND(D4,-2)","v":5500}]

{"sheet":"n1000","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,11,8],[3,3,9,7]]}
[]
[null,null,null,"Round to the nearest 1000:"]
[]
[null,null,null,{"$f":"ROUND(RAND()*100000,0)","v":73416}]
[]
[]
[]
[]
[]
[]
[]
["Answer:",null,null,null,null,{"$f":"ROUND(D4,-3)","v":73000}]

{"sheet":"mixed","index":4,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[11,5,11,10],[3,3,9,9],[1,8,1,9]]}
[]
[null,null,null,"Round to the nearest",null,null,null,null,{"$f":"10^D22","v":100}]
[]
[null,null,null,{"$f":"ROUND(RAND()*100000,0)","v":59284}]
[]
[]
[]
[]
[]
[]
[]
["Answer:",null,null,null,null,{"$f":"ROUND(D4,-D22)","v":59300}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"1+INT(RAND()*3)","v":2}]

{"sheet":"1dp","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,11,8],[3,3,9,7]]}
[]
[null,null,null,"Round to one decimal place"]
[]
[null,null,null,{"$f":"RAND()*1000","v":947.6161887972371}]
[]
[]
[]
[]
[]
[]
[]
["Answer:",null,null,null,null,{"$f":"ROUND(D4,1)","v":947.6}]

{"sheet":"2dp","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,11,8],[3,3,9,7]]}
[]
[null,null,null,"Round to two decimal places"]
[]
[null,null,null,{"$f":"RAND()*1000","v":487.7291047821717}]
[]
[]
[]
[]
[]
[]
[]
["Answer:",null,null,null,null,{"$f":"ROUND(D4,2)","v":487.73}]