{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Overview","ROUND","MROUND","ROUNDUP","CEILING","ROUNDDOWN","FLOOR","VBA","Whole Number"],"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":"Overview","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Overview of Dataset"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,{"$f":"ROUND(C5/5,0)*5","v":80}]
[null,"Steve Gibbs",84.33,{"$f":"ROUND(C6/5,0)*5","v":85}]
[null,"Alen Moor",57.91,60]
[null,"Richard Hick",76.89,75]
[null,"Kevin Orwell",34.43,35]
[null,"Shane Jennings",91.75,90]
[null,"Natalia Austin",96.95,95]
[null,"Jennifar Marlo",57.22,55]
[null,"Mike Robbins",50.03,50]

{"sheet":"ROUND","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Application of ROUND Function"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,{"$f":"ROUND(C5/5,0)*5","v":80}]
[null,"Steve Gibbs",84.33,{"$f":"ROUND(C6/5,0)*5","v":85}]
[null,"Alen Moor",57.91,60]
[null,"Richard Hick",76.89,75]
[null,"Kevin Orwell",34.43,35]
[null,"Shane Jennings",91.75,90]
[null,"Natalia Austin",96.95,95]
[null,"Jennifar Marlo",57.22,55]
[null,"Mike Robbins",50.03,50]

{"sheet":"MROUND","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of MROUND Function"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,{"$f":"MROUND(C5,5)","v":80}]
[null,"Steve Gibbs",84.33,{"$f":"MROUND(C6,5)","v":85}]
[null,"Alen Moor",57.91,60]
[null,"Richard Hick",76.89,75]
[null,"Kevin Orwell",34.43,35]
[null,"Shane Jennings",91.75,90]
[null,"Natalia Austin",96.95,95]
[null,"Jennifar Marlo",57.22,55]
[null,"Mike Robbins",50.03,50]

{"sheet":"ROUNDUP","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Insert ROUNDUP Function"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",81.650000000000006,{"$f":"ROUNDUP(C5/5,0)*5","v":85}]
[null,"Steve Gibbs",84.33,{"$f":"ROUNDUP(C6/5,0)*5","v":85}]
[null,"Alen Moor",57.91,60]
[null,"Richard Hick",76.89,80]
[null,"Kevin Orwell",34.43,35]
[null,"Shane Jennings",91.75,95]
[null,"Natalia Austin",96.95,100]
[null,"Jennifar Marlo",57.22,60]
[null,"Mike Robbins",50.03,55]

{"sheet":"CEILING","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of CEILING Function"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,{"$f":"CEILING(C5,5)","v":80}]
[null,"Steve Gibbs",84.33,{"$f":"CEILING(C6,5)","v":85}]
[null,"Alen Moor",57.91,60]
[null,"Richard Hick",76.89,80]
[null,"Kevin Orwell",34.43,35]
[null,"Shane Jennings",91.75,95]
[null,"Natalia Austin",96.95,100]
[null,"Jennifar Marlo",57.22,60]
[null,"Mike Robbins",50.03,55]

{"sheet":"ROUNDDOWN","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilize ROUNDDOWN Function"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,{"$f":"ROUNDDOWN(C5/5,0)*5","v":75}]
[null,"Steve Gibbs",84.33,{"$f":"ROUNDDOWN(C6/5,0)*5","v":80}]
[null,"Alen Moor",57.91,55]
[null,"Richard Hick",76.89,75]
[null,"Kevin Orwell",34.43,30]
[null,"Shane Jennings",91.75,90]
[null,"Natalia Austin",96.95,95]
[null,"Jennifar Marlo",57.22,55]
[null,"Mike Robbins",50.03,50]

{"sheet":"FLOOR","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Application of FLOOR Function"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,{"$f":"FLOOR(C5,5)","v":75}]
[null,"Steve Gibbs",84.33,{"$f":"FLOOR(C6,5)","v":80}]
[null,"Alen Moor",57.91,55]
[null,"Richard Hick",76.89,75]
[null,"Kevin Orwell",34.43,30]
[null,"Shane Jennings",91.75,90]
[null,"Natalia Austin",96.95,95]
[null,"Jennifar Marlo",57.22,55]
[null,"Mike Robbins",50.03,50]

{"sheet":"VBA","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Run Excel VBA Code"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,80]
[null,"Steve Gibbs",84.33,85]
[null,"Alen Moor",57.91,60]
[null,"Richard Hick",76.89,80]
[null,"Kevin Orwell",34.43,35]
[null,"Shane Jennings",91.75,95]
[null,"Natalia Austin",96.95,100]
[null,"Jennifar Marlo",57.22,60]
[null,"Mike Robbins",50.03,55]

{"sheet":"Whole Number","index":8,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of ROUND Function to Nearest Whole Number"]
[]
[null,"Student Name ","Average Marks","Rounded Marks"]
[null,"Jack Morris",79.650000000000006,{"$f":"ROUND(C5,0)","v":80}]
[null,"Steve Gibbs",84.33,{"$f":"ROUND(C6,0)","v":84}]
[null,"Alen Moor",57.91,58]
[null,"Richard Hick",76.89,77]
[null,"Kevin Orwell",34.43,34]
[null,"Shane Jennings",91.75,92]
[null,"Natalia Austin",96.95,97]
[null,"Jennifar Marlo",57.22,57]
[null,"Mike Robbins",50.03,50]