Innovations Game Studio has locations in Portland, Seattle, and Salt Lake City. Each location has game-development teams to produce video games for various consoles. You will use text functions to format the list and copy records of programmers in one location. In addition, you will insert database functions to calculate summary statistics and create a lookup area to look up an employee’s ID to retrieve that person’s name, job title, and salary. Start   Excel. Download and open the file named . Grader has automatically added   your last name to the beginning of the filename. You want to combine the first,   middle, and last names into one cell for each person. Display the Salary Data worksheet. In cell E2, insert the TEXTJOIN function   to join the range B2:D2, using a space delimiter and ignoring blank cells. Copy the function to   the range E3:E49. Column F contains job titles and   departments. You want to separate the data into two columns. Select the range F2:F49 and convert text to columns using the comma delimiter   to separate the department names from the job titles. Click OK when prompted with

The Innovations Game Studio has locations in three different cities: Portland, Seattle, and Salt Lake City. Each location has its own team of game developers who are responsible for creating video games for various gaming consoles. In this assignment, we will be using various text and database functions in Excel to format a list of programmers in one specific location.

To begin, open the Excel file provided named “Grader_LastName”, where your last name has been automatically added to the filename. Once the file is open, navigate to the “Salary Data” worksheet.

Our first task is to combine the first, middle, and last names of each programmer into a single cell. To do this, we will use the TEXTJOIN function. In cell E2, insert the TEXTJOIN function. This function allows us to join the range of cells from B2 to D2, using a space delimiter and ignoring any blank cells. After inserting the function, copy it to the range E3 to E49.

Moving on to column F, which contains the job titles and departments of the programmers. Our goal is to separate this data into two separate columns. To do this, select the range F2 to F49 and then navigate to the “Data” tab in the Excel ribbon. Here, you will find the “Text to Columns” option. Click on this option to open the “Convert Text to Columns” dialog box.

In the “Convert Text to Columns” dialog box, select the “Delimited” option and click on “Next”. In the next step, choose the comma delimiter to separate the department names from the job titles. You will see a preview of the separation in the preview pane. Once you are satisfied with the preview, click “Next” to proceed.

In the final step of the “Convert Text to Columns” dialog box, you can specify the data format for each column if needed. Since we only need to separate the department names from the job titles, you can leave the data format options as they are. Click on “Finish” to complete the text to columns operation.

Now, you have successfully separated the job titles and departments into two separate columns. You can continue with the remaining steps of the assignment, which include using database functions to calculate summary statistics and creating a lookup area to retrieve employee information based on their ID.

In conclusion, this assignment requires you to use text functions like TEXTJOIN and database functions in Excel to format a list of programmers and perform calculations on the data. By following the provided instructions, you will be able to successfully complete the tasks and obtain the desired results.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer