In column G, use an IF statement to calculate the penalty for each vendor based on the following criteria: For accounts with a Total Past Due Balance of $10,000 or more, apply a penalty of $600. For accounts with a Total Past Due Balance of less than $10,000 but more than $3,000, apply a penalty of $250. For accounts with a Total Past Due Balance of less than or equal to $3,000, do not apply a penalty (i.e. $0). Check Figure: Cell G4 = $250

9. In column H, use an IF statement to calculate the penalty for each vendor based on the following criteria: For vendors in the Labor Category, apply a penalty of $100 or 6% of the Total Past Due Balance, whichever is higher. For vendors in the Utilities Category, apply a penalty of $150. For vendors in any other Category, apply a penalty of 2.5% of the Total Past Due Balance. Check Figure: Cell H6 = $192

10. In cell A10, type your first and last name in all lowercase letters. Change the font size of cell A10 to 8.

please answer the following showing the formulas and steps it takes to get there thankyou

Kids R Us Child Care Centers is creating an online parent portal that parents will access with a username and password. Use a formula to create a username for each parent based on the following rules: Lowercase first letter of first name. Digit five of ID. Uppercase first four letters of last name. Last digit of phone number. Number of characters in first name.

thank you!

8. 0 In column G, use an IF statement to calculate the penalty for each vendor based on the following criteria: For accounts with a Total Past Due Balance of $10,000 or more, apply a penalty of $600. For accounts with a Total Past Due Balance of less than $10,000 but more than $3,000, apply a penalty of $250. For accounts with a Total Past Due Balance of less than or equal to $3,000, do not apply a penalty (i.e. $0). Check Figure: Cell G4 = $250 9. 0 In column H, use an IF statement to calculate the penalty for each vendor based on the following criteria: For vendors in the Labor Category, apply a penalty of $100 or 6% of the Total Past Due Balance, whichever is higher. For vendors in the Utilities Category, apply a penalty of $150. For vendors in any other Category, apply a penalty of 2.5% of the Total Past Due Balance. Check Figure: Cell H6 = $192 10. In cell A10, type your first and last name in all lowercase letters. Change the font size of cell A10 to 8. A1 x fx Vendor Name A B D E H j K L Vendor Name Category Penalty #1 Penalty #2 1 - 2 RTF Electric 3 Ross County Water & Sewer 4 YNC Trucking s Italian Leather Group Ltd. 6 Union Plastics 7 Freight to Go 8 Temps R'Us 9 Notworth Telephone 10 Utilities Utilities Transportation Raw Materials Raw Materials Transportation Labor Telephone $ $ $ $ $ $ $ $ 30-Days 60-Days 90-Days Total Past Past Due Past Due Past Due Due Balance 12,100 $ $ $ 12,100 500 $ - $ $ 500 $ - $ 3,100 $ 3,100 $ 850 $ 5,674 $ 6,524 7,250 $ 436 $ $ 7,686 $ $ $ 8,730$ 8,730 2,700$ $ $ 2,700 250 $ 650 $ 400$ 1,300 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Work Days Sheet1 Rules IF Statements Usernames + Usernames Worksheet 11. Kids R Us Child Care Centers is creating an online parent portal that parents will access with a username and password. Use a formula to create a username for each parent based on the following rules: Lowercase first letter of first name. Digit five of ID. Uppercase first four letters of last name. Last digit of phone number. Number of characters in first name. . 12. Make the Work Days tab the active worksheet, save and close your file, and use the Excel 6 link on Blackboard to submit your work. A1 4 x fx Parent ID A B C D E F G H 1 1 K L M N Parent Username 1 Parent ID Parent Last Name Parent First Name Parent Phone 2 100000 Ewing Levi (550) 726-7424 3 100001 Gillespie Vera (263) 579-3567 4 100002 Mccall Astra (897) 263-3526 5 100003 Woodward Constance (845) 953-5717 6 100004 Duke Keaton |(289) 465-5356 7 100005 Stephenson Alana (693) 335-3919 8 100006 Guzman Cally (836) 183-4738 9 100007 Zimmerman Flavia (590) 994-9083 10 100008 Cooper Jameson (373) 497-3310 11 100009 Fleming Jemima (367) 563-1301 12 100010 Waller Yolanda (547) 638-5601 13 100011 Lloyd Nigel (664) 205-4196 14 100012 Mack Gil (547) 452-5690 15 100013 Blankenship Michelle (162) 427-2133 16 100014 Slater Akeem (940) 387-3950 17 100015 Huber Aaron |(846) 956-4117 18 100016 Levine Quyn (596) 852-1734 19 100017 Lindsey Patrick (675) 252-8525 20 100018 Mccullough May (294) 149-3783 21 100019 Sampson Brent (676) 693-7135 22 100020 Welch Sierra (932) 627-7402 23 100021 Parrish lan (232) 151-6837 24 100022 Mccormick Keefe (111) 213-9128 25 100023 Monroe Melinda (420) 774-4450 26 100024 Gomez Lisandra (354) 379-7398 27 100025 Turner Kylan (697) 846-7407 28 100026 Lloyd Maris (656) 976-4033 29 100027 Norris Chancellor |(435) 134-7933 30 100028 Davidson Haviva (977) 136-1493 IrLi-II- Work Days Sheet1 Rules IF Statements 10nnnn 14 AN 47nnarr Usernames + 8. 0 In column G, use an IF statement to calculate the penalty for each vendor based on the following criteria: For accounts with a Total Past Due Balance of $10,000 or more, apply a penalty of $600. For accounts with a Total Past Due Balance of less than $10,000 but more than $3,000, apply a penalty of $250. For accounts with a Total Past Due Balance of less than or equal to $3,000, do not apply a penalty (i.e. $0). Check Figure: Cell G4 = $250 9. 0 In column H, use an IF statement to calculate the penalty for each vendor based on the following criteria: For vendors in the Labor Category, apply a penalty of $100 or 6% of the Total Past Due Balance, whichever is higher. For vendors in the Utilities Category, apply a penalty of $150. For vendors in any other Category, apply a penalty of 2.5% of the Total Past Due Balance. Check Figure: Cell H6 = $192 10. In cell A10, type your first and last name in all lowercase letters. Change the font size of cell A10 to 8. A1 x fx Vendor Name A B D E H j K L Vendor Name Category Penalty #1 Penalty #2 1 - 2 RTF Electric 3 Ross County Water & Sewer 4 YNC Trucking s Italian Leather Group Ltd. 6 Union Plastics 7 Freight to Go 8 Temps R'Us 9 Notworth Telephone 10 Utilities Utilities Transportation Raw Materials Raw Materials Transportation Labor Telephone $ $ $ $ $ $ $ $ 30-Days 60-Days 90-Days Total Past Past Due Past Due Past Due Due Balance 12,100 $ $ $ 12,100 500 $ - $ $ 500 $ - $ 3,100 $ 3,100 $ 850 $ 5,674 $ 6,524 7,250 $ 436 $ $ 7,686 $ $ $ 8,730$ 8,730 2,700$ $ $ 2,700 250 $ 650 $ 400$ 1,300 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Work Days Sheet1 Rules IF Statements Usernames + Usernames Worksheet 11. Kids R Us Child Care Centers is creating an online parent portal that parents will access with a username and password. Use a formula to create a username for each parent based on the following rules: Lowercase first letter of first name. Digit five of ID. Uppercase first four letters of last name. Last digit of phone number. Number of characters in first name. . 12. Make the Work Days tab the active worksheet, save and close your file, and use the Excel 6 link on Blackboard to submit your work. A1 4 x fx Parent ID A B C D E F G H 1 1 K L M N Parent Username 1 Parent ID Parent Last Name Parent First Name Parent Phone 2 100000 Ewing Levi (550) 726-7424 3 100001 Gillespie Vera (263) 579-3567 4 100002 Mccall Astra (897) 263-3526 5 100003 Woodward Constance (845) 953-5717 6 100004 Duke Keaton |(289) 465-5356 7 100005 Stephenson Alana (693) 335-3919 8 100006 Guzman Cally (836) 183-4738 9 100007 Zimmerman Flavia (590) 994-9083 10 100008 Cooper Jameson (373) 497-3310 11 100009 Fleming Jemima (367) 563-1301 12 100010 Waller Yolanda (547) 638-5601 13 100011 Lloyd Nigel (664) 205-4196 14 100012 Mack Gil (547) 452-5690 15 100013 Blankenship Michelle (162) 427-2133 16 100014 Slater Akeem (940) 387-3950 17 100015 Huber Aaron |(846) 956-4117 18 100016 Levine Quyn (596) 852-1734 19 100017 Lindsey Patrick (675) 252-8525 20 100018 Mccullough May (294) 149-3783 21 100019 Sampson Brent (676) 693-7135 22 100020 Welch Sierra (932) 627-7402 23 100021 Parrish lan (232) 151-6837 24 100022 Mccormick Keefe (111) 213-9128 25 100023 Monroe Melinda (420) 774-4450 26 100024 Gomez Lisandra (354) 379-7398 27 100025 Turner Kylan (697) 846-7407 28 100026 Lloyd Maris (656) 976-4033 29 100027 Norris Chancellor |(435) 134-7933 30 100028 Davidson Haviva (977) 136-1493 IrLi-II- Work Days Sheet1 Rules IF Statements 10nnnn 14 AN 47nnarr Usernames +