Create a worksheet containing 100+ sales records with columns:
|
Order ID |
Date |
Customer |
City |
Product |
Quantity |
Sales |
|
O101 |
01-Sep-26 |
Amit |
Sirsa |
Keyboard |
5 |
4000 |
|
O102 |
02-Sep-26 |
Neha |
Hisar |
Mouse |
10 |
5000 |
|
O103 |
03-Sep-26 |
Rahul |
Sirsa |
Monitor |
3 |
25500 |
|
O104 |
04-Sep-26 |
Priya |
Fatehabad |
Printer |
2 |
24000 |
Tasks
- Switch between Normal, Page Layout and Page Break Preview.
- Show/hide Formula Bar.
- Show/hide Gridlines.
- Show/hide Headings.
- Test different Zoom levels.
- Freeze the top row.
- Freeze the first column.
- Use Split Window.
- Create a New Window.
- Use Arrange All.
- Hide and Unhide a worksheet.
- View two reports Side by Side.
Practice File: View_Tab_Large_Data_Navigation.xlsx