[go: up one dir, main page]
Scribd
Upload
8 views8 pages

Excel Practice Worksheet

The document contains employee data including names, departments, salaries, and joining dates. It also provides instructions for formatting and visual enhancements in a spreadsheet, such as applying borders, changing orientation, and highlighting specific values. Additionally, it includes instructions for viewing options and managing data presentation.

Uploaded by

Ahmad Halime
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
8 views8 pages

Excel Practice Worksheet

The document contains employee data including names, departments, salaries, and joining dates. It also provides instructions for formatting and visual enhancements in a spreadsheet, such as applying borders, changing orientation, and highlighting specific values. Additionally, it includes instructions for viewing options and managing data presentation.

Uploaded by

Ahmad Halime
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/ 8

Name Department Salary Joining Date

Alice HR 4000 2020-01-15


Bob IT 5000 2019-07-23
Charlie IT 5500 2021-03-12
Diana Finance 4500 2020-06-30
Eli HR 4200 2022-02-10
Instructions
1. Apply different border styles to cells.
2. Change orientation to Landscape (Page Layout > Orientation).
3. Set margins to Narrow (Page Layout > Margins).
4. Set paper size to A4 (Page Layout > Size).
5. Enable Sheet Right-to-Left (Page Layout > Sheet Right-to-Left).
6. Add background (Page Layout > Background).
7. Set Print Titles (Page Layout > Print Titles).
8. Add Header/Footer (Insert > Header & Footer).
9. Show/Hide Gridlines and Headings (Page Layout > Sheet Options).
CurrencyPercentage Date
4000 0.25 2023-01-01
3000 0.5 2023-06-15
5000 0.75 2023-12-31
Instructions
1. Highlight cells with values > 4000.
2. Apply Data Bars to Salary.
3. Use Icon Sets for performance.
Name Department Salary Joining Date
Alice HR 4000 2020-01-15
Bob IT 5000 2019-07-23
Charlie IT 5500 2021-03-12
Diana Finance 4500 2020-06-30
Eli HR 4200 2022-02-10
Email Department
a@examplHR
b@examplIT
a@examplHR
c@exampleFinance
Instructions
1. Switch between Normal, Page Layout, and Page Break Preview (View Tab).
2. Split and Freeze top row.
Salary Age
4000 28
5000 35
5500 32
4500 29
4200 30

You might also like