{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Topics","Excel","Excel (an)","Formulas","Formulas (an)","Formatting","Formatting (an)","Ranges","Ranges (an)","NumberFormatting","NumberFormatting (an)","Order","Order (an)","Functions","Functions (an)","Cell References","Cell References (an)","All","All (an)","Homework==>>","HW(1)","HW(1an)","HW(2)","HW(2an)","HW(3)","HW(3an)","HW(4)","HW(4an)","HW(5)","HW(5an)","HW(6)","HW(6an)","HW(7)","HW(7an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Topics","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[1,"Introduction To Excel"]
[2,"Formulas"]
[null,"Formula Inputs"]
[null,"Cell References"]
[null,"Math Operators"]
[null,"Functions"]
[null,"Comparative Operators"]
[3,"Formatting: Stylistic or Number"]
[4,"Number Formatting"]
[5,"Math Order of Operations"]
[6,"Functions"]
[7,"Cell References"]
[8,"Putting It All Together: Formulas, Formatting, Cell References"]
[9,"Homework in this Excel Workbook"]

{"sheet":"Excel","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["What is Excel?","Calculations",null,null,null,"Calculations",null,"Data Analysis"]
[null,"Data Analysis"]
[null,null,null,null,null,"Minutes",null,"Minutes"]
["Columns?",{"$f":"IF(C4=\".\",\"Up and down -- letters\",\"\")","v":""},null,null,null,12,null,68]
["Rows?",{"$f":"IF(C5=\".\",\"Left to right -- numbers\",\"\")","v":""},null,null,null,22,null,40]
["Cells",{"$f":"IF(C6=\".\",\"Intersection of row and column\",\"\")","v":""},null,null,null,35,null,35]
["Worksheet?",{"$f":"IF(C7=\".\",\"All the cells in one sheet: also called 'sheet'\",\"\")","v":""},null,null,null,68,null,22]
["Sheet Tab?",{"$f":"IF(C8=\".\",\"Name of sheet\",\"\")","v":""},null,null,null,5,null,10]
["Workbook?",{"$f":"IF(C9=\".\",\"All the sheets\",\"\")","v":""},null,null,null,40,null,5]
["Scroll Arrows?",{"$f":"IF(C10=\".\",\"Moves sheets, but not 'Active Sheet'\",\"\")","v":""},null,null,"Total"]
["Move Active Sheet Keyboard:",{"$f":"IF(C11=\".\",\"Ctrl + PageDown or PageUp\",\"\")","v":""}]
["Save?",{"$f":"IF(C12=\".\",\"Ctrl + S -- saves the changes you made to workbook\",\"\")","v":""}]
["Save As?",{"$f":"IF(C13=\".\",\"F12 - allows you to change the name or save workbook to a different location\",\"\")","v":""}]
["Folders?",{"$f":"IF(C14=\".\",\"We will use a folder named \"\"Busn Math\"\"\",\"\")","v":""}]
["Typing in cell?"]
["Word to left"]
["Numbers to right"]
["Calculate with a  formula in a cell, must have an equal sign as the first character. To make a math calculation, click on the cell with the number to insert a Cell Reference and type math operators."]
[]
[{"$f":"\"Our First Formula = \"&B17&\" * \"&C17&CHAR(10)&\"=\"&ADDRESS(ROW(B17),COLUMN(B17),4)&\"*\"&ADDRESS(ROW(C17),COLUMN(C17),4)","v":"Our First Formula =  * \n=B17*C17"}]
[]
["Keyboards:"]
[]
["F2 puts cell in Edit Mode"]
["Ctrl + PageDown","Move Active Sheet"]
["Ctrl + PageUp","Move Active Sheet"]
["Ctrl + Arrow","Jumps to end of Current Region"]
["Ctrl + Home","Goes To A1"]
["Enter Data, Numbers, Text, Formulas into cell ==> Enter, Tab, Ctrl + Enter."]
["Enter goes down"]
["Tab moves right"]
["Ctrl + Enter keeps cell selected"]
["Window + E","Opens Windows Explorer"]

{"sheet":"Excel (an)","index":2,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["What is Excel?","Calculations",null,null,null,"Calculations",null,"Data Analysis"]
[null,"Data Analysis"]
[null,null,null,null,null,"Minutes",null,"Minutes"]
["Columns?",{"$f":"IF(C4=\".\",\"Up and down -- letters\",\"\")","v":"Up and down -- letters"},".",null,null,12,null,5]
["Rows?",{"$f":"IF(C5=\".\",\"Left to right -- numbers\",\"\")","v":"Left to right -- numbers"},".",null,null,22,null,10]
["Cells",{"$f":"IF(C6=\".\",\"Intersection of row and column\",\"\")","v":"Intersection of row and column"},".",null,null,80,null,22]
["Worksheet?",{"$f":"IF(C7=\".\",\"All the cells in one sheet: also called 'sheet'\",\"\")","v":"All the cells in one sheet: also called 'sheet'"},".",null,null,68,null,35]
["Sheet Tab?",{"$f":"IF(C8=\".\",\"Name of sheet\",\"\")","v":"Name of sheet"},".",null,null,5,null,40]
["Workbook?",{"$f":"IF(C9=\".\",\"All the sheets\",\"\")","v":"All the sheets"},".",null,null,40,null,68]
["Scroll Arrows?",{"$f":"IF(C10=\".\",\"Moves sheets, but not 'Active Sheet'\",\"\")","v":"Moves sheets, but not 'Active Sheet'"},".",null,"Total",{"$f":"SUM(F4:F9)","v":227}]
["Move Active Sheet Keyboard:",{"$f":"IF(C11=\".\",\"Ctrl + PageDown or PageUp\",\"\")","v":"Ctrl + PageDown or PageUp"},"."]
["Save?",{"$f":"IF(C12=\".\",\"Ctrl + S -- saves the changes you made to workbook\",\"\")","v":"Ctrl + S -- saves the changes you made to workbook"},"."]
["Save As?",{"$f":"IF(C13=\".\",\"F12 - allows you to change the name or save workbook to a different location\",\"\")","v":"F12 - allows you to change the name or save workbook to a different location"},"."]
["Folders?",{"$f":"IF(C14=\".\",\"We will use a folder named \"\"Busn Math\"\"\",\"\")","v":"We will use a folder named \"Busn Math\""},"."]
["Typing in cell?"]
["Word to left","Excel","Fun"]
["Numbers to right",43,5]
["Calculate with a  formula in a cell, must have an equal sign as the first character. To make a math calculation, click on the cell with the number to insert a Cell Reference and type math operators."]
[]
[{"$f":"\"Our First Formula = \"&B17&\" * \"&C17&CHAR(10)&\"=\"&ADDRESS(ROW(B17),COLUMN(B17),4)&\"*\"&ADDRESS(ROW(C17),COLUMN(C17),4)","v":"Our First Formula = 43 * 5\n=B17*C17"},{"$f":"B17*C17","v":215}]
[]
["Keyboards:"]
[]
["F2 puts cell in Edit Mode"]
["Ctrl + PageDown","Move Active Sheet"]
["Ctrl + PageUp","Move Active Sheet"]
["Ctrl + Arrow","Jumps to end of Current Region"]
["Ctrl + Home","Goes To A1"]
["Enter Data, Numbers, Text, Formulas into cell ==> Enter, Tab, Ctrl + Enter."]
["Enter goes down"]
["Tab moves right"]
["Ctrl + Enter keeps cell selected"]
["Window + E","Opens Windows Explorer"]

{"sheet":"Formulas","index":3,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"Math Operators","Symbol",null,null,"Comparative Operator"]
[null,"Parenthesis"," (   )",null,null,"Equal"," ="]
[null,"Exponents"," ^",null,null,"Greater Than"," >"]
[null,"Multiply"," *",null,null,"Greater Than or Equal To"," >=","Equal sign always comes second"]
[null,"Divide"," /",null,null,"Less Than"," <","Equal sign always comes second"]
[null,"Add"," +",null,null," or Equal To"," <="]
[null,"Subtract"," -",null,null,"Not"," <>"]
[]
["Basic Rules for Formulas:"]
[1,"Equal sign starts all formulas"]
[2,"Numbers that can \"vary\" or \"change\" are typed into cells"]
[3,"Cell References are used in formula to point to the formula inputs"]
[4,"Math operators or comparative operators (above)"]
[]
["4 examples of Formulas:"]
[]
[1,"Earnings for Month",null,null," <<== Formula Input = Number typed into cell"]
[null,"Expenses for Month",null,null," <<== Formula Input = Number typed into cell"]
[null,"Left For Savings for Other",null,null," <<== Build formula with equal sign as 1st character in cell"]
[null,null,null,null,"            point to formula inputs with Cell References"]
[null,null,null,null,"             use math operators"]
[null,null,null,null,"             and hit Enter, Tab, or Ctrl + Enter to put formula in cell."]
[null,null,null,null,"             Cell References can be entered into formula using"]
[null,null,null,null,"             the Mouse or the Arrow Keys."]
[]
[2,"Business Expenses","Amounts"]
[null,"Truck",542.45000000000005]
[null,"Delivery",40.700000000000003]
[null,"Utilities",300.44]
[null,"Lease",837.69]
[null,"Depreciation",363]
[null,"COGS",809.78]
[null,"Wage",6520]
[null,"Salary",724.43]
[null,null,43.61]
[null,"Web Site",735.73]
[null,null,null,null,"<<== Use SUM Function instead of plus symbol. It is more"]
[null,null,null,null,"efficient because you can create formula more quickly"]
[null,null,null,null,"and if you insert a row the \"range of cells\" updates."]
[null,null,null,null,"Be sure to always label formula inputs and calculations!!"]
[]
[3,"Annual Truck Insurance",2501.25]
[null,"Amount Spent per Month",null,null," <<== Example of a Formula Input that does not every \"vary\" or \"change\"."]
[]
[4,"Your Monthly Sales",65000]
[null,"Bonus Hurdle",70000]
[null,"Did you get bonus?",null,null,"<<== Logical Formulas use Comparative Operators and show either TRUE"]
[null,null,null,null,"or FALSE (No other answer is possible)."]
[]
["** Notice that formulas can have elements such as:"]
["Equal signs"]
["Cell References"]
["Typed Numbers if the Number will not change"]
["Math Operators"]
["Functions"]
["Comparative Operator"]

{"sheet":"Formulas (an)","index":4,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"Math Operators","Symbol",null,null,"Comparative Operator"]
[null,"Parenthesis"," (   )",null,null,"Equal"," ="]
[null,"Exponents"," ^",null,null,"Greater Than"," >"]
[null,"Multiply"," *",null,null,"Greater Than or Equal To"," >=","Equal sign always comes second"]
[null,"Divide"," /",null,null,"Less Than"," <","Equal sign always comes second"]
[null,"Add"," +",null,null," or Equal To"," <="]
[null,"Subtract"," -",null,null,"Not"," <>"]
[]
["Basic Rules for Formulas:"]
[1,"Equal sign starts all formulas"]
[2,"Numbers that can \"vary\" or \"change\" are typed into cells"]
[3,"Cell References are used in formula to point to the formula inputs"]
[4,"Math operators or comparative operators (above)"]
[]
["4 examples of Formulas:"]
[]
[1,"Earnings for Month",2500,null," <<== Formula Input = Number typed into cell"]
[null,"Expenses for Month",1800,null," <<== Formula Input = Number typed into cell"]
[null,"Left For Savings for Other",{"$f":"C17-C18","v":700},null," <<== Build formula with equal sign as 1st character in cell"]
[null,null,null,null,"            point to formula inputs with Cell References"]
[null,null,null,null,"             use math operators"]
[null,null,null,null,"             and hit Enter, Tab, or Ctrl + Enter to put formula in cell."]
[null,null,null,null,"             Cell References can be entered into formula using"]
[null,null,null,null,"             the Mouse or the Arrow Keys."]
[]
[2,"Business Expenses","Amounts"]
[null,"Truck",542.45000000000005]
[null,"Delivery",40.700000000000003]
[null,"Utilities",300.44]
[null,"Lease",837.69]
[null,"Depreciation",363]
[null,"COGS",809.78]
[null,"Wage",6520]
[null,"Salary",724.43]
[null,"Misc",43.61]
[null,"Web Site",735.73]
[null,"Total",{"$f":"SUM(C27:C36)","v":10917.830000000002},null,"<<== Use SUM Function instead of plus symbol. It is more"]
[null,null,null,null,"efficient because you can create formula more quickly"]
[null,null,null,null,"and if you insert a row the \"range of cells\" updates."]
[null,null,null,null,"Be sure to always label formula inputs and calculations!!"]
[]
[3,"Annual Truck Insurance",2501.25]
[null,"Amount Spent per Month",{"$f":"C42/12","v":208.4375},null," <<== Example of a Formula Input that does not every \"vary\" or \"change\"."]
[]
[4,"Your Monthly Sales",10000000]
[null,"Bonus Hurdle",70000]
[null,"Did you get bonus?",{"$f":"C45>=C46","v":true},null,"<<== Logical Formulas use Comparative Operators and show either TRUE"]
[null,null,null,null,"or FALSE (No other answer is possible)."]
[]
["** Notice that formulas can have elements such as:"]
["Equal signs"]
["Cell References"]
["Typed Numbers if the Number will not change"]
["Math Operators"]
["Functions"]
["Comparative Operator"]

{"sheet":"Formatting","index":5,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["4 examples of Formulas, Stylistic Formatting and Number Formatting:"]
[]
[null,"Stylistic Formatting = Things like colors, fonts and borders"]
[null,"Number Formatting = How you display the numbers (changing the display"]
[null,"of the numbers does not change the underlying number)"]
[]
[1,"Earnings for Month",null,null," <<== \"Currency\" Number Format has a Floating $ sign"]
[null,"Expenses for Month",null,null,"Keyboard for \"Currency\" ==>> Ctrl + Shift + 4"]
[null,"Left For Savings for Other"]
[]
[]
[null,null,null,null,"<<== \"Accounting\" Number Format has a Fixed $ sign, and"]
[2,"Business Expenses","Amounts",null,"will always line up decimals. To show Accounting without a"]
[null,"Truck",542.45000000000005,null,"dollar sign use \"Comma\" Number Format."]
[null,"Delivery",40.700000000000003,null,"<<== Use SUM Function instead of plus symbol. It is more"]
[null,"Utilities",300.44,null,"efficient because you can create formula more quickly"]
[null,"Lease",837.69,null,"and if you insert a row the \"range of cells\" updates."]
[null,"Depreciation",363,null,"Be sure to always label formula inputs and calculations!!"]
[null,"COGS",809.78]
[null,"Wage",6520]
[null,"Salary",724.43]
[null,null,43.61]
[null,"Web Site",735.73]
[null,null,null,null,"<<== Keyboard shortcut for SUM function is Alt + ="]
[]
[]
[]
[]
[3,"Annual Truck Insurance",2501.25]
[null,"Amount Spent per Month"]
[]
[4,"Your Monthly Sales",65000]
[null,"Bonus Hurdle",70000]
[null,"Did you get bonus?"]

{"sheet":"Formatting (an)","index":6,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["4 examples of Formulas, Stylistic Formatting and Number Formatting:"]
[]
[null,"Stylistic Formatting = Things like colors, fonts and borders"]
[null,"Number Formatting = How you display the numbers (changing the display"]
[null,"of the numbers does not change the underlying number)"]
[]
[1,"Earnings for Month",2000,null," <<== \"Currency\" Number Format has a Floating $ sign"]
[null,"Expenses for Month",1950,null,"Keyboard for \"Currency\" ==>> Ctrl + Shift + 4"]
[null,"Left For Savings for Other",{"$f":"C7-C8","v":50}]
[]
[]
[null,null,null,null,"<<== \"Accounting\" Number Format has a Fixed $ sign, and"]
[2,"Business Expenses","Amounts",null,"will always line up decimals. To show Accounting without a"]
[null,"Truck",542.45000000000005,null,"dollar sign use \"Comma\" Number Format."]
[null,"Delivery",40.700000000000003,null,"<<== Use SUM Function instead of plus symbol. It is more"]
[null,"Utilities",300.44,null,"efficient because you can create formula more quickly"]
[null,"Lease",837.69,null,"and if you insert a row the \"range of cells\" updates."]
[null,"Depreciation",363,null,"Be sure to always label formula inputs and calculations!!"]
[null,"COGS",809.78]
[null,"Wage",6520]
[null,"Salary",724.43,null,"Format Cells Dialog Box = Ctrl + 1"]
[null,"Misc",43.61]
[null,"Web Site",735.73]
[null,"Total",{"$f":"SUM(C14:C23)","v":10917.830000000002},null,"<<== Keyboard shortcut for SUM function is Alt + ="]
[]
[]
[]
[]
[3,"Annual Truck Insurance",3900]
[null,"Amount Spent per Month",{"$f":"C29/12","v":325}]
[]
[4,"Your Monthly Sales",65000]
[null,"Bonus Hurdle",70000]
[null,"Did you get bonus?",{"$f":"C32>=C33","v":false}]

{"sheet":"Ranges","index":7,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Business Expenses","Amounts"]
["COGS",809.78]
["Delivery",40.700000000000003]
["Depreciation",363]
["Lease",837.69]
["Misc",43.61]
["Salary",724.43]
["Truck",542.45000000000005]
["Utilities",300.44]
["Wage",6520]
["Web Site",735.73]
["Total"]

{"sheet":"Ranges (an)","index":8,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Business Expenses","Amounts"]
["COGS",809.78]
["Delivery",80]
["Depreciation",363]
["Insurance",500]
["Lease",837.69]
["Misc",43.61]
["Salary",724.43]
["Truck",542.45000000000005]
["Utilities",300.44]
["Wage",6520]
["Web Site",735.73]
["Total",{"$f":"SUM(B2:B12)","v":11457.13},{"$f":"B2+B3+B4+B6+B7+B8+B9+B10+B11+B12","v":10957.13}]

{"sheet":"NumberFormatting","index":9,"n_rows":76,"n_cols":6,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Keyboard Shortcut for Format Cells Dialog box = Ctrl + 1"]
[]
["Number Formatting is a façade that sits on top of the number and can show"]
["a number that is different than the underlying number."]
[]
["Example 1:"]
["Number 1",9.99,null,"<<== if you decrease the decimals the Number Formatting does not change"]
["Number 2",10,null,"the number in the cell it only changes the appearance of the number."]
["Multiply",null,null," <<== Formulas do not see the Number Formatting"]
[]
["Applying the \"General\" Number Format will remove any Number Formatting"]
["and show the actual number that sits in the cell."]
[]
["Example 2:"]
["Number 1",9.99]
["Number 2",10]
["Multiply"]
[]
[]
[]
["If you apply a Number Formatting like \"Currency\" to the cell before you type"]
["the numbers, you can save time with typing."]
[]
["Example 3:"]
[]
[]
[]
[]
["Total",null,"Total"]
[]
["Example 4:"]
["Revenue",1500]
["Expenses",1900]
["Net Income",null,null," <<== Format Cells Dialog box gives you all the power with Number Formatting"]
[null,null,null,"Keyboard ==>> Ctrl + 1 = Format Cells Dialog Box"]
[]
[]
["Some Built-in Number Formatting like Date have a completely different"]
["number in the cell than what you see on the surface of the spreadsheet."]
["Types in Dates are stored as \"serial Numbers\"; for example 1/1/1900 = 1,"]
["1/2/1900 = 2, 9/22/2011 = 40808. This is so we can do Date Math."]
[]
["Example 5:"]
["1900-01-01",null," <<== Apply \"General\" Number Format to prove this to yourself."]
["1900-01-02",null,"Keyboard for \"General\" ==>> Ctrl + Shift + ~ or Ctrl + Shift + `"]
["2011-09-22"]
[]
[]
[1,null," <<== Apply \"Date\" Number Format to prove this to yourself."]
[2]
[40808]
[]
["Example 6: Later Date - Earlier Date",null,null,null,"Example 6: Bigger Number - Smaller Number"]
["Invoice Due Date","2011-09-22",null,null,"Invoice Due Date",40808]
["Today's Date","2011-10-12",null,null,"Today's Date",40828]
["Days Past Due",null,"Prove it ==>>",null,"Days Past Due"]
[]
["\"Percent\" Number Formatting"]
[]
["Example 7:"]
[]
["Interest Rate",0.03,null,"Interest Rate",{"$f":"B62","v":0.03}," <<== Apply \"Percent\" Number formatting"]
["Amount Invested",100,null,"Amount Invested",100]
["Interest Earned",null,null,"Interest Earned"]
[]
["Example 8:"]
[]
["Interest Rate",3.5000000000000003E-2," <<== Pre Applied Apply \"Percent\" Number formatting with 0 decimals showing"]
["Amount Invested",100]
["Interest Earned",null," <<== Formula looks at underlying Number"]
[]
["Lesson Learned: Don't Get Tricked By Number Formatting!"]
[]
["**We will learn a lot about \"Percentage\" Number formatting in the chapters on Percents."]
["**We will see a lot of Date Math in the chapters on Invoicing and Investing"]
["**We will also see \"Time\" Number formatting in the chapters on Payroll"]

{"sheet":"NumberFormatting (an)","index":10,"n_rows":76,"n_cols":10,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Keyboard Shortcut for Format Cells Dialog box = Ctrl + 1"]
[]
["Number Formatting is a façade that sits on top of the number and can show"]
["a number that is different than the underlying number."]
[]
["Example 1:"]
["Number 1",9.99,null,"<<== if you decrease the decimals the Number Formatting does not change"]
["Number 2",10,null,"the number in the cell it only changes the appearance of the number."]
["Multiply",{"$f":"B8*B7","v":99.9},null," <<== Formulas do not see the Number Formatting"]
[]
["Applying the \"General\" Number Format will remove any Number Formatting"]
["and show the actual number that sits in the cell."]
[]
["Example 2:"]
["Number 1",9.99,null,2000]
["Number 2",10]
["Multiply",{"$f":"B16*B15","v":99.9},null,"Ctrl + Shift + ~"]
[null,null,null,"Ctrl + Shift + `"]
[]
[]
["If you apply a Number Formatting like \"Currency\" to the cell before you type"]
["the numbers, you can save time with typing."]
[]
["Example 3:"]
[null,20,null,20,20]
[null,10,null,10,10]
[null,35.25,null,35.25,35.25]
[null,19.5,null,19.5,19.5]
["Total",{"$f":"SUM(B25:B28)","v":84.75},"Total",{"$f":"SUM(D25:D28)","v":84.75}]
[]
["Example 4:"]
["Revenue",1500]
["Expenses",1900]
["Net Income",{"$f":"B32-B33","v":-400},null," <<== Format Cells Dialog box gives you all the power with Number Formatting"]
[null,null,null,"Keyboard ==>> Ctrl + 1 = Format Cells Dialog Box"]
[]
[]
["Some Built-in Number Formatting like Date have a completely different"]
["number in the cell than what you see on the surface of the spreadsheet."]
["Types in Dates are stored as \"Serial Numbers\"; for example 1/1/1900 = 1,"]
["1/2/1900 = 2, 9/22/2011 = 40808. This is so we can do Date Math."]
[]
["Example 5:"]
[1,null," <<== Apply \"General\" Number Format to prove this to yourself."]
[2,200,"Keyboard for \"General\" ==>> Ctrl + Shift + ~ or Ctrl + Shift + `"]
[40808]
[]
[]
["1900-01-01",null," <<== Apply \"Date\" Number Format to prove this to yourself."]
["1900-01-02"]
["2011-09-22"]
[]
["Example 6: Later Date - Earlier Date",null,null,null,"Example 6: Bigger Number - Smaller Number"]
["Invoice Due Date","2011-09-22",null,null,"Invoice Due Date",40808,null,null,"Loan Issue Date","2011-09-23"]
["Today's Date","2011-10-12",null,null,"Today's Date",40828,null,null,"Days",90]
["Days Past Due",{"$f":"B55-B54","v":20},"Prove it ==>>",null,"Days Past Due",{"$f":"F55-F54","v":20},null,null,"Due Date",{"$f":"J54+J55","v":"2011-12-22"}]
[]
["\"Percent\" Number Formatting"]
[]
["Example 7:"]
[]
["Interest Rate",0.03,null,"Interest Rate",{"$f":"B62","v":0.03}," <<== Apply \"Percent\" Number formatting"]
["Amount Invested",100,null,"Amount Invested",100]
["Interest Earned",{"$f":"B63*B62","v":3},null,"Interest Earned",{"$f":"E63*E62","v":3}]
[]
["Example 8:"]
[]
["Interest Rate",3.5000000000000003E-2," <<== Pre Applied Apply \"Percent\" Number formatting with 0 decimals showing"]
["Amount Invested",100]
["Interest Earned",{"$f":"B69*B68","v":3.5000000000000004}," <<== Formula looks at underlying Number"]
[]
["Lesson Learned: Don't Get Tricked By Number Formatting!"]
[]
["**We will learn a lot about \"Percentage\" Number formatting in the chapters on Percents."]
["**We will see a lot of Date Math in the chapters on Invoicing and Investing"]
["**We will also see \"Time\" Number formatting in the chapters on Payroll"]

{"sheet":"Order","index":11,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["What is the answer?",null,{"$f":"K1&\" + \"&L1&\" * \"&M1","v":"2 + 2 * 3"},null,null,null,null,null,null,null,2,2,3]
[]
[null,null,"12 or 8 ?????"]
[]
[" Prove it!!!!  (Excel does not make math or logic errors)"]
[]
[null,{"$f":"$C$1","v":"2 + 2 * 3"},null,null,"<<== Use Formula Evaluator to \"see\" how"]
[null,null,null,null,"Excel uses the Order of Operations:"]
[null,null,null,null,"Formula Ribbon Tab, Formula Auditing"]
[null,null,null,null,"Group, Evaluate Formula."]
[]
["Math order of operations",null,null,null,null,"Math order of operations"]
[1,"First, do everything in the parentheses",null,null,null,1," ( )"]
[2,"Second, do all exponents",null,null,null,2," ^"]
[3,"Third, do all multiplication and division, left to right",null,null,null,3," * / Left to Right"]
[4,"Fourth, do all adding and subtracting, left to right",null,null,null,4," + - Left to Right"]
[]
[null,"If you really want to do the adding first you must use Parenthesis like:"]
[]
[null,{"$f":"\"(\"&K1&\" + \"&L1&\") * \"&M1","v":"(2 + 2) * 3"}]
[]
[null,"Remember:"]
[null,{"$f":"\"(\"&K1&\" + \"&L1&\") * \"&M1&\" = \"&(K1+L1)*M1","v":"(2 + 2) * 3 = 12"}]
[null,{"$f":"K1&\" + \"&L1&\" * \"&M1&\" = \"&K1+L1*M1","v":"2 + 2 * 3 = 8"}]
[]
[null,"Cost Of Goods Example:"]
[null,"Beg Qty","End Qty","Value Each","COGS"]
[null,10,3,5,null," <<== Incorrect"]
[]
[null,"Beg Qty","End Qty","Value Each","COGS"]
[null,10,3,5,null," <<== Correct"]

{"sheet":"Order (an)","index":12,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["What is the answer?",null,{"$f":"K1&\" + \"&L1&\" * \"&M1","v":"2 + 2 * 3"},null,null,null,null,null,null,null,2,2,3]
[]
[null,null,"12 or 8 ?????"]
[]
[" Prove it!!!!  (Excel does not make math or logic errors)"]
[]
[null,{"$f":"$C$1","v":"2 + 2 * 3"},{"$f":"2+2*3","v":8},null,"<<== Use Formula Evaluator to \"see\" how"]
[null,null,null,null,"Excel uses the Order of Operations:"]
[null,null,null,null,"Formula Ribbon Tab, Formula Auditing"]
[null,null,null,null,"Group, Evaluate Formula."]
[]
["Math order of operations",null,null,null,null,"Math order of operations"]
[1,"First, do everything in the parentheses",null,null,null,1," ( )"]
[2,"Second, do all exponents",null,null,null,2," ^"]
[3,"Third, do all multiplication and division, left to right",null,null,null,3," * / Left to Right"]
[4,"Fourth, do all adding and subtracting, left to right",null,null,null,4," + - Left to Right"]
[]
[null,"If you really want to do the adding first you must use Parenthesis like:"]
[]
[null,{"$f":"\"(\"&K1&\" + \"&L1&\") * \"&M1","v":"(2 + 2) * 3"},{"$f":"(2+2)*3","v":12}]
[]
[null,"Remember:"]
[null,{"$f":"\"(\"&K1&\" + \"&L1&\") * \"&M1&\" = \"&(K1+L1)*M1","v":"(2 + 2) * 3 = 12"}]
[null,{"$f":"K1&\" + \"&L1&\" * \"&M1&\" = \"&K1+L1*M1","v":"2 + 2 * 3 = 8"}]
[]
[null,"Cost Of Goods Example:"]
[null,"Beg Qty","End Qty","Value Each","COGS"]
[null,10,3,5,{"$f":"B28-C28*D28","v":-5}," <<== Incorrect"]
[]
[null,"Beg Qty","End Qty","Value Each","COGS"]
[null,10,3,5,{"$f":"(B31-C31)*D31","v":35}," <<== Correct"]

{"sheet":"Functions","index":13,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Expenses",null,null,"Sales In 1 Day"]
[null,79,null,null,727]
[null,35,null,null,2547]
[null,137,null,null,216]
[null,40,null,null,1031]
[null,18,null,null,276]
[null,109,null,null,844]
[null,35,null,null,3598]
[null,119,null,null,3867]
[null,67,null,null,2672]
["Total",null,null,"Average"]
[]
["Car Loan",16000]
["Monthly Rate",5.0000000000000001E-3]
["Months Until Due",60]
["Monthly Payment"]

{"sheet":"Functions (an)","index":14,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Expenses",null,null,"Sales In 1 Day"]
[null,79,null,null,727]
[null,35,null,null,2547]
[null,137,null,null,216]
[null,40,null,null,1031]
[null,18,null,null,276]
[null,109,null,null,844]
[null,35,null,null,3598]
[null,119,null,null,3867]
[null,67,null,null,2672]
["Total",{"$f":"SUM(B2:B10)","v":639},null,"Average",{"$f":"AVERAGE(E2:E10)","v":1753.1111111111111}]
[]
["Car Loan",16000]
["Monthly Rate",5.0000000000000001E-3]
["Months Until Due",60]
["Monthly Payment",{"$f":"PMT(B14,B15,B13)","v":-309.32482447084664}]

{"sheet":"Cell References","index":15,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Relative Cell References"]
[null,"When formulas with Relative Cell References are copied, the Cell References \"Move\" with the copied formula."]
[null,"A Relative Cell Reference always looks relative to the position of the formula being copied."]
[]
[1,"Name","Quiz 1","Quiz 2","Quiz 3"]
[null,"Joe",18,15,3]
[null,"Chin",16,18,2]
[null,"Kiko",2,4,15]
[null,"Sue",17,16,3]
[null,"Isaac",24,7,9]
[null,"Sioux",16,16,3]
[null,"Phil",14,5,16]
[null,"Luong",20,23,1]
[null,"Jo",14,7,18]
[null,"Mo",7,21,6]
[null,"Phuong",1,5,3]
[null,"June",11,5,19]
[null,"Average",null,null,null,null,"Keyboard: F2 Key puts cell in Edit Mode"]
[]
[2,null,"Jan","Feb","Mar","Apr","May"]
[null,null,3908,1012,3809,4761,2266]
[null,null,2339,2923,2085,2609,2848]
[null,null,1165,4731,4712,3055,3158]
[null,null,3105,3135,1021,1603,4038]
[null,null,3108,4804,2979,2899,2634]
[null,null,4237,1079,2746,4967,4749]
[null,null,1819,2438,3081,4750,4589]
[null,"Total"]
[]
[null,"Absolute Cell References"]
[null,"When formulas with Absolute Cell References are copied, the Cell References are \"locked\" throughout the copy action."]
[null,"The Absolute Cell Reference does not move throughout copy action."]
[]
[3,"Names","Gross Pay","Deduction",null,"Assumptions"]
[null,"Joe",5000,null,null,"Tax Rate",0.125]
[null,"Chin",4500]
[null,"Kiko",6300,null,null,"<<== In the Payroll Chapters this Excel knowledge will save us a lot of time"]
[null,"Sue",5800]
[null,"Isaac",4300,null,null,"If Your Cursor is touching the Cell Reference, Use F4 key to Lock Cell Reference"]
[]
[4,"Student Grades"]
[null,"Names","Points For Class","% Grade"]
[null,"Max Possible",500,{"$f":"C43/$C$43","v":1}]
[null,"Joe",478,null," ","We are comparing a \"Part\" to the \"Whole\""]
[null,"Chin",366,null,null,"<<== In the Percent Chapters this Excel knowledge will save us a lot of time"]
[null,"Kiko",272]
[null,"Sue",478,null,null,"**Note: There are other types of Cell References, but we will not use them in this class."]
[null,"Isaac",468]
[null,"Sioux",255]
[null,"Phil",244]
[null,"Luong",449]
[null,"Jo",144]
[null,"Mo",101]
[null,"Phuong",221]
[null,"June",373]

{"sheet":"Cell References (an)","index":16,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Relative Cell References"]
[null,"When formulas with Relative Cell References are copied, the Cell References \"Move\" with the copied formula."]
[null,"A Relative Cell Reference always looks relative to the position of the formula being copied."]
[]
[1,"Name","Quiz 1","Quiz 2","Quiz 3"]
[null,"Joe",18,15,3]
[null,"Chin",16,18,2]
[null,"Kiko",2,4,15]
[null,"Sue",17,16,3]
[null,"Isaac",24,7,9]
[null,"Sioux",16,16,3]
[null,"Phil",14,5,16]
[null,"Luong",20,23,1]
[null,"Jo",14,7,18]
[null,"Mo",7,21,6]
[null,"Phuong",1,5,3]
[null,"June",11,5,19]
[null,"Average",{"$f":"AVERAGE(C6:C17)","v":13.333333333333334},{"$f":"AVERAGE(D6:D17)","v":11.833333333333334},{"$f":"AVERAGE(E6:E17)","v":8.1666666666666661},null,"Keyboard: F2 Key puts cell in Edit Mode"]
[]
[2,null,"Jan","Feb","Mar","Apr","May","Total",null,"Mon"]
[null,"Pro 1",3908,1012,3809,4761,2266,{"$f":"SUM(C21:G21)","v":15756},null,"Tue"]
[null,"Pro 2",2339,2923,2085,2609,2848,{"$f":"SUM(C22:G22)","v":12804},null,"Wed"]
[null,"Pro 3",1165,4731,4712,3055,3158,16821,null,"Thu"]
[null,"Pro 4",3105,3135,1021,1603,4038,12902,null,"Fri"]
[null,"Pro 5",3108,4804,2979,2899,2634,16424]
[null,"Pro 6",4237,1079,2746,4967,4749,17778,null,"Monday"]
[null,"Pro 7",1819,2438,3081,4750,4589,16677,null,"Tuesday"]
[null,"Total",{"$f":"SUM(C21:C27)","v":19681},{"$f":"SUM(D21:D27)","v":20122},20433,24644,24282,109162,null,"Wednesday"]
[]
[null,"Absolute Cell References"]
[null,"When formulas with Absolute Cell References are copied, the Cell References are \"locked\" throughout the copy action."]
[null,"The Absolute Cell Reference does not move throughout copy action."]
[]
[3,"Names","Gross Pay","Deduction",null,"Assumptions"]
[null,"Joe",5000,{"$f":"C35*$G$35","v":625},null,"Tax Rate",0.125]
[null,"Chin",4500,{"$f":"C36*$G$35","v":562.5}]
[null,"Kiko",6300,787.5,null,"<<== In the Payroll Chapters this Excel knowledge will save us a lot of time"]
[null,"Sue",5800,725]
[null,"Isaac",4300,{"$f":"C39*$G$35","v":537.5},null,"If Your Cursor is touching the Cell Reference, Use F4 key to Lock Cell Reference"]
[]
[4,"Student Grades"]
[null,"Names","Points For Class","% Grade"]
[null,"Max Possible",500,{"$f":"C43/$C$43","v":1}]
[null,"Joe",478,{"$f":"C44/$C$43","v":0.95599999999999996}," ","We are comparing a \"Part\" to the \"Whole\""]
[null,"Chin",366,{"$f":"C45/$C$43","v":0.73199999999999998},null,"<<== In the Percent Chapters this Excel knowledge will save us a lot of time"]
[null,"Kiko",272,0.54400000000000004]
[null,"Sue",478,0.95599999999999996,null,"**Note: There are other types of Cell References, but we will not use them in this class."]
[null,"Isaac",468,0.93600000000000005]
[null,"Sioux",255,0.51]
[null,"Phil",244,0.48799999999999999]
[null,"Luong",449,0.89800000000000002]
[null,"Jo",144,0.28799999999999998]
[null,"Mo",101,0.20200000000000001]
[null,"Phuong",221,0.442]
[null,"June",373,{"$f":"C55/$C$43","v":0.746}]

{"sheet":"All","index":17,"n_rows":6,"n_cols":45,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["You are the payroll accountant at Rad Corp. The employee names are Sioux, Tom, Chin and Sheliadawn. The Weekly Pay for Sioux is $750.00, for Tom it is $800.00, for Chin it is $795.00, and for Sheliadawn it is $825.00. The Tax Deduction rate is 7.95%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"You are the payroll accountant at \"&AP3&\". The employee names are \"&AQ3&\", \"&AQ4&\", \"&AQ5&\" and \"&AQ6&\". The \"&AR2&\" for \"&AQ3&\" is \"&DOLLAR(AR3)&\", for \"&AQ4&\" it is \"&DOLLAR(AR4)&\", for \"&AQ5&\" it is \"&DOLLAR(AR5)&\", and for \"&AQ6&\" it is \"&DOLLAR(AR6)&\". The Tax Deduction rate is \"&TEXT(AS3,\"0.00%\")&\". Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.\"","v":"You are the payroll accountant at Rad Corp. The employee names are Sioux, Tom, Chin and Sheliadawn. The Weekly Pay for Sioux is $750.00, for Tom it is $800.00, for Chin it is $795.00, and for Sheliadawn it is $825.00. The Tax Deduction rate is 7.95%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Hidden Here that is linked to Cell A1 ==>> ","Company Name","Name","Weekly Pay","Deduction Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rad Corp","Sioux",750,7.9500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tom",800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chin",795]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheliadawn",825]

{"sheet":"All (an)","index":18,"n_rows":8,"n_cols":45,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["You are the payroll accountant at Rad Corp. The employee names are Sioux, Tom, Chin and Sheliadawn. The Weekly Pay for Sioux is $750.00, for Tom it is $800.00, for Chin it is $795.00, and for Sheliadawn it is $825.00. The Tax Deduction rate is 7.95%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"You are the payroll accountant at \"&AP3&\". The employee names are \"&AQ3&\", \"&AQ4&\", \"&AQ5&\" and \"&AQ6&\". The \"&AR2&\" for \"&AQ3&\" is \"&DOLLAR(AR3)&\", for \"&AQ4&\" it is \"&DOLLAR(AR4)&\", for \"&AQ5&\" it is \"&DOLLAR(AR5)&\", and for \"&AQ6&\" it is \"&DOLLAR(AR6)&\". The Tax Deduction rate is \"&TEXT(AS3,\"0.00%\")&\". Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.\"","v":"You are the payroll accountant at Rad Corp. The employee names are Sioux, Tom, Chin and Sheliadawn. The Weekly Pay for Sioux is $750.00, for Tom it is $800.00, for Chin it is $795.00, and for Sheliadawn it is $825.00. The Tax Deduction rate is 7.95%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Hidden Here that is linked to Cell A1 ==>> ","Company Name","Name","Weekly Pay","Deduction Rate"]
["Names","Weekly Pay","Tax Deduction",null,"Tax Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rad Corp","Sioux",750,7.9500000000000001E-2]
["Sioux",750,{"$f":"B4*$E$4","v":59.625},null,7.9500000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tom",800]
["Tom",800,{"$f":"B5*$E$4","v":63.6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chin",795]
["Chin",795,63.202500000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheliadawn",825]
["Sheliadawn",825,65.587500000000006]
["Total",{"$f":"SUM(B4:B7)","v":3170},{"$f":"SUM(C4:C7)","v":252.01500000000001}]

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

{"sheet":"HW(1)","index":20,"n_rows":6,"n_cols":45,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["You are the payroll accountant at Fun Industries. The employee names are Pham, Loung, Tina and Mo. The Weekly Pay for Pham is $910.00, for Loung it is $890.00, for Tina it is $725.00, and for Mo it is $695.00. The Tax Deduction rate is 12.50%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"You are the payroll accountant at \"&AP3&\". The employee names are \"&AQ3&\", \"&AQ4&\", \"&AQ5&\" and \"&AQ6&\". The \"&AR2&\" for \"&AQ3&\" is \"&DOLLAR(AR3)&\", for \"&AQ4&\" it is \"&DOLLAR(AR4)&\", for \"&AQ5&\" it is \"&DOLLAR(AR5)&\", and for \"&AQ6&\" it is \"&DOLLAR(AR6)&\". The Tax Deduction rate is \"&TEXT(AS3,\"0.00%\")&\". Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.\"","v":"You are the payroll accountant at Fun Industries. The employee names are Pham, Loung, Tina and Mo. The Weekly Pay for Pham is $910.00, for Loung it is $890.00, for Tina it is $725.00, and for Mo it is $695.00. The Tax Deduction rate is 12.50%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Hidden Here that is linked to Cell A1 ==>> ","Company Name","Name","Weekly Pay","Deduction Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fun Industries","Pham",910,0.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loung",890]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tina",725]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mo",695]

{"sheet":"HW(1an)","index":21,"n_rows":8,"n_cols":45,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["You are the payroll accountant at Fun Industries. The employee names are Pham, Loung, Tina and Mo. The Weekly Pay for Pham is $910.00, for Loung it is $890.00, for Tina it is $725.00, and for Mo it is $695.00. The Tax Deduction rate is 12.50%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"You are the payroll accountant at \"&AP3&\". The employee names are \"&AQ3&\", \"&AQ4&\", \"&AQ5&\" and \"&AQ6&\". The \"&AR2&\" for \"&AQ3&\" is \"&DOLLAR(AR3)&\", for \"&AQ4&\" it is \"&DOLLAR(AR4)&\", for \"&AQ5&\" it is \"&DOLLAR(AR5)&\", and for \"&AQ6&\" it is \"&DOLLAR(AR6)&\". The Tax Deduction rate is \"&TEXT(AS3,\"0.00%\")&\". Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee.\"","v":"You are the payroll accountant at Fun Industries. The employee names are Pham, Loung, Tina and Mo. The Weekly Pay for Pham is $910.00, for Loung it is $890.00, for Tina it is $725.00, and for Mo it is $695.00. The Tax Deduction rate is 12.50%. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the tax for each employee."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Hidden Here that is linked to Cell A1 ==>> ","Company Name","Name","Weekly Pay","Deduction Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fun Industries","Pham",910,0.125]
["Company Name","Name","Weekly Pay","Tax Deduction",null,"Deduction Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loung",890]
["Fun Industries","Pham",910,{"$f":"C5*$F$5","v":113.75},null,0.125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tina",725]
[null,"Loung",890,111.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mo",695]
[null,"Tina",725,90.625]
[null,"Mo",695,86.875]

{"sheet":"HW(2)","index":22,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["If Company A had Revenue of $50,250 and Expenses of $43,795, what is the Net Income? Net Income is Revenue - Expenses. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the Net Income."]

{"sheet":"HW(2an)","index":23,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["If Company A had Revenue of $50,250 and Expenses of $43,795, what is the Net Income? Net Income is Revenue - Expenses. Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the Net Income."]
[]
[]
["Revenue",50250]
["Expenses",43795]
["Net Income",{"$f":"B4-B5","v":6455}]

{"sheet":"HW(3)","index":24,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Format the column of numbers below and then in the cells below calculate the total, the average and the maximum value (remember if you don't know what function to use for finding the maximum, search the Insert Functions dialog box)."]
[]
[null,"Sales"]
[null,308.83]
[null,139.57]
[null,343.32]
[null,254.63]
[null,171.23]
[null,213.12]
[null,437.15]
[null,253.41]
[null,485.18]
[null,289.14]
[null,411.18]
[null,222.68]
[null,117.94]
[null,234.59]
[null,436.9]
[null,143.02000000000001]

{"sheet":"HW(3an)","index":25,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Format the column of numbers below and then in the cells below calculate the total, the average and the maximum value (remember if you don't know what function to use for finding the maximum, search the Insert Functions dialog box)."]
[]
[null,"Sales"]
[null,308.83]
[null,139.57]
[null,343.32]
[null,254.63]
[null,171.23]
[null,213.12]
[null,437.15]
[null,253.41]
[null,485.18]
[null,289.14]
[null,411.18]
[null,222.68]
[null,117.94]
[null,234.59]
[null,436.9]
[null,143.02000000000001]
["Total",{"$f":"SUM(B4:B19)","v":4461.8899999999994}]
["Average",{"$f":"AVERAGE(B4:B19)","v":278.86812499999996}]
["Max",{"$f":"MAX(B4:B19)","v":485.18}]

{"sheet":"HW(4)","index":26,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["If an invoice due date is 9/23/2011 and todays date is 11/15/2011, how many days past due is the invoice? Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the Days Past Due."]

{"sheet":"HW(4an)","index":27,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["If an invoice due date is 9/23/2011 and todays date is 11/15/2011, how many days past due is the invoice? Using your new knowledge about Excel Formulas, Formatting and Cell References, use the cells below to make the necessary calculations to determine the Days Past Due."]
[]
["Invoice Due Date","2011-09-23"]
["Today's Date","2011-11-15"]
["Days Past Due",{"$f":"B4-B3","v":53}]

{"sheet":"HW(5)","index":28,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Format the table below with Number Format and add all the sales for each week and each employee."]
[]
["Names","Sales Week 1","Sales Week 2","Sales Week 3","Sales Week 4","Sales Week 5","Total"]
["Lenore Kaser",565.17999999999995,755.62,528.33000000000004,936.45,864.32]
["Emilia Nulph",936.55,894.35,806.61,432.86,477.93]
["Erik Northam",855.42,764.41,455.42,398.65,562.03]
["Javier Nitti",793.25,832.89,754.65,722.73,483.64]
["Margery Vanderheyden",498.63,612.57000000000005,839.66,720.34,380.08]
["Cody Santee",552.62,783.62,355.65,616,625.87]
["Darren Dysart",420.69,958.03,658.03,631.67999999999995,763.33]
["Rae Maultsby",918.32,392.17,631.34,601.64,649.48]
["Mathew Pincus",560.38,402.49,992.47,482.95,539.41]
["Dona Hadsell",389.31,640,615.54,991,694.11]
["Total"]

{"sheet":"HW(5an)","index":29,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Format the table below with Number Format and add all the sales for each week and each employee."]
[]
["Names","Sales Week 1","Sales Week 2","Sales Week 3","Sales Week 4","Sales Week 5","Total"]
["Lenore Kaser",565.17999999999995,755.62,528.33000000000004,936.45,864.32,{"$f":"SUM(B4:F4)","v":3649.9}]
["Emilia Nulph",936.55,894.35,806.61,432.86,477.93,3548.3]
["Erik Northam",855.42,764.41,455.42,398.65,562.03,3035.9300000000003]
["Javier Nitti",793.25,832.89,754.65,722.73,483.64,3587.16]
["Margery Vanderheyden",498.63,612.57000000000005,839.66,720.34,380.08,3051.28]
["Cody Santee",552.62,783.62,355.65,616,625.87,2933.7599999999998]
["Darren Dysart",420.69,958.03,658.03,631.67999999999995,763.33,3431.7599999999998]
["Rae Maultsby",918.32,392.17,631.34,601.64,649.48,3192.95]
["Mathew Pincus",560.38,402.49,992.47,482.95,539.41,2977.7]
["Dona Hadsell",389.31,640,615.54,991,694.11,3329.96]
["Total",{"$f":"SUM(B4:B13)","v":6490.35},{"$f":"SUM(C4:C13)","v":7036.15},{"$f":"SUM(D4:D13)","v":6637.7000000000007},{"$f":"SUM(E4:E13)","v":6534.3},{"$f":"SUM(F4:F13)","v":6040.2},32738.7]

{"sheet":"HW(6)","index":30,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"In the Green Cell below (cell \"&ADDRESS(ROW(A9),COLUMN(A9),4)&\"), write statement about what you think the problem is with the calculation below.\"","v":"In the Green Cell below (cell A9), write statement about what you think the problem is with the calculation below."}]
[]
["Product","Boomerang"]
["Number of Product Sold",15]
["Price Each",17.55]
["Total Revenue",{"$f":"B5*B4","v":263.25}]
[]
["In the Green Cell below, write statement about what you think the problem is with the calculation above."]

{"sheet":"HW(6an)","index":31,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"In the Green Cell below (cell \"&ADDRESS(ROW(A9),COLUMN(A9),4)&\"), write statement about what you think the problem is with the calculation below.\"","v":"In the Green Cell below (cell A9), write statement about what you think the problem is with the calculation below."}]
[]
["Product","Boomerang",null,"Product","Boomerang"]
["Number of Product Sold",15,null,"Number of Product Sold",15]
["Price Each",17.55,null,"Price Each",17.55]
["Total Revenue",{"$f":"B5*B4","v":263.25},null,"Total Revenue",{"$f":"E5*E4","v":263.25}]
[]
["In the Green Cell below, write statement about what you think the problem is with the calculation above."]
[{"$f":"\"I was tricked by formatting!!!! But then I examined the cells and found that cell \"&ADDRESS(ROW(B5),COLUMN(B5),4)&\" had NO DECIMALS SHOWING!!. I copied the table and pasted it to the side and then increased the decimals to show the correct number.\"","v":"I was tricked by formatting!!!! But then I examined the cells and found that cell B5 had NO DECIMALS SHOWING!!. I copied the table and pasted it to the side and then increased the decimals to show the correct number."}]

{"sheet":"HW(7)","index":32,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["In the cells below, write the order of operations for math (Remember; it is just 4 things!! :)"]

{"sheet":"HW(7an)","index":33,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["In the cells below, write the order of operations for math (Remember; it is just 4 things!! :)"]
[]
[]
[1,"Parenthesis"," ( )"]
[2,"Exponents"," ^"]
[3,"Multiplicationa dn Division, Left to Right"," * /"]
[4,"Adding and Substracting, Left to Right"," + -","<<== if you want to type a symbol into the cell, it is"]
[null,null,null,"best to type a space first and then the symbol."]