{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Question 1","Question 2","Question 3"],"not_rendered":{"charts":1,"images":4,"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":"Question 1","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Question 1:\n\nUse userforms to create a calculator with 2 functions - addition and subtraction.\nThe calculator will in total have 10 keys – 10 numeric keys, one = key, one key for\naddition and subtraction, and one del/reset key. "]

{"sheet":"Question 2","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Question 2:\n\nWrite a macro that creates a combochart (column + line) for the following data: "]
[]
[]
[null,null,"Year","Population","Employment Rate"]
[null,null,1970,4800000,0.12]
[null,null,1971,5500000,0.11]
[null,null,1972,6500000,0.06]
[null,null,1973,7200000,0.11]
[null,null,1974,7700000,0.15]
[null,null,1975,8300000,0.2]

{"sheet":"Question 3","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Question 3:\n\nThe following is world population data from the year 2010-2020. Copy this data in an excel file. Then write a macro that does the following:\n\na. Generate properly labelled and titled line graphs for each of the parameters (world pop, yearly change, net change, density, urban pop) vs year\n\nb. Your graphs should be stacked side by side with no space in between.\n\nc. On running the macro every time, the previous graphs should be deleted and new graphs should be generated\n\nd. Since the data is the same, how do we generate new graphs every time? Use a random number generator to choose the style for the graphs so every time, a new random style is chosen."]
[]
[]
[null,null,null,"Year","World Population","Yearly Change","Net Change","Density (P/Km^2)","Urban Population"]
[null,"Unable to Solve the Sum",null,2020,7794798739,1.0500000000000001E-2,81330639,52,4378993944]
[null,null,null,2019,7713468100,1.0800000000000001E-2,82377060,52,4299438618]
[null,null,null,2018,7631091040,1.0999999999999999E-2,83232115,51,4219817318]
[null,null,null,2017,7547858925,1.12E-2,83836876,51,4140188594]
[null,null,null,2016,7464022049,1.14E-2,84224910,50,4060652683]
[null,null,null,2015,7379797139,1.1599999999999999E-2,84506374,50,3981497663]
[null,null,null,2014,7295290765,1.17E-2,84708789,49,3902831934]
[null,null,null,2013,7210581976,1.1900000000000001E-2,84753917,48,3824990329]
[null,null,null,2012,7125828059,1.2E-2,84633758,48,3747842586]
[null,null,null,2011,7041194301,1.21E-2,84370698,47,3671423872]
[null,null,null,2010,6956823603,1.2200000000000001E-2,84056510,47,3594868146]