Question

ONo. 1.
Objectives:
Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows.
Formatting Worksheets.
AutoFill, Numeric formats, previewing worksheets.
a) Create a new workbook as shown below and save the file with the name "Payroir
b) Enter the labels and values in the exact cells locations as desired.
c) Use AutoFill to put the Employee Numbers into cells A6 AB.
d) Set the columns width and rows height appropriately
e) Set labels alignment appropriately.
1) Use warp text and merge cells as desired.
6) Apply borders, gridlines and shading to the table as desired
h) Format cell B2 to Short Date format.
0) Format cells E4:68 to include Rs sign with two decimal places.
1) Calculate the Gross Pay for employee; enter a formula in cell 4 to multiply Hourly Rate by
Hours Worked. 11. Calculate the Social Security Tax (S.S Tax), which is 6% of the Gross Pays enter
a formula in cell F4 to multiply Gross Pay by 6%.
k) Calculate the Net Pay, enter a formula in cell G4 to subtract Social Security Tax from Gross Pay.
D) Set the work sheet vertically and horizontally on the page.
m) Save your work
A
B
D
1
Payroll
2
1/1/2011
Mourly
EMPL Name
Hours
Worked
Gross Pay & S Tax
Date:
EMPL
Number
4 E00001
5E00002
5 ?
7 ?
Ford
7.5
35?
302
252
2
>
2
6.5
7
2
Mino
Beli
Davis
Turra
9
2
B2
10
2
392​

Answer 1

Explanation:

ONo. 1.

Objectives:

Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows.

Formatting Worksheets.

AutoFill, Numeric formats, previewing worksheets.

a) Create a new workbook as shown below and save the file with the name "Payroir

b) Enter the labels and values in the exact cells locations as desired.

c) Use AutoFill to put the Employee Numbers into cells A6 AB.

d) Set the columns width and rows height appropriately

e) Set labels alignment appropriately.

1) Use warp text and merge cells as desired.

6) Apply borders, gridlines and shading to the table as desired

h) Format cell B2 to Short Date format.

0) Format cells E4:68 to include Rs sign with two decimal places.

1) Calculate the Gross Pay for employee; enter a formula in cell 4 to multiply Hourly Rate by

Hours Worked. 11. Calculate the Social Security Tax (S.S Tax), which is 6% of the Gross Pays enter

a formula in cell F4 to multiply Gross Pay by 6%.

k) Calculate the Net Pay, enter a formula in cell G4 to subtract Social Security Tax from Gross Pay.

D) Set the work sheet vertically and horizontally on the page.

m) Save your work

A

B

D

1

Payroll

2

1/1/2011

Mourly

EMPL Name

Hours

Worked

Gross Pay & S Tax

Date:

EMPL

Number

4 E00001

5E00002

5 ?

7 ?

Ford

7.5

35?

302

252

2

>

2

6.5

7

2

Mino

Beli

Davis

Turra

9

2

B2

10

2

392