Loading
Home › General Help › Background: Excel is a simple but also complicated tool t...
Status: Completed
 View Work

Background: Excel is a simple but also complicated tool that can help with analyzing data, creating charts, and creating calculations. It’s important for a user new to Excel to understand how to apply the basics of Microsoft Excel to a document before moving on to the more advanced features of Excel. Assignment Instructions: You are going to create an Excel spreadsheet that discusses the costs of school supplies.

Date Posted: 05/06/2020
Category: General
Due Date: 06/06/2020
Instruction
Create an Excel spreadsheet that discusses the costs of school supplies. 1. In the first row, create a header row called ‘School Supplies Needed’. Shade the header and use the Merge and Center feature to center the header. 2. Create column headers called ‘Item’, ‘Quantity’, and ‘Cost (per item)’, ‘Total Cost’. Shade the column headers a color of your choice. Expand the columns to show each column header title. 3. Format the font of the column headers to Arial Rounded MT Bold in 14 font. 4. Under each column header, list each item, quantity, and cost (per item). Use the Calibri font in 11 font. 5. Using a formula, create the ‘Total Cost’ per item. 6. Using formulas, create the sum of the following column – quantity, total cost. 7. Format the cost (per item) column and total cost using the currency format. 8. Add a cell border in between all of the cells in the data set. 9. For any total costs over $15.00, use conditional formatting to highlight the total in red. 10.Insert a stock picture of any type of school supplies on the sheet. 11. Create a simple pie chart showing the quantity of each item to purchase. Add data labels showing that quantity. Choose any design to apply to the pie chart. 12. Rename the sheet that the data is on to ‘School Supplies’. Color the tab any color of your choice. I have attached a screenshot of the assignment instructions and what MUST be included as line items. Please be proficient in excel spreadsheet and follow all directions without grammatical errors. Will add *bonus for good timely work. Thank you!
Attached
Download File 1 (PNG)
Download File 2 (PNG)
Tutor Uploads
Download File 1 (xlsx)
Bidders
Respectwriter 6 years, 3 months ago
Rated 9.03 earned 26253.25 around 814 assignments.
I am well equiped with knowledge and experience sufficient to handle this order.Be sure of a quality work.
$60.00
  • I have done many assignments like this and am sure I will deliver a quality paper
    Respectwriter | Jun 05, 2020, 19:28 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
kelvinrotich 6 years, 3 months ago
Rated 9.34 earned 14793.81 around 487 assignments.
Hello Dear Client. I am a long-serving academic tutor. I have done assignments like yours in the past and delivered excellent results. I promise to deliver very high-quality work within the deadline. Looking forward to hearing from you. Cheers!
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
Primetutor 6 years, 3 months ago
Rated 9.2 earned 5229.67 around 164 assignments.
Hi friend, I am a highly qualified and experienced tutor. I guarantee the best possible grade in this assignment. I will surely complete it within the due time. kindly assign and I won't disappoint you. thank you.
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
exclusivewriting 6 years, 3 months ago
Rated 9.47 earned 34069.12 around 1154 assignments.
Hello friend , this is my area of expertise,I am committed to deliverorder right away and deliver it within the shortest time. Kindly HIRE top quality and 100% plagiarism FREE assignment. I can work on your ME
$100.00
  • Hello friend , this is my area of expertise,I am committed to deliverorder right away and deliver it within the shortest time. Kindly HIRE top quality and 100% plagiarism FREE assignment. I can work on your ME
    exclusivewriting | Jun 05, 2020, 19:26 PM
  • Hello friend , this is my area of expertise,I am committed to deliverorder right away and deliver it within the shortest time. Kindly HIRE top quality and 100% plagiarism FREE assignment. I can work on your ME
    exclusivewriting | Jun 05, 2020, 19:26 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
TalentedTeacher 6 years, 3 months ago
Rated 9.33 earned 18202.75 around 525 assignments.
Hello Client, I have a great experience to guarantee you a top class, a great and an excellent work, 100% free from PLAGIARISM, and within the stipulated time frame. Kindly hire me and I will make you proud. Thanks
$70.00
  • hello friend, are you there? I wish to help you
    TalentedTeacher | Jun 05, 2020, 19:31 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}
 
 
Javawriter 6 years, 3 months ago
Rated 8.81 earned 69150.66 around 2092 assignments.
Hello friend...,Concerning the homework that you want done for you, I am an American native and I have a PHD in sociology also PHD in business administration which i got from Alberta university based in Canada and am currently working as an auditor for Reserve Bank Australia for four years now and u have probably seen it in the top 30 companies in Australia also working at a non governmental organization dealing with women negligence and mistreatment. I assure you a content homework and nothing less than an A. I have written various articles and be rest assured i will deliver a timely,quality,substantial and PLAGIARISM free work. Thanks in advance
$65.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[5] $}

{$ showNewChatSuccessMsg[5] $}
Unable to send Message: {$ showChatProcessErrorMsg[5] $}
 
 
phoniextutor 6 years, 3 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
Hello, i am a qualified, experienced and a professional writer. I aim at providing a high quality paper. Kindly assign me and be assured of a highly rated paper. Thank you in advance
$120.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[6] $}

{$ showNewChatSuccessMsg[6] $}
Unable to send Message: {$ showChatProcessErrorMsg[6] $}
 
 
academicminded 6 years, 3 months ago
Rated 9.5 earned 87858.79 around 3236 assignments.
Dear Client, I am a prolific writer. I have been writing for so many years. I promise you a high quality job with 0% plagiarism. I have both Grammarly and Turnitin accounts to test for grammar and plagiarism.
$130.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[7] $}

{$ showNewChatSuccessMsg[7] $}
Unable to send Message: {$ showChatProcessErrorMsg[7] $}
 
 
Augustine24 6 years, 3 months ago
Rated 9.28 earned 42861.36 around 1428 assignments.
hey friend, I only need a few hours to complete this assignment since everything is clear to me please assign me for the perfect and timely work
$60.00
  • Hey, my good friend, I have a PhD in this field of study, where I deliver TIMELY, PERFECT, 100% QUALITY WORK and 0% PLAGIARISM-FREE paper as my first priority, you can be rest assured I have checked the assignment instructions and am WELL VERSED and COMPETENT to deliver an A on the field subject. Kindly consider my bid to take this assignment and I guarantee to work on it according to the given instructions. Thank you in advance for your faith in me.
    Augustine24 | Jun 05, 2020, 19:25 PM
  • Hello, Please let me know if you have any questions.
    User_28890 | Jun 05, 2020, 19:44 PM
  • thanks much friend, be assured of the perfect and timely work on this
    Augustine24 | Jun 05, 2020, 19:45 PM
  • Thank you, I have attached the rubric for this assignment.
    User_28890 | Jun 05, 2020, 19:46 PM
  • Hi, my good friend,
    Augustine24 | Jun 06, 2020, 12:23 PM
  • Good morning
    User_28890 | Jun 06, 2020, 14:12 PM
  • goodmorning to you, am done with the wok already
    Augustine24 | Jun 06, 2020, 14:18 PM
  • Ok. I dont see the upload
    User_28890 | Jun 06, 2020, 14:24 PM
  • I have uploaded it please confirm it friend
    Augustine24 | Jun 06, 2020, 14:30 PM
  • please, friend, let me know if you received the work, please
    Augustine24 | Jun 06, 2020, 15:14 PM
  • Thank you will add bonus
    User_28890 | Jun 06, 2020, 17:31 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[8] $}

{$ showNewChatSuccessMsg[8] $}
Unable to send Message: {$ showChatProcessErrorMsg[8] $}
 
 
COMMITEDTUTOR 6 years, 3 months ago
Rated 9.18 earned 5387.52 around 193 assignments.
Hi, I have significant experience with various kinds of papers. I’m really interested in your assignment and I would like to have the chance to work on this task. I hope you can send me additional details for this. Contact me ASAP so we can discuss more about this..
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[9] $}

{$ showNewChatSuccessMsg[9] $}
Unable to send Message: {$ showChatProcessErrorMsg[9] $}
 
 
surrogatewriter 6 years, 3 months ago
Rated 9.31 earned 75264.37 around 2854 assignments.
Hello, I would like to work on this project. I have gone through your instructions and I can deliver. Thanks
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[10] $}

{$ showNewChatSuccessMsg[10] $}
Unable to send Message: {$ showChatProcessErrorMsg[10] $}
 
 
Prof1990 6 years, 3 months ago
Rated 9.52 earned 54153.62 around 1785 assignments.
Hello. Kindly hire me please, promise to deliver HIGH-QUALITY WORK, PLAGIARISM FREE and 100% GRAMMAR that will guarantee you A+ ASAP
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[11] $}

{$ showNewChatSuccessMsg[11] $}
Unable to send Message: {$ showChatProcessErrorMsg[11] $}