{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Multiple Choice Questions","Australia","Australia (2)","Australia (3)"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Multiple Choice Questions","index":0,"n_rows":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":false,"merged":[[62,2,66,2],[5,3,6,3],[32,2,36,2],[38,2,42,2],[44,2,48,2],[50,2,54,2],[56,2,60,2],[8,2,12,2],[2,2,6,2],[14,2,18,2],[20,2,24,2],[26,2,30,2]]}
[null,"Type your multiple choice answers to Q1 - Q09  in the boxes in column B. When you finish, switch to the other worksheet and do the practical Excel question!","Answer"]
[]
["Q0","Example. If I forget to submit my worksheet in the mid-session quiz:","A"]
["(A)","My test answers will be lost and unable to be retrieved"]
["(B)","I will be able to retrieve the worksheet after the exam, using magic"]
["(C)","I will be fined more than $205 by the NSW police"]
["(D)","The lecturer will automatically give me full marks"]
[null,"In the test, you have no Z-drive access. You must submit your answers! You can submit them as many times as you like, so treat Submit like Save."]
["Q1","Using the fill handle on a cell containing a formula"]
["(A)","cannot complete a sequence of dates in a column."]
["(B)","changes the background color of the selected cells to yellow."]
["(C)","copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula."]
["(D)","has two or more sub-commands related to the command."]
[]
["Q2"," A mixed cell reference"]
["(A)","occurs when a formula directly or indirectly refers to the cell containing the formula."]
["(B)","causes a potential error."]
["(C)","contains absolute or relative cell references, but not both."]
["(D)","contains an absolute row and a relative column reference, or vice-versa."]
[]
["Q3","The VLOOKUP function"]
["(A)","is the argument in a function that describes to which column to return a value."]
["(B)","is a range containing a lookup table."]
["(C)","is a reference to a cell containing a value to look up."]
["(D)","looks up a value and returns a related result from the lookup table"]
[]
["Q4","A clustered column chart"]
["(A)","groups or clusters similar data in columns to compare values across categories."]
["(B)","places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color."]
["(C)","places (stacks) data in one column per category, with each column having the same height of 100%."]
["(D)"," is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart."]
[]
["Q5","To Freeze Columns and/or rows"]
["(A)","first indicate where data starts on a new printed page."]
["(B)","use the View Tab, Window Group, and click Freeze Panes."]
["(C)","scroll through a worksheet and click on the Freeze button."]
["(D)","adjust settings to control how the worksheet will print."]
[]
["Q6","Which of the following is NOT a concern when adding subcategories to a PivotTable?"]
["(A)","The number of rows increases."]
["(B)","It improves the readability of the PivotTable."]
["(C)","It may add unnecessary groupings."]
["(D)","The data becomes overwhelming with too many details."]
[]
["Q7","Which What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?"]
["(A)","Scenario Manager"]
["(B)","Goal Seek"]
["(C)","One-variable data table"]
["(D)","Two-variable data table"]
[]
["Q8","Which What-If Analysis tool would be best at determining how much you can borrow for a car loan while paying only $350 a month?"]
["(A)","Scenario Manager"]
["(B)","Solver"]
["(C)","Data Table"]
["(D)","Goal Seek"]
[]
["Q9","To group two nonadjacent worksheets:"]
["(A)","click first tab, hold Shift and then click the last tab."]
["(B)","click first tab, hold Ctrl and then click the last tab."]
["(C)","right-click a worksheet tab, then select Select Two Sheets"]
["(D)","right-click a worksheet tab, than select Group"]
[]
[]
[]
[]
[]
[]
[]
[null,"To check your answers, select this cell, and type Shift+Ctrl+M , then go to the next worksheet."]

{"sheet":"Australia","index":1,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,0,21,11],[22,0,22,11],[23,0,23,11],[10,0,10,11],[20,0,20,11],[11,0,11,11],[12,0,12,11],[13,0,13,11],[14,0,14,11],[15,0,15,11],[16,0,16,11],[17,0,17,11],[18,0,18,11],[19,0,19,11]]}
[null,"Area (km2)","Population","Population Density","Highest Point (m)","Rank of Highest Point","Gross State Product ($bn)","Product per Capita","Rank of Product Per Capita","Population of capital","Proportion in Capital (%)","Area of capital (km2)","Capital Pop. Density"]
["NSW",809444,7272800,{"$f":"C2/B2","v":8.9849328674991717},2228,{"$f":"RANK(E2,HighPoints)","v":1},419.9,{"$f":"G2/C2*1000*1000000","v":57735.67264327356},{"$f":"RANK(H2,ProdPerCap)","v":4},4336374,{"$f":"J2/C2*100","v":59.624546254537456},12145,{"$f":"J2/L2","v":357.050144092219}]
["ACT",2358,373100,{"$f":"C3/B3","v":158.22731128074639},1912,3,25.9,{"$f":"G3/C3*1000*1000000","v":69418.386491557205},3,367752,{"$f":"J3/C3*100","v":98.566604127579737},814,{"$f":"J3/L3","v":451.7837837837838}]
["VIC",237629,5603100,23.579192775292579,1986,2,305.60000000000002,54541.236101443843,6,4169103,74.407078224554269,8806,473.43890529184648]
["QLD",1852642,4537700,2.4493129271602392,1622,4,252,55534.742270313152,5,2146577,47.305397007294445,5950,360.769243697479]
["SA",1043514,1650600,1.5817708243492661,1435,7,86.3,52284.017932872892,7,1262940,76.513994910941477,1827,691.26436781609198]
["WA",2645615,2451400,0.92658984772916697,1249,8,236.3,96393.897364771154,1,1832114,74.737456147507544,5386,340.16227255848497]
["TAS",90758,512100,5.642477798100443,1617,5,22.3,43546.182386252687,8,211656,41.330990041007617,1696,124.79716981132076]
["NT",1420970,233300,0.16418362104759424,1531,6,16.3,69867.123874839264,2,129100,55.33647663951993,112,1152.6785714285713]
["Australia",{"$f":"SUM(B2:B9)","v":8102930},{"$f":"SUM(C2:C9)","v":22634100},2.7933229091205281,{"$f":"MAX(HighPoints)","v":2228},1,{"$f":"SUM(G2:G9)","v":1364.6},60289.563092855467]
["Instructions"]
["1. Insert a new column to the right of Product per Capita, called \"Rank of Product per Capita\"."]
["2. Insert another new column to the right of Highest Point (m), called \"Rank of Highest Point\"."]
["3. Add a summary row, with row header \"Australia\", and give it an upper border."]
["4. Set the background of the column headers to Orange, Accent 6, Lighter 60%, and bold them."]
["5. Set the background of the row headers to Dark Blue, Text 2, Lighter 80%, and bold them."]
["6. Set the height of row 1 to 45, and wrap and centre the column headers."]
["7. Calculate the values for columns D (1 dec. pl.), and H, K, and M (all 0 dec. pl.) (use fill handle)."]
["8. Define a name for the range E2:E9 (say HighPoints), and for the range H2:H9 (say ProdPerCap). "]
["9. Calculate the ranks for columns F and I using the =RANK(cell, rangename) function."]
["10. Calculate totals for columns B , C, and G, national population density for col. D, highest high point for column E, then rank of highest high point for col. F, and national product per capita for col. H. No national figures need be calculated for columns I to M."]
["11. Add a pie chart showing Gross State Product by State, with a suitable title, and showing the data values as percentages."]
["12. Record and test a macro to clear out the numbers in rows 2-9 of  the Population, Population of Capital, and Gross State Product ($bn) columns (as these would all change with time) and delete the pie chart. This will leave lots of #DIV/0! errors - don't worry about them. Hint: record and test the macro on a copy of your worksheet."]
["Note: In the actual mid-session  test, you have no Z-drive access. You must submit your answers! You can submit them as many times as you like, so treat Submit like Save."]

{"sheet":"Australia (2)","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,0,15,11],[10,0,10,11],[11,0,11,11],[12,0,12,11],[13,0,13,11],[14,0,14,11],[22,0,22,11],[23,0,23,11],[16,0,16,11],[17,0,17,11],[18,0,18,11],[19,0,19,11],[20,0,20,11],[21,0,21,11]]}
[null,"Area (km2)","Population","Population Density","Highest Point (m)","Rank of Highest Point","Gross State Product ($bn)","Product per Capita","Rank of Product Per Capita","Population of capital","Proportion in Capital (%)","Area of capital (km2)","Capital Pop. Density"]
["NSW",809444,null,{"$f":"C2/B2","v":0},2228,{"$f":"RANK(E2,HighPoints)","v":1},null,{"$f":"G2/C2*1000*1000000","v":{"$error":"#DIV/0!"}},{"$f":"RANK(H2,ProdPerCap)","v":{"$error":"#DIV/0!"}},null,{"$f":"J2/C2*100","v":{"$error":"#DIV/0!"}},12145,{"$f":"J2/L2","v":0}]
["ACT",2358,null,{"$f":"C3/B3","v":0},1912,3,null,{"$f":"G3/C3*1000*1000000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"J3/C3*100","v":{"$error":"#DIV/0!"}},814,{"$f":"J3/L3","v":0}]
["VIC",237629,null,0,1986,2,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},8806,0]
["QLD",1852642,null,0,1622,4,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},5950,0]
["SA",1043514,null,0,1435,7,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},1827,0]
["WA",2645615,null,0,1249,8,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},5386,0]
["TAS",90758,null,0,1617,5,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},1696,0]
["NT",1420970,null,0,1531,6,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},112,0]
["Australia",{"$f":"SUM(B2:B9)","v":8102930},{"$f":"SUM(C2:C9)","v":0},0,{"$f":"MAX(HighPoints)","v":2228},1,{"$f":"SUM(G2:G9)","v":0},{"$error":"#DIV/0!"}]
["Instructions"]
["1. Insert a new column to the right of Product per Capita, called \"Rank of Product per Capita\"."]
["2. Insert another new column to the right of Highest Point (m), called \"Rank of Highest Point\"."]
["3. Add a summary row, with row header \"Australia\", and give it an upper border."]
["4. Set the background of the column headers to Orange, Accent 6, Lighter 60%, and bold them."]
["5. Set the background of the row headers to Dark Blue, Text 2, Lighter 80%, and bold them."]
["6. Set the height of row 1 to 45, and wrap and centre the column headers."]
["7. Calculate the values for columns D (1 dec. pl.), and H, K, and M (all 0 dec. pl.) (use fill handle)."]
["8. Define a name for the range E2:E9 (say HighPoints), and for the range H2:H9 (say ProdPerCap). "]
["9. Calculate the ranks for columns F and I using the =RANK(cell, rangename) function."]
["10. Calculate totals for columns B , C, and G, national population density for col. D, highest high point for column E, then rank of highest high point for col. F, and national product per capita for col. H. No national figures need be calculated for columns I to M."]
["11. Add a pie chart showing Gross State Product by State, with a suitable title, and showing the data values as percentages."]
["12. Record and test a macro to clear out the numbers in rows 2-9 of  the Population, Population of Capital, and Gross State Product ($bn) columns (as these would all change with time) and delete the pie chart. This will leave lots of #DIV/0! errors - don't worry about them. Hint: record and test the macro on a copy of your worksheet."]
["Note: In the actual mid-session  test, you have no Z-drive access. You must submit your answers! You can submit them as many times as you like, so treat Submit like Save."]

{"sheet":"Australia (3)","index":3,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,0,15,11],[10,0,10,11],[11,0,11,11],[12,0,12,11],[13,0,13,11],[14,0,14,11],[22,0,22,11],[23,0,23,11],[16,0,16,11],[17,0,17,11],[18,0,18,11],[19,0,19,11],[20,0,20,11],[21,0,21,11]]}
[null,"Area (km2)","Population","Population Density","Highest Point (m)","Rank of Highest Point","Gross State Product ($bn)","Product per Capita","Rank of Product Per Capita","Population of capital","Proportion in Capital (%)","Area of capital (km2)","Capital Pop. Density"]
["NSW",809444,null,{"$f":"C2/B2","v":0},2228,{"$f":"RANK(E2,HighPoints)","v":1},null,{"$f":"G2/C2*1000*1000000","v":{"$error":"#DIV/0!"}},{"$f":"RANK(H2,ProdPerCap)","v":{"$error":"#DIV/0!"}},null,{"$f":"J2/C2*100","v":{"$error":"#DIV/0!"}},12145,{"$f":"J2/L2","v":0}]
["ACT",2358,null,{"$f":"C3/B3","v":0},1912,3,null,{"$f":"G3/C3*1000*1000000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,{"$f":"J3/C3*100","v":{"$error":"#DIV/0!"}},814,{"$f":"J3/L3","v":0}]
["VIC",237629,null,0,1986,2,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},8806,0]
["QLD",1852642,null,0,1622,4,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},5950,0]
["SA",1043514,null,0,1435,7,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},1827,0]
["WA",2645615,null,0,1249,8,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},5386,0]
["TAS",90758,null,0,1617,5,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},1696,0]
["NT",1420970,null,0,1531,6,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},112,0]
["Australia",{"$f":"SUM(B2:B9)","v":8102930},{"$f":"SUM(C2:C9)","v":0},0,{"$f":"MAX(HighPoints)","v":2228},1,{"$f":"SUM(G2:G9)","v":0},{"$error":"#DIV/0!"}]
["Instructions"]
["1. Insert a new column to the right of Product per Capita, called \"Rank of Product per Capita\"."]
["2. Insert another new column to the right of Highest Point (m), called \"Rank of Highest Point\"."]
["3. Add a summary row, with row header \"Australia\", and give it an upper border."]
["4. Set the background of the column headers to Orange, Accent 6, Lighter 60%, and bold them."]
["5. Set the background of the row headers to Dark Blue, Text 2, Lighter 80%, and bold them."]
["6. Set the height of row 1 to 45, and wrap and centre the column headers."]
["7. Calculate the values for columns D (1 dec. pl.), and H, K, and M (all 0 dec. pl.) (use fill handle)."]
["8. Define a name for the range E2:E9 (say HighPoints), and for the range H2:H9 (say ProdPerCap). "]
["9. Calculate the ranks for columns F and I using the =RANK(cell, rangename) function."]
["10. Calculate totals for columns B , C, and G, national population density for col. D, highest high point for column E, then rank of highest high point for col. F, and national product per capita for col. H. No national figures need be calculated for columns I to M."]
["11. Add a pie chart showing Gross State Product by State, with a suitable title, and showing the data values as percentages."]
["12. Record and test a macro to clear out the numbers in rows 2-9 of  the Population, Population of Capital, and Gross State Product ($bn) columns (as these would all change with time) and delete the pie chart. This will leave lots of #DIV/0! errors - don't worry about them. Hint: record and test the macro on a copy of your worksheet."]
["Note: In the actual mid-session  test, you have no Z-drive access. You must submit your answers! You can submit them as many times as you like, so treat Submit like Save."]