You will submit the files and assignments the Excel Tech Challenge.
1.Personal Budget
2. Invoice form and Tracker
3. Loan Amortization Schedule
4. Sales Report for Gourmet Style
Team Project
Project Summary
In the appropriate area of the table below, enter your name and write a description (up to 200 words) about the skills you’ve practiced while completing the Team Project. List a selection of the skills you used to create the workbook, then comment on any challenges you experienced with specific skills and how you solved them. For example, if you experienced difficulties while working with tables, describe the issues and what you did to fix them.
Team Member 1
Name
Description
Team Member 2
Name
Description
Team Member 3
Name
Description
>Sheet Unit Sales
Years a Slave
0
1
Drama 2 30 4
Drama 10 Drama Comedy 1 50 Drama 20 Drama 30 200 Drama Drama 5 10 Drama 20 Drama 14 Drama 3 30 Drama 4 10 Drama 2 10 Drama 4 50 Drama 3 70 Drama 3 8 Drama 3 2 Musical 10 150 Drama 20 10 Musical 20 200 Drama 2 15 Drama 3 20 Drama 10 20 1940 Drama 1 3 Drama 5 20 Comedy 20 Drama Drama 17 20 Drama 2 Drama 3 20 Drama 20 30 Drama 3 30 Drama 15 40 Drama 15 20 Drama 28 Musical Comedy 8 15 Drama 5 12 Musical 6 Comedy 2 6 >Sheet 2 0
0
2 France 5 4 0
France 2 US 7 800 a
2 US 7 800 1 US Italy 7 800 2 Lugano Italy 5 650 2 65 Canada Tuscany Italy 5 650 4 Australia Provence France 3 0
2 UK 7 800 2 58 US Lugano Italy 7 800 2 60 Italy 7 800 2 Brazil Provence France 7 800 2 Canada Provence France 3 1 45 US Bavaria Germany 3 400 2 58 UK Galicia Spain 5 650 2 Canada Tuscany Italy 7 800 2 42 UK Tuscany Italy 7 800 2 US Provence France 7 800 2 Germany Loire Valley France 5 650 2 Germany Umbria Italy 5 650 4 63 Canada France 5 650 2 Germany Galicia Spain 7 3 58 US Tuscany Italy 7 800 2 66 Australia Tuscany Italy 7 800 2 40 UK Brittany France 7 800 2 Germany Galicia Spain 7 800 2 UK Brittany France 3 400 2 60 Brazil Provence France 5 650 Kee 4 Canada Bavaria Germany 3 400 2 65 Lugano Italy 7 800 2 48 US Dordogne France 7 800 2 Japan Galicia Spain 7 800 2 52 UK Tuscany Italy 7 800 2 56 US Tuscany Italy 7 800 4 Canada Brittany France 5 650 2 63 Canada Galicia Spain 5 650 2 66 Canada Loire Valley France 7 800 2 Canada Loire Valley France 7 800 3 US Provence France 7 800 2 73 Germany Provence France 7 800 2 52 Canada Tuscany Italy 7 800 Amir 2 59 UK Tuscany Italy 3 400 2 63 Australia Tuscany Italy 3 400 In the appropriate area of the table below, enter your name and write a description (up to 200 words) about the skills you’ve practiced while completing the Team Project. List a selection of the skills you used to create the workbook, then comment on any challenges you experienced with specific skills and how you solved them. For example, if you experienced difficulties while working with PivotTables, describe the issues and what you did to fix them.
Team Member 1 Name Description Team Member 2 Name Description Team Member 3 Name Description 0
0
0
Salad 45 30 Salad 50 40 30 0
0
0
300 Main Course 300 200 Dessert Main Course 200 200 Main Course 550 500 400 Salad 600 Salad 500 400 350 Dessert 400 Appetizer 300 Salad 600 Dessert 500 400 200 Main Course 90 80 70 Salad 500 300 Main Course 500 350 Appetizer 600 420 Appetizer 90 Main Course 400 500 200 Salad 400 300 Main Course 350 200 90 Salad 120 100 30 Main Course 250 200 Appetizer 100 60 40 Appetizer 90 80 40 Main Course 150 120 60 .00
Construction Character Toddler 20 School Age $ 15.00 Academic School Age 40 $ 45.00 Character Preschool 45 Academic School Age 25 Construction Toddler $ 20.00 Academic School Age $ 15.00 Toddler Art School Age $ 25.00
2
1
Title
Year
Genre
20
17
2017 Unit Rentals
12
201
3
Drama
30
4
A Beautiful Mind
200
Amadeus
19
8
10
80
Annie Hall
1977
Comedy
5
Argo
2012
15
1
50
Around the World in 80 Days
195
6
Birdman
20
14
100
Braveheart
1995
Casablanca
1943
45
150
Chariots of Fire
1981
55
Chicago
2002
Musical
70
Forrest Gump
1994
26
Gone with the Wind
1939
65
Hamlet
1948
In the Heat of the Night
1967
Kramer vs. Kramer
1979
Lawrence of Arabia
1962
Million Dollar Baby
2004
Mrs. Miniver
19
40
Mutiny on the Bounty
1935
My Fair Lady
1964
No Country for Old Men
2007
Oliver!
1968
Ordinary People
1980
Out of Africa
1985
Patton
1970
Rebecca
Schindler’s List
1993
Shakespeare in Love
1998
89
Slumdog Millionaire
2008
28
78
Terms of Endearment
1983
The Bridge on the River Kwai
1957
60
The Deer Hunter
1978
The Departed
2006
The English Patient
1996
The Godfather
1972
The King’s Speech
2010
The Lord of the Rings: The Return of the King
2003
120
The Sound of Music
1965
25
400
The Sting
1973
Unforgiven
1992
West Side Story
1961
75
You Can’t Take it With You
1938
2
1
First Name
Last Name
Guests
Average Age
Home Country
Tour Region
Tour Country
Days
Per Person Cost
Total Cost
Jennifer
Bennett
4
Canada
Provence
France
5
65
Farzeneh
Sharif
60
US
Loire Valley
650
Vince
Burleigh
3
UK
Brittany
7
800
Kaiya
Quillin
45
Tuscany
Italy
Amir
Masood
58
Galicia
Spain
Gil
Moran
63
Lugano
Brian
Quinn
66
Australia
Daphne
Welsh
Matthew
Morado
52
40
Indira
Singh
55
Bavaria
Germany
Carlos
Vanderzee
Uta
Larocca
Brazil
Umbria
Leonora
Maag
61
Rod
Lee
42
400
Tatiana
Guthenberg
Abdul
Kamali
Ellen
Corcoran
48
Miguel
Renfrew
Alec
Ogilvie
43
Dunya
Hashim
70
Lance
Adams
71
Isobel
Tayce
Dordogne
Ingrid
Kruger
56
850
Grace
Kee
Rosie
Kim
Anna
Macpherson
Ella
Schultz
32
Jonas
Finamore
73
Alberto
Sanchez
Sally
64
Mikoto
Yanamoto
Japan
Tara
Sloane
Yoko
Hanamoto
57
Jim
Danze
Chuck
Laramie
Joanne
Prentiss
59
Erik
Laarson
Lori
Black
Jolene
Harrison
67
Ernest
Shad
69
Pat
Rhinehart
Jan
Lawrence
Omar
Sherrie
Glatz
Team Project
Project Summary
Sheet1
Product
Category
2015
2016
2017
Pineapple Slaw
Salad
40
45
30
Mango Custard
Dessert
3
50
300
200
Blueberry Salad
90
Toasted Almond Salad
Salmon with Lemon
Main Course
80
70
400
Lime Scallops
Appetizer
60
500
Roast Chicken
150
Kiwi Cream
650
550
350
Baked Yams with Feta
240
Tuna Sashimi
Papaya Salad
900
890
Asparagus Salad
Raspberry Tart
420
250
Sweet Onion Pie
340
120
Stilton Salad
530
450
Apricot Cobbler
Maple Salmon
Hazelnut Salad
700
Braised Lamb Shanks
480
Green Olive Tapenade
590
Smoked Salmon Wrap
220
280
Mahi Mahi
Artichoke Salad
100
Roast Beef
Crunchy Kale Salad
Pork with Blackberries
290
Leek Fritters
Quince in Aspic
Mushroom Casserole
Data
Product Name
Category
Age Group
Quantity
Price
Total
Builder Buddies
Construction
Preschool
20
$
25
Andy Anatomy Doll
Character
Toddler
30
$ 30.00
Mechanitron
School Age
45
$ 45.00
Happy Friends
$ 15.00
Science Plus Card Sets
Academic
40
Prehistoric Adventures
Jake the Builder
$ 20.00
Gem Collection
$ 40.00
Soft Blocks
60
Arithmetic Cards
72
My First Painting
Art
35
$ 25.00
Modeling Kit
12