{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Score","Initial-Instructions","P(1)","P(2)","P(3)","P(4)","P(5)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Problem","Description","Possible Points","Earned Points","Note"]
[null,"1)","Check list for building model:",{"$f":"100/ROWS(D3:D54)","v":1.9230769230769231},{"$f":"D3","v":1.9230769230769231}]
[null,null,"Excel's Golden Rule: List all formula elements in cells with label?",1.9230769230769231,1.9230769230769231]
[null,null,"Style Formatting: is it easy to read and understand?",1.9230769230769231,1.9230769230769231]
[null,null,"Is Number Formatting interfering with our solution, or helping?",1.9230769230769231,1.9230769230769231]
[null,null,"Document model?",1.9230769230769231,1.9230769230769231]
[null,null,"Use ROUND function if necessary?",1.9230769230769231,1.9230769230769231]
[null,null,"Keep default alignments?",1.9230769230769231,1.9230769230769231]
[null,null,"Use formulas like:",1.9230769230769231,1.9230769230769231]
[null,null,"E15: =D15*C15",1.9230769230769231,1.9230769230769231]
[null,null,"F15: =ROUND(E15*$F$12,2)",1.9230769230769231,1.9230769230769231]
[null,null,"Other",1.9230769230769231,1.9230769230769231]
[null,"2)","Check list for building model:",1.9230769230769231,1.9230769230769231]
[null,null,"Excel's Golden Rule: List all formula elements in cells with label?",1.9230769230769231,1.9230769230769231]
[null,null,"Style Formatting: is it easy to read and understand?",1.9230769230769231,1.9230769230769231]
[null,null,"Is Number Formatting interfering with our solution, or helping?",1.9230769230769231,1.9230769230769231]
[null,null,"Document model?",1.9230769230769231,1.9230769230769231]
[null,null,"Use ROUND function if necessary?",1.9230769230769231,1.9230769230769231]
[null,null,"Keep default alignments?",1.9230769230769231,1.9230769230769231]
[null,null,"Use formulas like:",1.9230769230769231,1.9230769230769231]
[null,null,"E15: =C15:C26*D15:D26",1.9230769230769231,1.9230769230769231]
[null,null,"F15: =ROUND(E15#*F12,2)",1.9230769230769231,1.9230769230769231]
[null,null,"Other",1.9230769230769231,1.9230769230769231]
[null,"3)","Did you convert table to an Excel Table?",1.9230769230769231,1.9230769230769231]
[null,null,"Did you name the Excel Table?",1.9230769230769231,1.9230769230769231]
[null,null,"Check list for building model:",1.9230769230769231,1.9230769230769231]
[null,null,"Excel's Golden Rule: List all formula elements in cells with label?",1.9230769230769231,1.9230769230769231]
[null,null,"Style Formatting: is it easy to read and understand?",1.9230769230769231,1.9230769230769231]
[null,null,"Is Number Formatting interfering with our solution, or helping?",1.9230769230769231,1.9230769230769231]
[null,null,"Document model?",1.9230769230769231,1.9230769230769231]
[null,null,"Use ROUND function if necessary?",1.9230769230769231,1.9230769230769231]
[null,null,"Keep default alignments?",1.9230769230769231,1.9230769230769231]
[null,null,"Use formulas like:",1.9230769230769231,1.9230769230769231]
[null,null,"E15: =[@PricePerUnit]*[@UnitsSold]",{"$f":"100/ROWS(D35:D86)","v":1.9230769230769231},{"$f":"D35","v":1.9230769230769231}]
[null,null,"F15: =ROUND([@Sales]*$F$12,2)",1.9230769230769231,1.9230769230769231]
[null,"4)","Use SORT function?",1.9230769230769231,1.9230769230769231]
[null,null,"Use UNIQUE function?",1.9230769230769231,1.9230769230769231]
[null,null,"Use COUNTIFS function",1.9230769230769231,1.9230769230769231]
[null,null,"Other 1",1.9230769230769231,1.9230769230769231]
[null,null,"Other 2",1.9230769230769231,1.9230769230769231]
[null,"5)","List variable name: Last Day of Summer Q = 8/17/2024",1.9230769230769231,1.9230769230769231,null,null,"Last Day of Summer Q = 8/17/2024"]
[null,null,"List variable name: Last day of Summer Break = September 22, 2024",1.9230769230769231,1.9230769230769231,null,null,"Last day of vaction = September 22, 2024"]
[null,null,"List variable name: Workdays = 14",1.9230769230769231,1.9230769230769231,null,null,"Workdays = 14"]
[null,null,"Days of Highline Break =  Last day of Summer Break - Last Day of Summer Q = 37",1.9230769230769231,1.9230769230769231]
[null,null,"Total Break Days = Days of Highline Break - Workdays = 23",1.9230769230769231,1.9230769230769231]
[null,null,"Check list for building model:",1.9230769230769231,1.9230769230769231]
[null,null,"Excel's Golden Rule: List all formula elements in cells with label?",1.9230769230769231,1.9230769230769231]
[null,null,"Style Formatting: is it easy to read and understand?",1.9230769230769231,1.9230769230769231]
[null,null,"Is Number Formatting interfering with our solution, or helping?",1.9230769230769231,1.9230769230769231]
[null,null,"Document model?",1.9230769230769231,1.9230769230769231]
[null,null,"Keep default alignments?",1.9230769230769231,1.9230769230769231]
[null,null,"Other",1.9230769230769231,1.9230769230769231]
[null,null,"Name in Test file name?",1.9230769230769231,1.9230769230769231]
[null,null,"Total Possible Points",{"$f":"SUM(D3:D54)","v":99.999999999999886}]
[null,null,"Is Test Submitted Past due date-time?","No",{"$f":"IF(D56=\"Yes\",-0.25*SUM(E3:E54),\"\")","v":""},{"$f":"IF(D56=\"Yes\",\"Deduction for late test\",\"\")","v":""}]
[null,null,null,"Your Earned Test Score:",{"$f":"SUM(E3:E56)","v":99.999999999999886}]
[]
[]
[null,"Be sure to scroll up to see whole score sheet.",null,null,null,"fall 2022"]

{"sheet":"Initial-Instructions","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["* This test covers everything in class up to  MECS video #3"]
[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 “Busn218Fall2022Test04.xlsm\","]
[null,"you MUST rename the file to become: “SiouxNoline Busn218Fall2022Test04.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 four problems on the worksheets with the names \"P(1)\", \"P(2)\", \"P(3)\" and \"P(4)\"."]
["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 contact Michael Girvin: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[null,null,null,null,null,"Fall, 2022 File"]

{"sheet":"P(1)","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"For this problem, use a Single Input-Single Output formula."]
[null,"Add a new column that calculates Sales with the formula: UnitsSold * PricePerUnit"]
[null,"Create a second column that calculates the Discount on Sales with the formula: Sales * DiscountPercentage, where the DiscountPercentage is 4.50% (This DiscountPercentage may change)."]
[null,"Use the ROUND function for the Discount on Sales calculation."]
[null,"Be sure to follow Excel's Golden Rule and build an Excel Model to solve this problem."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[]
[]
[]
[null,"ProductSold","UnitsSold","PricePerUnit"]
[null,"Quad",84,45.67]
[null,"Carlota",24,32.200000000000003]
[null,"Aspen",72,30.21]
[null,"Yanaki",108,42.03]
[null,"Quad",156,45.56]
[null,"Quad",156,43.01]
[null,"Carlota",156,29.2]
[null,"Aspen",96,28.93]
[null,"Yanaki",24,39.840000000000003]
[null,"Yanaki",144,39.950000000000003]
[null,"Quad",132,46.05]
[null,"Aspen",144,29.53]

{"sheet":"P(2)","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"For this problem, use a Dynamic Spilled Array formula."]
[null,"Add a new column that calculates Sales with the formula: UnitsSold * PricePerUnit"]
[null,"Create a second column that calculates the Discount on Sales with the formula: Sales * DiscountPercentage, where the DiscountPercentage is 4.50% (This DiscountPercentage may change)."]
[null,"Use the ROUND function for the Discount on Sales calculation."]
[null,"Be sure to follow Excel's Golden Rule and build an Excel Model to solve this problem."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[]
[]
[]
[null,"ProductSold","UnitsSold","PricePerUnit"]
[null,"Quad",84,45.67]
[null,"Carlota",24,32.200000000000003]
[null,"Aspen",72,30.21]
[null,"Yanaki",108,42.03]
[null,"Quad",156,45.56]
[null,"Quad",156,43.01]
[null,"Carlota",156,29.2]
[null,"Aspen",96,28.93]
[null,"Yanaki",24,39.840000000000003]
[null,"Yanaki",144,39.950000000000003]
[null,"Quad",132,46.05]
[null,"Aspen",144,29.53]

{"sheet":"P(3)","index":4,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"For this problem, use an Excel Table formula (you will have to convert table to an Excel Table and name it."]
[null,"Add a new column that calculates Sales with the formula: UnitsSold * PricePerUnit"]
[null,"Create a second column that calculates the Discount on Sales with the formula: Sales * DiscountPercentage, where the DiscountPercentage is 4.50% (This DiscountPercentage may change)."]
[null,"Use the ROUND function for the Discount on Sales calculation."]
[null,"Be sure to follow Excel's Golden Rule and build an Excel Model to solve this problem."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[]
[]
[]
[null,"ProductSold","UnitsSold","PricePerUnit"]
[null,"Quad",84,45.67]
[null,"Carlota",24,32.200000000000003]
[null,"Aspen",72,30.21]
[null,"Yanaki",108,42.03]
[null,"Quad",156,45.56]
[null,"Quad",156,43.01]
[null,"Carlota",156,29.2]
[null,"Aspen",96,28.93]
[null,"Yanaki",24,39.840000000000003]
[null,"Yanaki",144,39.950000000000003]
[null,"Quad",132,46.05]
[null,"Aspen",144,29.53]

{"sheet":"P(4)","index":5,"n_rows":113,"n_cols":10,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Create a dynamic worksheet model that will list a sorted list of products and the count of transaction sales for each product."]
[null,"You can use the COUNTIFS function (similar to MAXIFS) top calculate the count of transaction sales for each product, a formula like this would work: =COUNTIFS(Test04Problem04[Product],G7#)"]
[null,"When you are done with the worksheet formulas, you can add the new data from the range G93:J109 to the bottom of the Excel Table."]
[null,"Be sure to follow Excel's Golden Rule and build an Excel Model to solve this problem."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]
[]
[null,"Date","Product","Customer","Sales ($)"]
[null,"2022-07-19","Quad","Customer 20",36368.19]
[null,"2022-07-17","Aspen","Customer 6",32532.89]
[null,"2022-07-10","Yanaki","Customer 20",27638.77]
[null,"2022-07-17","Aspen","Customer 15",14635.89]
[null,"2022-07-09","Yanaki","Customer 14",34372.400000000001]
[null,"2022-07-07","Yanaki","Customer 16",37088.49]
[null,"2022-07-03","Yanaki","Customer 10",24704.79]
[null,"2022-07-13","Aspen","Customer 27",38171.46]
[null,"2022-07-18","Quad","Customer 19",28347.85]
[null,"2022-07-30","Quad","Customer 2",12746.14]
[null,"2022-07-23","Yanaki","Customer 12",24177.25]
[null,"2022-07-29","Quad","Customer 1",16007.05]
[null,"2022-07-18","Aspen","Customer 8",44332.480000000003]
[null,"2022-07-05","Carlota","Customer 16",33232.67]
[null,"2022-07-24","Aspen","Customer 15",71245.42]
[null,"2022-07-18","Aspen","Customer 19",32359.3]
[null,"2022-07-29","Quad","Customer 8",23631.69]
[null,"2022-07-09","Quad","Customer 14",13628.28]
[null,"2022-07-15","Quad","Customer 19",48261.919999999998]
[null,"2022-07-10","Yanaki","Customer 13",11177.42]
[null,"2022-07-30","Quad","Customer 27",47571.98]
[null,"2022-07-08","Carlota","Customer 13",40004.629999999997]
[null,"2022-07-20","Quad","Customer 18",23528.799999999999]
[null,"2022-07-10","Yanaki","Customer 16",40585.61]
[null,"2022-07-10","Quad","Customer 16",12596.67]
[null,"2022-07-31","Carlota","Customer 15",39140.67]
[null,"2022-07-16","Aspen","Customer 9",47734.35]
[null,"2022-07-31","Quad","Customer 17",49964.14]
[null,"2022-07-27","Carlota","Customer 16",16543.25]
[null,"2022-07-09","Aspen","Customer 5",54714.36]
[null,"2022-07-20","Aspen","Customer 18",52705.49]
[null,"2022-07-01","Carlota","Customer 10",31849.47]
[null,"2022-07-09","Carlota","Customer 27",21385.39]
[null,"2022-07-13","Aspen","Customer 4",29228.44]
[null,"2022-07-14","Aspen","Customer 8",61043.19]
[null,"2022-07-02","Yanaki","Customer 13",51255.23]
[null,"2022-07-27","Carlota","Customer 22",13206.49]
[null,"2022-07-10","Aspen","Customer 7",51678.83]
[null,"2022-07-23","Carlota","Customer 1",54859.02]
[null,"2022-07-24","Carlota","Customer 3",46497.47]
[null,"2022-07-10","Carlota","Customer 1",16147.47]
[null,"2022-07-20","Aspen","Customer 13",34898.17]
[null,"2022-07-11","Carlota","Customer 26",17296.310000000001]
[null,"2022-07-17","Aspen","Customer 20",19047.7]
[null,"2022-07-24","Yanaki","Customer 12",52856.78]
[null,"2022-07-12","Quad","Customer 25",29177.41]
[null,"2022-07-30","Aspen","Customer 3",41334.58]
[null,"2022-07-03","Quad","Customer 16",46394.22]
[null,"2022-07-15","Yanaki","Customer 15",41930.300000000003]
[null,"2022-07-05","Quad","Customer 16",38800.94]
[null,"2022-07-19","Yanaki","Customer 12",51842.64]
[null,"2022-07-02","Yanaki","Customer 6",15040.56]
[null,"2022-07-19","Aspen","Customer 21",37759.58]
[null,"2022-07-30","Quad","Customer 25",36042.65]
[null,"2022-07-20","Quad","Customer 8",68465.100000000006]
[null,"2022-07-29","Quad","Customer 23",23599.08]
[null,"2022-07-28","Aspen","Customer 9",38026.9]
[null,"2022-07-07","Quad","Customer 26",24981.95]
[null,"2022-07-18","Aspen","Customer 8",32145.360000000001]
[null,"2022-07-24","Quad","Customer 20",36503.57]
[null,"2022-07-05","Quad","Customer 3",13142.83]
[null,"2022-07-03","Quad","Customer 14",11197.38]
[null,"2022-07-03","Quad","Customer 15",11498.82]
[null,"2022-07-09","Aspen","Customer 6",16502.87]
[null,"2022-07-08","Carlota","Customer 24",45111.96]
[null,"2022-07-07","Yanaki","Customer 1",17126.05]
[null,"2022-07-31","Aspen","Customer 17",44088.86]
[null,"2022-07-23","Carlota","Customer 18",12508.49]
[null,"2022-07-15","Quad","Customer 2",20214.48]
[null,"2022-07-11","Carlota","Customer 12",47044.93]
[null,"2022-07-27","Quad","Customer 27",53428.75]
[null,"2022-07-06","Yanaki","Customer 23",40460.959999999999]
[null,"2022-07-27","Aspen","Customer 1",40221.06]
[null,"2022-07-24","Carlota","Customer 4",46538.78]
[null,"2022-07-20","Aspen","Customer 13",45051.99]
[null,"2022-07-28","Aspen","Customer 21",20479.189999999999]
[null,"2022-07-17","Quad","Customer 5",16727.59]
[null,"2022-07-09","Quad","Customer 13",32913.74]
[null,"2022-07-20","Quad","Customer 23",21870.240000000002]
[null,"2022-07-25","Carlota","Customer 21",22275.29]
[null,"2022-07-16","Quad","Customer 25",51974.720000000001]
[null,"2022-07-27","Yanaki","Customer 23",35437.43]
[null,"2022-07-10","Aspen","Customer 9",27940.81]
[null,"2022-07-27","Carlota","Customer 3",11967.16]
[null,"2022-07-10","Quad","Customer 13",37356.25]
[null,"2022-07-06","Carlota","Customer 5",27474.82]
[null,null,null,null,null,null,"2022-07-29","Yanaki","Customer 21",18020.810000000001]
[null,null,null,null,null,null,"2022-07-14","Aspen","Customer 22",12150.4]
[null,null,null,null,null,null,"2022-07-25","Aspen","Customer 12",35545.25]
[null,null,null,null,null,null,"2022-07-15","Carlota","Customer 2",52252.04]
[null,null,null,null,null,null,"2022-07-18","Yanaki","Customer 24",19660.14]
[null,null,null,null,null,null,"2022-07-05","Carlota","Customer 17",25518.5]
[null,null,null,null,null,null,"2022-07-23","Yanaki","Customer 16",21918.01]
[null,null,null,null,null,null,"2022-07-15","Carlota","Customer 7",42817.63]
[null,null,null,null,null,null,"2022-07-18","Quad","Customer 26",71123.28]
[null,null,null,null,null,null,"2022-07-09","Carlota","Customer 16",11671.9]
[null,null,null,null,null,null,"2022-07-25","Sunshine","Customer 9",49962.37]
[null,null,null,null,null,null,"2022-07-08","Aspen","Customer 27",44583.8]
[null,null,null,null,null,null,"2022-07-26","Sunshine","Customer 4",31253.16]
[null,null,null,null,null,null,"2022-07-07","Carlota","Customer 25",97008.74]
[null,null,null,null,null,null,"2022-07-12","Yanaki","Customer 1",25540.23]
[null,null,null,null,null,null,"2022-07-16","Sunshine","Customer 23",54182.63]
[null,null,null,null,null,null,"2022-07-08","Quad","Customer 19",45047.97]

{"sheet":"P(5)","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"At Highline College, August 16, 2024 is that last day of summer quarter. September 23, 2024 is the first day of fall quarter. This means that summer break runs from August 17, 2024 to September 22, 2024. "]
[null,"If you have to work 14 days during this summer break, how many days of summer break do you get?"]
[null,"Hint: Total summer break days = Later Date - Earlier Date = Sep 22, 2024 - August 16, 2024."]
[null,"Build a model that calculates how many days of vacation you have."]
[null,"Be sure to follow Excel's Golden Rule and build an Excel Model to solve this problem."]
[null,"Do not copy and paste work previously done."]
[null,"Do not ask for help with test or work with others on test."]
[null,"It is OK to re-watch class videos, read pdf notes, look at the Excel files for this class, or contact Michael Girvin with questions: mgirvin@highline.edu, 206-592-3562, or office 29-307."]