Selecting cells, rows, and columns in Google Sheets - Dashboard Guide

Dashboard Mode - Selecting cells, rows, and columns

Goal: Understand how to select cells, rows, and columns in Google Sheets

This dashboard helps you learn how to select different parts of a spreadsheet to work with data easily.

Sample Data: Weekly Sales

Day	Product A	Product B	Product C
Monday	10	20	30
Tuesday	15	25	35
Wednesday	20	30	40
Thursday	25	35	45
Friday	30	40	50

Dashboard Components

• KPI Card: Total sales for Product A
  Formula: =SUM(B2:B6)
  Result: 10+15+20+25+30 = 100
• KPI Card: Total sales for Tuesday (whole row)
  Formula: =SUM(B3:D3)
  Result: 15+25+35 = 75
• KPI Card: Total sales for all products on Wednesday (select row)
  Formula: =SUM(B4:D4)
  Result: 20+30+40 = 90
• KPI Card: Total sales for Product B (whole column)
  Formula: =SUM(C2:C6)
  Result: 20+25+30+35+40 = 150
• Table: Selected cells B2 to C4 (Product A and B sales for Monday to Wednesday)
  Shows values: 10,20; 15,25; 20,30

Dashboard Layout

+----------------------+----------------------+----------------------+
| Total Product A (100) | Total Tuesday (75)   | Total Wednesday (90) |
+----------------------+----------------------+----------------------+
| Total Product B (150) | Selected Cells B2:C4 (Table)               |
+----------------------+-------------------------------------------+

Interactivity

Clicking on a cell, row, or column in the sample data highlights the selection and updates the KPI cards and table below to show sums or values for that selection.

For example, selecting the entire column for Product B updates the total sales KPI for Product B.

Self Check

If you select the row for Thursday (cells B5:D5), which KPI card updates and what is the total sales value?

Answer: The KPI card for total sales on Thursday updates.
Formula: =SUM(B5:D5)
Result: 25 + 35 + 45 = 105

Key Result

Dashboard shows how to select cells, rows, and columns with formulas summing sales data.