A D COST BEHAVIOR ITEM F F F F V F F F F V V F F V PRODUCT OR PERIOD PER PER PER PER PER PRO PRO PER PER PRO PRO PRO PRO PRO B TYPE AMOUNT OF COST $236.108 OE $174,992 OE $261,026 OE $303,610 OE $247,846 OE $332,197 MOH $314,093 MOH $207,591 OE $248,726 OE $340,982 DL $315,521 DM $170,545 MOH $163,420 MOH $258,545 MOH $341,119 OE $176,027 OE $171,301 MOH $183,712 MOH $308,839 OE $172,953 OE $246,610 MOH $199,264 MOH $187,621 OE $228,154 MOH $175,356 MOH $159,034 OE $248,906 OE $210,544 OE $182 211 OE $163,446 OE $173.756 OE $219,113 MOH M 1 2 Accounting manager's salary 3 Administrative office insurance 4 Advertising 3. Company president's salary 6 Cost of goods sold 7 Depreciation on factory building 8 Depreciation on factory equipment 9 Depreciation on office building 10 Depreciation on office equipment 11 Direct labor 12 Direct materials 13 Factory insurance 14 Factory machinery rent 15 Glue, screws, paint and other small parts used in production 16 Heat & electricity for the general office 17 Income tax expense 18 Indirect labor 19 Indirect materials 20 Insurance on showroom 21 Janitorial services for administrative offices 22 Maintenance salaries - factory 23 Manufacturing supervisor's salary 24 Payroll taxes - administration 25 Payroll taxes-factory 26 Property taxes-factory 27 Rent expense on showroom 28 Salaries of accounts receivable payable clerki 29 Sales commissions 30 Sales Discount 31 Sales manager's salary 32 Supplies for administrative office 33 Wages for assembly line workers 34 35 36 37 38 PER V V V F F F F V V F PP14 PER PRO PRO PER PER PRO PRO PER PRO PRO PER PER PER PER PER PER PRO F V V F M V InstructoExcel Lab 6 Il you need outside help with VLOOKUP, copy and paste the link below into your browser. Watch "Introduction to VLOOKUP" (3-59 minutes) and "How, and when to use VLOOKUP" (5:37 minutes) http://support.office.com Vides-VLOOKUP West and lactose 19861572-5542-4148-536724823014785 2. With your new found knowledge and appreciation for VLOOKUP, une the function in cells 117, NT, and to look up call (that is, go find Waldo). We want to fill Type of Cost", "Cout Behavior and Product or Period' IN 117, 117, and J17 respectively after typing referencing any hem from column Am cell 17. 3. Once you feel that VLOOKUP is written correctly in the three aforementioned celli, type or reference Accounting manager's salary" in cell G17 to see if 117, 117, and J17 change 4. Save your satigrutent with the proper (first name) (last name) Excel #6_Fall2021 and upload to Leam before the due date. Congratulations, you're a =VLOOKUP espert! ITEM TYPE OF COST COST BEHAVIOR PRODUCT OR PERIOD Green cells above will be ded. Prof's Pro Tips for Excel Lab #6 Don't try to click and drag the formula from HIZ TO J17. It is best to create each formula independently Verify all your cell references for the table arrays are absolute cell reference (B.SASI). - Using either "FALSE" or "O is acceptable for from_lookup Verify that your final submission has "Accounting manager's salary in cell G17 Make sure that you have a created a complete VLOOKUP function in each cell. There are 4 parts inside each VLOOKUP formula Grading Rubric for Excel Lab #6 4 points for each missing or incorrect cell reference to G17 (12 pts total) - 2 points for each missing or incorrect column index sumber (6 pts total) - 2 points for each missing or incorrect use of true false statements in the VLOOKUP formla (8 pts total) - 2 points for any other tect other than Accounting manager's salary in cell G17 - 2 points for incorrect file name Should be (First Name) (Last Name) - Excel+6_Fall2021 20 points if any all green cell does not have a VLOOKUP formula - 20 points for an Excel Lab 6 from previous semester I for Excel La 1. you need outside help with VLOOKUT, copy and paste the link below into your browser. Watch "Introduction to VLOOKUP (3:59 mm) and "How, and when to me VLOTO Thu H) pepperonike.com/est/VideoVLOOKUP-White-and-hot-315735424148-253672423014785 2. Wiyong new found knowledge and appreciation for -VLOOKUP, use the function in cells 117. 11, and to look up call GT (that is, go find Waldo). We want to fill Type of Coot", "Coul Behavior and Product or Period IN HI7, 117, and J17 respectively after typing sering my ten free column A in cell G17. 3. Once you feel that VLOOKUP is written correctly in the three forestioned cella, type of reference Accounting manager's salary" in cell G17 to see if H117, 117, and 117 change 4. Save your assignment with the proper samt: (fint sama) (last name) - Excel #6_Fall 2021 and upload to Learn before the due date. Congratulations, you're a VLOOKUP expert! ITEM TYPE OF COST COST BEHAVIOR PRODUCT OR PERIOD Green cells above will be dedi Profs Pro Tips for Excel Lab 6 Don't try to click and dry the formula from H17 TO J17. It is best to create each formula independently Verify all your cell references for the table stays are absolute cell references (es. SASI) . Uning either "FALSE" or "O is acceptable for flookpl Verify that your finalissional Accounting manager's salary in cell G17 - Make sure that you have a created a complete VLOOKUP function in each cell There are parts and each VLOOKUP formula Grading Rubric for Excel Labo 4 points for each missing or correct cell reference to G17 (12 pts total) 2 points for each missing or incorrect cousinde aber pts total -2 points for each mining or incorrect use of trafalse statements in the =VLOOKUP formula (8 pts total) - 2 points for any other text other than "Accounting manager's salary in cell G17 -2 points for correct file name. Should be (First Name) (Last Name) - Excel 6 Fall2021 20 points if any all green cell does not have a VLOOKUP formula 20 points for an Excel Lab 6 from a presso semester A D COST BEHAVIOR ITEM F F F F V F F F F V V F F V PRODUCT OR PERIOD PER PER PER PER PER PRO PRO PER PER PRO PRO PRO PRO PRO B TYPE AMOUNT OF COST $236.108 OE $174,992 OE $261,026 OE $303,610 OE $247,846 OE $332,197 MOH $314,093 MOH $207,591 OE $248,726 OE $340,982 DL $315,521 DM $170,545 MOH $163,420 MOH $258,545 MOH $341,119 OE $176,027 OE $171,301 MOH $183,712 MOH $308,839 OE $172,953 OE $246,610 MOH $199,264 MOH $187,621 OE $228,154 MOH $175,356 MOH $159,034 OE $248,906 OE $210,544 OE $182 211 OE $163,446 OE $173.756 OE $219,113 MOH M 1 2 Accounting manager's salary 3 Administrative office insurance 4 Advertising 3. Company president's salary 6 Cost of goods sold 7 Depreciation on factory building 8 Depreciation on factory equipment 9 Depreciation on office building 10 Depreciation on office equipment 11 Direct labor 12 Direct materials 13 Factory insurance 14 Factory machinery rent 15 Glue, screws, paint and other small parts used in production 16 Heat & electricity for the general office 17 Income tax expense 18 Indirect labor 19 Indirect materials 20 Insurance on showroom 21 Janitorial services for administrative offices 22 Maintenance salaries - factory 23 Manufacturing supervisor's salary 24 Payroll taxes - administration 25 Payroll taxes-factory 26 Property taxes-factory 27 Rent expense on showroom 28 Salaries of accounts receivable payable clerki 29 Sales commissions 30 Sales Discount 31 Sales manager's salary 32 Supplies for administrative office 33 Wages for assembly line workers 34 35 36 37 38 PER V V V F F F F V V F PP14 PER PRO PRO PER PER PRO PRO PER PRO PRO PER PER PER PER PER PER PRO F V V F M V InstructoExcel Lab 6 Il you need outside help with VLOOKUP, copy and paste the link below into your browser. Watch "Introduction to VLOOKUP" (3-59 minutes) and "How, and when to use VLOOKUP" (5:37 minutes) http://support.office.com Vides-VLOOKUP West and lactose 19861572-5542-4148-536724823014785 2. With your new found knowledge and appreciation for VLOOKUP, une the function in cells 117, NT, and to look up call (that is, go find Waldo). We want to fill Type of Cost", "Cout Behavior and Product or Period' IN 117, 117, and J17 respectively after typing referencing any hem from column Am cell 17. 3. Once you feel that VLOOKUP is written correctly in the three aforementioned celli, type or reference Accounting manager's salary" in cell G17 to see if 117, 117, and J17 change 4. Save your satigrutent with the proper (first name) (last name) Excel #6_Fall2021 and upload to Leam before the due date. Congratulations, you're a =VLOOKUP espert! ITEM TYPE OF COST COST BEHAVIOR PRODUCT OR PERIOD Green cells above will be ded. Prof's Pro Tips for Excel Lab #6 Don't try to click and drag the formula from HIZ TO J17. It is best to create each formula independently Verify all your cell references for the table arrays are absolute cell reference (B.SASI). - Using either "FALSE" or "O is acceptable for from_lookup Verify that your final submission has "Accounting manager's salary in cell G17 Make sure that you have a created a complete VLOOKUP function in each cell. There are 4 parts inside each VLOOKUP formula Grading Rubric for Excel Lab #6 4 points for each missing or incorrect cell reference to G17 (12 pts total) - 2 points for each missing or incorrect column index sumber (6 pts total) - 2 points for each missing or incorrect use of true false statements in the VLOOKUP formla (8 pts total) - 2 points for any other tect other than Accounting manager's salary in cell G17 - 2 points for incorrect file name Should be (First Name) (Last Name) - Excel+6_Fall2021 20 points if any all green cell does not have a VLOOKUP formula - 20 points for an Excel Lab 6 from previous semester I for Excel La 1. you need outside help with VLOOKUT, copy and paste the link below into your browser. Watch "Introduction to VLOOKUP (3:59 mm) and "How, and when to me VLOTO Thu H) pepperonike.com/est/VideoVLOOKUP-White-and-hot-315735424148-253672423014785 2. Wiyong new found knowledge and appreciation for -VLOOKUP, use the function in cells 117. 11, and to look up call GT (that is, go find Waldo). We want to fill Type of Coot", "Coul Behavior and Product or Period IN HI7, 117, and J17 respectively after typing sering my ten free column A in cell G17. 3. Once you feel that VLOOKUP is written correctly in the three forestioned cella, type of reference Accounting manager's salary" in cell G17 to see if H117, 117, and 117 change 4. Save your assignment with the proper samt: (fint sama) (last name) - Excel #6_Fall 2021 and upload to Learn before the due date. Congratulations, you're a VLOOKUP expert! ITEM TYPE OF COST COST BEHAVIOR PRODUCT OR PERIOD Green cells above will be dedi Profs Pro Tips for Excel Lab 6 Don't try to click and dry the formula from H17 TO J17. It is best to create each formula independently Verify all your cell references for the table stays are absolute cell references (es. SASI) . Uning either "FALSE" or "O is acceptable for flookpl Verify that your finalissional Accounting manager's salary in cell G17 - Make sure that you have a created a complete VLOOKUP function in each cell There are parts and each VLOOKUP formula Grading Rubric for Excel Labo 4 points for each missing or correct cell reference to G17 (12 pts total) 2 points for each missing or incorrect cousinde aber pts total -2 points for each mining or incorrect use of trafalse statements in the =VLOOKUP formula (8 pts total) - 2 points for any other text other than "Accounting manager's salary in cell G17 -2 points for correct file name. Should be (First Name) (Last Name) - Excel 6 Fall2021 20 points if any all green cell does not have a VLOOKUP formula 20 points for an Excel Lab 6 from a presso semester
