0
0
Excelspreadsheet~5 mins

Workbook, worksheet, and cell structure in Excel - Cheat Sheet & Quick Revision

Choose your learning style9 modes available
Recall & Review
beginner
What is a workbook in Excel?
A workbook is the entire Excel file that contains one or more worksheets. Think of it like a book that holds many pages.
Click to reveal answer
beginner
What is a worksheet in Excel?
A worksheet is a single page inside a workbook. It has rows and columns where you enter and organize your data.
Click to reveal answer
beginner
How do you identify a cell in Excel?
A cell is identified by its column letter and row number, like A1 or B5. The column is the letter on top, and the row is the number on the side.
Click to reveal answer
beginner
What is the intersection of a row and a column called?
The intersection of a row and a column is called a cell. It is where you enter data or formulas.
Click to reveal answer
beginner
How can you switch between worksheets in a workbook?
You can switch worksheets by clicking the sheet tabs at the bottom of the Excel window. Each tab has the worksheet's name.
Click to reveal answer
What does a workbook contain?
AMultiple worksheets
BOnly one worksheet
COnly cells
DOnly formulas
How is a cell identified in Excel?
ABy row number only
BBy column letter and row number
CBy column letter only
DBy worksheet name
Where do you find the worksheet tabs in Excel?
AAt the bottom of the window
BAt the top of the window
COn the right side
DIn the ribbon menu
What is the main purpose of a worksheet?
ATo create charts only
BTo save the Excel file
CTo format the workbook
DTo store data in rows and columns
Which of these is NOT part of Excel's cell structure?
AColumn letter
BRow number
CWorksheet tab
DCell address
Explain the relationship between a workbook, worksheet, and cell in Excel.
Think of a workbook as a book, worksheets as pages, and cells as boxes on the page.
You got /4 concepts.
    Describe how you would find and select a specific cell in Excel.
    Cells are named by column letter plus row number.
    You got /4 concepts.