Excel Word Problems 1-2.docx - Excel Word Problems General Requirements of ALL problems this semester 1 All numbers in worksheets must be properly

# Excel Word Problems 1-2.docx - Excel Word Problems General...

• 2

This preview shows page 1 - 2 out of 2 pages.

Excel Word Problems General Requirements of ALL problems this semester: 1. All numbers in worksheets must be properly formatted. 2. No numbers in your formulas. All variables must be on the worksheet, labeled, and cell addresses used in the formulas. 3. Make sure all charts are properly titled. Must tell us Who, What, Exactly when, and the unit of measure of the data. 4. Make sure you proofread your content. Field headings in problems should be in Title Case. Problem 1 1. Create a table for Jansen Corporation. We are tracking the sales of 4 items each day for the week (Monday – Friday). 2. Insert the sales for each item for each day. 3. Find the total sales for each item for the week. 4. Find the total sales each day for Jansen Corporation. Find the total sales for the week. 5. Find the average daily sales for each item for the week. 6. Create a line chart that illustrates the daily sales for each item for the week. Make sure the chart is properly titled.