ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Practice!
3
4
NumberDescriptionExercisesNavigation
To move from one worksheet to the previous or next worksheet..
5
1.1Starting ExcelNo
6
1.2Understanding the Excel InterfaceYes
7
1.3
Getting Familiar with the Excel Workbook and Worksheets
Yes
8
1.4Explaining the RibbonYes
9
1.5Saving an Excel FileYes
10
 2.1aWhat You can Enter in a CellYes
11
 2.1bData TypeYes
12
2.2Relative and Absolute Cell ReferencesYes
13
2.3FormulaYes
14
2.4Order of OperationsYes
15
2.5Date Serial NumbersYes
16
3.1Copy and DragYes
17
3.2aRows and Columns Select/Insert/RemoveYes
18
3.2bRows and Columns Width AdjustYes
19
3.2cRows and Columns HideYes
20
3.2dRows and Columns GroupYes
21
3.3Working with WorksheetsYes
22
4.1Function introductionYes
23
4.2Sum FunctionYes
24
4.3Copy and Drag FormulaYes
25
4.4More FunctionsYes
26
4.5Named RangesYes
27
28
Shortcuts 1
29
Shortcuts 2
30
Shortcuts 3
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100