{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Q1","Q2","Q3","Q4","Q5"],"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":"Q1","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,2,11],[11,0,11,2]]}
["Q1    \nWrite a VBA function (not a sub) to calculate the sum of n terms of the Fibonacci sequence . \nThe function should only take 1 argument, which is n - the number of terms which are to be summed."]
[]
[]
[]
["Check Visual Basics For VBA code"]
[]
["Fibonacci series "]
["Formula","Output "]
[{"$f":"_xlfn.FORMULATEXT(B9)","v":"=fib(3)"},{"$f":"fib(3)","v":{"$error":"#NAME?"}},null,{"$f":"fib(5)","v":{"$error":"#NAME?"}}]
[]
[]
["Refer Module 1 for the code"]

{"sheet":"Q2","index":1,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,6,13],[8,0,8,2]]}
["Q2\nCreate a sub which plays a guessing game with the user.\nOn running the macro, a messagebox should ask the user to think of an integer and ask him to input the upper and lower limit of an interval in which the number lies. \nThe macro will then guess the number through a msgbox, if the user gets it wrong, the computer will ask if it is higher or lower than the guess.\nDepending on the answer, the computer will guess again till the right answer is guessed. \nKeep a counter of the number of guesses and out put the number of guesses at the end."]
[]
[]
[]
[]
[]
[]
[]
["Refer Module 4 for the code"]

{"sheet":"Q3","index":2,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,3,9],[5,0,5,2]]}
["Q3\nCreate a function that takes as input a rupee amount and then calculates the minimum number of rupee notes (5,10,20,50,100,200,500 and 2000) to compose that amount. \nGive the output in 8 different cells corresponding to each currency note. [Hint: use the mod function]"]
[]
[]
[]
[]
["Refer Module 5 for the code"]
["Not solved completely "]
["Doubt"]

{"sheet":"Q4","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,8],[10,0,10,2]]}
["Q4\nWrite a function that calculates sum of the following series to n terms while taking n as an argument."]
[]
[]
["Check Visual Basics For VBA code"]
[]
[]
["Formula","Output "]
[{"$f":"_xlfn.FORMULATEXT(B8)","v":"=S(10)"},{"$f":"S(10)","v":{"$error":"#NAME?"}}]
[]
[]
["Refer Module 2 for the code"]

{"sheet":"Q5","index":4,"n_rows":107,"n_cols":5,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,0,3,10],[8,4,8,6]]}
["Q5 \nObtain the names of the first 100 countries by alphabetical order from; and paste them in a worksheet. \nWrite a macro that visually groups countries starting with the same letter by giving their cells the same background colour. \nSo all countries starting with A should have the same cell color, all cells with countries starting with B have the same color, and so on."]
[]
[]
[]
[]
[]
["Country Names "]
["Afghanistan"]
["Albania",null,null,null,"Refer Module 3 for the code"]
["Algeria"]
["Andorra"]
["Angola"]
["Antigua and Barbuda"]
["Argentina"]
["Armenia"]
["Australia"]
["Austria"]
["Azerbaijan"]
["Bahamas"]
["Bahrain"]
["Bangladesh"]
["Barbados"]
["Belarus"]
["Belgium"]
["Belize"]
["Benin"]
["Bhutan"]
["Bolivia"]
["Bosnia and Herzegovina"]
["Botswana"]
["Brazil"]
["Brunei"]
["Bulgaria"]
["Burkina Faso"]
["Burundi"]
["Côte d'Ivoire"]
["Cabo Verde"]
["Cambodia"]
["Cameroon"]
["Canada"]
["Central African Republic"]
["Chad"]
["Chile"]
["China"]
["Colombia"]
["Comoros"]
["Congo (Congo-Brazzaville)"]
["Costa Rica"]
["Croatia"]
["Cuba"]
["Cyprus"]
["Czechia (Czech Republic)"]
["Democratic Republic of the Congo"]
["Denmark"]
["Djibouti"]
["Dominica"]
["Dominican Republic"]
["Ecuador"]
["Egypt"]
["El Salvador"]
["Equatorial Guinea"]
["Eritrea"]
["Estonia"]
["Eswatini "]
["Ethiopia"]
["Fiji"]
["Finland"]
["France"]
["Gabon"]
["Gambia"]
["Georgia"]
["Germany"]
["Ghana"]
["Greece"]
["Grenada"]
["Guatemala"]
["Guinea"]
["Guinea-Bissau"]
["Guyana"]
["Haiti"]
["Holy See"]
["Honduras"]
["Hungary"]
["Iceland"]
["India"]
["Indonesia"]
["Iran"]
["Iraq"]
["Ireland"]
["Israel"]
["Italy"]
["Jamaica"]
["Japan"]
["Jordan"]
["Kazakhstan"]
["Kenya"]
["Kiribati"]
["Kuwait"]
["Kyrgyzstan"]
["Laos"]
["Latvia"]
["Lebanon"]
["Lesotho"]
["Liberia"]
["Libya"]
["Liechtenstein"]
["Lithuania"]