Hiding the social security number information

Assignment Help Basic Computer Science
Reference no: EM133214221

1. Open ExcelTest.xls Workbook

2. Create 3 New Worksheets called: Manage, Formula, Pivot

3. In Manage worksheet, please do the following:

a. Copy all data from Original worksheet

b. Format the table, Freeze the top row

c. Hiding the Social Security Number (SSN) information

d. Format all cell in the first row to wrap text and center

e. Format date column to MM/YY

f. Change all data to Arial font, size 11

g. Sort the data by Job Rating

4. In Formula worksheet, please do the following:

a. Copy all data from Original worksheet

b. Create a new column called Earning that categorize Salary less than 25000, Low; Salary between 25000 and less than 50000, Moderate; and Salary equal or more than 50000, High (Use the logical IF function). Format the Low cell, red; the Moderate cell, yellow; and High cell, green (Use Conditional Formatting)  

c. Create a New Table label Summary Table next to the Tax Table

d. In the Summary Table calculate:

i. Total of Salary (SUM)

ii. Average Salary by Job Rating (AVERAGE)

iii. Calculate number of people with Low, Moderate, High Salary (Use COUNTIF)

iv. Calculate the total salary of people with High Salary (Use SUMIF)

5. In Pivot worksheet, please do the following:

a. Copy all data from the Original worksheet

b. Create a pivot table of Total Salary of Each Department by Employee Status

c. Create a new column call Tax Rate, next Job Rating. Value of the Tax Rate of each employee column is determined by the Tax Table (VLOOKUP)

6. Create a chart

a. Create a chart of Earning and add title and legend, save it in a new worksheet called Chart

Calculate number of employee by department and status and a chart to display the information, save it in the Chart worksheet

Reference no: EM133214221

Questions Cloud

What purpose is kapchebet tea trying to ?ll : What purpose is Kapchebet Tea trying to ?ll? How does this differ from the purpose they are actually prepared to ?ll?
Overall description of the business : Describe an unconventional small business (or part of it) currently not using any technology to support operations (think about services, NOT selling products),
What other data considerations should be considered : If the selected project was a static work, what ideas do you have for potentially making it usefully interactive? How might you approach the design if it had to
Pick from one of three owasp : Pick from one of your three OWASP Top 10 Presentations and record a video of you presenting it as though you were giving it to the mythical development team - s
Hiding the social security number information : 1. Open ExcelTest.xls Workbook 2. Create 3 New Worksheets called: Manage, Formula, Pivot
Review plan to consult with the team via email : Review the below scenario and answer the tasks. Peter has asked Bob to review his plan to consult with the team via email.
Determine the appropriate fixes by testing hypotheses : As an IT support specialist at a help desk for a large company. Recently, the company created a knowledge base that IT support specialists can refer to when a u
Review the organisations policies : Review your organisation's policies and procedures for completing an intake interview for clients.
Data exfiltration by cloud services : Rule 1-Apply UBA-Data Exfiltration by Cloud Services on events which are detected by the Local system

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd