2 truck location 3 farragut square gw georgetown k street 4 old bay 2800 1000 700 1200 5 truffle 3300 700 1500 2000 6 sea salt B u s i n e s s F i n a n c e

2 truck location 3 farragut square gw georgetown k street 4 old bay 2800 1000 700 1200 5 truffle 3300 700 1500 2000 6 sea salt B u s i n e s s F i n a n c e

In this project, you will work with sales data from Top’t Corn, a popcorn company with
an online store, multiple food trucks, and two retail stores. You will begin by copying
the sales data for one of the retail stores from another workbook. Next, you will insert a
new worksheet and enter sales data for the four food truck locations, formatting the data,
and calculating totals. You will create a pie chart to represent the total units sold by
location and a column chart to represent sales by popcorn type. You will format the
charts, and then set up the worksheet for printing. Next, you help Top’t Corn calculate
payments for a loan and decide whether or not the purchase is a good idea. Working with
the daily sales data for one of the brick-and-mortar stores, you will apply conditional
formatting to find the top 10 sales dates. You will also calculate the sales for each
date, and the average, minimum, and maximum sales. Finally, you will work with their
online sales data to format it as an Excel table and apply sorting and filtering.

Skills needed to complete this

  • Close a workbook
  • Insert a worksheet
  • Name a worksheet
  • Move a worksheet
  • Enter text
  • Enter numbers
  • Edit text
  • Autofit a column
  • Apply a cell style
  • Add cell shading
  • Change font color
  • Merge and center text across cells
  • Apply bold formatting
  • Apply number formatting
  • Enter a SUM function
  • Copy formula using AutoFill
  • Insert a pie chart
  • Apply a chart Quick Layout
  • Move a chart
  • Insert a column chart
  • Switch the row/column in a column chart
  • Change the chart title
  • Apply a chart Quick Style
  • Show chart data labels
  • Preview how a worksheet will look when printed
  • Change worksheet orientation
  • Change the print margins
  • Scale a worksheet for printing
  • Change the color of a worksheet tab
  • Apply a column width
  • Enter a simple formula using multiplication
  • Enter a simple formula using subtraction
  • Add cell borders
  • Create a formula referencing cells in another worksheet
  • Enter an AVERAGE function
  • Use the IF function
  • Apply date formats
  • Use an absolute reference in a formula
  • Name a range of cells
  • Use a named range in a formula
  • Use the MIN function in a formula
  • Use the MAX function in a formula
  • Apply a table Quick Style
  • Use the table Total row
  • Sort data in a table
  • Filter data in a table
  1. A B C D E
    1 Top’t Corn Mobile Sales (August)
    2 Truck Location
    3 Farragut Square GW Georgetown K Street
    4 Old Bay 2800 1000 700 1200
    5 Truffle 3300 700 1500 2000
    6 Sea Salt and Caramel 4500 1900 1800 1400
    1. Format the data as follows:
    2. Calculate total sales for each of the truck locations.
    3. Modify the pie chart as follows:
    4. Modify the column chart as follows:
    5. Preview how the worksheet will look when printed, and then apply print settings to
      print the worksheet on a single page. Hint: If you have one of the charts selected,
      deselect it before previewing the worksheet. Preview the worksheet again when you are
      finished to check your work.

    6. Top’t Corn is considering a new truck purchase. Calculate the total cost
      of the loan.

    7. Complete the following steps in the TysonsStore2019

    8. Filter the table to show only rows where the value in the
      State column is

Posted in Uncategorized