Formula Practice - Public
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGH
1
GroupTest CasesInstructions
Expected Output (Don't touch these)
Enter Solution Formula HereTest Result (Don't touch this!)
2
1https://www.example.com/world/Extract the subdomain www
3
http://cn.example.com/Extract the subdomaincn
4
ftp://cn.example.com/Extract the subdomaincn
5
2string with spacesFind length of string without spaces16
6
3this is another stringFind length of string with spaces22
7
4 hello how are you today Remove leading and trailing whitespacehello how are you today
8
5good day ^ sirFind the location of the carat (^)10
9
6good day * sirFind the location of the asterisk (*)10
10
71Test if the cell contains a number, if so, return True, else return FalseTRUE
11
8Test if the cell is blank, if so, return True, else return FalseTRUE
12
91235434345345345Test if the cell is text, if so, return False, else return TrueFALSE
13
10hello world!Return the first 3 charactershel
14
11hello world!Return the last 4 charactersrld!
15
12hello world!Return hello earth!hello earth!
16
13cat in theCombine cells b16 and b17cat in the hat
17
hat
18
14what's the weather like today?Test if cell contains ' and ?, if so, return True, else return FalseTRUE
19
15Don't cry because it's over. In the cell range b19 to b21, how many cells contain a value?2
20
21
Smile because it happened.
22
163.14159Round the number up to the nearest whole number4
23
178.435345Round the number down to the nearest whole number8
24
182543981Multiply the first number in the cell by the last number in the cell2
25
192543971Check if cell b25 equals b4FALSE
26
20http://example.comChange cell b26 into a clickable linkhttp://example.com
27
21marketingtechnologypartnersCheck if cell b27 contains cell b28, if so, return True, else return FalseTRUE
28
technology
29
22what's 100 fahrenheit in celsius?Extract 100 from cell b29 and convert from Fahrenheit to Celsius37.7778
30
23dogIn the range b30 to b32, return only the unique values into one cell separated by commasdog,cat
31
cat
32
dog
33
242In the range b33:b37, return the following into one cell in the following order separated by semi colons. Average of the range; Highest number in the range, Lowest number in the range, Mode of the range, Sum of the range14.8;45;2;4;74;
34
45
35
4
36
4
37
19
38
25hello thereReverse the words in cell b38, ensure you conserve any whitespacesthere hello
39
26What is the width of the cell c24?78
40
2723Sort the range b40:b44 in highest to lowest order using 1 formula33356
41
5656
42
3335623
43
216
44
162
45
28dogFrom the range b45:b47, return all cells matching "dog"dog
46
big dogbig dog
47
catsNo test here
48
29In the range a2:a47, find the number 20 and return it's adjacent cell value. For example, if you were to lookup the number 2 in the range a2:a7, you would return "string with spaces"http://example.com
49
30Return the coordinate representation of cell f23 in the following format: "x,y". 23,6
50
31example.com/helloIn the range b50:b54, return all the values that do NOT include a ? (question mark)example.com/hello
51
example.com/hello?parameter=1example.com
52
example.com/hello?parameter=2&value=34
No test here
53
example.com/hello?parameter=3&showId=3242343
54
example.com
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