Introduction
This chapter contains practical Excel questions based on workbooks and worksheets. You will practice creating workbooks, managing worksheets, renaming sheets, copying and moving sheets, inserting and deleting sheets, and organizing Excel files. The 10 questions are designed to test different basic Excel skills rather than repeating the same task with different data. Excel Basics, Workbook and Worksheet Management practice questions with solutions to help you understand the concepts.
Question 1: Create Multiple Worksheets for Different Departments
Problem Statement
Create a workbook for a small company. The workbook should contain separate worksheets for:
- Sales
- Marketing
- HR
- Finance
Excel Data
No data is required.
Solution
- Open a new Excel workbook.
- Keep the first worksheet.
- Rename it to Sales.
- Click the + button three times to create three more worksheets.
- Rename them:
- Sales
- Marketing
- HR
- Finance
Expected Output
The workbook should contain four worksheets:
| Worksheet |
|---|
| Sales |
| Marketing |
| HR |
| Finance |
Question 2: Rename Worksheets According to Their Purpose
Problem Statement
Suppose an existing workbook contains these worksheet names:
- Sheet1
- Sheet2
- Sheet3
Rename them according to the following requirements:
- Sheet1 → Students
- Sheet2 → Attendance
- Sheet3 → Results
Excel Data
No additional data is required.
Solution
- Right-click Sheet1.
- Select Rename.
- Type
Students. - Press Enter.
- Rename Sheet2 to
Attendance. - Rename Sheet3 to
Results.
Expected Output
The workbook should now contain:
| Old Name | New Name |
|---|---|
| Sheet1 | Students |
| Sheet2 | Attendance |
| Sheet3 | Results |
Question 3: Insert a New Worksheet in an Existing Workbook
Problem Statement
You have a workbook containing these worksheets:
- Sales
- Expenses
- Profit
Now create another worksheet named Summary.
Excel Data
No data is required.
Solution
- Open the workbook.
- Click the + button next to the worksheet tabs.
- A new worksheet will be created.
- Right-click the new worksheet tab.
- Select Rename.
- Enter
Summary.
Expected Output
The workbook should contain:
Sales | Expenses | Profit | Summary
Question 4: Move a Worksheet to Change Its Position
Problem Statement
A workbook contains the following worksheets:
Summary | Sales | Expenses | Employees
Move the Summary worksheet to the last position.
Excel Data
No additional data is required.
Solution
- Click and hold the Summary worksheet tab.
- Drag it toward the right.
- Place it after the Employees worksheet.
- Release the mouse button.
Expected Output
The worksheet order should become:
Sales | Expenses | Employees | Summary
Question 5: Copy a Worksheet for a New Month
Problem Statement
A workbook contains a worksheet named January Sales. You need to create a similar worksheet for February while keeping the original January worksheet unchanged.
Excel Data
The January worksheet contains sales records.
Solution
- Right-click the January Sales worksheet tab.
- Select Move or Copy.
- Select Create a copy.
- Choose the location of the copied worksheet.
- Click OK.
- Rename the copied worksheet to February Sales.
Expected Output
The workbook should contain both:
- January Sales
- February Sales
The original January worksheet should remain unchanged.
Question 6: Delete an Unwanted Worksheet
Problem Statement
A workbook contains these worksheets:
Sales | Expenses | Old Data | Profit
The Old Data worksheet is no longer required. Remove it from the workbook.
Excel Data
No additional data is required.
Solution
- Right-click the Old Data worksheet tab.
- Select Delete.
- If Excel displays a confirmation message, confirm the deletion.
Expected Output
The workbook should contain:
Sales | Expenses | Profit
The Old Data worksheet should no longer exist.
Note: Deleting a worksheet permanently removes its contents from the workbook, so make sure it is no longer needed before deleting it.
Question 7: Hide and Unhide a Worksheet
Problem Statement
A company workbook contains a worksheet named Employee Salary. Temporarily hide this worksheet and then make it visible again.
Excel Data
The worksheet contains employee salary information.
Solution
To hide the worksheet:
- Right-click the Employee Salary worksheet tab.
- Select Hide.
To unhide it:
- Right-click any visible worksheet tab.
- Select Unhide.
- Select Employee Salary.
- Click OK.
Expected Output
First, Employee Salary should disappear from the visible worksheet tabs.
After unhiding it, the worksheet should become visible again.
Question 8: Organize Worksheets Using Tab Colors
Problem Statement
A workbook contains these worksheets:
- Sales
- Expenses
- Employees
- Summary
Use different worksheet tab colors to make the workbook easier to organize.
Excel Data
No additional data is required.
Solution
- Right-click the Sales worksheet tab.
- Select Tab Color.
- Choose a color.
- Repeat the process for:
- Expenses
- Employees
- Summary
- Use different colors to visually distinguish the worksheets.
Expected Output
Each worksheet should have a different tab color.
For example:
| Worksheet | Tab Color |
|---|---|
| Sales | Color 1 |
| Expenses | Color 2 |
| Employees | Color 3 |
| Summary | Color 4 |
The exact colors are not important; the goal is to organize the workbook visually.
Question 9: Create and Organize a Complete Business Workbook
Problem Statement
Create a workbook for a small business that maintains monthly sales records.
The workbook should contain:
- January
- February
- March
- April
- Summary
The Summary worksheet should be placed at the beginning, followed by the monthly worksheets.
Excel Data
No sales data is required for this question. Focus on workbook and worksheet organization.
Solution
- Create a new Excel workbook.
- Rename the first worksheet to January.
- Add three worksheets:
- February
- March
- April
- Add another worksheet named Summary.
- Move Summary to the first position.
- Arrange the worksheets in this order:
Summary | January | February | March | April
Expected Output
The final workbook should have five properly organized worksheets:
| Position | Worksheet |
|---|---|
| 1 | Summary |
| 2 | January |
| 3 | February |
| 4 | March |
| 5 | April |
Key Takeaways
- An Excel workbook is the complete Excel file.
- A worksheet is an individual sheet inside a workbook.
- Worksheets can be created, renamed, moved, copied, hidden, unhidden and deleted.
- A workbook can contain multiple worksheets for organizing related information.
- Worksheet names should clearly describe their purpose.
- Copying a worksheet is useful when creating similar monthly or departmental reports.
- Hiding a worksheet does not delete its data.
- Deleting a worksheet removes the worksheet and its contents.
- Worksheet tab colors can make large workbooks easier to navigate.
- Proper worksheet organization becomes especially important when working with large Excel reports.
FAQs
1. What is an Excel workbook?
An Excel workbook is the complete Excel file that contains one or more worksheets. An .xlsx file is a common Excel workbook format.
2. What is an Excel worksheet?
A worksheet is an individual spreadsheet inside an Excel workbook. It contains rows, columns and cells where you enter and manage data.
3. What is the difference between a workbook and a worksheet?
A workbook is the complete Excel file, while a worksheet is one individual sheet inside that file.
4. How do I create a new worksheet in Excel?
Click the + button next to the worksheet tabs at the bottom of the Excel window.
5. Can I rename an Excel worksheet?
Yes. Right-click the worksheet tab, select Rename, enter the new name and press Enter.
6. Can I copy an Excel worksheet?
Yes. Right-click the worksheet tab, select Move or Copy, choose Create a copy, and click OK.
7. What happens when I delete a worksheet?
The worksheet and its contents are removed from the workbook. Therefore, make sure you no longer need the worksheet before deleting it.
8. Can I hide an Excel worksheet?
Yes. Right-click the worksheet tab and select Hide. You can later use Unhide to make it visible again.
9. Why should I organize worksheets properly?
Proper organization makes large workbooks easier to navigate, understand and maintain, especially when a workbook contains information for multiple months, departments or projects.
10. Can an Excel workbook contain multiple worksheets?
Yes. An Excel workbook can contain multiple worksheets, allowing you to keep related data in separate sheets within the same file.
Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.
