All details are below please make the 4 parts separate.
All details are below please make the 4 parts separate. please ask if you have any questionsPART 1
Take an inventory of 30 of your personal items in your dorm room, apartment, or home that fall into the following categories:
1.Clothing: Shirts, Pants, Shoes, Jackets …
2.Electronics: Computer, Microwave, cell phone, …
3.Household Goods: Furniture, Glassware, Bowls, Lamps …
4.Personal Items: Shampoo, Soap, Toilet Paper, Towels, Razors…
Make tables in Excel
Table 1
Column Headings: Item#, Item Name, Country (where manufactured), Category (see list above), Unit Value, Quantity, Own More Than 1, Total value of items in category, % of Total Value of All Items, Where Purchased: online or locally or both at various times
For example
#
Item
Country
Category
Unit Value
…
1
MU t-shirt
…
While you must assign a $ value to every item, you can guestimate
List at least 30 items–make sure to include some from each category.
Use formulas to create the following column contents: Item#, total $ value, % of Total Value of All Items
Formatting
Bold and italicize the words in the headings. Also, draw a thick border around each heading and make the heading cells red (don’t follow my example above—it is not correct)
Center the quantity column.
Format the values as currency.
Sort by Category and then Item
Calculate the total value as quantity times unit value
Total the quantity and total value columns
Below the total, calculate the average quantity, unit value and total value
Below the average, calculate the minimum quantity, unit value and total value
Below the minimum, calculate the total number of lines in your inventory list using the COUNTA function.
Under “Own More than 1”, use an if statement to show “yes” if the quantity is more than one and “no” otherwise. (At least one item should have a quantity of 1 and at least one with more than 1.)
Use series fill to assign the item numbers.
Calculate the % of the total value of all items by dividing the total value for the row by the total value for all items. Use one formula for all the rows by properly setting the $ in the formula.
Autofit the rows so that the height accommodates the contents.
Add colors
Add grid lines.
Set the Margin to 7 inches from the bottom, so that only about 17 lines will print on a page, and you will get two pages. The column headings should also print on page 2
Freeze the column headings so they stay put when you scroll.
Save in Landscape mode.
Table 2
Same formatting as Table 1
Provide an appropriate heading for the table
For each of the CATEGORIES, use the following columns: Country, GDP/ Capita, and % of US GDP.
For example
Category: CLOTHING
Item
Country
GDP/Capita
% of US GDP
MU t-shirt
…
…
Category: SHOES
…
Find the GDP for each country for 2020 or later
Use a formula to figure out the % of US GDP of the country’s GDP
Table 3
First column is for Country, the next columns are for each of the main Categories, and the final column is the Total of items made in the country
Use a formula to figure out the Total.
PART 2
MAKE GRAPHS OF TABLE 3
Create line graph showing Totals for each country. Provide legend.
Create bar graph showing the same.
Create a pie chart. In each slice, label the total.
Create a chart of your choice to compare what you got online versus at the local store.
Save your excel spreadsheets and graphs as both excel and pdf files
PART 3
MAKE A POWERPOINT
Choose a theme.
Title Page
Insert slides, using at least 3 different text layouts.
Include photos and maps
Add text (Use BULLET points, max of 4 per slide)
Format your text
Change the color of your text
Provide an outline color
Apply text effects, such as a shadow, reflection, glow, bevel, 3-D rotation, and
transform
Add a shape to at least one slide.
Add animation
At LEAST 8 slides, please
Save as pptx AND as pdf files
PART 4
CONCLUSION
1.In a Word document, write an approximately 500-word conclusion based on what you, the Human, has learned from this assignment, including discussion of clothes, countries, economy, inequality, your shopping habits and global implications, and so on and so forth.
Go to AI and have it write a conclusion too. It will need to create its own scenario so you will have to figure out appropriate prompts
3.Then evaluate. What did H
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
