This exam will require you to develop $3$ tabs found on a separate

spreadsheet. Meaning, you will need to copy and paste the

information into a new spreadsheet. Follow the directions

closely as seen below.

Tab $"1"$ will be named "Sales Data" and the data will be

taken from the tab at the bottom of the spreadsheet attached

in Module $8,$ and it has the same name. It requires you to:

a$.$ Organize the data in one analysis showing the sales

totals for each "Type" of product.

b$.$ In a separate analysis, you are asked to show total

sales by Region and by type.

c$.$ Finally, you are asked to create a summary of sales by

year.

d$.$ These are three $(3)$ separate analysis to be completed

on the same sheet.

Tab $"2"$ will be named "List Functions" and the data will

be taken from the tab at the bottom of the spreadsheet

attached in Module $8,$ and it has the same name. This

requires you to:

a$.$ Organize the data into each category type, along with

the sum of all categories.

b$.$ Next you are to conduct an analysis of all the

"Divisions" with a sum of their totals.

c$.$ This is two $(2)$ separate analysis to be completed on

the same sheet.