Phone Rental Cost Months In Year

$ 120.00 12

TOTAL MONTHLY COST:

PLAN: A B C
Fixed Service Cost: $ 30.00 $ 35.00 $ 40.00
Variable Cost (per MB): $ 0.10 $ 0.09 $ 0.08
100 $ 50.00 $ 54.00 $ 58.00
150 $ 55.00 $ 58.50 $ 62.00
200 $ 60.00 $ 63.00 $ 66.00
250 $ 65.00 $ 67.50 $ 70.00
500 $ 90.00 $ 90.00 $ 90.00
Data

1000 $ 140.00 $ 135.00 $ 130.00

1500 $ 190.00 $ 180.00 $ 170.00
2000 $ 240.00 $ 225.00 $ 210.00
4000 $ 440.00 $ 405.00 $ 370.00
5000 $ 540.00 $ 495.00 $ 450.00
10000 $ 1,040.00 $ 945.00 $ 850.00
 D
$ 45.00
$ 0.07
$ 62.00
$ 65.50
$ 69.00
$ 72.50
$ 90.00
$ 125.00
$ 160.00
$ 195.00
$ 335.00
$ 405.00
$ 755.00
http://corporate.flyeia.com/node/17950
(build your table here, based on the data extracted from the Airport Data Excel Document)

Year Month Domestic Transborder International Total

2014 Jan 409,056 118,614 56,246 583916
2014 Feb 392,278 123,450 51,711 567439
2014 Mar 427,133 140,076 57,590 624799
2014 Apr 439,363 130,201 49,295 618859
2014 May 459,895 109,223 28,631 597749
2014 June 478,107 91,810 23,288 593205
2014 July 536,206 103,965 26,730 666901
2014 August 572,105 107,846 28,823 708774
2014 September 479,005 91,106 21,438 591549
2014 October 466,259 111,262 20,136 597657
2014 November 405,170 119,512 41,391 566073
2014 December 436,015 124,761 53,981 614757
2015 January 398,154 118,217 65,690 582061
2015 February 380,918 119,725 60,969 561612
2015 March 421,422 129,143 63,210 613775
2015 April 413,376 119,259 60,059 592694
2015 May 438,699 95,149 31,653 565501
2015 June 490,913 82,097 25,460 598470
2015 July 559,446 93,494 30,639 683579
2015 August 583,402 93,632 32,932 709966
2015 September 493,555 81,253 27,317 602125
2015 October 472,385 96,954 25,577 594916
2015 November 405,582 99,231 46,170 550983
2015 December 469,059 100,052 56,125 625236
2016 January 400,033 96,994 65,361 562388
2016 February 397,925 95,166 61,089 554180
2016 March 426,708 95,474 56,139 578321
2016 April 399,485 85,929 49,708 535122
2016 May 492,660 70,524 28,779 591963
2016 June 497,579 62,983 22,788 583350
2016 July 559,097 60,200 25,707 645004
2016 August 586,241 57,193 26,074 669508
2016 September 503,743 61,749 23,384 588876
2016 October 491,675 72,268 22,180 586123
2016 November 421,246 78,400 41,402 541048
2016 December 459,720 79,794 51,521 591035
2017 January 426,381 84,817 60,541 571739
2017 February 413,219 83,376 53,681 550276
2017 March 462,812 90,462 55,594 608868
2017 April 461,704 86,993 55,809 604506
2017 May 523,078 64,615 28,136 615829
2017 June 522,120 53,961 21,383 597464
2017 July 598,181 61,441 29,505 689127
2017 August 632,864 61,105 28,813 722782
2017 September 518,014 59,766 21,090 598870
2017 October 513,647 70,003 19,684 603334
2017 November 457,704 81,073 43,681 582458
2017 December 488,598 82,221 56,222 627041
Excel Scavenger Hunt
Find your way through the different clues and to the end of the
by using an Excel function to find the row number of the next c

(Hint: when you find the address of the next cell, you can enter

Go To Cell:
Column: CQ
Row: 1969 Find the largest of all the numbers in the data below.

1967 1933 1939 1908 1915 1956 1902

1962 1910 1941 1939 1905 1911 1968
1934 1947 1968 1911 1941 1950 1921
1918 1940 1925 1928 1938 1951 1958
1920 1934 1921 1949 1908 1932 1937
1961 1904 1962 1903 1937 1942 1938
1937 1924 1945 1942 1937 1969 1918
1938 1968 1919 1915 1958 1901 1923
1929 1905 1956 1929 1910 1923 1968
1954 1930 1917 1914 1936 1922 1962
1936 1968 1903 1959 1952 1928 1950
1959 1936 1936 1966 1956 1938 1947
1963 1957 1969 1937 1924 1937 1914
1968 1901 1950 1902 1906 1909 1919
1924 1906 1902 1955 1950 1932 1939
1968 1939 1937 1920 1961 1952 1913
1956 1963 1950 1953 1963 1953 1908
1930 1942 1960 1952 1936 1908 1920
1916 1910 1967 1958 1910 1903 1914
1958 1945 1901 1960 1907 1966 1961
d to the end of the scavenger hunt
mber of the next clue.

ell, you can enter it in the "Name Box" above column A.)

1967 1920 1957

1906 1966 1952
1969 1904 1911
1904 1915 1936
1948 1937 1904
1928 1906 1954
1956 1928 1902
1901 1903 1952
1946 1955 1922
1911 1955 1954
1932 1921 1967
1926 1952 1935
1934 1945 1936
1905 1909 1960
1944 1932 1952
1963 1936 1920
1966 1904 1938
1937 1913 1944
1907 1943 1922
1910 1929 1958
You Found It!
Your next clue is in cell:
CC
29 Find the number of times t
(Hint - use the CountIf func

69 67
62 64
64 68
69 66
60 61
62 64
66 60
62 65
62 63
61 61
68 68
64 63
66 63
68 64
64 66
65 60
63 63
62 67
69 63
64 68
63 61
61 63
68 63
69 63
68 65
e is in cell:

e number of times that the number 64 shows up in the data below.

use the CountIf function)

67 62 67 63 65 60 62 65 67
68 60 67 60 67 65 63 66 68
64 63 65 67 62 60 63 69 67
67 65 68 63 64 66 66 62 62
60 60 69 63 67 62 68 63 69
61 69 60 63 68 61 62 68 65
64 61 63 66 69 69 66 62 64
67 64 66 64 69 66 64 66 68
60 68 65 68 60 62 65 67 66
63 67 62 69 66 64 69 61 63
68 66 66 64 64 67 67 62 61
63 65 60 64 68 62 63 65 68
68 68 67 61 61 68 68 60 68
64 65 66 60 65 64 68 60 68
61 63 67 61 60 68 65 68 63
68 63 62 61 68 69 63 64 68
66 61 65 66 61 64 68 66 61
61 67 60 67 68 66 68 69 64
67 62 60 62 66 66 67 60 69
61 67 64 67 67 69 65 62 60
61 62 68 63 60 69 61 63 60
66 66 68 66 68 64 68 62 63
69 65 66 67 62 64 61 69 60
67 61 69 68 61 68 62 63 69
69 68 65 67 66 69 62 67 64
65
66
67
65
62
69
61
62
60
60
69
60
69
68
66
61
69
65
69
63
68
64
61
68
63
 You Found It!
Now Go To Cell:
Column: AA
Row: 24007 Find the average of the values in the table below

24687 24300 25799 23825 25703

23015 22771 24214 25342 24003
25824 25331 24528 23245 25306
23321 22602 23445 22886 23528
24734 24196 22601 24142 25438
23058 24784 23758 25816 23600
22358 25332 23895 24576 24459
25591 22261 23288 22044 22324
24093 25656 22452 24437 22280
22183 24369 24137 25657 22405
25477 25617 22171 23830 25214
22484 24843 22410 23775 24745
24983 24691 24050 23285 23228
22704 24168 24070 23836 22939
25433 24146 23370 24749 22210
23556 24595 22052 23406 23655
24059 24004 25644 25770 25663
25177 24864 24926 23725 25079
23454 22480 22311 25721 25942
24824 24104 22286 24505 25043
23004 23909 23462 24829 24052
24581 24736 24033 22176 23963
23827 24320 23800 24860 23977
23264 23817 22693 25733 24921
24446 22030 23279 22475 22649
in the table below.

23623 23504 22057 24035 22399

22263 23597 23678 24653 24636
22689 24008 25342 23415 23463
23445 23889 22850 25305 22451
22428 25193 24364 23190 23901
25362 22207 22126 23201 25906
24790 22277 22322 25475 22352
22914 25312 23264 25304 22657
23959 25090 25084 25676 25105
24440 24743 25879 23542 22261
22974 24808 25541 22736 24233
22658 22526 23545 25611 23260
22572 22150 23802 25537 25703
25238 25499 23920 23072 24858
24624 24581 23367 25966 24095
24823 23409 24554 22332 25641
24662 22429 24850 24946 24538
23762 24917 24403 23788 24113
25763 25461 23025 25553 25014
23433 24311 22931 25224 25510
23448 25279 23900 25652 23493
23503 24460 25489 23250 22377
24012 22942 25469 24060 23642
23708 23543 24254 22572 23217
25500 23593 22850 25624 22266
Have a great day!
See you next week!
 You Found It!
Next Clue in Cell:
Column: BA
Row: 13040 Use the Sumproduct() function to find the tota
i.e., this will be the sum, over all products, of th

Product Price Sales Qty

1 $ 4.00 89 $ 356.00
2 $ 9.00 99 $ 891.00
3 $ 7.00 93 $ 651.00
4 $ 3.00 51 $ 153.00
5 $ 7.00 251 $ 1,757.00
6 $ 5.00 147 $ 735.00
7 $ 8.00 22 $ 176.00
8 $ 11.00 146 $ 1,606.00
9 $ 4.00 57 $ 228.00
10 $ 4.00 11 $ 44.00
11 $ 9.00 144 $ 1,296.00
12 $ 5.00 28 $ 140.00
13 $ 8.00 106 $ 848.00
14 $ 9.00 50 $ 450.00
15 $ 10.00 130 $ 1,300.00
16 $ 1.00 178 $ 178.00
17 $ 3.00 217 $ 651.00
18 $ 11.00 58 $ 638.00
19 $ 5.00 147 $ 735.00
20 $ 3.00 69 $ 207.00
$ 13,040.00
on to find the total dollar value of sales.
all products, of the price*sales qty
x