{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Question 1","Question 2","Question 3","Question 4","Question 5"],"not_rendered":{"charts":0,"images":6,"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":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Question 1:\n\nWrite a VBA function (not a sub) to calculate the sum of n terms of the Fibonacci sequence\n(https://www.mathsisfun.com/numbers/fibonacci-sequence.html). The function should only take 1\nargument, which is n - the number of terms which are to be summed."]
[]
[]
[null,null,{"$f":"fibonaci(33)","v":3524578},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=fibonaci(33)"}]

{"sheet":"Question 2","index":1,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Question 2:\n\nCreate a sub which plays a guessing game with the user. On 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. The 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. Depending on the answer, the computer will guess again till the right answer is guessed. Keep a counter of the number of guesses and out put the number of guesses at the end"]

{"sheet":"Question 3","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Question 3:\n\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. Give the output in 8 different cells corresponding to each currency note. [Hint: use the mod function]"]
[]
[]
[null,null,"Currency Denomination (in Rs.)","No. of Notes"]
[]
[null,null,2000]
[null,null,500]
[null,null,200]
[null,null,100]
[null,null,50]
[null,null,20]
[null,null,10]
[null,null,5]

{"sheet":"Question 4","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Question 4:\n\nWrite a function that calculates sum of the following series to n terms while taking n as an argument.\n\n\n"]
[]
[]
[null,null,{"$f":"S(6)","v":0.96866793837950038},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=S(6)"}]

{"sheet":"Question 5","index":4,"n_rows":104,"n_cols":4,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Question 5:\n\nObtain the names of the first 100 countries by alphabetical order from https://www.worldometers.info/geography/alphabetical-list-of-countries and paste them in a worksheet. Write a macro that visually groups countries starting with the same letter by giving their cells the same background colour. So 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."]
[]
[null,null,"Sr. No.","Country Name"]
[null,null,1,"Afghanistan"]
[null,null,2,"Albania"]
[null,null,3,"Algeria"]
[null,null,4,"Andorra"]
[null,null,5,"Angola"]
[null,null,6,"Antigua and Barbuda"]
[null,null,7,"Argentina"]
[null,null,8,"Armenia"]
[null,null,9,"Australia"]
[null,null,10,"Austria"]
[null,null,11,"Azerbaijan"]
[null,null,12,"Bahamas"]
[null,null,13,"Bahrain"]
[null,null,14,"Bangladesh"]
[null,null,15,"Barbados"]
[null,null,16,"Belarus"]
[null,null,17,"Belgium"]
[null,null,18,"Belize"]
[null,null,19,"Benin"]
[null,null,20,"Bhutan"]
[null,null,21,"Bolivia"]
[null,null,22,"Bosnia and Herzegovina"]
[null,null,23,"Botswana"]
[null,null,24,"Brazil"]
[null,null,25,"Brunei"]
[null,null,26,"Bulgaria"]
[null,null,27,"Burkina Faso"]
[null,null,28,"Burundi"]
[null,null,29,"Côte d'Ivoire"]
[null,null,30,"Cabo Verde"]
[null,null,31,"Cambodia"]
[null,null,32,"Cameroon"]
[null,null,33,"Canada"]
[null,null,34,"Central African Republic"]
[null,null,35,"Chad"]
[null,null,36,"Chile"]
[null,null,37,"China"]
[null,null,38,"Colombia"]
[null,null,39,"Comoros"]
[null,null,40,"Congo (Congo-Brazzaville)"]
[null,null,41,"Costa Rica"]
[null,null,42,"Croatia"]
[null,null,43,"Cuba"]
[null,null,44,"Cyprus"]
[null,null,45,"Czechia (Czech Republic)"]
[null,null,46,"Democratic Republic of the Congo"]
[null,null,47,"Denmark"]
[null,null,48,"Djibouti"]
[null,null,49,"Dominica"]
[null,null,50,"Dominican Republic"]
[null,null,51,"Ecuador"]
[null,null,52,"Egypt"]
[null,null,53,"El Salvador"]
[null,null,54,"Equatorial Guinea"]
[null,null,55,"Eritrea"]
[null,null,56,"Estonia"]
[null,null,57,"Eswatini (fmr. \"Swaziland\")"]
[null,null,58,"Ethiopia"]
[null,null,59,"Fiji"]
[null,null,60,"Finland"]
[null,null,61,"France"]
[null,null,62,"Gabon"]
[null,null,63,"Gambia"]
[null,null,64,"Georgia"]
[null,null,65,"Germany"]
[null,null,66,"Ghana"]
[null,null,67,"Greece"]
[null,null,68,"Grenada"]
[null,null,69,"Guatemala"]
[null,null,70,"Guinea"]
[null,null,71,"Guinea-Bissau"]
[null,null,72,"Guyana"]
[null,null,73,"Haiti"]
[null,null,74,"Holy See"]
[null,null,75,"Honduras"]
[null,null,76,"Hungary"]
[null,null,77,"Iceland"]
[null,null,78,"India"]
[null,null,79,"Indonesia"]
[null,null,80,"Iran"]
[null,null,81,"Iraq"]
[null,null,82,"Ireland"]
[null,null,83,"Israel"]
[null,null,84,"Italy"]
[null,null,85,"Jamaica"]
[null,null,86,"Japan"]
[null,null,87,"Jordan"]
[null,null,88,"Kazakhstan"]
[null,null,89,"Kenya"]
[null,null,90,"Kiribati"]
[null,null,91,"Kuwait"]
[null,null,92,"Kyrgyzstan"]
[null,null,93,"Laos"]
[null,null,94,"Latvia"]
[null,null,95,"Lebanon"]
[null,null,96,"Lesotho"]
[null,null,97,"Liberia"]
[null,null,98,"Libya"]
[null,null,99,"Liechtenstein"]
[null,null,100,"Lithuania"]