06. Spreadsheets - Basics

	A	B	C	D	E	F	H	I	J	K	L	M	N	O
1	Format number in column A, so that it looks like column C
2	100.00		$100.00
3	10.99		$10.99
4	100.00		100.00 zł
5	10.99		10.99 zł				Move around the table using crl+arrow keys
6	-100.00		-100.00 zł				Use shift + arrow keys to select multiple cells				CTRL + A
7	3.34580		3.346
8	2.1		2.100				1	2	3	4	5	6	7	8
9	5.000000		5.000				1	2	3	4	5	6	7	8
10	2016-01-30		Saturday, January 30, 2016 at 6:00:00 PM				1	2	3	4	5	6	7	8
11	2015-11-12		15-Nov-12,Thursday				1	2	3	4	5	6	7	8
12							1	2	3	4	5	6	7	8
13							1	2	3	4	5	6	7	8
14	Create a series of numbers						1	2	3	4	5	6	7	8
15	1	1	1	Monday	AA		1	2	3	4	5	6	7	8
16		2	2	Tuesday	BB		1	2	3	4	5	6	7	8
17					CC		1	2	3	4	5	6	7	8
18							1	2	3	4	5	6	7	8
19							1	2	3	4	5	6	7	8
20							1	2	3	4	5	6	7	8
21							1	2	3	4	5	6	7	8
22							1	2	3	4	5	6	7	8
23							1	2	3	4	5	6	7	8
24							1	2	3	4	5	6	7	8
25
26							what is the fastest way to select all cells in a single row using keyboard?
27
28
29	Make an exact copy of the following table (copying entire table is forbidden).
30
31	Sales
32	January	February	March	April	May	June
33	1	10	0	11	12	13
34	2	20	0	50	50	50
35	3	30	0	30	50	50
36	4	40	0	30	50	50
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