Hannah Joy Dille - Excel #6_Fall2022-2

What does it take to use =V l lookup_value is the cell/value in a data set or table we want Excel to find information about. Lookup_value is Waldo. "Excel, go find lookup_value in a table I will select." A table_array is the data set or table of information where we want to find lookup_value .

You got it... table_array is the picture containing Waldo! A co col_index_num is maybe the most complicated argument. Remember we want Excel to return to us a piece of info in the table_array based on lookup_value . Column index number is the column (vertical reference) where we want the info to come from. Argument [range_look Going back to Waldo, do we lookalike or Waldo himself depends on the data we're w with.

ITEM AMOUNT Direct labor $14,150 DL V Supplies for administrative office $19,678 OE M Payroll taxes-factory $22,535 MOH V Depreciation on office equipment $23,350 OE F Depreciation on office building $26,796 OE F Sales Discount $31,694 OE V Maintenance salaries - factory $33,257 MOH F Indirect labor $36,728 MOH V Sales commissions $40,071 OE V Accounting manager's salary $41,801 OE F Cost of goods sold $50,543 OE V Insurance on showroom $50,864 OE F Sales manager's salary $51,835 OE F Heat & electricity for the general office $51,900 OE M Manufacturing supervisor's salary $52,338 MOH F Wages for assembly line workers $52,988 MOH V Factory machinery rent $55,567 MOH F Property taxes-factory $56,716 MOH F Factory insurance $58,150 MOH F Salaries of accounts receivable/payable clerks $58,608 OE F Glue, screws, paint and other small parts used in production $64,250 MOH V Janitorial services for administrative offices $66,751 OE F Advertising $68,103 OE F Indirect materials $69,686 MOH V Company president's salary $73,634 OE F Depreciation on factory building $77,127 MOH F Depreciation on factory equipment $79,249 MOH F Direct materials $80,530 DM V Income tax expense $82,299 OE V Rent expense on showroom $82,304 OE F Administrative office insurance $85,601 OE F Payroll taxes - administration $87,658 OE V TYPE OF COST COST BEHAVIOR

PRO PER PRO PER PER PER PRO PRO PER PER PER PER PER PER PRO ITEM PRO Sales Discoun OE V PRO PRO Green cells above will be gr PRO PER PRO PER PER PRO PER PRO PRO PRO PER PER PER PER PRODUCT OR PERIOD TYPE OF COST COST BEHAVIOR Instructions for Excel Lab # 6 1. If you need outside help with =VLOOKUP, copy and paste the link belo VLOOKUP" (5:37 minutes) 2. With your new found knowledge and appreciation for =VLOOKUP, use Cost", "Cost Behavior", and "Product or Period" IN H17 , I17 , and J17 res 3. Once you feel that =VLOOKUP is written correctly in the three aforem 4. Save your assignment with the proper name: (first name) (last name) - E https://support.office.com/en-us/article/Vide Prof's Pro Tips for Excel Lab # 6 • Don't try to click and drag the formula from H17 TO J17 . It is best t • Verify all your cell references for the table arrays are absolute cell refere • Using either "FALSE" or "0" is acceptable for [range_lookup] . • Verify that your final submission has "Sales Discount" in cell G17. • Make sure that you have a created a complete VLOOKUP function in ea 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 number (6 pts total) - 2 points for each missing or incorrect use of true/false statements in the = - 2 points for any other text other than "Sales Discount" in cell G17 - 2 points for incorrect file name. Should be (First Name) (Last Name) - E - 20 points if any/all green cell does not have a =VLOOKUP formula - 20 points for an Excel Lab #6 from a previous semester.

e Type of pert!