see attachment Module 7: Assignment:   Data Sheet – Weekly Online Sales1. Download the DataSheet

see attachment 

Module 7: Assignment:
 
Data Sheet – Weekly Online Sales

1. Download the DataSheet (Word document).

2. Copy the information and insert it into an Excel document.

3. Use the correct formulas and functions to carry out the following operations:

·

· Calculate the subtotal of each individual sale (Total column)

· Calculate the grand total of all sales (Grand Total)

· Create a chart showing the total sales (Profit) distributed by item category

· Create a chart showing the distribution of items sold

4. After doing the calculations, answer the following questions:

·

· How much is the grand total of sales?

· Which item was sold the most?

· Which item generated the most profit?

IMPORTANT: Use Excel to perform the assignment.

(See document 

A7-2.DataSheet


 Download A7-2.DataSheet
  and 

Instructor Workbook

Download Instructor Workbook

 

Be sure to review the 

academic expectations
 for your submission.

Submission Instructions:

· Submit your assignment by 11:59 p.m. ET on Saturday.

 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

powerpoint presentationCAMPUS EXPLORATIONPresented by Leanngeli LatorreCourse: UNIV104_B68_202530ACADEMIC SUCCESS CENTER (ASC) • The

powerpoint presentation CAMPUS EXPLORATION Presented by Leanngeli Latorre Course: UNIV104_B68_202530 ACADEMIC SUCCESS CENTER (ASC) • The Academic Success Center provides tutoring, writing services and academic workshops to support student success. • Located at Demoss Hall, Room 1100. • Email: [email protected] • Phone: (434) 592-6387 *url can be found on page

Help with developing Descriptive, Associative, and Causal Research Questions.Resources: ·

Help with developing Descriptive, Associative, and Causal Research Questions. Resources: · Correlation and Causation: Tyler Vigen’s Spurious Correlations SAGE Publications. (Publisher). (2017).  Correlation and causation: Tyler Vigen’s spurious correlations [Video file]. SAGE Publications, Ltd. This video explains how correlation does not always mean causation or a meaningful relationship. · Distinguishing Correlational

see attachment  InterviewInstructions 1. 1. Review the discussion

see attachment  Interview Instructions 1. 1. Review the discussion material for this module and additional references. Review the previous modules and the topics discussed in the course so far. 2. This activity consists of interviewing a person who works in an area related to the topics or study of human

1 3[Instructional text in this template is contained

1 3 [Instructional text in this template is contained in square brackets ([…]). After reading the instructional text, please delete it, and use the document as a template for your own paper. To keep the correct format, cover page, and reference list with your own information, and add your own