Essay about Assignment IL Excel2013 CS P1a
Christy Chen works at SpringLeaf Designs, a Seattle-based company that makes jewelry and accessories out of recycled materials. Christy has created a workbook to analyze costs and profits by product line. She has also compiled sales forecasts for the next five years. She has asked you to complete the data entry and analysis and to format the worksheets so they have a consistent and professional look.
GETTING STARTED
Download the following file from the SAM website:
IL_Excel2013_CS_P1a_FirstLastName_1.xlsx
Open the file you just downloaded and save it with the name:
IL_Excel2013_CS_P1a_FirstLastName_2.xlsx
Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. …show more content…
6. In cell F6, type a formula to calculate the average selling price per beaded earring unit. (Hint: The average selling price for the beaded earrings is calculated by dividing the total Sales values in cell C6, by the number of Units Sold value in cell D6.) Copy the formula from cell F6 to the ranges F7:F8, F10:F13, and F15:F18.
7. Apply the Currency Number format to the range F6:F18. (Tip: The Currency Number format should have 2 decimal places displayed by default. If it doesn’t, update the range to display 2 decimal places.)
8. Select the range D6:D18 and use the Quick Analysis tool to create a formula that calculates the total number of units sold. The formula will use the SUM function and should appear in cell D19.
9. Enter a formula in cell E6 to calculate the percentage of total sales accounted for by beaded earrings. The formula will divide beaded earring sales in C6 by total sales in C19. (Hint: Use an absolute reference to the total sales in cell C19, and a relative reference to beaded earring sales in cell C6). Copy the formula from cell E6 to the ranges E7:E8, E10:E13, and E15:E18.
10. Apply the Percentage Number format with no decimal places to the range E6:E18.
11. Based on range I6:I18, enter a formula in cell I21 that uses the MAX function to identify the highest average
-
Assignment NP Access2013 CS P1a
2664 Words | 11 PagesPROJECT DESCRIPTION Northwestern Swimming (NWS) manages athlete and coach data for swim teams with different locations in Washington. Athletes include developmental swimmers who are learning to swim and national-level athletes who have competed at the Olympic and world-championship levels. Julia Montoya is the General Chairperson of NWS and has just received approval from the Board of Directors to replace NWS’s manual system of managing data about athletes, coaches, and teams with…
-
Unfair Competition Of Chicago, Il
1254 Words | 6 PagesKeywords: unfair competition in Chicago, IL, related antitrust in Chicago, IL trade secret protection in Chicago, IL, intellectual property lawyer in Chicago, IL Filing Suit for Unfair Competition in Chicago, IL Unfair competition in Chicago, Illinois refers to economic harm caused to an individual or organization due to some sort of deceptive practice. Unfair competition in Chicago, Illinois may refer to acts that are used to confuse consumers, as well as a number of other actions that are inappropriate…
-
Cs 682 Assignment 1 Essay
1337 Words | 6 PagesCS682 Spring Session 1 2014 Revision: 1.1 Author: Amita Shrivastava Date: January 20, 2014 ------------------------------------------------- Contents 1. Introduction 2 2. Assignment Part 1 2 2.1 Management Information Systems - for WallGray’s pharmacy chain.(1) 2 2.1.1 Purpose 2 2.1.2 System Users 2 2.1.3 Inputs to the System 2 2.1.4 Outputs from the System 2 2.2 Decision Support Systems – for Home Depot (2) 2 2.2.1 Purpose 2 2.2.2 System Users 3 2.2…
-
CS-669 Assignment 1 Essay
991 Words | 4 PagesThe two parts in this assignment will contribute equally to your grade and will be evaluated separately. Part 1: Database Concepts Imagine that a countryside inn maintains its data in flat files on a file system. To assist in reserving rooms and booking guests, the innkeepers use a custom application that accesses these flat files. The innkeepers sometimes access the files directly. With this scenario in mind, address each of the topics below. Topic 1: The Advantages of Database Management…
-
Mcdonalds Edwardsville, Il Location
1370 Words | 6 PagesThe purpose of this summary is to show what was researched after completing and analyzing the results from the McDonalds Edwardsville, Il location. Most of the results showed satisfaction in our store. However, one of the five surveys taken showed a dissatisfaction in the location. This may seem alarming, being only that this individual showed dissatisfaction can mean they may not think highly of McDonald’s in the first place. Others relatively showed the same satisfaction towards the quality…
-
Sop for Ms in Cs with Networks
1275 Words | 6 Pagesmost. My ambition to pursue M.S. My hunger to discover more on the above-mentioned subjects is also a reason to go higher up the ladder in this stream. CS or IT is not just a subject but a tool whose application can be found in all aspects of life may it be Manufacturing, Agriculture or Service sectors. I would like to plan my career in CS/IT so that I could act as enabler for any industry vertical and explore the usage of the above tools in unexplored world. And my interest to learn new upcoming…
-
cs description
2828 Words | 12 Pagessatisfaction of staff * Repeat Business * Recommendations * Increased Profits * Safe and Secure Environment Poor Customer Service leads to: * Falling of sales * Customer Complaints * Low Staff morale * Reduced Profits For this assignment in Customer Service, the organisation I have chosen to study is Hollywood Bowl. When I first arrived at Hollywood Bowl, my first impressions were that it was situated in a clean, bright area. The main sign was in very bold and bright colours…
-
Utopia and Il Muqaddimah Essay
599 Words | 3 PagesUtopia and Il Muqaddimah both show the importance of families and social groups in the civilization they live in. Utopian families all have an equal role in the cities they live in; they are a microcosm of their city and its objective to survive; however, in Il Muqaddimah the subjects have the responsibility to help the ruler prosper. Utopians work and in return share what they earn, while subjects work for their survival. Utopians all have an equal work load and subjects hardships depend on their…
-
Cs 315 Lab2
1281 Words | 6 PagesCS 315 Lab 02 A. Try to find the proper Linux commands that will answer the following questions. Hint: You can either find the answer from the textbook or from the Internet. *You need to write the procedure that is necessary to accomplish the tasks listed below. Test to see if your answers are correct and type your correct answer under each question. Upload your finished lab document to the dropbox. 1. Use the ls command to list the contents of the root file system directory (/) on…
-
Assignment 1 Cs 782
964 Words | 4 PagesAssignment 1 CS 782 Fall 2013 Author: Almas Zakat Date September 23, 2013 ------------------------------------------------- Contents 1. Introduction_____________________________________________ 3 2. Business Model_________________________________________ 3 3. Operational Model_______________________________________ 5 4. Business Model_________________________________________ 6 5. Conclusion ____________________________________________ 6 -------------------------------------------------…
More about Essay about Assignment IL Excel2013 CS P1a
-
Assignment NP Access2013 CS P1a
2664 Words | 11 Pages -
Unfair Competition Of Chicago, Il
1254 Words | 6 Pages -
Cs 682 Assignment 1 Essay
1337 Words | 6 Pages -
CS-669 Assignment 1 Essay
991 Words | 4 Pages -
Mcdonalds Edwardsville, Il Location
1370 Words | 6 Pages -
Sop for Ms in Cs with Networks
1275 Words | 6 Pages -
cs description
2828 Words | 12 Pages -
Utopia and Il Muqaddimah Essay
599 Words | 3 Pages -
Cs 315 Lab2
1281 Words | 6 Pages -
Assignment 1 Cs 782
964 Words | 4 Pages