Note be sure your lookup function uses the tables

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: okup function uses the Table's name, not an A1 style range reference. Settings Dept Num Dept Name 100 Exercise 5 Data Please perform the following: Convert the department list below to a Table named tbl_depts. Set up a custom name dd_depts that refers to the structured table reference for the Dept Num column. Departments Dept Num Dept Name 100 Corporate 101 Accounting 102 HR 200 Operations 202 Research 206 Manufacturing 301 Sales 305 Marketing 400 Logistics 410 IT 420 Warehouse Exercise 6 Please perform the following: Using the VLOOKUP function, write the lookup formulas needed to populate the Amount column Use the data on the Exercise 6 Data sheet Hint: use column only references (B:C) for the 2nd argument of the VLOOKUP function Balance Sheet Amount Checking account Money market Savings Prepaids Deposits Accounts Receivable Inventory Current assets $- Furniture and Fixtures Computer Equipment Machinery Automobiles Fixed assets $- Total assets $- Accounts Payable Payroll liabilities Taxes Loan from officer Total liabilities $- Retained earnings Current year earnings Total equity $- Total liabilities and equity $- Exercise 6 Data Data Export Checking account Money market Savings Prepaids Deposits Accounts Receivable Inventory Furniture and Fixtures Computer Equipment Machinery Automobiles Accounts Payable Payroll liabilities Taxes Loan from officer Retained earnings Current year earnings Income COGS Wages Salary Overhead Office supplies Marketing Trade shows Computer software Small office equipment Postage Telephone Internet Travel Meals and Entertainment 11,449 8,829 11,524 2,845 2,165 14,870 15,131 6,490 13,137 3,171 14,901 13,118 8,653 6,208 14,891 14,648 46,994 725,110 117,550 248,623 129,552 75,635 13,067 14,210 8,215 7,526 4,564 10,193 14,901 10,324 10,636 13,120 Exercise 7 Please perform the following: Convert the range representing the bonus lookup into a Table named tbl_bonus. Use Data Validation to ensure the user enters a decimal number greater than or equal to zero. Write a lookup formula using the VLOOKUP...
View Full Document

This note was uploaded on 03/28/2014 for the course ACC 562 taught by Professor Staff during the Spring '14 term at University of Arizona- Tucson.

Ask a homework question - tutors are online