logo
Microsoft Excel - Interview Questions and Answers
What is the difference between a workbook and a worksheet?

The key difference between a workbook and a worksheet in Excel is:

Workbook :
  • A workbook is the entire Excel file that contains one or more worksheets.
  • It has a .xlsx or .xls extension.
  • A workbook can store multiple sheets, macros, charts, and external data.
  • Think of it as a folder that holds multiple sheets.
Worksheet :
  • A worksheet (also called a spreadsheet) is a single sheet inside a workbook.
  • It consists of rows and columns where you enter data.
  • Each workbook can have multiple worksheets, accessible via tabs at the bottom.
  • Think of it as a page within a workbook.