IT204 Assignment 7 Instructions
While working through the exercises in this assignment, explore the various options in each tab and think about how you will use them for future school assignments or in the workplace.
For assignment 7, open the file for week 7 labeled “Assignment 7 Excel.xlsx”.
This spreadsheet already has data you can use.
On the Excel page, add a second worksheet by clicking the + symbol after Sheet 1 at the lower left. Copy the data from page one onto page two. (This preserves the original spreadsheet.) Right click on the sheet 2 tab and rename it as Employee Table. Right click and choose a tab color.
On sheet 2, expand the columns by placing your cursor between the columns on the header row and dragging or double clicking. Select all of the columns and rows and create a table from the Insert tab, Tables, Table and click My table has headers. You will now see drop drop-down arrows for each column. Click the arrow on the last name column and Sort A-Z. Save this as a screenshot and copy it into a MS Word document. You can also use the Snipping tool by holding down the Windows key, Shift and S. Label the screenshot as “table” using a bold 14 point font. (Along with other screenshots, you will upload the document for your assignment 7 submission.)
Click the arrow on the Department header and click the select all to turn it off. Now, select the Marketing and Sales departments to see only the who works there. Now, select the Salary column. On the Styles tab, use Conditional Formatting to select Highlight Rules, Greater Than, and enter 50,000. Highlight the Salary column and choose Accounting from the drop- down arrow on the Number tab. If necessary, make the column wider by double clicking or dragging the cell’s edge on the column header. Take a screenshot and save your table onto your Word document. Label as “Conditional Formatting” using a bold 14 point font.
Now, you create information using a pivot table. On sheet 1, select any cell. From the Insert tab, Tables, choose Pivot Table. Make sure New Worksheet is selected and click OK. Rename the sheet Pivot Table and choose a tab color. Click in the pivot table box and choose Employee ID, Department and Salary. On the pivot table you just created, select all of the salaries, but do not include the total. From the Styles tab on the Home ribbon, choose Conditional Formatting, Top/Bottom Rules/Above Average and choose a color. Take a screenshot and add it to your Word document. Label as “Pivot Table” using bold 14 point font.
To keep the top row or left column visible while scrolling, you can use Freeze Frame. Use sheet one. From the View tab, Window option, click the down arrow of the Freeze Pane option and choose Freeze Top Row. Scroll down to row 24 and you will see that the header row stays visible. Take a screenshot and add it to your Word document. Label as “Freeze Frame” using a bold 14 point font.
On sheet 1, click the column header for Salary to select the entire column. Click Filter on the Data ribbon. A down arrow option will appear on the Salary header. Select Number Filter and choose the Between option. Enter Greater than 45,000 and Less than 65,000. Screenshot the results and add it to your Word document. Label as “Filter’ using a bold 14 point font.
Put your name and date at the top of the Word document and submit as Assignment 7.
Why Work with Us
Top Quality and Well-Researched Papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional and Experienced Academic Writers
We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.
Free Unlimited Revisions
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
Admission Essays & Business Writing Help
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.