day 3 excercise1

day 3 excercise1 - A B C D E 1 2 3 4 Trans Number Name Date...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Tasks Trans Number Name Date Product Units Dol ars Sort data, filter 1 Betsy 4/1/20 4 lip glos 45 $137.20 name ranges - columns 2 Hal agan 3/10/20 4 foundation 50 $152.01 Sum sales 3 Ashley 2/25/20 5 lipstick 9 $28.72 4 Hal agan 5/2 /20 6 lip glos 5 $167.08 Ap ly conditional format ing to high and low performers 5 Zaret 6/17/20 4 lip glos 43 $130.60 6 Col e n 1 /27/20 5 eye liner 58 $175.9 Create pivot tables for sales per product, name, etc 7 Cristina 3/21/20 4 eye liner 8 $25.80 Create pivot table charts 8 Col e n 12/17/20 6 lip glos 72 $217.84 9 Ashley 7/5/20 6 eye liner 75 $2 6.64 10 Betsy 8/7/20 6 lip glos 24 $73.50 1 Ashley 1 /29/20 4 mascara 43 $130.84 12 Ashley 1 /18/20 4 lip glos 23 $71.03 13 Emile 8/31/20 5 lip glos 49 $149.59 14 Hal agan 1/1/20 5 eye liner 18 $56.47 15 Zaret 9/20/20 6 foundation -8 $(21.9 ) 16 Emile 4/12/20 4 mascara 45 $137.39 17 Col e n 4/30/20 6 mascara 6 $19 .65 18 Jen 8/31/20 5 lip glos 8 $265.19 19 Jen 10/27/20 4 eye liner 78 $236.15 20 Zaret 1 /27/20 5 lip glos 57 $173.12 21 Zaret 6/2/20 6 mascara 12 $38.08 2 Betsy 9/24/20 4 eye liner 28 $86.51 23 Col e n 2/1/20 6 mascara 25 $7 .31 24 Hal agan 5/2/20 5 foundation 29 $8 .2 25 Jen 1 /7/20 4 mascara -4 $(9.94) 26 Emile 12/6/20 6 lip glos 24 $74.62 27 Jen 4/12/20 4 lipstick 38 $1 5.9 28 Cristina 9/2 /20 5 foundation 7 $23 .05 29 Betsy 10/23/20 6 foundation 7 $23 .36 30 Hal agan 1 /16/20 5 foundation 60 $182.25 31 Zaret 9/1 /20 5 lip glos 6 $20.48 32 Cristina 3/28/20 6 lip glos 53 $161.46 3 Cici 6/17/20 4 mascara 41 $125.27 34 Zaret 9/9/20 6 mascara 19 $59.15 35 Jen 12/28/20 6 foundation 39 $1 9.30 36 Betsy 9/13/20 4 lip glos 2 $8.26 37 Zaret 7/7/20 5 eye liner 34 $103.4 38 Emile 3/8/20 5 foundation 59 $179.01 39 Cici 2/23/20 6 foundation -9 $(24.63) 40 Hal agan 6/24/20 6 foundation 38 $1 5.58 41 Emile 2/6/20 4 eye liner 25 $76.56 42 Emile 4/10/20 5 mascara 19 $59.38 43 Betsy 4/1/20 4 foundation 86 $259.86 4 Col e n 6/6/20 4 lip glos 5 $167.12 45 Emile 9/20/20 6 lip glos 2 $7.85 46 Ashley 8/9/20 5 mascara 93 $280.69 47 Zaret 9/24/20 4 eye liner 14 $43.93 48 Emile 5/24/20 5 eye liner 37 $1 3.03 49 Betsy 1 /18/20 4 foundation 63 $190.70 50 Zaret 1 /18/20 4 lip glos 1 $5.60 51 Zaret 6/15/20 5 eye liner 24 $73.60 52 Hal agan 1/4/20 4 eye liner 83 $250.3 53 Cici 7/7/20 5 eye liner 49 $148.51 54 Cristina 4/10/20 5 lip glos 26 $80.20 5 Jen 5/2 /20 6 lip glos 35 $107.9 56 Cristina 4/12/20 4 lip glos 8 $26.91 57 Cici 6/28/20 4 mascara 49 $148.78 58 Cristina 4/12/20 4 foundation 34 $104.09 59 Cristina 12/8/20 5 lip glos 8 $26.24 60 Jen 10/27/20 4 mascara 89 $269.09 61 Col e n 1 /16/20 5 foundation 62 $189.25 62 Emile 8/1 /20 4 foundation 23 $71.31 63 Cici 6/17/20 4 eye liner 95 $287.76 64 Emile 5/1 /20 6 eye liner 41 $125.0 65 Ashley 4/10/20 5 lip glos -6 $(15.94) 6 Betsy 1/1/20 5 mascara 84 $253.9 67 Hal agan 1 /5/20 5 foundation 63 $191.37 68 Zaret 7/16/20 6 lip glos 0 $2.37 69 Cristina 1/23/20 5 eye liner 73 $2 1.41 70 Emile 12/21/20 4 eye liner 95 $287.05 71 Ashley 1 /16/20 5 lipstick
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

day 3 excercise1 - A B C D E 1 2 3 4 Trans Number Name Date...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online