Question: Write a VLOOKUP command for cell B5 that shows the name associated with the employee number stored in cell B4 . Employee details are stored
- Write a VLOOKUP command for cell B5 that shows the name associated with the employee number stored in cell B4. Employee details are stored in cells A36 to C41.
- Show a formula for cell E26 that can be used calculate the values in cells E26:E30. The formula in E26 should be constructed so that it can be copied to E27:E30 without modification.
- Construct a formula that can be used to calculate the values in cells F26:F30. The formula in F26 should be constructed so that it can be copied to F27:F30 without modification.
- Show a formula that can be placed in cell H14. The formula in H14 should be constructed so that it can be copied to H15:H22 without modification. This formula should be used to test whether the amount invoiced for each item corresponds to the formula quantity shipped x unit price, and which returns the values too low, correct, or too high to indicate whether the invoice amount value is too low, correct, or too high respectively.
Close Call Trading 1 2 Internal Audit Inspection 3 4 Employee# 1111 5 Employee Name Davidson 6 Date Performed 3/4/17 7 8 Audit Type Sales Invoices 9 Prepared on 31/3/17 10 11 Analysis 12 Sales Invoices Date Shipped Invoice No Product Unit Price Customer Quantity Shipped 5 3 4 1 13 14 15 16 17 18 19 20 21 22 23 24 31/3/17 31/3/17 31/3/17 31/3/17 31/3/17 31/3/17 31/3/17 31/3/17 31/3/17 Total 101101 101101 101101 101102 101102 101103 101104 101104 101104 A10 C30 D10 BOS D10 E50 C30 D10 E50 3 $30.30 $20.10 $50.50 $110.00 $50.50 $80.80 $20.10 $50.50 $80.80 Invoice Test Amount $151.50 Correct $100.30 Too high $200.00 Too low $110.00 Correct $100.50 Too low $484.80 Correct $40.20 Correct $220.00 Too high $565.60 Correct $1,972.90 ABB Alumina ABB Alumina ABB Alumina Lion Bakery Lion Bakery Golden South Cotton Down Cotton Down Cotton Down 6 2 4 7 35 Product Count # Sale Value 1 1 Quantity Shipped 5 1 5 A10 BOS C30 D10 E50 Total Match 2 3 11 $151.50 $110.00 $140.50 $520.50 $1,050.40 $1,972.90 Yes 2 13 35 Yes 25 26 27 28 29 30 31 32 33 34 Table 35 Employee# 36 1000 37 1111 38 2000 39 2222 40 3000 41 3333 Employee Name Amanda Davidson James Majella Samuel Zoey Role Sales Clerk Internal Auditor A/R Clerk Internal Auditor Purchasing Clerk A/P Clerk
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help