Studybay uses cookies to ensure that we give you the best experience on our website. By continuing to use Studybay you accept our use of cookies view more on our Cookie Policy
How can I earn money with StudyBay Top writers
Order Assignment
This order has already been completed on Studybay
On Studybay you can order your academic assignment from one of our 45000 professional writers. Hire your writer directly, without overpaying for agencies and affiliates! Check price for your assignment
15 bids submitted. Essay Example.

Excelling with Excel

o successfully complete this assignment, submit the Microsoft Excel template that includes the required information and formatting. Steps: Review this Assignment 2 Sample to see a completed version of this assignment for reference. Note: You may not copy any information from this sample into your own assignment. Select the "Read-Only" option when the password window appears as you open this sample. Download the Assignment 2 Directions and Template workbook here. Follow the directions that are listed in the template. Save your document with the following name: CIS105_Assignment2_FirstName_Last Name_Date.xlsx Submit your assignment through the submission button. Use the template to record and calculate the costs of the school materials you purchased for this quarter. First, in the Title Page worksheet, enter the following information: Type your name in cell B1. Type in the course section you are in cell B2. (For example: CIS105111) Type your professor’s name in cell B3.Type the title of the assignment in cell B4. Type the title ("Excelling with Excel") of the assignment in cell B4. Rename the worksheet to "Overview." Change the font type for this information to Century Gothic. Change the font size for this information to 14 point. Search for the school supplies you purchased at Amazon, Office Depot, Staples, or some other store. Find ten supplies that you purchased. You can include textbooks, lab code fees, and paper supplies such as notepads, planners, pens, pencils, highlighters, etc. Go to Sheet 3. This will be where you add your list of school supplies. Type a title in cell A1. (For example: “School Supply Costs” or “My School Purchases.”) Format cell A1, so the font type is Calibri Light (Headings), the font size is 20-point, and the font color is one of your choosing. Enter the following labels in the cells specified: Cell A2: School Supplies Cell B2: Quantity CellC2: Price Cell D2: Total Cost Make the font size 16 point and bold these labels. Column A: School Supplies In cells A3 through A12, enter the names of the ten (10) school supplies that you purchased. (If you didn't buy 10 supplies, list what you would have purchased or will purchase next term.) Auto fit the contents of column A so you can see the name of each supply item name. Format cells A3 through A12 so the text is 16-point Calibri Light (Headings) and the font color is orange. Column B: Quantity In column B enter the Quantity for each of the supplies. For example, will you need four (4) notebooks? Set the width of column B to 11.5”. Format cells B3 through B12 so the text is 16-point Calibri Light (Headings) and the font color is brown. Column C: Price Enter the price for each school supply item. For example, a single notebook costs $5. Expand column C so you can see all of your costs. Format cells C3 through C12 so the font is Arial, the font size is 14-point, and the font color is dark blue. Column D: Total costs Use the multiplication function to determine the total cost for each item. Hint: In D3, the formula would be =(B3*C3). Fill in cells D4 through D12 to calculate the total cost of the other supplies. Format cells D3 through D12 so the font is Arial Bold, the font size is 14-point, and the font color is Dark Blue. Now, rename Sheet 3 to “School Supplies.” Create a pie chart: In the School Supplies worksheet, select the range “School Supplies” and “Total Costs.” Insert a pie chart that displays the school supply items and the total cost for each item. Select the pie chart view that shows the dollar amounts for each item. Add a title to your chart so the title is above the chart (can be found in “Chart Formatting”). Add data labels to the pie chart that shows the total cost for each item. Position the chart so it does not overlap with the data in column A, column B, and column C. Review the assignment for accuracy.
o successfully complete this assignment, submit the Microsoft Excel template that includes the required information and formatting. Steps: Review this Assignment 2 Sample to see a completed version of this assignment for reference. Note: You may not copy any information from this sample into your own assignment.
Assignment ID
775769
CREATED ON
21 November 2018
COMPLETED ON
22 November 2018
Price
$40
This order has already been completed on Studybay
On Studybay you can order your academic assignment from one of our 45000 professional writers. Hire your writer directly, without overpaying for agencies and affiliates!
Check price for your Other types
Discussion
Other types, English Language
Price 40 $
Letter to uscis for a change status
Other types, English Language
Price 40 $
Visual rhetorical analysis
Other types, English Language
Price 40 $
Discussion
Other types, English Language
Price 40 $
T’s not your opinion; you’re just wrong
Other types, English Language
Price 40 $
Paper 6 can money buy happiness?
Other types, English Language
Price 40 $
Drones
Other types, English Language
Price 40 $
English
Other types, English Language
Price 40 $
Missing scene
Other types, English Language
Price 40 $
Journals
Other types, English Language
Price 40 $
Competency statement 1
Other types, English Language
Price 40 $
Analysis paper
Other types, English Language
Price 40 $
Studybay assignment progress timeline
Studybay is a freelance platform where you can order a Excelling with Excel paper, written from scratch by professors and tutors.
21 November 2018
User posted an order for English Language
21 November 2018
15 writers responded and offered to do the job for a price between $65 and $65
21 November 2018
User contacted writer
21 November 2018
User hired writer who offered a price of $65 for the job and has experience doing similar assignments
22 November 2018
Writer completed order Excelling with Excel for 1 day, meeting the deadline
22 November 2018
User accepted the job right away and completed the payment
22 November 2018
User left a positive review
Basic Steps to Write a Life without Electricity Essay
Before you start writing a life without electricity essay, you should learn the basics, such as making a strong thesis statement and creating an outline.
The Family Composition And Delinquency Sociology Essay
Sociology Delinquency is a very vital concern in American Population, and many questions are raised in regards to what inflames and affects a child to be...
Religious Influences on Stanley Spencer's Art
Arts What influence did religion have on the task of Stanley Spencer and did this contribute the reference as a 'village innocent' or avant garde genius?...
Steps to Overcoming Depressive disorder and Growing Healthy Habits
Psychology Joyce Mae Alyssa R. Mandanas Overcoming melancholy have three major steps, these includes understanding your despair, improving your life, and...
Other assignments in this discipline
Apa style research paper
Research Paper, English Language
Price 40 $.
Assisted suicide
Research Paper, English Language
Price 40 $.
What is in a name ?
Other types, English Language
Price 40 $.
Paper 3 outline
Outline, English Language
Price 30 $.
Argumentive research synthesis
Research Paper, English Language
Price 40 $.
Drama analysis
Coursework, English Language
Price 40 $.
World literature essay 1
Essay, English Language
Price 30 $.
Critical analysis essay on mother tongue by amy tan
Essay, English Language
Price 30 $.
Feral pigs in the southeast
Outline, English Language
Price 30 $.
Is the university budget enough
Essay, English Language
Price 30 $.
Winter of hardship
Essay, English Language
Price 30 $.

Reviews about the work performed

4.9
quality
rating
3
reviews