{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Score","Instructions","P(1)","P(2)"],"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":"Score","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Problem","Description","Possible Points","Earned Points","Note"]
[null,1,"Did you, in cell C14, create a Single Input-Output Formula to calculate the Tax Amount, like: =ROUND(B14*$C$11,2)?",{"$f":"100/ROWS($C$3:$C$39)","v":2.7027027027027026},{"$f":"D3","v":2.7027027027027026}]
[null,null,"Did you use ROUND?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you lock the cell reference for the tax rate, like $C$11?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you copy the formula through the range C14:C18?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you, in cell C14, create a Dynamic Spilled Array Formula to calculate the Tax Amount, like: =ROUND(E14:E18*F11,2)?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use ROUND?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you, in cell F14, create a Table Formula to calculate the Tax Amount, like: =ROUND([@Sales]*$I$11,2)?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use ROUND?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you lock the cell reference for the tax rate, like $I$11?",2.7027027027027026,2.7027027027027026]
[null,null,"In the yellow cells (starting in the range B22, did you write an answer and say which of the three formula method you like best.",2.7027027027027026,2.7027027027027026]
[null,2,"Did you download the data file \"AutoData.csv\" from this link: https://excelisfun.net/files/AutoData.csv?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you save the  data file \"AutoData.csv\" to the folder you created in Video #1 (folder with your name)?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use the From Text/CSV button in the Get & Transform Data group in the Data tab in the Excel ribbon, import the data file \"AutoData.csv\" onto this worksheet?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you join the first two fields into a single filed?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you have the correct Data Types on each field?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you lode the table to cell B15?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you organize your answers with the correct letters from the homework problem, such as a, b, c, d, e",2.7027027027027026,2.7027027027027026]
[null,"a","Did you get the number of variables as 5?",2.7027027027027026,2.7027027027027026]
[null,"b","Did you get the correct type of data: Overall Score = Quantitative?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you get the correct type of data: Recommended = Categorical?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you get the correct type of data: Owner Satisfaction = Categorical?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you get the correct type of data: Overall Miles Per Gallon = Quantitative?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you get the correct type of data: Acceleration (0-60) Sec = Quantitative?",2.7027027027027026,2.7027027027027026]
[null,"c","Did you get the % recommended of: 46.67%?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use a PivotTable or formula to calculate your answer?",2.7027027027027026,2.7027027027027026]
[null,"d","Did you get Average overall miles per gallon = 24.4?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use a PivotTable or formula to calculate your answer?",2.7027027027027026,2.7027027027027026]
[null,"e","Did you complete SUV Owner Satisfaction?",2.7027027027027026,2.7027027027027026]
[null,"f","Did you create frequency distribution with a PivotTable?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use the grouping PivotTable feature?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you make the grouping categories unambiguous, like: 7 up to 8, rather than 7-8?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use COUNT function (Summarize Values As) in Values area to calculate the frequency?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you use Show Values As, % of Column Total to calculate the % Frequency?",2.7027027027027026,2.7027027027027026]
[null,null,"Did you have labels in the PivotTable for field name and calculations to make it easy to read and understand?",2.7027027027027026,2.7027027027027026]
[null,null,"Other grading elements 1",2.7027027027027026,2.7027027027027026]
[null,null,"Other grading elements 2",2.7027027027027026,2.7027027027027026]
[null,null,"Other grading elements 3",2.7027027027027026,2.7027027027027026]
[null,null,"Total Possible Points",{"$f":"SUM(D3:D39)","v":100.00000000000007}]
[null,null,"Is Test Submitted Past due date-time?","No",{"$f":"IF(D41=\"Yes\",-0.25*SUM(E3:E39),\"\")","v":""},{"$f":"IF(D41=\"Yes\",\"Deduction for late test\",\"\")","v":""}]
[null,null,null,"Your Earned Test Score:",{"$f":"SUM(E41,E3:E39)","v":100.00000000000007}]
[]
[]
["Be sure to scroll up to see full score sheet",null,null,null,null,"fall 2022"]

{"sheet":"Instructions","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["* This test covers everything in class up through chapter 1"]
[null,"Test Instructions:"]
["1)","You must rename each test file so that the file name contains your name."]
[null,"For example, if your name is “Sioux Noline” and the test file has the name “YourNameBusn210Test01.xlsm\","]
[null,"you MUST rename the file to become: “SiouxNolineBusn210Test01.xlsm”."]
[null,"Tests that do not follow this naming rule are scored as zero."]
["2)","The Excel test file MUST use the file extension \".xlsm\". Tests that do not follow this rule are scored as zero."]
["3)","This test has two problems on the worksheets with the names \"P(1)\" and \"P(2)\"."]
["4)","Late tests without a documentable emergency are assessed as a 25% deduction."]
[null,"You can hand in tests late if a documentable emergency occurs, like documented deaths or medical emergencies."]
["5)","The test scores earned will count toward your grade for the class."]
[]
["If you have questions you can e-mail me at mgirvin@highline.edu"]
[null,null,null,null,null,"Fall, 2022 File"]

{"sheet":"P(1)","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[21,1,23,8]]}
[]
[null,"In cell C14, create a Single Input-Output Formula to calculate the Tax Amount, then copy the formula down through the range C14:C18."]
[null,"In cell F14, create a Dynamic Spilled Array Formula to calculate the Tax Amount, then spill the formula down through the range F14:F18."]
[null,"In cell I14, create an Excel Table Formula to calculate the Tax Amount for the Excel Table field Tax Amount."]
[null,"In the yellow cells below (starting in the range B22, write an answer and say which of the three formula method you like best."]
[null,"Hint #1: Be sure to use the ROUND function to round to the penny for each formula."]
[null,"Hint #2: Video #3 shows exactly how to create the three formulas : )"]
[]
[null,"Single Input-Output Formulas",null,null,"Dynamic Spilled Array Formulas",null,null,"Excel Table Formulas"]
[]
[null,"Tax Rate",0.1075,null,"Tax Rate",0.1075,null,"Tax Rate",0.1075]
[]
[null,"Sales","Tax Amount",null,"Sales","Tax Amount",null,"Sales","Tax Amount"]
[null,1049.99,null,null,1049.99,null,null,1049.99]
[null,1765.21,null,null,1765.21,null,null,1765.21]
[null,537.03,null,null,537.03,null,null,537.03]
[null,860.03,null,null,860.03,null,null,860.03]
[null,947.61,null,null,947.61,null,null,947.61]

{"sheet":"P(2)","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"For this test problem, you will have to repeat the homework problem #25 on this sheet."]
[null,"Even if you already completed the problem, you must re-do it in this Excel workbook test file on this P(2) worksheet."]
[null,"Do not copy and paste work previously done."]
[null,"Use this worksheet below row 13 to complete this test problem. When you import the table, load it to cell B15."]
[null,"Organize your answers with the correct letters from the homework problem, such as a, b, c, d, e"]
[null,"Hint: Video #4 shows exactly how to use Power Query and PivotTable to complete this problem."]
[null,"1)","Download the data file \"AutoData.csv\" from this link:",null,null,null,null,null,"https://excelisfun.net/files/AutoData.csv"]
[null,"2)","Save the  data file \"AutoData.csv\" to the folder you created in Video #1 (folder with your name)."]
[null,"3)","Using the From Text/CSV button in the Get & Transform Data group in the Data tab in the Excel ribbon,"]
[null,null,"import the data file \"AutoData.csv\" onto this worksheet."]
[null,"4)","Follow the rest of the steps for ch 1 homework #25, except that you do not have to create the Histogram for 25 f."]