I have aleady completed the step below!!! PLEASE HELP ME I DON'T UNDERSTANDDD
| Go to the Laundry_Rate_Data sheet and name the following ranges. Cell range A8:B11 should be named Loc_A. Cell range A14:B17 should be named Loc_B. Cell range A20:B23 should be named Loc_C. You will not receive credit for this step if the ranges are not named exactly as specified. Do not misspell the range names or capitalize the letters incorrectly. |
Create an Invoice Number for each invoice on the Customer Invoice sheet. Place a formula in cell H5 of the Customer Invoice sheet that will use the TEXT, LEFT, RIGHT, UPPER and something to join text strings. The Invoice Number should begin with the letter X. It should be followed by the Invoice Date in MMDDYY fomat. The date should be followed by the first 3 characters of the Cust Last Name which should be capitalized. The first 3 characters of the Cust Last Name should be followed by a dash (-). The dash should be followed by the right 4 characters of the Customer ID (For example, the Invoice Number in cell H34 should be: X020219YAN-3349.) Copy the formula in cell H5 to cell range H6:H34 New River Laundry Services, Inc. 9/29/2019- 10/5/2019 Customer Invoice Data for Sum of Total Befc Cust_First_Name Cust Last Name Account_Type Location Credit_Card_On_File Invoice_Date Invoice_Number Number_of_Pounds Yes Yes Total Before Customer_ID 5 AB7342 5 AC22709 Laundry_Rate Rhonda PR 9/29/2019 10/5/2019 10/4/2019 Adams Ahmad Alvarez Anderson C 32 Mahmoud Ricardo Robert Ruth Roger Reba SD PP SD B B 19 AR3440 No 11 AE21567 9AB913564 0 AF154 10/3/2019 C C Yes 23 24 Baldwin Bentley Caldwell Callihan Chu PP 9/29/2019 No 49 PR Yes 10/1/2019 A 1 AE80578 9/30/2019 SD Yes 42 Roy 10/4/2019 10/3/2019 2 AD2772 PP Yes 15 C No 3 AR6568 SD Jane Rodrigo 21 4 AE54105 5 AC32107 Davila Delaney PP B No 10/5/2019 10/2/2019 30 16 Rebecca John A SD PR Yes 6 AF74883 7 AB835768 Evans No Yes 9/29/2019 8 A A 10/1/2019 SD PR Joan Foster 44 Fitzgerald Kadappakam Lane 9/30/2013 8 AE9955 C Yes No James 21 10/3/2019 10/4/2019 9AC56593 0AR10524 1 AC6061 SD C Rajan 6 Jessica Justin Jordan SD 29 2 24 A No Miller Monroe Ogilvie Radcliffe. Yes 10/5/2019 PR PP SD B 10/2/2019 9/29/2019 2 AE749 No Ronald IMicanda. A 10 3 AR4512 Yes s 10/1/2019 37 AAC5380 Ivae SD Laundry Rate Data Documentation Customer Data Customer_Invoice Balance_by_...) |Services Provided Wash and dry only. No pick up and delivery. Wash and dry plus pick up and delivery. Wash and dry, pick up and delivery and fold clothes separately for each individual. Account_Type Description SD Standard PR Premium PP Premium Plus Location A (0-10 miles away) Account_Type Rate per Pound $2.00 $2.25 $2.50 SD PR PP Location B (greater than 10 and less than or equal to 20 miles away) Account_Type Rate per Pound $2.50 $2.75 $3.00 SD PR PP Location C (greater than 20 and less than or equal to 30 miles away) Account_Type Rate per Pound $3.00 $3.25 SD PR $3.50 PP 8 Create an Invoice Number for each invoice on the Customer Invoice sheet. Place a formula in cell H5 of the Customer Invoice sheet that will use the TEXT, LEFT, RIGHT, UPPER and something to join text strings. The Invoice Number should begin with the letter X. It should be followed by the Invoice Date in MMDDYY fomat. The date should be followed by the first 3 characters of the Cust Last Name which should be capitalized. The first 3 characters of the Cust Last Name should be followed by a dash (-). The dash should be followed by the right 4 characters of the Customer ID (For example, the Invoice Number in cell H34 should be: X020219YAN-3349.) Copy the formula in cell H5 to cell range H6:H34 New River Laundry Services, Inc. 9/29/2019- 10/5/2019 Customer Invoice Data for Sum of Total Befc Cust_First_Name Cust Last Name Account_Type Location Credit_Card_On_File Invoice_Date Invoice_Number Number_of_Pounds Yes Yes Total Before Customer_ID 5 AB7342 5 AC22709 Laundry_Rate Rhonda PR 9/29/2019 10/5/2019 10/4/2019 Adams Ahmad Alvarez Anderson C 32 Mahmoud Ricardo Robert Ruth Roger Reba SD PP SD B B 19 AR3440 No 11 AE21567 9AB913564 0 AF154 10/3/2019 C C Yes 23 24 Baldwin Bentley Caldwell Callihan Chu PP 9/29/2019 No 49 PR Yes 10/1/2019 A 1 AE80578 9/30/2019 SD Yes 42 Roy 10/4/2019 10/3/2019 2 AD2772 PP Yes 15 C No 3 AR6568 SD Jane Rodrigo 21 4 AE54105 5 AC32107 Davila Delaney PP B No 10/5/2019 10/2/2019 30 16 Rebecca John A SD PR Yes 6 AF74883 7 AB835768 Evans No Yes 9/29/2019 8 A A 10/1/2019 SD PR Joan Foster 44 Fitzgerald Kadappakam Lane 9/30/2013 8 AE9955 C Yes No James 21 10/3/2019 10/4/2019 9AC56593 0AR10524 1 AC6061 SD C Rajan 6 Jessica Justin Jordan SD 29 2 24 A No Miller Monroe Ogilvie Radcliffe. Yes 10/5/2019 PR PP SD B 10/2/2019 9/29/2019 2 AE749 No Ronald IMicanda. A 10 3 AR4512 Yes s 10/1/2019 37 AAC5380 Ivae SD Laundry Rate Data Documentation Customer Data Customer_Invoice Balance_by_...) |Services Provided Wash and dry only. No pick up and delivery. Wash and dry plus pick up and delivery. Wash and dry, pick up and delivery and fold clothes separately for each individual. Account_Type Description SD Standard PR Premium PP Premium Plus Location A (0-10 miles away) Account_Type Rate per Pound $2.00 $2.25 $2.50 SD PR PP Location B (greater than 10 and less than or equal to 20 miles away) Account_Type Rate per Pound $2.50 $2.75 $3.00 SD PR PP Location C (greater than 20 and less than or equal to 30 miles away) Account_Type Rate per Pound $3.00 $3.25 SD PR $3.50 PP 8
