Complete the following question in the yellow cell by using the Data Tab. 1. Input a Vlookup formula in the yellow cell
Posted: Mon Apr 25, 2022 7:37 am
Complete the following question in the yellow cell by using the
Data Tab.
1. Input a Vlookup formula in the yellow cell and determine the
Due Date for Order ID # 4. Change date format to show
dd-mmm-yy
Order ID Product Category Amount Due Date Country 1 Carrots Vegetables 4270 1/6/2012 United States 2 Broccoli Vegetables 8329 1/7/2012 United Kingdom 3 Banana Fruit 617 1/8/2012 United States 4 Banana Fruit 8384 1/10/2012 Canada 5 Beans Vegetables 2626 1/10/2012 Germany 6 Orange Fruit 3610 1/11/2012 United States 7 Broccoli Vegetables 9062 1/11/2012 Australia 8 Banana Fruit 6906 1/16/2012 New Zealand 9 Apple Fruit 2417 1/16/2012 France 10 Apple Fruit 7131 1/16/2012 Canada
Order ID Due Date 4
Data Tab.
- Complete The Following Question In The Yellow Cell By Using The Data Tab 1 Input A Vlookup Formula In The Yellow Cell 1 (16.95 KiB) Viewed 65 times
Due Date for Order ID # 4. Change date format to show
dd-mmm-yy
- Complete The Following Question In The Yellow Cell By Using The Data Tab 1 Input A Vlookup Formula In The Yellow Cell 2 (1.02 KiB) Viewed 65 times
Order ID Due Date 4