Need corrections for this powerpoint project thats it!!!!

ALL I NEED IS FOR SOMEONE TO GO BACK IN MY PROJECT AND MAKE THE CORRECTIONS NEEDED IN ORDER TO RESUBMIT THIS FOR GRADES THIS IS DUE TODAY!!!

Top’t Corn

Gourmet popcorn with capitol toppings

3/9/20

1

8

The Top’t Corn Company

1

1

Overview
Founded in 1996 in Washington DC
Family owned and operated
Serving the greater Washington DC area

Goals
Unique and delicious flavor profiles
Affordable prices for families
Easy access locations for quick purchasing

Our Top’t 3 Sellers
Original Blend
Old Bay
Truffle

Future Flavors
Coco Mocha
Pumpkin Spice
Key Lime
Spicy Buffalo

Brick and Mortar Stores
Tyson’s Corner
National Harbor
Nationals Park
Old Town Alexandria

Food Truck Locations
K Street
Farragut Square
Georgetown
George Washington

Maryland Sales of Old Bay Flavor
Date Quantity Column1 Price $9.00
11/6/2016 15 135
11/9/2016 15 135 Average Quantity 10.625
11/9/2016 12 108 Total Sales $765.00
11/10/2016 12 108
11/9/2016 11 99
11/6/2016 9 81
11/10/2016 9 81
11/9/2016 2 18

Truffle Sales by State

Total AL CA DC MD MO NY OH SC VA 5 22 16 2 36 70 33 10 67

Pricing
Price per box $9
Commemorative packaging $2
DIY Toppings $3

SIMnet 2016: PowerPoint, Word, Excel Integrated Project 3

1 | P a g e Last Modified: 2/26/18

Office 2016 Integrated Applications – Project 3

Creating a Company’s Presentation
In this project, you will create a presentation for the Top’t Corn popcorn company using resources from a

Word document and an Excel file. First, you will format an outline in Word so it can be imported as slides

and content for the presentation. You will format the look of the text before and after importing and use

Format Painter to copy and paste formatting between slides. Next, work with data in Excel, adding formulas

and creating a table and a chart. Finally, you will copy and paste the chart and table data from Excel into

your PowerPoint presentation.

Skills needed to complete this project:

Word Skills

• Apply heading styles

• Change the color theme

PowerPoint Skills

• Import slides from a Word outline

• Change the font

• Align text

• Use Format Painter

• Change slide layout

• Add a table to a slide

• Paste data from Excel

• Change font color

• Paste a chart from Excel

• Move an object on a slide

Excel Skills

• Enter text and numbers in cells

• Create a formula using multiplication

• Use an absolute reference in a formula

• Copy a formula

• Format data as a table

• Sort data in a table

• Use the AVERAGE function in a formula

• Use the SUM function in a formula

• Apply a number format

• Modify the font size

• Autofit columns

• Create a PivotTable using a Recommended

PivotTable

• Create a pie chart

• Hide the chart title

• Apply a chart style

IMPORTANT: Download the resource file needed for this project from the Resources link. Be sure

to extract the file after downloading the resources zipped folder. Please visit SIMnet Instant Help for

step-by-step instructions.

1. Open the start file OF2016-Integrated-Project3. If the document opens in Protected View, click the

Enable Editing button in the Message Bar at the top of the document so you can modify it.

2. The file will be renamed automatically to include your name. Change the project file name if directed to

do so by your instructor, and save it.

3. Open the Top’t Corn Outline Word document from the location where you saved the data files

for this project (downloaded from the Resources link).

a. Apply the Heading 1 style to numbered items in the list.

b. Apply the Heading 2 style to the lettered items in the list.

Step 1
Download
start file

Download
Resources

SIMnet 2016: PowerPoint, Word, Excel Integrated Project 3

2 | P a g e Last Modified: 2/26/18

c. Change the color theme of the document to Red Orange

d. Save the document with the name Top’t Corn Outline for Import. Close the document.

e. Return to the PowerPoint presentation you downloaded from SIMnet.

4. Import the Top’t Corn Outline for Import Word file into OF2016-Integrated-Project3 presentation.

a. Use Slides from Outline… option to import the Top’t Corn Outline for Import file.

Note: When you are finished with this step, your presentation should contain 10 slides. If it does

not, your project will not grade properly and you may lose a significant number of points. Check

your work carefully.

b. Verify that the Heading 1 style items from the Word file appear as the titles, Heading 2 style items

appear in the body.

c. Verify that the title font on the imported slides appears to be an Red Orange color.

d. Select the title placeholder on Slide 2 (the placeholder with the word Overview). Change the font to

Calibri and left align the text.

e. With the title placeholder still selected, use Format Painter to copy the formatting and paste the

formatting each of the title placeholders on Slides 3 through 10.

5. Open the OldBayMDSales Excel file (downloaded from the Resources link) and create a table to copy

into PowerPoint.

a. Go to the OldBaySales worksheet. In cell C1, type: Total Sale

b. In cell E1, type: Price

c. In cell F1, type: $9.00

d. In cell C2, enter a formula to calculate the total sale. Multiple the quantity sold (cell B2) by the price

per box (cell F1). You are going to copy this formula to cells C3:C9, so use relative and absolute

references as appropriate.

e. Copy the formula in cell C2 to cells C3:C9.

f. Format the data in cells A1:C9 as a table using any style.

g. Sort the table data by values in the quantity column so the largest number is at the top.

h. In cell E3, type: Average Quantity

i. Enter a formula in cell F3 to calculate the average of cells B2:B9.

j . In cell E4, type: Total Sales

k. Enter a formula in cell F4 to calculate the sum of cells C2:C9.

l. Apply the Currency number format to cell F4.

m. Select cells A1:F9 and change the font size to 18.

n. Autofit all columns so the data are completely visible.

o. Copy cells A1:F9.

p. Save the Excel file, but leave it open.

Download
Resources

SIMnet 2016: PowerPoint, Word, Excel Integrated Project 3

3 | P a g e Last Modified: 2/26/18

6. Return to the PowerPoint presentation and navigate to Slide 8.

a. Change the layout for Slide 8 to Title and Content.

b. Add a table to the slide with six columns and nine rows.

c. Paste the data you copied from Excel into the table, and select Use Destination Style paste option.

d. Where necessary, change the text in the header row to bold, White, Background 1 (the first color

in the first row of theme colors).

e. Save the PowerPoint presentation, but do not exit PowerPoint yet.

7. Return to the OldBayMDSales Excel file and create a chart from the data in the TruffleSales worksheet.

a. Create a PivotTable from the data in the TruffleSales worksheet. Use the first (only) recommended

PivotTable – Sum of Quantity by State.

b. Create a 2-D pie PivotChart from the PivotTable data.

c. Hide the chart title.

d. Apply the chart Quick Style, Style 11.

e. Copy the chart.

f. Save and close the Excel file.

8. Return to the PowerPoint presentation and navigate to Slide 9.

a. Change the layout for Slide 9 to Title Only.

b. Paste the chart you copied from Excel into the slide. Use the Keep Source Formatting & Embed

Workbook paste option.

c. Drag the chart down so it is positioned in the middle of the slide.

9. Save and close the presentation.

10. Upload and save your project file.

11. Submit project for grading. Step 2
Upload &
Save

Step 3
Grade my
Project

OF2016-Integrated-Project3-resources/OldBayMDSales.xlsx
OldBaySales

Date Quantity

11/6/16 15

11/6/16 9

11/9/16 11

11/9/16 15

11/9/16 2

11/9/16 12

11/10/16 9

11/10/16 12

TruffleSales

Quantity State ItemName

5 AL Truffle

6 CA Truffle

10 CA Truffle

6 CA Truffle

11 DC Truffle

5 DC Truffle

2 MD Truffle

18 MO Truffle

18 MO Truffle

14 NY Truffle

8 NY Truffle

9 NY Truffle

9 NY Truffle

14 NY Truffle

10 NY Truffle

6 NY Truffle

9 OH Truffle

10 OH Truffle

14 OH Truffle

10 SC Truffle

15 VA Truffle

7 VA Truffle

11 VA Truffle

8 VA Truffle

14 VA Truffle

12 VA Truffle

OF2016-Integrated-Project3-resources/Top’t Corn Outline x
1. Overview
a. Founded in 1996 in Washington DC
b. Family owned and operated
c. Serving the greater Washington DC area
2. Goals
a. Unique and delicious flavor profiles
b. Affordable prices for families
c. Easy access locations for quick purchasing
3. Our Top’t 3 Sellers
a. Original Blend
b. Old Bay
c. Truffle
4. Future Flavors
a. Coco Mocha
b. Pumpkin Spice
c. Key Lime
d. Spicy Buffalo
5. Brick and Mortar Stores
a. Tyson’s Corner
b. National Harbor
c. Nationals Park
d. Old Town Alexandria
6. Food Truck Locations
a. K Street
b. Farragut Square
c. Georgetown
d. George Washington
7. Maryland Sales of Old Bay Flavor
8. Truffle Sales by State
9. Pricing
a. Price per box $9
b. Commemorative packaging $2
c. DIY Toppings $3

MODULE RESULTS
QUESTIONS: 21

expand all collapse all

CORRECT ANSWER:

International Monetary Fund (IMF)

see more

CORRECT ANSWER:

The intere

st

rate charged to commercial banks and other depository institutions for loans received from the Fed

see more
CORRECT ANSWER:

Checking account

see more
CORRECT ANSWER:

Currency

see more
CORRECT ANSWER:

Banker’s acceptance

see more
CORRECT ANSWER:

Check

see more

attempts i

Which of the following is responsible for promoting stable exchange rates, providing short-term loans, and encouraging the development

of a system for international payments?

Which of the following best describes discount rate?

Which noninterest bearing form of M-1 money supply is held at the bank until withdrawn by the owner, or a designated payee?

_____ consists of government-issued paper money and coins.

When a U.S. firm wants to buy products from an international supplier, payment must be negotiated. Which type of payment option

guarantees the bank will pay a predetermined amount at a future date?

Which liquid form of money instructs a bank to pay someone a specific sum of money on demand?

Under which law are banks required to implement a customer identification program (CIP) to verify customers’ identities, maintain

records of their activities, and compare the identities of new customers with government terrorist lists?

Ch16a
smart refresh 3 min refresh 24 min course report

CORRECT ANSWER:

USA Patriot Act

see more
CORRECT ANSWER:

Federal Deposit Insurance Corporation (FDIC)

see more
CORRECT ANSWER:

Certificate of deposit

see more
CORRECT ANSWER:

Electronic funds transfers

see more
CORRECT ANSWER:

Federal funds rate

see more
CORRECT ANSWER:

Commercial banks

see more
CORRECT ANSWER:

open-market operations

see more
CORRECT ANSWER:

A nondeposit pool of funds managed to provide retirement income for its members

Which of the following supervises banks and insures deposits?

Which of the following is the best example of a time deposit?

Which payment systems move funds among businesses and individuals without the use of a check or cash and can be used online, in

stores, and internationally?

Which rate is based on supply and demand for funds and is the rate commercial banks charge when they lend overnight?

Which for-profit financial institutions can make loans, accept deposits, earn profits, pay interests to members, and allow members to

have access to checking and savings accounts?

The purchase and/or sale of treasury securities by the Federal Reserve in order to expand or contract the U.S. money supply is known as

_______.

Which of the following best describes a pension fund?

see more
CORRECT ANSWER:
USA Patriot Act
see more
CORRECT ANSWER:

M-1

see more
CORRECT ANSWER:

exchange rate

see more
CORRECT ANSWER:

A nondeposit institution that specializes in making loans to businesses and consumers

see more
CORRECT ANSWER:

automated teller machines

see more
CORRECT ANSWER:

Debit cards immediately transfer funds.

see more
CORRECT ANSWER:

Check Clearing for the 21 Century Act

see more

Which Act is designed to reduce terrorism risks and requires banks to better understand a customer’s identity by obtaining and verifying

their name, address, date of birth, and Social Security Number?

Which measure of the U.S. money supply includes cash (coins and currency), checks, and checking accounts (demand deposits)?

The value of one currency compared to another is its _____.

Which of the following best describes a finance company?

Consumers around the world can now withdraw cash, transfers funds, and manage bank accounts through the use of ______.

How do debit cards differ from credit cards?

Which of the following is the federal law that allows a receiving bank to make an electronic image of a paper check and electronically

send the image to the paying bank for instant payment instead of waiting days for the paper check to wind its way back to the sender?

st

MODULE RESULTS
QUESTIONS: 24

expand all collapse all
CORRECT ANSWER:

World Bank

see more
CORRECT ANSWER:

The Federal Reserve

see more
CORRECT ANSWER:

By managing interest rates

see more
CORRECT ANSWER:

Nondeposit institutions

see more
CORRECT ANSWER:

Track and report suspicious transactions, such as a sudden increase in wire transfers or cash transactions exceeding $10,000

see more
CORRECT ANSWER:

The percentage of its deposits that a bank must keep on hand in cash in its vault or on deposit with Federal Reserve Banks

see more
attempts i

Which organization does NOT act as a traditional bank but instead provides limited services that help build infrastructure in countries

that borrow and help increase production capacity and international trade?

There are many types of banking institutions in the United States. Which is the nation’s central bank, with power to form monetary policy

for the nation?

How does a nation’s monetary policy affect the economic growth of the country?

Organizations such as pension funds and securities investment dealers take in money and use the funds for purposes other than earning

interest for depositors. What type of banks are these?

The Bank Secrecy Act (BSA) requires banks to do which of the following?

Which of the following best describes the Federal Reserve function known as the reserve requirement?

Ch16b
refresh 20 min course report

CORRECT ANSWER:

Trust services

see more
CORRECT ANSWER:

Savings and loan associations

see more
CORRECT ANSWER:

Money market mutual fund

see more
CORRECT ANSWER:

Prime

see more
CORRECT ANSWER:

Letter of credit

see more
CORRECT ANSWER:

Money

see more
CORRECT ANSWER:

Point-of-sale terminal

see more

Sometimes a person needs help ensuring regular, monthly bills are paid, or the estate of a deceased person needs to be managed. What

type of banking service would help with the management of funds for those who cannot, or choose not to, do so on their own?

Which institutions were created to encourage savings habits and provide financing for homes, but did not offer other services such as

checking?

Which of the following is a fund of short-term, low-risk financial securities purchased with the pooled assets of investor-owners?

What is the interest rate that banks offer to their most creditworthy customers?

In order to facilitate international trade and business, buyers and sellers must be able to negotiate costs based on fluctuating exchange

rates. Which of the following is used as a promise by a bank to pay a certain amount of money when specified conditions are met?

Which of the following is defined as a medium of exchange based on its value or worth?

What type of equipment must be utilized to transfer payment when using credit or debit cards to shop at a brick-and-mortar store?

Workers who wish to supplement their income after they no longer work full-time can set up which type of account as a way to save pre-

tax income?

CORRECT ANSWER:

Individual retirement account

see more
CORRECT ANSWER:

Time deposits

see more
CORRECT ANSWER:

M-2

see more
CORRECT ANSWER:

Insurance companies

see more
CORRECT ANSWER:

Smart cards

see more
CORRECT ANSWER:

Mutual savings bank

see more
CORRECT ANSWER:

Credit union

see more

Which type of M-2 money has a fixed term and cannot be transferred by check?

Which measure of the money supply is used by businesses and government agencies to aid in economic planning because it indicates

how much money will be available for consumer purchases and investments?

Which nondeposit institution takes in money based on premiums charged for protections against losses, such as death, injury, or

healthcare expenses?

These banking and payment devices have an embedded computer chip that can be programmed with “electronic” money.

Which of the following is a financial institution whose depositors are owners sharing in its profits?

Which of the following is a nonprofit, cooperative financial institution owned and operated by its members, usually employees of a

particular organization?

The ________ is the percentage of deposits that a bank must keep on hand in cash in its vault or on deposit with Federal Reserve

Banks.

CORRECT ANSWER:

reserve requirement

see more
CORRECT ANSWER:

A fund of short-term, low-risk financial securities purchased with the pooled assets of investor-owners

see more
CORRECT ANSWER:

A nonprofit, cooperative financial institution owned and operated by its members, usually employees of a particular organization

see more
CORRECT ANSWER:

A financial institution whose depositors are owners sharing in its profits

see more

Which of the following best describes a money market mutual fund?

Which of the following best describes a credit union?

Which of the following best describes a mutual savings bank?

• Chapter 16a-BizLab
• Chapter 16b-BizLab

OF2016-Integrated-Project3-resources/OldBayMDSales.xlsx
OldBaySales

Date Quantity

11/6/16 15

11/6/16 9

11/9/16 11

11/9/16 15

11/9/16 2

11/9/16 12

11/10/16 9

11/10/16 12

TruffleSales

Quantity State ItemName

5 AL Truffle

6 CA Truffle

10 CA Truffle

6 CA Truffle

11 DC Truffle

5 DC Truffle

2 MD Truffle

18 MO Truffle

18 MO Truffle

14 NY Truffle

8 NY Truffle

9 NY Truffle

9 NY Truffle

14 NY Truffle

10 NY Truffle

6 NY Truffle

9 OH Truffle

10 OH Truffle

14 OH Truffle

10 SC Truffle

15 VA Truffle

7 VA Truffle

11 VA Truffle

8 VA Truffle

14 VA Truffle

12 VA Truffle

OF2016-Integrated-Project3-resources/Top’t Corn Outline x
1. Overview
a. Founded in 1996 in Washington DC
b. Family owned and operated
c. Serving the greater Washington DC area
2. Goals
a. Unique and delicious flavor profiles
b. Affordable prices for families
c. Easy access locations for quick purchasing
3. Our Top’t 3 Sellers
a. Original Blend
b. Old Bay
c. Truffle
4. Future Flavors
a. Coco Mocha
b. Pumpkin Spice
c. Key Lime
d. Spicy Buffalo
5. Brick and Mortar Stores
a. Tyson’s Corner
b. National Harbor
c. Nationals Park
d. Old Town Alexandria
6. Food Truck Locations
a. K Street
b. Farragut Square
c. Georgetown
d. George Washington
7. Maryland Sales of Old Bay Flavor
8. Truffle Sales by State
9. Pricing
a. Price per box $9
b. Commemorative packaging $2
c. DIY Toppings $3