TKM AMOUNT OF COST COST BEHAVIOR NURULE OR PERIOD Insmictions for Excel Lab 16 1. If you need outside help with VLOOKUP, copy and paste the link below into your browser. Watch "Introduction to VLOOKUP(:59 minutes and How and when, to use VLOOKUT (5:37 mile) https://suppor.oice.cua-us/article/Video-VLOOKUP-Whem-and-bow-to-use-it-99861570-5542-4148-a536-724823014765 F F F F Y F F IF F F V V F F V PER PHR PER PER PER TRO PRD PHR PER PRO PRO TRO PRD PRD PER 2. With your new food knowledge and appreciation for -VLOOKUP, use the action in cells H17, 117, and J17 to look up cell G17 (that is, go find Waldo). We want to fill Type of Cnst", "Lost Behavior', and Product or Period' IN H17, 117, and 117 respectively after typing referencing any "Item: from colummA in cell G1%. 2. Once you feel that VLOOKLP is written correctly in the three aforementioned cells, type de reference Accounting manager's salary' in call 017 to see if H17, 117, and J17 change. 4. Save your assignment with the proper name: (first name) (last name) - Excel #s_F212021 and upload to Learn before the due date. Congratulations, you're a-VLOOKUP expert! M ITEM TYPE OF COSTCOST BEHAVIOR PRODUCT OR PERIOD Accounting manager's salary Administrative office insurance Advertising Company president's salary Cost of goeds sold Depection on clory building Depreciation on factory equipment Depreciation on office huilding Depreciation on office Equipment Direct labor Daca Factory Insurance Factory machinery rent Cile, crews, point and other mall parts used in production Heat & electricity for the general office Income tax expense Indirect labor La direct materials Ise on showroom Janitorial services for administral valices Maintenance salaries factory Manufacturing supervisor's salary Payroll taxes administration Payroll taxes-Eactory Property taxectory Rent expense on showroom Salaries of accounts receivabljazyable clerks Sales commissions Sales Discount Slee's salary Supplics for adminisuntive lice Wages for assembly line workers 5236,108 OE S174,992 $261,026 OH S303.610 OE $217,846 OB OE 5332,197 MOI 5314,093 MOH $207,591 CH S248,726 OH: $340,982 DL S315,521 DM 5170,545 MOH S163,420 MOH S258.545 MOH S341,119 : 5176,02 CH S171,301 MOI $183,712 MOI! 5308,839 OE S172,953 ( S246,610 MOH S199,264 MOH S187,621 OD 3228,154 MOI! 5175,356 MOH S159,014 CH S243,906 S210,54 OE S182,211 OD OE 5163,446 OD OE 5173,756 OH ( $219,113 MOM Greco vells above will be graded. V V Y F F F F V V F F F V V F M V V CA PER PRO TRO PER PER PRD PRO PIR TRO PRO PER PER PER PER PER PER PRD Pro Tips for ExcelLab 6 Don't try to click xxl crap the locals from H17 TO J17. It is best to calcach Poemuls indepenkuly - Verify all your cell references for the table arrays are absolute cell references (0.5, SAS). Using cithar "FALSE' 'O' is sceptable for renge_lockwi + Verify that your final submission has "Acevanting managers zilary" in cell G17. Make sure Gat you are created a complete VLOOKUP function in each cell There are 4 parts inside och VLOOKUP Formula Grading Rubrie for Excellan - 4 points for each missing or incorrect cell reference to G17 (12 pos total - 2 points for each missing or incorrect alam index numer (total) - 2 points for each missing or incorrect use of me false sements in the-VLOOKUP formula i pts Tulal) - 2 points for any other text other than "Accounting manager's salary" in cell GI? - 2 points for incorrect be name. Shuuld be [First Name) (Last Name) - Excel 6 F3112021 - 20 prints if any all groenoll das y eve-VLOOKUP formula - 20 points for an Excel Lab 16 from previous semester TKM AMOUNT OF COST COST BEHAVIOR NURULE OR PERIOD Insmictions for Excel Lab 16 1. If you need outside help with VLOOKUP, copy and paste the link below into your browser. Watch "Introduction to VLOOKUP(:59 minutes and How and when, to use VLOOKUT (5:37 mile) https://suppor.oice.cua-us/article/Video-VLOOKUP-Whem-and-bow-to-use-it-99861570-5542-4148-a536-724823014765 F F F F Y F F IF F F V V F F V PER PHR PER PER PER TRO PRD PHR PER PRO PRO TRO PRD PRD PER 2. With your new food knowledge and appreciation for -VLOOKUP, use the action in cells H17, 117, and J17 to look up cell G17 (that is, go find Waldo). We want to fill Type of Cnst", "Lost Behavior', and Product or Period' IN H17, 117, and 117 respectively after typing referencing any "Item: from colummA in cell G1%. 2. Once you feel that VLOOKLP is written correctly in the three aforementioned cells, type de reference Accounting manager's salary' in call 017 to see if H17, 117, and J17 change. 4. Save your assignment with the proper name: (first name) (last name) - Excel #s_F212021 and upload to Learn before the due date. Congratulations, you're a-VLOOKUP expert! M ITEM TYPE OF COSTCOST BEHAVIOR PRODUCT OR PERIOD Accounting manager's salary Administrative office insurance Advertising Company president's salary Cost of goeds sold Depection on clory building Depreciation on factory equipment Depreciation on office huilding Depreciation on office Equipment Direct labor Daca Factory Insurance Factory machinery rent Cile, crews, point and other mall parts used in production Heat & electricity for the general office Income tax expense Indirect labor La direct materials Ise on showroom Janitorial services for administral valices Maintenance salaries factory Manufacturing supervisor's salary Payroll taxes administration Payroll taxes-Eactory Property taxectory Rent expense on showroom Salaries of accounts receivabljazyable clerks Sales commissions Sales Discount Slee's salary Supplics for adminisuntive lice Wages for assembly line workers 5236,108 OE S174,992 $261,026 OH S303.610 OE $217,846 OB OE 5332,197 MOI 5314,093 MOH $207,591 CH S248,726 OH: $340,982 DL S315,521 DM 5170,545 MOH S163,420 MOH S258.545 MOH S341,119 : 5176,02 CH S171,301 MOI $183,712 MOI! 5308,839 OE S172,953 ( S246,610 MOH S199,264 MOH S187,621 OD 3228,154 MOI! 5175,356 MOH S159,014 CH S243,906 S210,54 OE S182,211 OD OE 5163,446 OD OE 5173,756 OH ( $219,113 MOM Greco vells above will be graded. V V Y F F F F V V F F F V V F M V V CA PER PRO TRO PER PER PRD PRO PIR TRO PRO PER PER PER PER PER PER PRD Pro Tips for ExcelLab 6 Don't try to click xxl crap the locals from H17 TO J17. It is best to calcach Poemuls indepenkuly - Verify all your cell references for the table arrays are absolute cell references (0.5, SAS). Using cithar "FALSE' 'O' is sceptable for renge_lockwi + Verify that your final submission has "Acevanting managers zilary" in cell G17. Make sure Gat you are created a complete VLOOKUP function in each cell There are 4 parts inside och VLOOKUP Formula Grading Rubrie for Excellan - 4 points for each missing or incorrect cell reference to G17 (12 pos total - 2 points for each missing or incorrect alam index numer (total) - 2 points for each missing or incorrect use of me false sements in the-VLOOKUP formula i pts Tulal) - 2 points for any other text other than "Accounting manager's salary" in cell GI? - 2 points for incorrect be name. Shuuld be [First Name) (Last Name) - Excel 6 F3112021 - 20 prints if any all groenoll das y eve-VLOOKUP formula - 20 points for an Excel Lab 16 from previous semester