Lab 5 Report

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…

Event Listeners Return to the mas_register.js file in your editor. Directly below the initial comment section, insert an event listener for the window load event. Run an anonymous function in response to the event containing the following commands: Call the calcCart() function (which you will create shortly.) Create an onclick event handler for the regSubmit button that runs the sessionTest() function when the button is clicked. Create onblur event handlers for the input boxes with the ids: fnBox, lnBox, groupBox, mailBox, phoneBox, and banquetBox, running the calcCart() function in response to each event. Create an onchange event handler for the sessionBox selection list, running the calcCart() function when the selection list is changed. Create an onclick event handler for the mediaCB check box, running the calcCart() function in response. JavaScript Functions Create the sessionTest() function. The purpose of this function is to provide a validation test for the conference session…

Step 2: Create the insertartist.php file Create the insertartist.php file that takes the data from the artist.html form, connects to the database, and successfully inserts the data into the artist table. A message should be displayed to confirm that the record has been added.

response page checks username and password against arrays of valid usernames and passwords (normally this is done against a database - we'll change it later) If valid - saves username to cookie, and sets session variable LoggedIn to TRUE. If not, sets the session variable to FALSE. Displays link to "content page" (the page you're protecting). Created with Mi Notes

Note:- Don't  copy from other contents if any wrong i will downvote

I need help with the part below and please add comments in the code to help me understand better what I am doing wrong in my own code. I have already created my database and the connection and some of the code but am stuck on these parts."Home" and "Create Account" pages The index.php file will ask the user to log in to the system with a login form If they're already logged in, the home page will NOT show the login form. It will show a "welcome to our store" type of message instead even if they click on the "home" button in the navigation. The create-account.php page has them fill out a form for creating an account. Use real-time JavaScript validation (and regex) to: Verify that the password and "verify password" match as they are typing. Verify that the password contains at least one number and is at least 8 characters long Be sure to display user feedback messages on the screen as they type, e.g.: Password must contain a number Password must be 8 characters long Password and…

Create user Peter, Brian and Cindy, create group Family and Friend. Add user Peter and Brian to the Family group, add Cindy to the Friend group. Set up password for all three users. Log in as Peter, create a file “Peter-file1”, set up permission to allow Brian to read and modify the file, but not Cindy. Verify your set up to see Peter and Brian can read and modify the file, but not Cindy. Take screenshot of your configuration.

Exercise 1 - Ms excel Insert Pivot Table: Your task is to bring up the pivot table. Then remove the grand total and edit the pivot table. Group Data by Year: The second task is to group the sales amount by the year or months. Find Running Total by Date: Your objective is to find the running total by date using the data. Insert a Pie Chart: You will create a pie chart from the data in this problem, you will need to insert slicer to the pivot table. Use the calculated Field to find the sales tax which is 5% of the total sales.

Hello, need sime help with this assignment. Photo is attached. Thank you!

Plotting assignment Create 4 subplots of y = x, y2 = x², y3 = x³, and y4 = Vx. Use 10 points between x = red circles, y2 = x2 use green dashes, y3 = x3 use blue triangles, and y4 = Vx use black squares. Also, give each subplot a title. Include a command to save the figure as a PNG file so that it can be imported into another program such as Microsoft PowerPoint. 0 to x: 10. For y1 = x use Show me the figure on the PNG file

Besides there is an options menu that includes two options in the main activity. These are: 1. New Student 2. Exit When you click on the “New Student” option, a “New Activity” opens and the teacher enters the Student ID, Visa, Final Number, Phone Number and clicks the Add button. Thus, the student's information is recorded in the database. In addition, the grade point average is calculated by taking 40% of the student visa and 60% of the final. Both the grade point average and this student's phone number are sent to MainActivity. When registration is complete, the main activity is updated to include the list of the currently added student. In addition, if the average score coming from the main activity to NewActivity is equal to or greater than 50, an SMS is sent directly to the student's phone number indicating that he or she has passed the course. For this process, necessary permissions are obtained by following the permission procedure. If the student's average is less than…

Create the file review.txt using “vi”Add text to “review tcmp$221.txt” as shown below      1.    My name is       3.    I am a junior      2.    My major is CTRe arrange the lines according to line no’s using nanoWhat is the default permission of file “review tcmp$221.txt”Change the permission of the above file to 755

Using C# in Visual Studio. Create a form with a button that will insert new data into a Database, the read button will retrieve data from a database and display it on the form, Update button will update a record into the database using the full name, and the delete button will delete a record into the database using full name.

EXCEL - VBA - MACRO   Create a code in VBA EXCEL, where every time you change cell B1 on Sheet1, a new tab is created, renamed with what is written in that cell. Each new tab created must contain all the information that is on Sheet1, if they are updated.