Scribd
Upload
24 views3 pages

Practice File1

The document contains a table of employee information including IDs, names, departments, contact details, hire dates, pay rates, hours worked, and gross pay. It also includes notes on Excel functionalities for managing data tables. The employee data spans various departments and includes specific pay and hire details for each individual.

Uploaded by

Caloy Celoy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
24 views3 pages

Practice File1

The document contains a table of employee information including IDs, names, departments, contact details, hire dates, pay rates, hours worked, and gross pay. It also includes notes on Excel functionalities for managing data tables. The employee data spans various departments and includes specific pay and hire details for each individual.

Uploaded by

Caloy Celoy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Creating Tables

Emp ID Last Name First Name Dept E-mail Phone Ext Location
1814 Al-Sabah Daoud HR daouda 103 Building 3
1721 Alstain Isolde HR isoldea 102 Building 3
1999 Atherly Katherine HR kathya 428 Building 3
1196 Atherton Katie HR katiea 289 Building 3
1792 Barton Eileen AT eileenb 111 Building 1
1516 Bell Tom AC tomb 105 Building 2
1284 Bellwood Frank MK frankb 124 Building 1
1673 Boughton Frank AD fboughton 112 Building 2
1758 Brwyne Melia AC meliab 107 Building 2
1990 Chang Jessica MF jessc 198 Building 1
1290 Cooper Linda AD lindac 113 Building 2
1964 Corwick Rob AC robertc 108 Building 2
Hire Date Pay Rate Hours Gross Pay jojo notes:
3/1/2012 $28.31 15 $424.72 1
8/3/2013 $30.53 165 $5,037.53 2
7/2/2021 $20.28 17 $344.69 3
3/29/2021 $21.12 19 $401.21
12/21/2013 $22.87 20 $457.31 4
3/3/2008 $25.04 21 $525.87
1/2/2008 $31.52 22 $693.47
3/23/2015 $34.74 23 $798.97
3/15/2005 $23.32 24 $559.76
2/11/2021 $27.18 25 $679.41
1/1/2008 $26.26 26 $682.85
11/14/2014 $32.75 27 $884.16
jojo notes:
ctrl+z is for undo
=countblank(*:*) it counts blank 9
CTRL + T convert to table
or Home>Styles>Format as table convert to table
Convert Table into normal cell
right click and selectd "convert to range"

You might also like