Sales Analysis

Campleting this activity will help you leam to:

Extract information from sales data.

Extract information from a data set using Excel formulas, functions, and$/$or pluat tables.

Scenarios

Company A is a new business that sells university merchandise online.

The company sells hats for $$10$ each, $t-$shirts for $$15$ each, and sweatshirts for $$30$ each.

The company sells wholesale to six customers: Atlanta, Dabota, Madrid, Orlando, Phoenix, and Venice companes.

To help plan for next year, the company is analyzing saks from the year that just ended.

The Data worksheet contains a list of invoice numbers related to product sales.

Each row provides information about an invoice number for one of the three products, including involce date, product sold, customer name, quantity sold, and selling price per unt. Note that the same invoice number may be listed up to three times in column $0.$

This is because each of the products on an invaice is listed on its own separate row.

Required:

Open spreadsheet

Complete one column on the Data worksheet: Invaice Amount. Use this information to complete the requirements below.

R$1.$ Cell $12$: Use a formulo referning to other amounts in the row to cakculate total movice amount for row $2$ onhy.

$2$ moen Check My Work uses remsing