If you're not sure where the update.txt file is on your computer, it's advised that you print one copy.

Open the start file EX2019-ChallengeYourself-6-3. The file will be renamed automatically to include your name.  If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.  On the Sales Data worksheet, enter a formula in cell J4 to find the sales associate's region by extracting the first three characters of the sales associate's ID in cell C4. Use cell references where appropriate. Fill the formula down through cell J64. On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate.  Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.Table EX 6.1 displays calculations for commission rates based on annual sales. IF ANNUAL SALES ARE: THEN THE COMMISSION…

To access budweiser.com, you must enter a birthdate: You must be at least 21 years old and born after 1900. Write at least 7 test cases.

To test weather a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. Or, when you're using mySQL Workbench, you can right-click on a table name in the navigator window and select the Select Rows - Limit 1000 command to display the data for the table in a Result tab. To refresh the data in this tab after modifying the table data, click the Refresh button in the toolbar at the top of the tab.1. Write an INSERT statement that adds this row to the Terms table:               terms_id:                             6               terms_description:             Net due 120 days               terms_due_days:                120 Use MySQL Workbench to review the column definitions for the Terms table, an dinclude a column list with the required columns in the insert statement.   2. Write an UPDATE statement that modifies the row you just added to the Terms table. This statement should change the terms_description column to "Net due…