# himansh rana

Create a new excel workbook and save it as Student Full Name_Midterm.xlsx.

a) Create a workbook to enter the monthly salary details of 10 employees. Make the

column headings are as follows. EmployeeID, FirstName, LastName, Department,

Hours, HourlyRate.

b) Fill the next 10 rows with sample data. (EmployeeID, FirstName, LastName,

Department, Hours, HourlyRate details of 10 employees, you can make up the data).

c) Enter a new column named Salary, apply an equation to find out salary of the

employees. Copy the formula to the other cells in salary column. Change the format of

the salary column to currency.

d) Select all columns and change the width to 20. Pt, select all rows and change row height

to 17 pt.

e) Rename the sheet as EmployeeMonthlySalary. Change the tab color to Red.

f) Insert a new row at the top and type Employee Salary Sheet, merge and center across

other data, make it bold and change font size to 14.

g) Freeze the first two rows and first column.

h) Apply the appropriate formulas to calculate the total and average salary given to the

employees. Add a label as Total Salary.

i) Apply the appropriate functions to calculate the maximum and minimum salary given

to the employees. Add labels Highest and Lowest respectively.

j) Create a new sheet and using appropriate formula bring the Employee First name’s and

salary from the EmployeeMonthlySalary sheet with reference to the cell values in

EmployeeMonthlySalary sheet, so that if you change any value in the first sheet it

automatically updates values in the new sheet.

k) Using the data in Sheet 2 insert a Pie Chart. Move the chart down to the data values so

that it is visible properly. Change the title of the chart to Salary Chart.

l) Include a hyperlink (hyperlink display should be “Yourname” _ chart) in the first

worksheet that takes you to the chart worksheet.

Skills: Excel

( 0 reviews ) Surrey, Canada

Project ID: #29395940

## 11 freelancers are bidding on average \$16/hour for this job

rIbrarahmed

Hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit mysel More

(24 Reviews)
5.0
hayteekeys

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be More

(9 Reviews)
4.2
Iqbal74

Greetings! I can get you the Excel sheet in less than 2 hours. It is pretty straight forward for someone who knows the Excel inside out. Let's start now! Iqbal

(10 Reviews)
4.0
Yusufabu

i can enter the data correctly as you want it to be inserted into the excel spreadsheet. Looking forward to working with you.

(0 Reviews)
0.0
SHAHRUKHKB

hello there, I just came across your project during scrolling Freelancer. I understand that you are looking for an excel data entry expert for your specified work. I am a professional data entry expert with having 10+ More

(0 Reviews)
0.0
haziqmalik

Remarkable experience in data entry (alpha and numeric) Proficient in Microsoft Office products (Word Excel Access and Outlook), 10-key and alphanumeric typing. In-depth knowledge of entering data fields into computers More

(0 Reviews)
0.0
deepibindal

Hii , I can do all the required tasks mentioned by you on excel. I have excellent excel skills and can work on all formulae's and analysis . I have been organizing data & doing data analysis for the past 10 years for More

(0 Reviews)
0.0
khokharasim944

i am proffessiona data entry work my expericne 3 years other work desing copy past and business card desing

(0 Reviews)
0.0
tanmayk30

Can give you finish product in 1 hour. I'm currently working as a data analyst. Working on excel and creating dashboard is my daily job now due to lockdown I have lot of free time. So coming on freelancer to utilise th More

(0 Reviews)
0.0
udibandara

Hi, I will help you with this project. I am an experienced administrative assistant with good technical skills in Excel.