SheetSkill
Learning pathLesson 2 of 2
Practice sheetEverything is checked as you go. Rules can be changed or deleted any time.
A1
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
L
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Region
Rep
Product
Units
Sales
North
Asha
Pens
10
25
South
Fay
Paper
27
162
East
Kai
Ink
44
528
West
Dee
Folders
61
244
North
Ivo
Paper
18
108
South
Ben
Ink
35
420
East
Gus
Folders
52
208
West
Lia
Pens
69
172.5
North
Eli
Ink
26
312
South
Jo
Folders
43
172
East
Chen
Pens
60
150
West
Hana
Paper
17
102
North
Asha
Folders
34
136
South
Fay
Pens
51
127.5
East
Kai
Paper
68
408
West
Dee
Ink
25
300

Conditional formatting

A number, or a cell like =$H$1

AaBbCc 123

Rules on this sheet (0)

No rules yet. When several rules affect the same cell, the one higher in this list wins.

Find and Replace

Go To

Format Cells

SampleRegion

No specific number format.

Insert Hyperlink

A cell reference like Sheet2!A1 links to a place in this workbook. Ctrl+click a link cell to open it.

New note · A1

Notes show as a red corner. Ctrl+Enter saves.

Insert Function

SUM(number1, [number2], …)
Adds numbers