Workbook, worksheet, and cell structure in Excel - Dashboard Guide

Dashboard Mode - Workbook, worksheet, and cell structure

Goal

Understand how Excel organizes data using workbooks, worksheets, and cells to help you find and enter information easily.

Sample Data

Item	Quantity	Price
Apples	10	0.5
Bananas	5	0.3
Oranges	8	0.6
Grapes	3	1.2
Pears	7	0.8

Dashboard Components

• KPI Card: Total Items = =SUM(B2:B6) (Result: 33)
• KPI Card: Average Price = =AVERAGE(C2:C6) (Result: 0.68)
• Table: Data Table showing Items, Quantity, and Price (cells A1:C6)
• Explanation Box: Shows cell reference example: Cell B2 contains quantity for Apples.

Dashboard Layout

+----------------------+----------------------+
|      Total Items      |    Average Price     |
|       (KPI Card)      |      (KPI Card)      |
+----------------------+----------------------+
|                                              |
|               Data Table (A1:C6)             |
|                                              |
+----------------------------------------------+
|           Explanation: Cell B2 = 10          |
+----------------------------------------------+

Interactivity

This simple dashboard does not have filters yet. You can click on any cell in the table to see its address (like B2) in the name box above the sheet. This helps you understand how cells are named by column letter and row number.

Self Check

If you select cell C4, what item and price does it show? (Answer: Grapes, 1.2)

Key Result

Shows how Excel organizes data in workbooks with worksheets and cells using a simple item list and formulas.