Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.
A. For current sales, display sales by category and total.
B. For projected sales, display sales by category and total.
C. Apply formatting conventions appropriate for a business audience.
1. Select a consistent font and font size.
2. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
3. Apply labels that identify the values contained in each row and column.
D. Apply formulas to calculate totals for current sales as well as projected sales.
E. Embed a bar chart that accurately displays the total sales for the current year.
F. Embed a bar chart that accurately displays the projected sales for the next five years.
G. Embed a line graph that accurately displays the projected sales growth over the next five years.
Then, reflect on your experience;
1. What type of chart is appropriate to visually represent the numerical data?
2. Describe how you will adapt the formatting, labeling, formulas, and organization of your Excel document to fit the purpose of the document and its audience.
3. What type of number format would be appropriate for representing the information required? For example, how many decimal spaces will you include? Will you use a number format or a currency format