* solve it using excel *

Question 1: The data in the table represents the order quantity that was sold by different salesmen (Ahmed, Mohammed, Ali, Abdullah and Abdulrahman) to 14 different companies in January 2020. Use Microsoft Excel and the data in the table to find the points below (1-9). (9 marks) 1- The total sales for each salesman (Ahmed, Mohammed, Ali, Abdullah and Abdulrahman). 2- The total order quantity for each company. 3- The total order quantities bought by Companies A, E, H and N together. 4- The Maximum order quantity sold to each Company I, J and K. 5- The Minimum order quantity sold to each Company B, C and D. 6- The number of order that was delivered to each company and was greater than 300. 7- The average of the order for each company. 8- The total sales for January. 9- The square root of the total order quantity for each company. Salesman Name Company E Company F Company G Company H 447 123 266 447 Company A Company B Company C Company D 489 407 100 234 390 261 255 278 Company K 122 Company Company) 435 154 315 374 Company L Company M 188 362 AHMED MOHAMMED Company N 338 173 248 494 373 199 262 251 426 264 485 404 268 245 386 182 102 190 198 489 451 409 492 ABDULLAH 109 406 232 137 418 121 407 468 481 180 397 218 475 447 304 480 241 384 421 112 410 107 273 469 161 292 476 ABDULRAHMAN AHMED 165 269 279 401 404 125 277 231 335 424 405 254 309 113 247 MOHAMMED 321 293 284 231 200 492 256 129 438 195 231 235 268 286 357 207 308 447 395 374 274 217 297 275 150 110 493 212 202 475 396 369 184 122 481 146 204 235 405 292 127 204 ABDULLAH ABDULRAHMAN 160 103 174 237 246 120 175 498 198 400 389 145 449 272 AHMED 203 303 445 319 117 124 346 127 227 181 369 451 205 261 317 227 189 421 370 423 191 158 416 169 311 360 117 330 MOHAMMED ALI 348 181 117 464 266 328 353 448 272 490 363 266 408 105 ABDULLAH 104 426 368 335 365 484 335 325 362 259 116 342 337 366 277 229 208 481 469 463 320 363 182 333 110 466 435 ABDULRAHMAN AHMED 289 425 294 283 308 158 104 353 452 335 170 232 130 210 MOHAMMED 259 278 321 481 371 261 105 151 169 211 191 339 286 409 304 201 191 385 413 330 403 227 209 106 282 459 386 378 144 115 208 271 200 295 390 401 426 152 198 126 374 ABDULLAH ABDULRAHMAN 156 138 202 395 381 431 406 318 394 495 410 304 319 205 AHMED 315 131 148 118 207 237 132 188 211 100 120 393 475 485 MOHAMMED 369 139 177 409 238 243 205 205 216 270 346 183 379 299 443 199 212 445 440 410 184 250 133 383 208 391 300 110 ABDULLAH 344 176 164 480 448 237 334 453 100 327 441 307 235 372 ABDULRAHMAN 338 474 154 448 241 468 477 395 240 230 214 156 166 206 AHMED 345 467 497 323 363 252 342 245 390 243 257 176 170 MOHAMMED 371 338 211 273 180 345 457 356 330 472 353 347 284 463 159 162 404 204 382 327 129 143 140 228 259 460 266 280 201 420 479 492 481 413 449 301 361 176 277 393 476 174 ABDULLAH ABDULRAHMAN AHMED 317 373 323 231 474 492 108 398 136 497 308 408 450 368 285 108 101 314 436 385 151 358 430 163 403 462 419 351 MOHAMMED 179 100 125 100 181 324 125 340 205 366 157 428 384 145 380 368 135 329 353 161 480 131 147 182 297 399 157 351 175 348 463 299 158 207 139 210 238 420 280 468 170 ABDULLAH ABDULRAHMAN AHMED 282 328 266 383 175 275 316 331 168 174 278 193 194 460 498 171 464 164 317 361 362 296 306 380 124 441 468 406 126 328 262 390 266 476 413 394 179 341 398 MOHAMMED ALI 457 143 460 257 206 305 391 251 121 165 296 362 415 161 220 107 247 ABDULLAH 365 435 313 362 197 414 307 279 237 206 271 304 481 227 ABDULRAHMAN 418 366 284 266 371 465 136 306 312 408 468 448 264 167 319 239 335 183 318 101 151 483 488 177 267 232 378 AHMED MOHAMMED 284 251 354 389 207 190 195 470 123 402 423 254 374 128 ALI 119 128 126 147 160 254 251 369 104 161 116 164 409 214 ABDULLAH 268 288 306 204 356 205 150 311 318 405 337 380 441 431 215 167 308 290 466 249 256 238 201 282 424 283 ABDULRAHMAN AHMED 316 317 423 342 143 124 158 469 486 188 199 193 468 171 MOHAMMED 358 467 322 397 496 261 151 394 356 393 289 235 180 478 493 449 189 429 364 178 375 470 406 299 163 249 380 308 ABDULLAH 493 172 403 244 162 417 183 471 481 480 362 118 498 329