1- Using the COUNT function, how many orders are in your data?

2-

Using the SUM function, what is the total price of all of the orders?

Write your numeric answer with no commas.

3- Using the AVERAGE function, what is the average price of an order?

4- Using the COUNTIF function, how many orders occurred in March?

5- Using the SUMIF function, what is the total price of all orders placed in November?

Write your numeric answer with no commas.

6- Using the MAX function, what is the maximum price of an order in this data?

7- Using the MIN function, what is the minimum price of an order in this data?

8- Using the MEDIAN function, what is the median price of an order in this data?

CONNECTING DATA USING VLOOKUP AND INDEX/MATCH

1- Using the VLOOKUP function, in what month was order 10055 placed?

2- Using the INDEX and MATCH functions, what was the price of order 10030?

FILTERING AND SORTING

1- Using a filter, how many orders were placed in January?

2-Using a filter, how many orders were placed in January?

3- Using the sort feature, what is the maximum value of sales tax for an order?

4- Using the sort feature, what is the minimum value of sales tax for an order?

5- Using a filter or the sort feature, in what month was order 10134 placed?

6- Using a combination of sorting and filtering, what was the maximum sales tax amount for an order placed in March?

A158 XV fx 10157 A B D E F G Daun WN 1 Order Number Month Price ($) Sales Tax ($) 2 10001 January 233.38 11.78 3 10002 January 63.81 6.94 4 10003 January 296.03 19.69 10004 January 286.86 31.50 6 10005 January 179.55 9.87 7 10006 January 179.39 9.62 8 10007 January 306.15 20.58 9 10008 January 71.38 7.38 10 10009 January 90.51 9.68 11 10010 January 269.16 21.59 12 10011 January 192.12 10.99 13 10012 January 296.64 15.72 14 10013 January 86.27 6.67 15 10014 February 95.13 8.35 16 10015 February 124.81 13.10 17 10016 February 230.70 18.23 18 10017 February 124.54 9.47 19 10018 February 195.16 20.59 20 10019 February 133.24 13.42 21 10020 February 169.51 9.98 22 10021 February 115.12 9.77 23 10022 February 110.75 8.08 24 10023 February 92.62 10.13 25 10024 February 267.70 29.16 26 10025 February 102.43 8.18 27 10026 February 122.76 7.56 28 10027 March 76.19 4.36 29 10028 March 68.29 3.83 30 10029 March 326.32 32.95 31 10030 March 107.19 10.20 32 10031 March 220.07 16.39 33 10032 March 162.03 14.23 34 10033 March 85.51 7.35 35 10034 March 81.39 5.55 36 10035 March 66.62 5.09 37 10036 March 336.24 28.64 38 10037 March 316.54 34.14 Unique Student Info MP01 Orders Data d Student Workspace A158 X fx 10157 A B D E F G 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 10037 March 10038 March 10039 March 10040 April 10041 April 10042 April 10043 April 10044 April 10045 April 10046 April 10047 April 10048 April 10049 April 10050 April 10051 April 10052 April 10053 May 10054 May 10055 May 10056 May 10057 May 10058 May 10059 May 10060 May 10061 May 10062 May 10063 May 10064 May 10065 May 10066 May 10067 May 10068 May 10069 June 10070 June 10071 June 10072 June 10073 June 10074 June Unique Student Info 316.54 34.14 143.99 8.00 193.78 19.48 111.74 10.18 94.17 5.15 327.94 31.00 331.82 33.86 92.85 8.16 206.41 14.95 251.21 24.68 268.58 14.15 154.36 11.51 307.06 17.53 331.88 36.21 62.38 3.77 329.40 33.00 333.97 20.45 219.58 15.53 233.23 16.76 103.34 10.22 285.25 18.70 83.36 6.35 170.77 15.75 269.30 26.13 283.57 27.18 338.09 19.29 307.90 21.67 99.25 6.16 79.40 7.66 312.05 32.67 199.11 19.34 124.71 8.16 249.34 20.87 74.41 6.46 161.62 12.26 252.54 18.71 254.28 26.92 226.02 17.71 MPO1 Orders Data . Student Workspace A158 4 x fx 10157 A B D E F G 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 101 102 10074 June 10075 June 10076 June 10077 June 10078 June 10079 June 10080 June 10081 June 10082 June 10083 June 10084 June 10085 July 10086 July 10087 July 10088 July 10089 July 10090 July 10091 July 10092 July 10093 July 10094 July 10095 July 10096 July 10097 July 10098 July 10099 July 10100 August 10101 August 10102 August 10103 August 10104 August 10105 August 10106 August 10107 August 10108 August 10109 September 10110 September 10111 September Unique Student Info 226.02 17.71 289.72 16.21 195.93 18.28 60.48 6.54 172.69 11.76 244.25 23.55 125.33 8.94 224.96 17.69 229.15 20.65 301.78 30.23 267.33 28.87 208.15 11.70 195.26 10.11 51.17 4.59 264.37 15.21 165.74 10.78 77.72 5.29 218.58 12.77 331.67 23.71 236.40 22.18 155.40 8.62 184.28 20.14 349.61 23.90 145.42 15.94 136.45 14.07 268.98 15.01 147.88 14.49 176.17 12.20 304.00 20.26 98.56 7.64 127.94 13.86 187.33 12.98 88.57 8.31 108.46 8.96 154.39 13.38 348.49 18.54 138.37 12.77 115.58 9.76 MP01 Orders Data 103 104 105 106 107 108 109 110 111 112 Student Workspace A158 4 x vfx 10157 A B D E F G 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 10111 September 10112 September 10113 September 10114 September 10115 September 10116 September 10117 September 10118 September 10119 September 10120 September 10121 September 10122 September 10123 September 10124 September 10125 October 10126 October 10127 October 10128 October 10129 October 10130 October 10131 October 10132 October 10133 November 10134 November 10135 November 10136 November 10137 November 10138 November 10139 November 10140 November 10141 November 10142 November 10143 November 10144 November 10145 December 10146 December 10147 December 10148 December Unique Student Info 115.58 178.45 129.65 52.61 266.29 318.25 136.15 225.99 84.54 145.20 308.90 205.14 185.53 141.39 73.28 317.42 243.03 223.49 59.60 176.38 125.18 243.59 184.38 252.66 283.33 130.35 96.48 66.81 273.89 139.38 292.64 299.24 63.79 331.61 258.35 84.28 298.05 300.85 9.76 9.60 10.09 5.39 21.78 31.39 14.64 14.89 6.06 15.46 24.60 16.65 11.83 7.32 7.61 20.98 14.08 18.72 6.34 13.41 9.92 24.16 16.45 17.76 18.36 8.56 7.35 5.90 25.32 12.43 18.19 29.36 4.73 32.93 23.99 9.13 24.64 24.13 MP01 Orders Data Student Workspace A158 X fx 10157 A B D E F G H 142 143 145 146 147 148 149 150 151 10141 November 10142 November 10143 November 10144 November 10145 December 10146 December 10147 December 10148 December 10149 December 10150 December 10151 December 10152 December 10153 December 10154 December 10155 December 10156 December 10157 December 292.64 299.24 63.79 331.61 258.35 84.28 298.05 300.85 269.98 55.60 79.89 151.54 187.73 204.52 279.43 122.97 255.58 18.19 29.36 4.73 32.93 23.99 9.13 24.64 24.13 23.69 4.73 6.34 11.10 18.47 22.14 26.64 10.27 15.00 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 A P Unique Student Info MP01 Orders Data Student Workspace +