Scribd
Upload
14 views1 page

Excel Practice

The document presents a table of employee information including IDs, names, and salaries, with notable entries such as Mila Clark earning $188,657. It also includes a Vlookup section with employee details like emails and IDs, and a Hlookup section detailing fruit prices and stock levels. The data is structured to facilitate easy reference for salaries and contact information.

Uploaded by

m20018001
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views1 page

Excel Practice

The document presents a table of employee information including IDs, names, and salaries, with notable entries such as Mila Clark earning $188,657. It also includes a Vlookup section with employee details like emails and IDs, and a Hlookup section detailing fruit prices and stock levels. The data is structured to facilitate easy reference for salaries and contact information.

Uploaded by

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

INDEX Formula

ID First Name Last Name Salary


72 Emily Smith $64,901.00
66 James Bond $70,855.00
14 Mila Clark $1,88,657.00
30 John Lewis $97,566.00
53 Jessica Walker $58,339.00
56 Mark Reed $1,25,180.00
79 Richard Loper $91,632.00
ID 14
Salary $1,88,657.00
Vlookup
ID First Last Email
610 Janet Farley [email protected] ID 867
798 Steven Batista [email protected] First Erica
841 Evelyn Monet [email protected] Last Tan
886 Marliyn Adder [email protected] Email [email protected]
622 Jonathan Birt [email protected]
601 Adrian Irons [email protected]
869 Julie Bradley [email protected]
867 Erica Tan [email protected]
785 Harold Clayton [email protected]
648 Sharyn Castor [email protected]
Hlookup
Fruit Apples Bananas Lemons Oranges Pears Almonds Cashews
Price 8 5 6 5 8 4 9
Stock 121 130 132 146 124 146 139
Fruit Price Stock
Pears 8 124

You might also like