Excel Case 2 - Custom Cap Sales

Excel Case 2 - Custom Cap Sales - EXCEL CASE 2: CUSTOM CAP...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
EXCEL CASE 2: CUSTOM CAP SALES CUSTOM CAP SALES: SALES DATA ANALYSIS SKILLS Apply cell styles Apply date and comma number formats Change the font color Create formulas using the SUM function Create charts using column chart types Format charts Merge cells and center their contents Modify column width Position a chart Resize a chart CASE SCENARIO Custom Caps in Paramus, New Jersey, sells baseball-style caps to stores who customize the caps with silk-screened or appliquéd designs. As an assistant in the accounting department, you have been asked to analyze sales data for the past five years and determine which types of caps are the most popular. Your manager provides the sales data in an Excel worksheet. Because you will eventually present this information to the sales representatives, your manager asks you to include a chart that summarizes the sales data and compare sales by type. To do so, you will use Excel’s 3-D chart feature. STUDENT DATA FILE
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/07/2008 for the course CNA 169 taught by Professor Ghosh during the Spring '08 term at St. Cloud.

Page1 / 3

Excel Case 2 - Custom Cap Sales - EXCEL CASE 2: CUSTOM CAP...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online