{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Topics","W & D Numbers","Write It","Write It (an)","Round By Hand","Excel ROUND","Excel ROUND (an)","Add&Subtract","Add&Subtract (an)","Multiple&Divide","Multiple&Divide (an)","Exponents","OOO","Exponents (an)","Word","W(1)","W(1an)","W(2)","W(2an)","HW Answers MGirvin Created== >>","1.1","1.2","1.3","1.4","1.5"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":1,"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":"Topics","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Topics:"]
["Whole Numbers and Decimals"]
["Rounding"]
["Add"]
["Subtract"]
["Multiply"]
["Divide"]
["Exponents"]
["Order of Operations"]
["Word (Application) Problems"]

{"sheet":"W & D Numbers","index":1,"n_rows":7,"n_cols":22,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,16,0,21]]}
["Whole Numbers: numbers to the left of the decimal point. Uses the ten one-place digits: 0,1,2,3,4,5,6,7,8,9. Use a comma every third place.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The word \"and\" goes here when you write the words.","Decimals: numbers to the right of the decimal point - representing parts of a whole - \"a whole\" is the number 1 and the \"part\" is a number between 1 and 0."]
["Trillions",null,null,"Billions",null,null,"Millions",null,null,"Thousands",null,null,"Ones",null,null,"\"AND\""]
[{"$f":"\"Hundred \"&A2","v":"Hundred Trillions"},{"$f":"\"Ten \"&A2","v":"Ten Trillions"},{"$f":"A2","v":"Trillions"},{"$f":"\"Hundred \"&D2","v":"Hundred Billions"},{"$f":"\"Ten \"&D2","v":"Ten Billions"},{"$f":"D2","v":"Billions"},{"$f":"\"Hundred \"&G2","v":"Hundred Millions"},{"$f":"\"Ten \"&G2","v":"Ten Millions"},{"$f":"G2","v":"Millions"},{"$f":"\"Hundred \"&J2","v":"Hundred Thousands"},{"$f":"\"Ten \"&J2","v":"Ten Thousands"},{"$f":"J2","v":"Thousands"},"Hundreds","Tens","Ones","Decimal Point (and)","Tenths","Hundredths","Thousandths","Ten-Thousandths","Hundred-Thousandths","Millionths"]
[null,null,null,4,5,6,7,5,8,4,5,2,1,1,9,"■",1,5,5]
[]
["Define Whole Number ==> A number with no decimals, such as 5,678"]
["Define Decimal ==> A number written with a decimal such as 4.987 or 0.062"]

{"sheet":"Write It","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Number","Write it"]
[5215.29]
[456758452119.15997]

{"sheet":"Write It (an)","index":3,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Number","Write it",null,"Spell Number Function:"]
[5215.29,"Five thousand, two hundred fifteen dollars and twenty nine cents --"]
[456758452119.15503,"Four hundred fifty six billion, seven hundred fifty eight million, four hundred fifty two thousand, one hundred nineteen dollars and sixteen cents --"]
[]
[456758452119.15997]

{"sheet":"Round By Hand","index":4,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Rounding"]
["Why do we have to round?"]
[]
["Example 1:",null,null,"Because with money we do not have partial pennies,"]
["Gas Cost",3.7989999999999999,null,"for example gas costs $3.799 per gallon"]
[]
["Example 2:",null,null,"When you have calculated your Income Taxes to be"]
["Income Tax",567.34,null,"$567.34, how much should you pay (Income Tax you"]
[null,null,null,"round to the dollar)?"]
["Example 3:"]
["Debt =",4567897,null,"Financial Statements sometimes must be rounded to"]
[null,null,null,"the Thousands."]
[]
["Rounding by Hand Rules:"]
["1) Select the position you would like to round to, we'll call it \"selected position\""]
["2) Look at the number to the right of the selected position:"]
["If it is 5 or bigger (5, 6, 7, 8, 9), add 1 to the selected position and drop all the decimals"]
["to the right of the selected position."]
["If it is less than 5 (4, 3, 2, 1), drop all the decimals to the right of the selected position."]
["3) If numbers to drop are whole numbers, instead of dropping them convert them to zeros"]
[]
["Example 1: Buy 1 gallon of gas at $3.799, how much do you pay?"]
["Number =",3.7989999999999999]
["Step 1:","$3.79 | 9",null,"Select the position you would like to round to, we'll call it \"selected position\""]
["Step 2:",9,null,"Look at the number to the right of the selected position"]
[null,"Is 9 >= 5?",null,"TRUE, so we add 1 to the selected position and drop all the decimals to the"]
[null,null,null,"right of the selected position."]
[{"$f":"B23","v":3.7989999999999999}," ==>> ",{"$f":"ROUND(A28,2)","v":3.8}]
[]
["**Note: Don't get tricked by Number Formatting. If you type $3.799 into a cell the Currency Auto Format feature will"]
["\"show\" only two decimals and the resulting number will be $3.80. The solution is to immediately increase decimals. Try it:"]
[]
["Type Number:",3.7989999999999999]
[]
["Example 2: Income Taxes are $567.34, you must round to the dollar."]
["Number =",567.34]
["Step 1:","$567 | .34",null,"Select the position you would like to round to, we'll call it \"selected position\""]
["Step 2:",3,null,"Look at the number to the right of the selected position"]
[null,"Is 3 < 5?",null,"TRUE, so we drop all the decimals to the right of the selected position."]
[]
[{"$f":"B36","v":567.34}," ==>> ",{"$f":"ROUND(A41,0)","v":567}]
[]
["Example 3: Financial Statements sometimes must be rounded to the thousands position"]
["Debt =",4567897,null,"Select the position you would like to round to, we'll call it \"selected position\""]
["Step 1:","$4,567 | ,897",null,"Look at the number to the right of the selected position"]
["Step 2:",8,null,"TRUE, so we convert all the digits to the right of the selected position to zeros."]
[null,"Is 8 >= 5?"]
[null,null,null,null,"($000)","In Thousands"]
[{"$f":"B44","v":4567897}," ==>> ",{"$f":"ROUND(A49,-3)","v":4568000},null,4658]
[]
["LUCKILY, WE WILL NEVER HAVE TO ROUND BY HAND AGAIN!!!!!"]
["However, we will have to learn Excel's Rules For Rounding!"]

{"sheet":"Excel ROUND","index":5,"n_rows":178,"n_cols":7,"rows_kept":178,"cut":false,"hidden":false,"merged":[]}
["Example 1:","$3.799 ==> use 2 because it is the penny position.","ROUND Function",null,"Because with money we do not have partial pennies,"]
["Gas Cost",3.7989999999999999,null,null,"for example gas costs $3.799 per gallon"]
[]
["Example 2:","$567.34 ==> use 0 because it is the ones position.","ROUND Function",null,"When you have calculated your Income Taxes to be"]
["Income Tax",567.34,null,null,"$567.34, how much should you pay (Income Tax you"]
[null,null,null,null,"round to the dollar)?"]
["Example 3:","$4,567,897 ==> use -3 because it is the thousands position.","ROUND Function"]
["Debt =",4567897,null,null,"Financial Statements sometimes must be rounded to"]
[null,null,null,null,"the Thousands."]
["See the pattern?"]
[]
["ROUND function"]
["The Excel ROUND function can round any number for you as long as you tell it the position to round"]
["to (\"Selected Position\")"]
["Excel uses numbers to indicate the selected position."]
["ROUND function has to arguments: =ROUND(number, num_digits)"]
["number argument can be a number or a formula"]
["num_digits is an integer, like ...-3, -2, -1, 0, 1, 2, 3, 4..."]
["Memorization trick: just remember that the penny position is 2, then if you move to the right add 1, to the left subtract 1."]
[]
["Practice:"]
["Purpose","Number","Rounded Number"]
["Invoice Total",120.589,null,"to penny",2]
["Payroll Deduction",237.35119499999999,null,"to penny",2]
["Income Tax",1250.5999999999999,null,"to dollar",0]
["Financial Statement",23589511478,null,"to millions",-6]
[]
["Here's what to watch out for:"]
[]
["Using Number Formatting to try to round will NOT work:"]
["Income Taxes w Number Format","Income Taxes typed in what we see","Income Taxes without Number Formatting","Income Taxes with ROUND"]
[45.5]
[100.9]
[25.5]
[]
[]
["Here is why ROUND is sooooo Amazing:"]
[]
["Name","Gross Pay","Tax Deduction",null,"Tax Rate",null,"In the Old Days We Had To Round Each Number by Hand"]
["Dillon J",3228.15,null,null,7.6499999999999999E-2,null,{"$f":"B40*$E$40","v":246.953475}]
["Ian R",2820.44,null,null,null,null,215.76365999999999]
["Sarah",2856.12,null,null,null,null,218.49318]
["Maria G",3102.63,null,null,null,null,237.35119499999999]
["Daniel",2981.29,null,null,null,null,228.06868499999999]
["Bayram M",3151.47,null,null,null,null,241.08745499999998]
["Elizabeth A",3099.62,null,null,null,null,237.12092999999999]
["Rose",3205.85,null,null,null,null,245.247525]
["Deanna F",3128.79,null,null,null,null,239.35243499999999]
["Tynia M",3231.08,null,null,null,null,247.17761999999999]
["Stefanie K",3027.82,null,null,null,null,231.62823]
["Ernesa",2855.81,null,null,null,null,218.46946499999999]
["Tyler R",2803.38,null,null,null,null,214.45857000000001]
["George S",3033.64,null,null,null,null,232.07345999999998]
["Heidi A",3243.76,null,null,null,null,248.14764000000002]
["Janet M",2840.3,null,null,null,null,217.28295]
["Jonathan D",2837.05,null,null,null,null,217.03432500000002]
["Gurdeep",3031.62,null,null,null,null,231.91892999999999]
["Seneva R",3218.43,null,null,null,null,246.20989499999999]
["Anjula",3082,null,null,null,null,235.773]
["John",3135.6,null,null,null,null,239.87339999999998]
["Aisha R",3265.42,null,null,null,null,249.80463]
["Thu Thi Ngoc",3006.32,null,null,null,null,229.98348000000001]
["Pranee",2926.19,null,null,null,null,223.85353499999999]
["Ariel E",2893.55,null,null,null,null,221.35657500000002]
["Tabitha K",3086.33,null,null,null,null,236.10424499999999]
["Dana M",3124.48,null,null,null,null,239.02271999999999]
["Jane L",2955.86,null,null,null,null,226.12329]
["Maninder J",3096.47,null,null,null,null,236.87995499999997]
["Jerilyn S",2922.97,null,null,null,null,223.60720499999999]
["Kimberlee",3106.55,null,null,null,null,237.65107500000002]
["Lizaelle M",3043.55,null,null,null,null,232.83157500000002]
["Chad M",2819.43,null,null,null,null,215.68639499999998]
["Lisa L",2816.33,null,null,null,null,215.44924499999999]
["Roy J",3213.87,null,null,null,null,245.86105499999999]
["Aaron D",3290.74,null,null,null,null,251.74160999999998]
[]
["Here is why this is sooooo Important:"]
[]
["Name","Gross Pay","Tax Deduction",null,"Tax Rate",null,"In the Old Days We Had To Round Each Number by Hand"]
["Dillon J",3228.15,null,null,7.6499999999999999E-2,null,{"$f":"B80*$E$80","v":246.953475}]
["Ian R",2820.44,null,null,null,null,{"$f":"B81*$E$80","v":215.76365999999999}]
["Sarah",2856.12,null,null,null,null,218.49318]
["Maria G",3102.63,null,null,null,null,237.35119499999999]
["Daniel",2981.29,null,null,null,null,228.06868499999999]
["Bayram M",3151.47,null,null,null,null,241.08745499999998]
["Elizabeth A",3099.62,null,null,null,null,237.12092999999999]
["Rose",3205.85,null,null,null,null,245.247525]
["Deanna F",3128.79,null,null,null,null,239.35243499999999]
["Tynia M",3231.08,null,null,null,null,247.17761999999999]
["Stefanie K",3027.82,null,null,null,null,231.62823]
["Ernesa",2855.81,null,null,null,null,218.46946499999999]
["Tyler R",2803.38,null,null,null,null,214.45857000000001]
["George S",3033.64,null,null,null,null,232.07345999999998]
["Heidi A",3243.76,null,null,null,null,248.14764000000002]
["Janet M",2840.3,null,null,null,null,217.28295]
["Jonathan D",2837.05,null,null,null,null,217.03432500000002]
["Gurdeep",3031.62,null,null,null,null,231.91892999999999]
["Seneva R",3218.43,null,null,null,null,246.20989499999999]
["Anjula",3082,null,null,null,null,235.773]
["John",3135.6,null,null,null,null,239.87339999999998]
["Aisha R",3265.42,null,null,null,null,249.80463]
["Thu Thi Ngoc",3006.32,null,null,null,null,229.98348000000001]
["Pranee",2926.19,null,null,null,null,223.85353499999999]
["Ariel E",2893.55,null,null,null,null,221.35657500000002]
["Tabitha K",3086.33,null,null,null,null,236.10424499999999]
["Dana M",3124.48,null,null,null,null,239.02271999999999]
["Jane L",2955.86,null,null,null,null,226.12329]
["Maninder J",3096.47,null,null,null,null,236.87995499999997]
["Jerilyn S",2922.97,null,null,null,null,223.60720499999999]
["Kimberlee",3106.55,null,null,null,null,237.65107500000002]
["Lizaelle M",3043.55,null,null,null,null,232.83157500000002]
["Chad M",2819.43,null,null,null,null,215.68639499999998]
["Lisa L",2816.33,null,null,null,null,215.44924499999999]
["Roy J",3213.87,null,null,null,null,245.86105499999999]
["Aaron D",3290.74,null,null,null,null,251.74160999999998]
[]
[]
["For Payroll and Invoicing and other Business Money Calculations that require that you round, if"]
["you don't round and you calculate the incorrect number, people will not trust your ability to"]
["make calculations accurately."]
[]
["Rules for when you MUST use ROUND function:"]
["1) You are required to round (no unit of money smaller than a penny, income taxes, etc.)"]
["2) You will use formula result in subsequent formula"]
["3) If the numbers are already rounded, don't use the ROUND function (like for the SUM"]
["function when all the numbers being added are already rounded."]
[]
["Note: If you make a calculation, but you will never use the formula result in subsequent"]
["calculations, formatting to see only two decimals will suffice."]
[]
["Tax Rate","Gross","Tax Deduction"]
[7.6499999999999999E-2,5248.25,null,"<<== If you were just going to look at the number"]
[null,null,null,"and write it on paper, Number Formatting is fine."]
[]
["Tax Rate","Gross","Tax Deduction",null,"ROUND"]
[1.4500000000000001E-2,507.47]
[null,145.88999999999999]
[null,29.7]
[null,null,null,null,null,null,"<< Don't need to use"]
[null,null,"< <",null,null,null,"ROUND for SUM"]
[null,null,"But if the formula result will be used in subsequent"]
[null,null,"formulas, you must use ROUND."]
[]
["Homework type problem:"]
[]
["Problem","Number","Rounded To Penny"]
[37,5.056]
[38,375.00299999999999]
[39,42.137]
[40,8.0000000000000002E-3]
[41,1.9950000000000001]
[42,16.518999999999998]
[43,382.005]
[44,0.84599999999999997]
[45,1.5002]
[46,28.994]
[47,32.493000000000002]
[48,12802.965]
[49,1.5E-3]
[50,7.6009000000000002]
[51,752.798]
["Total",null,null,null,"<< Don't need to use ROUND for SUM"]
[]
[]
["One Last Things:"]
[]
["When in doubt about whether to round, maybe look at Number"]
["Formatting (Apply General Number Formatting) and see whether or not"]
["the numbers need to be rounded:"]
[]
[null,"Numbers (no requirement to round",null,"Dollars that will be added",null,null,"Dollars that have been Rounded"]
[null,480.42169999999999,null,{"$f":"B172","v":480.42169999999999}]
[null,736.41890000000001,null,736.41890000000001]
[null,661.93280000000004,null,661.93280000000004]
[null,866.55499999999995,null,866.55499999999995]
[null,101.80110000000001,null,101.80110000000001]
[null,172.345,null,172.345]
["Total",null,"Total"]

{"sheet":"Excel ROUND (an)","index":6,"n_rows":178,"n_cols":7,"rows_kept":178,"cut":false,"hidden":false,"merged":[]}
["Example 1:","$3.799 ==> use 2 because it is the penny position.","ROUND Function",null,"Because with money we do not have partial pennies,"]
["Gas Cost",3.7989999999999999,{"$f":"ROUND(B2,2)","v":3.8},null,"for example gas costs $3.799 per gallon"]
[]
["Example 2:","$567.34 ==> use 0 because it is the ones position.","ROUND Function",null,"When you have calculated your Income Taxes to be"]
["Income Tax",567.34,{"$f":"ROUND(B5,0)","v":567},null,"$567.34, how much should you pay (Income Tax you"]
[null,null,null,null,"round to the dollar)?"]
["Example 3:","$4,567,897 ==> use -3 because it is the thousands position.","ROUND Function"]
["Debt =",4567897,{"$f":"ROUND(B8,-3)","v":4568000},null,"Financial Statements sometimes must be rounded to"]
[null,null,null,null,"the Thousands."]
["See the pattern?"]
[]
["ROUND function"]
["The Excel ROUND function can round any number for you as long as you tell it the position to round"]
["to (\"Selected Position\")"]
["Excel uses numbers to indicate the selected position."]
["ROUND function has to arguments: =ROUND(number, num_digits)"]
["number argument can be a number or a formula"]
["num_digits is an integer, like ...-3, -2, -1, 0, 1, 2, 3, 4..."]
["Memorization trick: just remember that the penny position is 2, then if you move to the right add 1, to the left subtract 1."]
[]
["Practice:"]
["Purpose","Number","Rounded Number"]
["Invoice Total",120.589,{"$f":"ROUND(B23,2)","v":120.59},"to penny",2]
["Payroll Deduction",237.35119499999999,{"$f":"ROUND(B24,2)","v":237.35},"to penny",2]
["Income Tax",1250.5999999999999,{"$f":"ROUND(B25,0)","v":1251},"to dollar",0]
["Financial Statement",23589511478,{"$f":"ROUND(B26,-6)","v":23590000000},"to millions",-6]
[]
["Here's what to watch out for:"]
[]
["Using Number Formatting to try to round will NOT work:"]
["Income Taxes w Number Format","Income Taxes typed in what we see","Income Taxes without Number Formatting","Income Taxes with ROUND"]
[45.5,46,{"$f":"A32","v":45.5},{"$f":"ROUND(C32,0)","v":46}]
[100.9,101,100.9,{"$f":"ROUND(C33,0)","v":101}]
[25.5,26,25.5,26]
[{"$f":"SUM(A32:A34)","v":171.9},{"$f":"SUM(B32:B34)","v":173},171.9,{"$f":"SUM(D32:D34)","v":173}]
[]
["Here is why ROUND is sooooo Amazing:"]
[]
["Name","Gross Pay","Tax Deduction",null,"Tax Rate",null,"In the Old Days We Had To Round Each Number by Hand"]
["Dillon J",3228.15,{"$f":"ROUND(B40*$E$40,2)","v":246.95},null,7.6499999999999999E-2,null,{"$f":"B40*$E$40","v":246.953475}]
["Ian R",2820.44,{"$f":"ROUND(B41*$E$40,2)","v":215.76},null,null,null,215.76365999999999]
["Sarah",2856.12,218.49,null,null,null,218.49318]
["Maria G",3102.63,237.35,null,null,null,237.35119499999999]
["Daniel",2981.29,228.07,null,null,null,228.06868499999999]
["Bayram M",3151.47,241.09,null,null,null,241.08745499999998]
["Elizabeth A",3099.62,237.12,null,null,null,237.12092999999999]
["Rose",3205.85,245.25,null,null,null,245.247525]
["Deanna F",3128.79,239.35,null,null,null,239.35243499999999]
["Tynia M",3231.08,247.18,null,null,null,247.17761999999999]
["Stefanie K",3027.82,231.63,null,null,null,231.62823]
["Ernesa",2855.81,218.47,null,null,null,218.46946499999999]
["Tyler R",2803.38,214.46,null,null,null,214.45857000000001]
["George S",3033.64,232.07,null,null,null,232.07345999999998]
["Heidi A",3243.76,248.15,null,null,null,248.14764000000002]
["Janet M",2840.3,217.28,null,null,null,217.28295]
["Jonathan D",2837.05,217.03,null,null,null,217.03432500000002]
["Gurdeep",3031.62,231.92,null,null,null,231.91892999999999]
["Seneva R",3218.43,246.21,null,null,null,246.20989499999999]
["Anjula",3082,235.77,null,null,null,235.773]
["John",3135.6,239.87,null,null,null,239.87339999999998]
["Aisha R",3265.42,249.8,null,null,null,249.80463]
["Thu Thi Ngoc",3006.32,229.98,null,null,null,229.98348000000001]
["Pranee",2926.19,223.85,null,null,null,223.85353499999999]
["Ariel E",2893.55,221.36,null,null,null,221.35657500000002]
["Tabitha K",3086.33,236.1,null,null,null,236.10424499999999]
["Dana M",3124.48,239.02,null,null,null,239.02271999999999]
["Jane L",2955.86,226.12,null,null,null,226.12329]
["Maninder J",3096.47,236.88,null,null,null,236.87995499999997]
["Jerilyn S",2922.97,223.61,null,null,null,223.60720499999999]
["Kimberlee",3106.55,237.65,null,null,null,237.65107500000002]
["Lizaelle M",3043.55,232.83,null,null,null,232.83157500000002]
["Chad M",2819.43,215.69,null,null,null,215.68639499999998]
["Lisa L",2816.33,215.45,null,null,null,215.44924499999999]
["Roy J",3213.87,245.86,null,null,null,245.86105499999999]
["Aaron D",3290.74,{"$f":"ROUND(B75*$E$40,2)","v":251.74},null,null,null,251.74160999999998]
[]
["Here is why this is sooooo Important:"]
[]
["Name","Gross Pay","Tax Deduction",null,"Tax Rate",null,"In the Old Days We Had To Round Each Number by Hand"]
["Dillon J",3228.15,{"$f":"ROUND(B80*$E$80,2)","v":246.95},null,7.6499999999999999E-2,null,{"$f":"B80*$E$80","v":246.953475}]
["Ian R",2820.44,{"$f":"ROUND(B81*$E$80,2)","v":215.76},null,null,null,{"$f":"B81*$E$80","v":215.76365999999999}]
["Sarah",2856.12,218.49,null,null,null,218.49318]
["Maria G",3102.63,237.35,null,null,null,237.35119499999999]
["Daniel",2981.29,228.07,null,null,null,228.06868499999999]
["Bayram M",3151.47,241.09,null,null,null,241.08745499999998]
["Elizabeth A",3099.62,237.12,null,null,null,237.12092999999999]
["Rose",3205.85,245.25,null,null,null,245.247525]
["Deanna F",3128.79,239.35,null,null,null,239.35243499999999]
["Tynia M",3231.08,247.18,null,null,null,247.17761999999999]
["Stefanie K",3027.82,231.63,null,null,null,231.62823]
["Ernesa",2855.81,218.47,null,null,null,218.46946499999999]
["Tyler R",2803.38,214.46,null,null,null,214.45857000000001]
["George S",3033.64,232.07,null,null,null,232.07345999999998]
["Heidi A",3243.76,248.15,null,null,null,248.14764000000002]
["Janet M",2840.3,217.28,null,null,null,217.28295]
["Jonathan D",2837.05,217.03,null,null,null,217.03432500000002]
["Gurdeep",3031.62,231.92,null,null,null,231.91892999999999]
["Seneva R",3218.43,246.21,null,null,null,246.20989499999999]
["Anjula",3082,235.77,null,null,null,235.773]
["John",3135.6,239.87,null,null,null,239.87339999999998]
["Aisha R",3265.42,249.8,null,null,null,249.80463]
["Thu Thi Ngoc",3006.32,229.98,null,null,null,229.98348000000001]
["Pranee",2926.19,223.85,null,null,null,223.85353499999999]
["Ariel E",2893.55,221.36,null,null,null,221.35657500000002]
["Tabitha K",3086.33,236.1,null,null,null,236.10424499999999]
["Dana M",3124.48,239.02,null,null,null,239.02271999999999]
["Jane L",2955.86,226.12,null,null,null,226.12329]
["Maninder J",3096.47,236.88,null,null,null,236.87995499999997]
["Jerilyn S",2922.97,223.61,null,null,null,223.60720499999999]
["Kimberlee",3106.55,237.65,null,null,null,237.65107500000002]
["Lizaelle M",3043.55,232.83,null,null,null,232.83157500000002]
["Chad M",2819.43,215.69,null,null,null,215.68639499999998]
["Lisa L",2816.33,215.45,null,null,null,215.44924499999999]
["Roy J",3213.87,245.86,null,null,null,245.86105499999999]
["Aaron D",3290.74,{"$f":"ROUND(B115*$E$80,2)","v":251.74},null,null,null,251.74160999999998]
[null,null,{"$f":"SUM(C80:C115)","v":8375.41},null,null,null,{"$f":"SUM(G80:G115)","v":8375.4426149999999}]
[]
["For Payroll and Invoicing and other Business Money Calculations that require that you round, if"]
["you don't round and you calculate the incorrect number, people will not trust your ability to"]
["make calculations accurately."]
[]
["Rules for when you MUST use ROUND function:"]
["1) You are required to round (no unit of money smaller than a penny, income taxes, etc.)"]
["2) You will use formula result in subsequent formula"]
["3) If the numbers are already rounded, don't use the ROUND function (like for the SUM"]
["function when all the numbers being added are already rounded."]
[]
["Note: If you make a calculation, but you will never use the formula result in subsequent"]
["calculations, formatting to see only two decimals will suffice."]
[]
["Tax Rate","Gross","Tax Deduction"]
[7.6499999999999999E-2,5248.25,{"$f":"A132*B132","v":401.49112500000001},"<<== If you were just going to look at the number"]
[null,null,null,"and write it on paper, Number Formatting is fine."]
[]
["Tax Rate","Gross","Tax Deduction",null,"ROUND"]
[1.4500000000000001E-2,507.47,{"$f":"B136*$A$136","v":7.358315000000001},null,{"$f":"ROUND(B136*$A$136,2)","v":7.36}]
[null,145.88999999999999,{"$f":"B137*$A$136","v":2.115405},null,{"$f":"ROUND(B137*$A$136,2)","v":2.12}]
[null,29.7,0.43065000000000003,null,0.43]
[null,null,{"$f":"SUM(C136:C138)","v":9.9043700000000001},null,{"$f":"SUM(E136:E138)","v":9.91},null,"<< Don't need to use"]
[null,null,"< <",null,null,null,"ROUND for SUM"]
[null,null,"But if the formula result will be used in subsequent"]
[null,null,"formulas, you must use ROUND."]
[]
["Homework type problem:"]
[]
["Problem","Number","Rounded To Penny"]
[37,5.056,{"$f":"ROUND(B147,2)","v":5.0599999999999996}]
[38,375.00299999999999,{"$f":"ROUND(B148,2)","v":375}]
[39,42.137,42.14]
[40,8.0000000000000002E-3,0.01]
[41,1.9950000000000001,2]
[42,16.518999999999998,16.52]
[43,382.005,382.01]
[44,0.84599999999999997,0.85]
[45,1.5002,1.5]
[46,28.994,28.99]
[47,32.493000000000002,32.49]
[48,12802.965,12802.97]
[49,1.5E-3,0]
[50,7.6009000000000002,7.6]
[51,752.798,752.8]
["Total",{"$f":"SUM(B147:B161)","v":14449.9216},{"$f":"SUM(C147:C161)","v":14449.939999999999},null,"<< Don't need to use ROUND for SUM"]
[]
[]
["One Last Things:"]
[]
["When in doubt about whether to round, maybe look at Number"]
["Formatting (Apply General Number Formatting) and see whether or not"]
["the numbers need to be rounded:"]
[]
[null,"Numbers (no requirement to round",null,"Dollars that will be added",null,null,"Dollars that have been Rounded"]
[null,480.42169999999999,null,{"$f":"B172","v":480.42169999999999},null,null,{"$f":"ROUND(D172,2)","v":480.42}]
[null,736.41890000000001,null,736.41890000000001,null,null,{"$f":"ROUND(D173,2)","v":736.42}]
[null,661.93280000000004,null,661.93280000000004,null,null,661.93]
[null,866.55499999999995,null,866.55499999999995,null,null,866.56]
[null,101.80110000000001,null,101.80110000000001,null,null,101.8]
[null,172.345,null,172.345,null,null,172.35]
["Total",{"$f":"SUM(B172:B177)","v":3019.4744999999998},"Total",{"$f":"SUM(D172:D177)","v":3019.4744999999998},null,null,{"$f":"SUM(G172:G177)","v":3019.48}]

{"sheet":"Add&Subtract","index":7,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["Adding"]
[]
["Name","Gross Pay","Tax Deduction",null,"Tax Rate"]
["Dillon J",804,null,null,7.6499999999999999E-2]
["Ian R",761]
["Sarah",1125]
["Maria G",1070]
["Daniel",985]
["Bayram M",872]
["Elizabeth A",809]
["Rose",856]
["Deanna F",982]
["Tynia M",1074]
["Stefanie K",982]
["Ernesa",1176]
["Tyler R",1123]
["George S",1099]
["Heidi A",815]
["Janet M",843]
["Jonathan D",872]
["Gurdeep",902]
["Seneva R",1004]
["Anjula",1107]
["John",1040]
["Aisha R",1135]
["Thu Thi Ngoc",800]
["Pranee",1199]
["Ariel E",1156]
["Tabitha K",1144]
["Dana M",919]
["Jane L",1227]
["Maninder J",931]
["Jerilyn S",1071]
["Kimberlee",922,null,null,"IF NUMBERS REQUIRE ROUNDING, BE  SURE TO ROUND"]
["Lizaelle M",1206,null,null,"NUMBERS BEFORE ADDING!!!!!"]
["Chad M",1090]
["Lisa L",1117,null,null,"Efficient to use SUM function because: 1) Fast. 2) Can"]
["Roy J",752,null,null,"handle structural changes like inserting a row."]
["Aaron D",842]
[null,null,null,{"$f":"C4+C5+C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29+C30+C31+C32+C33+C34+C35+C36+C37+C38+C39","v":0}]
[]
["Invoice 12305","Amount",null,"Invoice 12332","Amount",null,"Invoice 12288","Amount",null,null,null,"Sales",null,"Sales",null,"Sales"]
["Product 1",45.32,null,"Product 1",90.43,null,"Product 1",37.630000000000003,null,null,null,6,null,8,null,5]
["Product 2",50,null,"Product 2",53.13,null,"Product 2",91.24,null,null,null,17,null,10,null,15]
["Product 3",69.3,null,"Product 3",78.62,null,"Product 3",39.020000000000003,null,null,null,19,null,9,null,15]
["Product 4",43.96,null,"Product 4",105.7,null,"Product 4",106.94,null,null,null,16,null,2,null,14]
["Product 5",102,null,"Product 5",73.7,null,"Product 5",49.38,null,null,null,12,null,12,null,5]
["Total",null,null,"Total",null,null,"Total",null,null,null,null,12,null,6,null,13]
[null,null,null,null,null,null,null,null,null,null,null,19,null,1,null,6]
["Total",null,null,null,null,null,null,null,null,null,null,20,null,7,null,6]
[null,"or",null,"Okay to use + + + + or SUM(,,,,) when cells are not next to each other."]
[null,null,null,null,null,null,null,null,null,null,null,"Total"]
[]
["$ in Thousands ($000)"]
["Department","Jan","Feb","Mar","Apr","May","Jun","Total"]
["Household"]
["Grocery"]
["Sport"]
["Garden"]
["Total"]
[]
["Highlight rectangular region in advance and use the Enter key to move down and across columns!"]
["To put SUM everywhere, highlighting 1 row below the numbers and 1 row to the right of the numbers, and then evoke"]
["keyboard for SUM function: Alt + ="]
[]
[]
["Subtracting",null,null,null,null,"To be Efficient with subtraction when you"]
[null,null,null,null,null,"have many deductions is to add up all the"]
["Total Revenue",5625896,null,null,null,"subtractions into one number and then"]
["Total Expenses",4985623,null,null,null,"subtract that one number"]
["Net Income",null,null,null,null,"<","<","<"]
[null,null,null,null,null,null,"Efficient","Not Efficient"]
["Name","Gross","Deduction 1","Deduction 2","Deduction 3","Total","Net Pay","Net Pay"]
["Sioux",754,{"$f":"ROUND($B74*C$80,2)","v":46.75},10.93,75.400000000000006]
["Sue",822,50.96,11.92,82.2]
["Jo",867,53.75,12.57,86.7]
["Joe",939,58.22,13.62,93.9]
[]
[null,null,"FICA","Medicare","Fed"]
[null,null,6.2E-2,1.4500000000000001E-2,0.1]
[]
["Income Statement ($000)"]
["Revenue:",null,null,"<<== Revenue means funds coming into"]
["Sales Revenue",500,null,"business"]
["Returns and Allowances",5]
["Net Revenue"]
[]
["Expenses:",null,null,"<<== Expenses means funds coming out of"]
["COGS",315,null,"business"]
["Wages",95]
["Lease Expense",55]
["Operations",41]
["Misc Expenses",12]
["Total Expenses"]
["Net Income",null,null,"<<== Net Income is a synonym for \"Profit\","]
[null,null,null,"\"Earnings\", \"Amount Left Over\""]

{"sheet":"Add&Subtract (an)","index":8,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":false,"merged":[]}
["Adding"]
[]
["Name","Gross Pay","Tax Deduction",null,"Tax Rate"]
["Dillon J",804,{"$f":"ROUND(B4*$E$4,2)","v":61.51},null,7.6499999999999999E-2]
["Ian R",761,{"$f":"ROUND(B5*$E$4,2)","v":58.22}]
["Sarah",1125,86.06]
["Maria G",1070,81.86]
["Daniel",985,75.349999999999994]
["Bayram M",872,66.709999999999994]
["Elizabeth A",809,61.89]
["Rose",856,65.48]
["Deanna F",982,75.12]
["Tynia M",1074,82.16]
["Stefanie K",982,75.12]
["Ernesa",1176,89.96]
["Tyler R",1123,85.91]
["George S",1099,84.07]
["Heidi A",815,62.35]
["Janet M",843,64.489999999999995]
["Jonathan D",872,66.709999999999994]
["Gurdeep",902,69]
["Seneva R",1004,76.81]
["Anjula",1107,84.69]
["John",1040,79.56]
["Aisha R",1135,86.83]
["Thu Thi Ngoc",800,61.2]
["Pranee",1199,91.72]
["Ariel E",1156,88.43]
["Tabitha K",1144,87.52]
["Dana M",919,70.3]
["Jane L",1227,93.87]
["Maninder J",931,71.22]
["Jerilyn S",1071,81.93]
["Kimberlee",922,70.53,null,"IF NUMBERS REQUIRE ROUNDING, BE  SURE TO ROUND"]
["Lizaelle M",1206,92.26,null,"NUMBERS BEFORE ADDING!!!!!"]
["Chad M",1090,83.39]
["Lisa L",1117,85.45,null,"Efficient to use SUM function because: 1) Fast. 2) Can"]
["Roy J",752,57.53,null,"handle structural changes like inserting a row."]
["Aaron D",842,{"$f":"ROUND(B39*$E$4,2)","v":64.41}]
[null,null,{"$f":"SUM(C4:C39)","v":2739.6199999999994},{"$f":"C4+C5+C6+C7+C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19+C20+C21+C22+C23+C24+C25+C26+C27+C28+C29+C30+C31+C32+C33+C34+C35+C36+C37+C38+C39","v":2739.6199999999994}]
[]
["Invoice 12305","Amount",null,"Invoice 12332","Amount",null,"Invoice 12288","Amount",null,null,null,"Sales",null,"Sales",null,"Sales"]
["Product 1",45.32,null,"Product 1",90.43,null,"Product 1",37.630000000000003,null,null,null,6,null,8,null,5]
["Product 2",50,null,"Product 2",53.13,null,"Product 2",91.24,null,null,null,17,null,10,null,15]
["Product 3",69.3,null,"Product 3",78.62,null,"Product 3",39.020000000000003,null,null,null,19,null,9,null,15]
["Product 4",43.96,null,"Product 4",105.7,null,"Product 4",106.94,null,null,null,16,null,2,null,14]
["Product 5",102,null,"Product 5",73.7,null,"Product 5",49.38,null,null,null,12,null,12,null,5]
["Total",{"$f":"SUM(B43:B47)","v":310.58000000000004},null,"Total",{"$f":"SUM(E43:E47)","v":401.58},null,"Total",{"$f":"SUM(H43:H47)","v":324.21000000000004},null,null,null,12,null,6,null,13]
[null,null,null,null,null,null,null,null,null,null,null,19,null,1,null,6]
["Total",{"$f":"B48+E48+H48","v":1036.3700000000001},null,null,null,null,null,null,null,null,null,20,null,7,null,6]
[null,"or",null,"Okay to use + + + + or SUM(,,,,) when cells are not next to each other."]
[null,{"$f":"SUM(B48,E48,H48)","v":1036.3700000000001},{"$f":"SUM(B48,E48,H48)","v":1036.3700000000001},null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(L43:L50,N43:N50,P43:P50)","v":255}]
[]
["$ in Thousands ($000)"]
["Department","Jan","Feb","Mar","Apr","May","Jun","Total"]
["Household",10,20,60,6,5,5,{"$f":"SUM(B56:G56)","v":106}]
["Grocery",20,20,5,6,4,5,{"$f":"SUM(B57:G57)","v":60}]
["Sport",30,30,8,6,4,45,{"$f":"SUM(B58:G58)","v":123}]
["Garden",50,50,9,5,5,78,{"$f":"SUM(B59:G59)","v":197}]
["Total",{"$f":"SUM(B56:B59)","v":110},120,82,23,18,133,{"$f":"SUM(B60:G60)","v":486}]
[]
["Highlight rectangular region in advance and use the Enter key to move down and across columns!"]
["To put SUM everywhere, highlighting 1 row below the numbers and 1 row to the right of the numbers, and then evoke"]
["keyboard for SUM function: Alt + ="]
[]
[]
["Subtracting",null,null,null,null,"To be Efficient with subtraction when you"]
[null,null,null,null,null,"have many deductions is to add up all the"]
["Total Revenue",5625896,null,null,null,"subtractions into one number and then"]
["Total Expenses",4985623,null,null,null,"subtract that one number"]
["Net Income",{"$f":"B69-B70","v":640273},null,null,null,"<","<","<"]
[null,null,null,null,null,null,"Efficient","Not Efficient"]
["Name","Gross","Deduction 1","Deduction 2","Deduction 3","Total","Net Pay","Net Pay"]
["Sioux",754,{"$f":"ROUND($B74*C$80,2)","v":46.75},10.93,75.400000000000006,{"$f":"SUM(C74:E74)","v":133.08000000000001},{"$f":"B74-F74","v":620.91999999999996},{"$f":"B74-C74-D74-E74","v":620.92000000000007}]
["Sue",822,50.96,11.92,82.2,{"$f":"SUM(C75:E75)","v":145.08000000000001},{"$f":"B75-F75","v":676.92},{"$f":"B75-C75-D75-E75","v":676.92}]
["Jo",867,53.75,12.57,86.7,153.01999999999998,713.98,713.9799999999999]
["Joe",939,58.22,13.62,93.9,165.74,773.26,773.26]
[]
[null,null,"FICA","Medicare","Fed"]
[null,null,6.2E-2,1.4500000000000001E-2,0.1]
[]
["Income Statement ($000)"]
["Revenue:",null,null,"<<== Revenue means funds coming into"]
["Sales Revenue",500,null,"business"]
["Returns and Allowances",5]
["Net Revenue",{"$f":"SUM(B84:B85)","v":505}]
[]
["Expenses:",null,null,"<<== Expenses means funds coming out of"]
["COGS",315,null,"business"]
["Wages",95]
["Lease Expense",55]
["Operations",41]
["Misc Expenses",12]
["Total Expenses",{"$f":"SUM(B89:B93)","v":518}]
["Net Income",{"$f":"B86-B94","v":-13},null,"<<== Net Income is a synonym for \"Profit\","]
[null,null,null,"\"Earnings\", \"Amount Left Over\""]

{"sheet":"Multiple&Divide","index":9,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Invoice # 3456"]
["Product","Number Bought","Price Each","Total"]
["Part 10022",23,0.76500000000000001,null,null,"<<== When multiplying decimals, we are likely to get"]
["Part 3499",52,1,null,null,"a bunch of decimals that will require rounding"]
["Part 33489",61,2.5499999999999998]
[]
[null,null,"Subtotal",null,null,"Tax Rate"]
[null,null,"Tax",null,null,9.8500000000000004E-2]
[null,null,"Total"]
[]
[]
["Chapter 7: Series Discounts: Require that you multiply more than two items"]
[]
["Discount 1",0.8,null,"Discount 1",0.65,null,"\"Product\" means \"Answer Result from"]
["Discount 2",0.9,null,"Discount 2",0.8,null,"Multiplying."]
["Discount 3",0.9,null,"Discount 3",0.85,null,"<<==  Occasionally, the PRODUCT function"]
["Net Cost Equivalent",null,{"$f":"B14*B15*B16","v":0.64800000000000013},"Net Cost Equivalent",null,null,"may come in handy when you have a"]
[null,null,null,null,null,null,"bunch of numbers to multiply"]
[]
["Chapter 3: Compare Parts to Whole, we use Division"]
[]
["Student Name","Student Score","Compare Your Score To Max Doing Division",null,"Max points for class"]
["Jo",362,null,null,500]
["Joe",500]
["Sioux",396]
["Sue",477]
["Chin",453]
["Sheliadawn",454]
[]
["Expense for Week",2955,null,"<<== Keyboard for \"Current\" Number Format = Ctrl + Shift + 4"]
["Daily Expense",null,null,"<< == Numbers that will never change can be typed into formulas."]
[]
[]
["** Dividing by zero not allowed because \"How many"]
["Zeroes are in a number???\""]
[]
["Numerator","Denominator","Quotient (answer)"]
[10,2]
[]
["Example of Remainder, Fraction, Decimal:"]
[]
["Long Hand Division",null,null,null,null,"Check"]
["Numerator","Denominator",null,126,null,24]
[126,24,null,24,"Whole Number"]
[]
[null,null,null,null,"Remainder"]
[]
["Numerator","Denominator","Quotient (answer)","QUOTIENT function shows just whole number","MOD Function shows just remainder","Whole Number w Fraction (Mixed Number)"]
[126,24,null,null,null,null," <<== Fraction Number Formatting"]

{"sheet":"Multiple&Divide (an)","index":10,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Invoice # 3456"]
["Product","Number Bought","Price Each","Total"]
["Part 10022",23,0.76500000000000001,{"$f":"ROUND(B3*C3,2)","v":17.600000000000001},null,"<<== When multiplying decimals, we are likely to get"]
["Part 3499",52,1,{"$f":"ROUND(B4*C4,2)","v":52},null,"a bunch of decimals that will require rounding"]
["Part 33489",61,2.5499999999999998,155.55000000000001]
[]
[null,null,"Subtotal",{"$f":"SUM(D3:D5)","v":225.15},null,"Tax Rate"]
[null,null,"Tax",{"$f":"ROUND(D7*F8,2)","v":22.18},null,9.8500000000000004E-2]
[null,null,"Total",{"$f":"SUM(D7:D8)","v":247.33}]
[]
[]
["Chapter 7: Series Discounts: Require that you multiply more than two items"]
[]
["Discount 1",0.8,null,"Discount 1",0.65,null,"\"Product\" means \"Answer Result from"]
["Discount 2",0.9,null,"Discount 2",0.8,null,"Multiplying."]
["Discount 3",0.9,null,"Discount 3",0.85,null,"<<==  Occasionally, the PRODUCT function"]
["Net Cost Equivalent",{"$f":"PRODUCT(B14:B16)","v":0.64800000000000013},{"$f":"B14*B15*B16","v":0.64800000000000013},"Net Cost Equivalent",{"$f":"PRODUCT(E14:E16)","v":0.442},null,"may come in handy when you have a"]
[null,null,null,null,null,null,"bunch of numbers to multiply"]
[]
["Chapter 3: Compare Parts to Whole, we use Division"]
[]
["Student Name","Student Score","Compare Your Score To Max Doing Division",null,"Max points for class"]
["Jo",362,{"$f":"B23/$E$23","v":0.72399999999999998},null,500]
["Joe",500,{"$f":"B24/$E$23","v":1}]
["Sioux",396,0.79200000000000004]
["Sue",477,0.95399999999999996]
["Chin",453,0.90600000000000003]
["Sheliadawn",454,0.90800000000000003]
[]
["Expense for Week",2955,null,"<<== Keyboard for \"Current\" Number Format = Ctrl + Shift + 4"]
["Daily Expense",{"$f":"B30/7","v":422.14285714285717},null,"<< == Numbers that will never change can be typed into formulas."]
[]
[]
["** Dividing by zero not allowed because \"How many"]
["Zeroes are in a number???\""]
[]
["Numerator","Denominator","Quotient (answer)"]
[10,null,{"$f":"A38/B38","v":{"$error":"#DIV/0!"}}]
[]
["Example of Remainder, Fraction, Decimal:"]
[]
["Long Hand Division",null,null,null,null,"Check"]
["Numerator","Denominator",null,126,null,24]
[126,24,null,24,"Whole Number",5]
[null,null,null,null,null,{"$f":"F43*F44","v":120}]
[null,null,null,null,"Remainder",{"$f":"D43-F45","v":6}]
[]
["Numerator","Denominator","Quotient (answer)","QUOTIENT function shows just whole number","MOD Function shows just remainder","Whole Number w Fraction (Mixed Number)"]
[126,24,{"$f":"A49/B49","v":5.25},{"$f":"QUOTIENT(A49,B49)","v":5},{"$f":"MOD(A49,B49)","v":6},{"$f":"A49/B49","v":5.25}," <<== Fraction Number Formatting"]

{"sheet":"Exponents","index":11,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Exponents are  convenient way to multiply when you have to"]
["multiply the same number over and over!"]
[]
[2,".","What is the number we are multiplying?"]
[2,null,null,null,{"$f":"IF(D5<>\"\",\"This is called an 'Base'\",\"\")","v":""}]
[2,".","How many times did we have to multiply it?"]
[2,null,null,null,{"$f":"IF(D7<>\"\",\"This is called an 'Exponent'\",\"\")","v":""}]
[]
["or",null,null,"24"]
[null,null,null,null,{"$f":"IF(D7=\"\",\"\",\"Formula is =2^4 or =D5^D7\")","v":""}]
[]
[null,null,null,"24"]

{"sheet":"OOO","index":12,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Arithmetic operation signs in Excel:"]
[" ( ) represents Parentheses"]
[" ^ represents Exponents (powers and roots)"]
[" * represents Multiplication"]
[" /  represents Division"]
[" + represents Addition"]
[" – represents Subtraction"]
[]
["Order of Operations form Algebra class (Each one is left to right):"]
["Please è Parenthesis è ( )"]
["Excuse è Exponents è ^ è 2^2 = 4 or 4^(1/2) = 2"]
["My Dear è Multiplication è * and Division è /"]
["Aunt Sally è Adding (SUM) è + and Subtraction è -"]
[]
[]
[]
["Excel's Order of Operations:"]
["Parenthesis ( )"]
["Ranges use of colon symbol \":\""]
["Example: =SUM(A1:A4)"]
["Evaluate unions (,)"]
["Example: =SUM(A1:A4,B2:C7)"]
["Negation (-)"]
["Example: =-2^4 è 16"]
["Example: =-(2^4) è -16"]
["Converts % (1% è .01)"]
["Exponents (^)"]
["Example 1: 4^(1/2) = 2"]
["Example: 3^2 = 9"]
["Multiplication (*) and division (/), left to right"]
["Adding (+) and division (-), left to right"]
["Text operators (& è Concatenation)"]
["Comparative symbols: =, <>, >=, <=, <, >"]
["If anything is still left, then left to right"]

{"sheet":"Exponents (an)","index":13,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Exponents are  convenient way to multiply when you have to"]
["multiply the same number over and over!"]
[]
[2,".","What is the number we are multiplying?"]
[2,null,null,2,{"$f":"IF(D5<>\"\",\"This is called an 'Base'\",\"\")","v":"This is called an 'Base'"}]
[2,".","How many times did we have to multiply it?"]
[2,null,null,4,{"$f":"IF(D7<>\"\",\"This is called an 'Exponent'\",\"\")","v":"This is called an 'Exponent'"}]
[{"$f":"A7*A5*A6*A4","v":16}]
["or",null,null,"24"]
[{"$f":"PRODUCT(A4:A7)","v":16},null,null,{"$f":"D5^D7","v":16},{"$f":"IF(D7=\"\",\"\",\"Formula is =2^4 or =D5^D7\")","v":"Formula is =2^4 or =D5^D7"}]
[]
[null,null,null,"24"]

{"sheet":"Word","index":14,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Steps for solving word-application problems:"]
["Step 1:","1) List all relevant facts and numbers with proper labels, 2) State goal of problem"]
["Step 2:","1) Set up problem, 2) solve using efficient Excel features, 3) check and double check"]
["Step 3:","Answer the question with a write statement."]
[]
["Translate words into math symbols"]
["Add","Subtract","Multiply","Division","Equal","Powers"]
["plus","less","product","divided by","is","squared"]
["more","subtract","double","divided into","the same as","raised to"]
["more than","subtracted from","triple","quotient","equals","to the second power"]
["added to ","difference","times","goes into","equal to","cubed"]
["increased by","less than","of","divide","yields","to the 12th power"]
["sum","fewer","twice","divided equally","results in"]
["total","decreased by","twice as much","per","are"]
["sum of","loss of"]
["increase of","minus"]
["gain of","take away"]
["add","reduced by"]

{"sheet":"W(1)","index":15,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Using the three steps for solving word problems (1. List all facts & goal, 2. Setup & solve using"]
["efficient Excel features, 3. Answer with written statement. Use the cells below to list facts and"]
[{"$f":"\"make calculations and put your written answer in cell \"&ADDRESS(ROW(A34),COLUMN(A34),4)&\".\"","v":"make calculations and put your written answer in cell A34."}]
["If you sell 5 Quad boomerangs for $32.00 each and the cost for each was $17.75 and you sell 2"]
["Carlota boomerangs for $22 each and the cost for each was $13, what was the total profit that"]
["you made?"]
[]
["Step 1:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 2:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 3:"]

{"sheet":"W(1an)","index":16,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Using the three steps for solving word problems (1. List all facts & goal, 2. Setup & solve using"]
["efficient Excel features, 3. Answer with written statement. Use the cells below to list facts and"]
[{"$f":"\"make calculations and put your written answer in cell \"&ADDRESS(ROW(A34),COLUMN(A34),4)&\".\"","v":"make calculations and put your written answer in cell A34."}]
["If you sell 5 Quad boomerangs for $32.00 each and the cost for each was $17.75 and you sell 2"]
["Carlota boomerangs for $22 each and the cost for each was $13, what was the total profit that"]
["you made?"]
[]
["Step 1:"]
["# Quad Sold",5]
["Sell Price of Quad",32]
["Cost of Quad",17.75]
["# of Carlota sold",2]
["sell Price of Carlota",22]
["Cost of Carlota",13]
["Goal:","Find Total Profit"]
[]
["Step 2:"]
[{"$f":"A9","v":"# Quad Sold"},{"$f":"B9","v":5}]
[{"$f":"A10","v":"Sell Price of Quad"},{"$f":"B10","v":32},null,"Check"]
["Total Revenue Quad",{"$f":"B19*B18","v":160},null,{"$f":"A9","v":"# Quad Sold"},5]
[{"$f":"A12","v":"# of Carlota sold"},{"$f":"B12","v":2},null,"Sell Price of Quad",32]
[{"$f":"A13","v":"sell Price of Carlota"},{"$f":"B13","v":22},null,"Cost of Quad",17.75]
["Total Revenue Carlota",{"$f":"B22*B21","v":44},null,"# of Carlota sold",2]
["Total Revenue",{"$f":"B23+B20","v":204},null,"sell Price of Carlota",22]
[{"$f":"A11","v":"Cost of Quad"},{"$f":"B11","v":17.75},null,"Cost of Carlota",13]
["Total Cost of Quads",{"$f":"B25*B18","v":88.75},null,"Total Profit",{"$f":"(E21-E22)*E20+(E24-E25)*E23","v":89.25}]
[{"$f":"A14","v":"Cost of Carlota"},{"$f":"B14","v":13}]
["Total Cost of Carlotas",{"$f":"B27*B21","v":26}]
["Total Cost",{"$f":"B28+B26","v":114.75}]
["Total Profit",{"$f":"B24-B29","v":89.25},null,"COGS"]
[]
[]
["Step 3:"]
["The total profit that we made after selling the 5 Quad and 2 Carlota Boomerangs was $89.25."]

{"sheet":"W(2)","index":17,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Using the three steps for solving word problems (1. List all facts & goal, 2. Setup & solve using",null,null,null,null,null,null,null,null,null,1500]
["efficient Excel features, 3. Answer with written statement. Use the cells below to list facts and",null,null,null,null,null,null,null,null,null,35]
[{"$f":"\"make calculations and put your written answer in cell \"&ADDRESS(ROW(A23),COLUMN(A23),4)&\".\"","v":"make calculations and put your written answer in cell A23."},null,null,null,null,null,null,null,null,null,25]
[{"$f":"\"If a theater owner needs \"&TEXT(K1,\"#,###\")&\" total seats and wants the main floor to have \"&K2&\" rows with \"&K3&\" seats in each, and the balcony to have \"&K4&\" rows, how many seats must be in each balcony row?\"","v":"If a theater owner needs 1,500 total seats and wants the main floor to have 35 rows with 25 seats in each, and the balcony to have 25 rows, how many seats must be in each balcony row?"},null,null,null,null,null,null,null,null,null,25]
[]
["Step 1:"]
[]
[]
[]
[]
[]
[]
["Step 2:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 3:"]

{"sheet":"W(2an)","index":18,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Using the three steps for solving word problems (1. List all facts & goal, 2. Setup & solve using",null,null,null,null,null,null,null,null,null,1500]
["efficient Excel features, 3. Answer with written statement. Use the cells below to list facts and",null,null,null,null,null,null,null,null,null,35]
[{"$f":"\"make calculations and put your written answer in cell \"&ADDRESS(ROW(A23),COLUMN(A23),4)&\".\"","v":"make calculations and put your written answer in cell A23."},null,null,null,null,null,null,null,null,null,25]
[{"$f":"\"If a theater owner needs \"&TEXT(K1,\"#,###\")&\" total seats and wants the main floor to have \"&K2&\" rows with \"&K3&\" seats in each, and the balcony to have \"&K4&\" rows, how many seats must be in each balcony row?\"","v":"If a theater owner needs 1,500 total seats and wants the main floor to have 35 rows with 25 seats in each, and the balcony to have 25 rows, how many seats must be in each balcony row?"},null,null,null,null,null,null,null,null,null,25]
[]
["Step 1:"]
["Total seats",1500]
["Main Floor # of Rows",35]
["Seats in Each Main Floor Row",25]
["Balcony # of Rows",25]
["Goal:","Find # of seats in each Balcony Row"]
[]
["Step 2:"]
[{"$f":"A8","v":"Main Floor # of Rows"},{"$f":"B8","v":35},null,{"$f":"A7","v":"Total seats"},{"$f":"B7","v":1500}]
[{"$f":"A9","v":"Seats in Each Main Floor Row"},{"$f":"B9","v":25},null,{"$f":"A8","v":"Main Floor # of Rows"},35]
["Total Seats on Main Floor",{"$f":"B15*B14","v":875},null,"Seats in Each Main Floor Row",25]
[{"$f":"A7","v":"Total seats"},{"$f":"B7","v":1500},null,"Balcony # of Rows",25]
["Total seats in Balcony",{"$f":"B17-B16","v":625},null,{"$f":"A20","v":"# of seats in each Balcony Row"},{"$f":"(E14-E15*E16)/E17","v":25}]
[{"$f":"A10","v":"Balcony # of Rows"},{"$f":"B10","v":25}]
["# of seats in each Balcony Row",{"$f":"B18/B19","v":25}]
[]
["Step 3:"]
["Given the information in the problem, the number of seats in each balcony row is 25."]

{"sheet":"HW Answers MGirvin Created== >>","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1.1","index":20,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[3,37901,"Thirty-seven thousand, nine hundred one."]
[5,4650015,"Four million, six hundred fifty thousand, fifteen."]
[]
[null,null,"Position to round to:"]
[null,null,"Ten","Hundred","Thousand"]
[null,null,-1,-2,-3]
[9,46231,{"$f":"ROUND($B$7,C6)","v":46230},{"$f":"ROUND($B$7,D6)","v":46200},46000]
[11,106054,{"$f":"ROUND($B$8,C6)","v":106050},{"$f":"ROUND($B$8,D6)","v":106100},106000]
[]
[31,"Product","Jan","Feb","Mar","Apr","May","Jun","Totals"]
[null,"S",49802,36911,47851,54732,29852,74119,{"$f":"SUM(C11:H11)","v":293267}]
[null,"C",86154,72908,31552,74944,85532,36705,{"$f":"SUM(C12:H12)","v":387795}]
[null,"Product",59854,85119,87914,45812,56314,91856,{"$f":"SUM(C13:H13)","v":426869}]
[null,"MP",73951,72564,39615,71099,72918,42953,{"$f":"SUM(C14:H14)","v":373100}]
[null,"Totals",{"$f":"SUM(C11:C14)","v":269761},267502,206932,246587,244616,245633,{"$f":"SUM(C15:H15)","v":1481031}]
[]
[71,"Step 1:"]
[null,null,"# of Sodas",900]
[null,null,"# candy bars",400]
[null,null,"Snack items",500]
[null,null,"Cups of coffee",200]
[null,null,"There are more than one vending machine"]
[null,null,"Time to restock all machines",4,"hours"]
[null,null,"Goal:","Find how many items have can re-stock in 1 hour"]
[null,null,"Hours considered",1]
[null,"Step 2:"]
[null,null,{"$f":"C18","v":"# of Sodas"},900]
[null,null,"# candy bars",400]
[null,null,"Snack items",500]
[null,null,"Cups of coffee",200]
[null,null,"Total",{"$f":"SUM(D27:D30)","v":2000},{"$f":"\" <<== This many in \"&D23&\" \"&E23","v":" <<== This many in 4 hours"}]
[]
[null,null,{"$f":"D31&\" / \"&D23&\" = # items in \"&D25&\" hours\"","v":"2000 / 4 = # items in 1 hours"},{"$f":"D31/D23","v":500}]
[]
[null,"Step 3:"]
[null,null,{"$f":"\"Jim Wilson can re-stock \"&D33&\" items in \"&D25&\" hour\"","v":"Jim Wilson can re-stock 500 items in 1 hour"}]

{"sheet":"1.2","index":21,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[3,"Step 1:"]
[null,"# miles driven last year",3020,"billion"]
[null,"# Miles driven this year",2920,"billion"]
[null,"Goal","Find reduction in miles driven"]
[]
[null,"Step 2:"]
[null,{"$f":"B2","v":"# miles driven last year"},{"$f":"C2","v":3020}]
[null,{"$f":"B3","v":"# Miles driven this year"},{"$f":"C3","v":2920}]
[null,"reduction in miles driven",{"$f":"C7-C8","v":100}]
[]
[null,"Step 3:"]
[null,{"$f":"\"The reduction in miles driven between last year and this year was \"&C9&\" billion miles.\"","v":"The reduction in miles driven between last year and this year was 100 billion miles."}]
[]
[5,"Step 1:"]
[null,"WW II veterans deaths per day",607]
[null,"Days in year",365]
[null,"Goal:","Project how many WW II veterans will die in next year"]
[]
[]
[null,"Step 2:"]
[null,{"$f":"B15","v":"WW II veterans deaths per day"},607]
[null,"Days in year",365]
[null,"Project how many WW II veterans will die in next year",{"$f":"C21*C22","v":221555}]
[]
[]
[null,"Step 3:"]
[null,{"$f":"\"The projected number of WW II veterans that will die in the next year is \"&TEXT(C23,\"#,###\")","v":"The projected number of WW II veterans that will die in the next year is 221,555"}]
[]
[7,"Step 1:"]
[null,"Boat weight",8375,"lbs"]
[null,"Engine removed",762,"lbs"]
[null,"New Engine",976,"lbs"]
[null,"Goal:","Find weight of boat after engine change"]
[]
[null,"Step 2:"]
[null,{"$f":"B30","v":"Boat weight"},{"$f":"C30","v":8375}]
[null,{"$f":"B31","v":"Engine removed"},762]
[null,"New Engine",976]
[null,"weight of boat after engine change",{"$f":"C36-C37+C38","v":8589}]
[]
[null,"Step 3:"]
[null,{"$f":"\"Weight of boat after engine change would be \"&TEXT(C39,\"#,###\")&\" \"&D30","v":"Weight of boat after engine change would be 8,589 lbs"}]
[]
[19,"Step 1:"]
[null,"Desired Seat Total",1250]
[null,"# of Main Floor Rows",30]
[null,"# of Main Floor Seats per Row",25]
[null,"# of Balcony Rows",25]
[null,"Goal:","Find number of seats in each balcony row"]
[null,"Step 2:"]
[null,{"$f":"B46","v":"# of Main Floor Rows"},{"$f":"C46","v":30}]
[null,{"$f":"B47","v":"# of Main Floor Seats per Row"},{"$f":"C47","v":25}]
[null,"Total Seats on Main Floor",{"$f":"C52*C51","v":750}]
[null,{"$f":"B45","v":"Desired Seat Total"},{"$f":"C45","v":1250}]
[null,"Seats in Balcony",{"$f":"C54-C53","v":500}]
[null,{"$f":"B48","v":"# of Balcony Rows"},{"$f":"C48","v":25}]
[null,"# of seats in each balcony row",{"$f":"C55/C56","v":20}]
[]
[null,"Step 3:"]
[null,{"$f":"\"Given the information in this problem, there would need to be \"&C57&\" seats in each balcony row.\"","v":"Given the information in this problem, there would need to be 20 seats in each balcony row."}]

{"sheet":"1.3","index":22,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number To Round To ==>>",1,2,3]
["Problem","Number","Tenth","Hundredth","Thousandths"]
[27,3.5217999999999998,{"$f":"ROUND(B4,$C$2)","v":3.5},{"$f":"ROUND(B4,$D$2)","v":3.52},{"$f":"ROUND(B4,$E$2)","v":3.5219999999999998}]
[28,4.8360000000000003,4.8,4.84,4.8360000000000003]
[29,2.5483600000000002,2.5,2.5499999999999998,2.548]
[30,7.4465199999999996,7.4,7.45,7.4470000000000001]
[31,27.32451,27.3,27.32,27.324999999999999]
[32,89.537959999999998,89.5,89.54,89.537999999999997]
[33,36.472490000000001,36.5,36.47,36.472000000000001]
[34,58.956510000000002,59,58.96,58.957000000000001]
[35,5.62E-2,0.1,0.06,5.6000000000000001E-2]
[36,7.8899999999999998E-2,0.1,0.08,7.9000000000000001E-2]
[]
["Problem","Number","Rounded To Penny"]
[37,5.056,{"$f":"ROUND(B16,2)","v":5.0599999999999996}]
[38,375.00299999999999,{"$f":"ROUND(B17,2)","v":375}]
[39,42.137,42.14]
[40,8.0000000000000002E-3,0.01]
[41,1.9950000000000001,2]
[42,16.518999999999998,16.52]
[43,382.005,382.01]
[44,0.84599999999999997,0.85]
[45,1.5002,1.5]
[46,28.994,28.99]
[47,32.493000000000002,32.49]
[48,12802.965,12802.97]
[49,1.5E-3,0]
[50,7.6009000000000002,7.6]
[51,752.798,752.8]
[]
["Problem","Number","Rounded To Dollar"]
[52,8.58,{"$f":"ROUND(B33,0)","v":9}]
[53,26.49,26]
[54,0.56999999999999995,1]
[55,0.49,0]
[56,299.76,300]
[57,12836.38,12836]
[58,268.72000000000003,269]
[59,395.18,395]
[60,666.66,667]
[61,4699.62,4700]
[62,11285.13,11285]
[63,378.59,379]
[64,233.86,234]
[65,722.38,722]
[66,8263.4699999999993,8263]

{"sheet":"1.4","index":23,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[19,"Step 1:"]
[null,"Ave cost of T-bone per lbs",6.71]
[null,"Ave cost of Turkey per lbs",1.39]
[null,"Goal:","Find how much more per pound is the price of T-bone than turkey"]
[]
[null,"Step 2:"]
[null,{"$f":"B2","v":"Ave cost of T-bone per lbs"},6.71]
[null,"Ave cost of Turkey per lbs",1.39]
[null,"Difference",{"$f":"C7-C8","v":5.32}]
[]
[]
[null,"Step 3:"]
[null,{"$f":"\"T-bone is \"&DOLLAR(C9)&\" more per pound than is turkey.\"","v":"T-bone is $5.32 more per pound than is turkey."}]
[]
["30, 31, 32","Step 1:"]
[null,"March 1 Bank Balance",5382.12]
[null,"March deposits",60375.82]
[null,"Credits from suppliers (incoming funds)",3280.18]
[null,"Tax Refund",75.53]
[null,"Paid out to suppliers",27282.75]
[null,"Rent and utilities",4280.83]
[null,"Salaries and Misc",12252.23]
[null,"Goal:","What are 1) total deposits, 2) Total Pay Out, 3) Final Balance?"]
[]
[null,"Step 2:"]
[null,{"$f":"B17","v":"March deposits"},60375.82]
[null,"Credits from suppliers (incoming funds)",3280.18]
[null,"Tax Refund",75.53]
[null,"Total deposits",{"$f":"SUM(C26:C28)","v":63731.53}]
[null,{"$f":"B20","v":"Paid out to suppliers"},27282.75]
[null,"Rent and utilities",4280.83]
[null,"Salaries and Misc",12252.23]
[null,"Total Pay Out",{"$f":"SUM(C30:C32)","v":43815.81}]
[null,{"$f":"B16","v":"March 1 Bank Balance"},{"$f":"C16","v":5382.12}]
[null,"Final Balance",{"$f":"C34+C29-C33","v":25297.839999999997}]
[]
[null,"Step 3:"]
[null,{"$f":"B29&\" were \"&DOLLAR(C29)&\", \"&B33&\" was \"&DOLLAR(C33)&\" and the final balance was \"&DOLLAR(C35)","v":"Total deposits were $63,731.53, Total Pay Out was $43,815.81 and the final balance was $25,297.84"}]

{"sheet":"1.5","index":24,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[27,"Step 1:"]
[null,"Miles in 1 week",519]
[null,"Gas used",10.199999999999999]
[null,"Goal:","Find miles per gallon to the nearest tenth"]
[]
[null,"Step 2:"]
[null,{"$f":"B2","v":"Miles in 1 week"},519]
[null,"Gas used",10.199999999999999]
[null,"Miles per Gallon",{"$f":"ROUND(C7/C8,1)","v":50.9}]
[]
[]
[null,"Step 3:"]
[null,{"$f":"\"The auto got \"&C9&\" miles per gallon\"","v":"The auto got 50.9 miles per gallon"}]
[]
[30,"Step 1:"]
[null,"Amount of ingredient in 1 dose of medication",1.62,"milligrams"]
[null,"Total amount of ingredient",57.13,"milligrams"]
[null,"Goal:","Find the total number of doses of medication that can be made, round to nearest whole number"]
[]
[null,"Step 2:"]
[null,{"$f":"B16","v":"Amount of ingredient in 1 dose of medication"},1.62]
[null,{"$f":"B17","v":"Total amount of ingredient"},57.13]
[null,"total number of doses of medication that can be made",{"$f":"ROUND(C22/C21,0)","v":35}]
[]
[null,"Step 3:"]
[null,{"$f":"\"The \"&B23&\" is \"&C23","v":"The total number of doses of medication that can be made is 35"}]