Hint use if statements c sort by employee and then by

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: statements c) Sort by employee and then by revenue d) Add a "totals" row that sums quantity sold and revenue columns Hint: Look on the Design ribbon Employee John Dan Ben John Ben John Dan Ben Sale Date 7/1/2001 11/10/2004 9/10/2004 8/29/2004 8/18/2002 7/4/2001 5/1/2001 8/1/2004 Quantity 74 29 39 77 43 46 27 41 Challenge Using the table you just created, and conditional functions (SUMIF(S), AVERAGEIF(S)) calculate the following values: Total quantity sold for John Average revenue for Ben Total revenue for John in 2001 There is a very specific way that Excel refers to columns of an Excel table in a formula. Using the formulas you just created, try to figure out how the naming of columns in Excel Tables works. Explain below. Facility ID # Air Basin County District 128 SV 6 COL 67 SV 6 COL 69 SV 6 COL 70 SV 6 COL 66 SV 6 COL 64 SV 6 COL 65 SV 6 COL 11961 SF 7 BA 16506 SF 7 BA 8 13 SF 7 BA 118 65 SF 7 BA 11918 SF 7 BA 1198 3 SF 7 BA 16168 SF 7 BA 12941 SF 7 BA 1638 1 SF 7 BA 1121 SJV 10 SJU 28 72 SJV 10 SJU 2658 SJV 10 SJU 28 8 5 SJV 10 SJU 2967 SJV 10 SJU 311 SJV 10 SJU 4306 SJV 10 SJU 5707 SJV 10 SJU 520 SJV 10 SJU 18 54 SJV 10 SJU 413 SJV 10 SJU 2249 SJV 10 SJU 4199 SJV 10 SJU 3798 SJV 10 SJU 3054 SJV 10 SJU 378 6 SJV 10 SJU 65 SV 11 GL E 15 SV 11 GL E 430 SV 11 GL E 542 SV 11 GL E 420 SV 11 GL E 532 SV 11 GL E 60 SV 11 GL E 502 SV 11 GL E 66 SV 11 GL E 114 SV 11 GL E 40 SV 11 GL E 8 7 SV 11 GL E 440 SV 11 GL E 512 SV 11 GL E 18 5 SV 11 GL E 153 SV 11 GL E 523 SV 11 GL E 445 SV 11 GL E 495 SV 11 GL E 18 6 SV 11 GL E 427 SV 11 GL E 529 SV 11 GL E 424 SV 11 GL E 490 SV 11 GL E 506 SV 11 GL E 531 SV 11 GL E 63 SV 11 GL E 441 SV 11 GL E 403 SV 11 GL E 437 SV 11 GL E 105 SV 11 GL E 522 SV 11 GL E 421 SV 11 GL E 35 SV 11 GL E 541 SV 11 GL E 123 SV 11 GL E 124 SV 11 GL E 125 SV 11 GL E 465 SV 11 GL E 526 SV 11 GL E 418 SV 11 GL E 494 SV 11 GL E 439 SV 11 GL E 501 SV 11 GL E 231 SV 11 GL E 436 SV 11 GL E 503 SV 11 GL E 434 SV 11 GL E 48 2 SV 11 GL E 505 SV 11 GL E 140 SV 11 GL E 417 SV 11 GL E 100 SV 11 GL E 533 SV 11 GL E 195 SV 11 GL E 122 SV 11 GL E 179 SV 11 GL E 402 SV 11 GL E 142 SV 11 GL E 121 SV 11 GL E 7 SV 11 GL E 64 SV 11 GL E 442 SV 11 GL E 431 SV 11 GL E 18 3 SV 11 GL E 524 SV 11 GL E 200 SV 11 GL E 491 SV 11 GL E 48 3 SV 11 GL E 57 SV 11 GL E 463 SV 11 GL E 423 SV 11 GL E 426 SV 11 GL E 18 2 SV 11 GL E 198 SV 11 GL E 511 SV 11 GL E 59 SV 11 GL E 8 6 SV 11 GL E 530 SV 11 GL E 16 SV 11 GL E 516 SV 11 GL E 513 SV 11 GL E 67 SV 11 GL E 534 S...
View Full Document

Ask a homework question - tutors are online