{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Basic Formulae"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Basic Formulae","index":0,"n_rows":72,"n_cols":12,"rows_kept":72,"cut":false,"hidden":false,"merged":[[63,1,63,2],[0,1,0,8],[0,0,52,0],[1,1,1,3],[2,1,2,3],[35,1,35,11]]}
[null,"This spreadsheet is protected, only in the red boxes formulae can be entered"]
[null,"Spreadsheet Operators"]
[null,"  "]
[null,"Add","+","plus"]
[null,"Subtract","-","minus"]
[null,"Multiply","*","star"]
[null,"Divide","/","forward slash"]
[]
[]
[null,"TASK 1"]
[null,"Work out the following  as a formula, use Number 1 then Number 2"]
[]
[null,"Number 1",null,"Do What ?",null,"Number 2",null,"Formula Answer ","Correct?",{"$f":"COUNTIF(I15:I29,\"Correct\")","v":0},"/8"]
[]
[null,200,null,"Add",null,345,null,null,{"$f":"IF(H15=B15+F15,\"Correct\",\"\")","v":""}]
[]
[null,345,null,"Add ",null,123,null,null,{"$f":"IF(H17=F17+B17,\"Correct\",\"\")","v":""}]
[]
[null,23455,null,"Subtract",null,6756,null,null,{"$f":"IF(H19=B19-F19,\"Correct\",\"\")","v":""}]
[]
[null,2311,null,"Subtract ",null,755,null,null,{"$f":"IF(H21=B21-F21,\"Correct\",\"\")","v":""}]
[]
[null,2234,null,"Multiply",null,32432,null,null,{"$f":"IF(H23=B23*F23,\"Correct\",\"\")","v":""}]
[]
[null,234,null,"Mulitply",null,44,null,null,{"$f":"IF(H25=B25*F25,\"Correct\",\"\")","v":""}]
[]
[null,435,null,"Divide",null,334,null,null,{"$f":"IF(H27=B27/F27,\"Correct\",\"\")","v":""}]
[]
[null,444,null,"Divide",null,23432,null,null,{"$f":"IF(H29=B29/F29,\"Correct\",\"\")","v":""}]
[]
[]
[null,"TASK 2    "]
[null,"Work out the following by putting in the numbers into the cells "]
[null,"then put the formula which will calculate it  in the Answer box provided"]
[]
[null,"Put the numbers into the Number 1,2 & 3 Box and then put in the correct formula"]
[]
[null,null,null,null,null,"Number 1","Number 2","Number 3","Formula Answer ","Correct?",{"$f":"COUNTIF(J40:J54,\"Correct\")","v":0},"/8"]
[null,null,null,null,null,{"$f":"IF(F40=5,\"Correct\",\"\")","v":""},{"$f":"IF(G40=3,\"Correct\",\"\")","v":""},{"$f":"IF(H40=2,\"Correct\",\"\")","v":""}]
[null,"1) Add 5 and 3 then multiply by  2 ",null,null,null,null,null,null,null,{"$f":"IF( I40=5+3*2,\"Correct\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F42=10,\"Correct\",\"\")","v":""},{"$f":"IF(G42=30,\"Correct\",\"\")","v":""},{"$f":"IF(H42=30,\"Correct\",\"\")","v":""}]
[null,"2) Add  10 & 30 , and subtract 30",null,null,null,null,null,null,null,{"$f":"IF(I42=10+30-30,\"Correct\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F44=3,\"Correct\",\"\")","v":""},{"$f":"IF(G44=4,\"Correct\",\"\")","v":""},{"$f":"IF(H44=200,\"Correct\",\"\")","v":""}]
[null,"3) Subtract 3 plus  4 from 200",null,null,null,null,null,null,null,{"$f":"IF(I44=3+4-200,\"Correct\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F46=20,\"Correct\",\"\")","v":""},{"$f":"IF(G46=30,\"Correct\",\"\")","v":""},{"$f":"IF(H46=50,\"Correct\",\"\")","v":""}]
[null,"4) Multiply 20 by 30, then subtract 50",null,null,null,null,null,null,null,{"$f":"IF(I46=20*30-50,\"Correct\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F48=2,\"Correct\",\"\")","v":""},{"$f":"IF(G48=2,\"Correct\",\"\")","v":""},{"$f":"IF(H48=56,\"Correct\",\"\")","v":""}]
[null,"5) Multipy 2 by 2 then by 56",null,null,null,null,null,null,null,{"$f":"IF(I48=2*2*56,\"Correct\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F50=10,\"Correct\",\"\")","v":""},{"$f":"IF(G50=45,\"Correct\",\"\")","v":""},{"$f":"IF(H50=5,\"Correct\",\"\")","v":""}]
[null,"6) Multiply 10 by 45 then by 5",null,null,null,null,null,null,null,{"$f":"IF(I50=10*45*5,\"Correct\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F52=100,\"Correct\",\"\")","v":""},{"$f":"IF(G52=2,\"Correct\",\"\")","v":""},{"$f":"IF(H52=25,\"Correct\",\"\")","v":""}]
[null,"7) Divide 100 by 2 then again by 25",null,null,null,null,null,null,null,{"$f":"IF(I52=100/2/25,\"Correct\",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(F54=100,\"Correct\",\"\")","v":""},{"$f":"IF(G54=6,\"Correct\",\"\")","v":""},{"$f":"IF(H54=4,\"Correct\",\"\")","v":""}]
[null,"8) Divide 100 by 6 then again by 4",null,null,null,null,null,null,null,{"$f":"IF(I54=100/6/4,\"Correct\",\"\")","v":""}]
[]
[]
[null,"Your Mark for TASK 1 is",null,null,{"$f":"J13","v":0},"out of 8"]
[null,"Your Mark for TASK 2 is",null,null,{"$f":"K38","v":0},"out of 8"]
[null,"Your total is ",null,null,{"$f":"E57+E58","v":0},"out of 16"]
[]
[null,"Your grade is ",null,null,{"$f":"VLOOKUP(E59,B66:C72,2)","v":"U"}]
[]
[]
[null,"Grade Boundaries:"]
[null,"Mark","Grade"]
[null,0,"U"]
[null,2,"E"]
[null,5,"D"]
[null,8,"C"]
[null,11,"B"]
[null,14,"A*"]
[null,16,"A*"]