1.\u00a0\u00a0\u00a0\u00a0 Assignment: Excel\u00ae Exercise “\ufffd Due Day 7\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Complete the following tasks by using the Microsoft\u00ae Excel\u00ae document provided in Course Materials:\t\u00a0\to\u00a0\u00a0\u00a0 Format appropriate cells for currency.\to\u00a0\u00a0\u00a0 Merge title cells.\to\u00a0\u00a0\u00a0 Construct a bar graph using the existing data and provide labels and a legend.\to\u00a0\u00a0\u00a0 Insert a border around data.\to\u00a0\u00a0\u00a0 Freeze the first column of the data set.\to\u00a0\u00a0\u00a0 Sort the daily spending amounts in ascending order.\to\u00a0\u00a0\u00a0 Using the Tools menu, set the Excel spreadsheet to be protected.\to\u00a0\u00a0\u00a0 Calculate the sum of the entire data set.\to\u00a0\u00a0\u00a0 Calculate the average of the entire data set.\to\u00a0\u00a0\u00a0 Delete any empty cells between the data cells to condense the data.\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Read the following scenario:\t\u00a0\tYou are working at a support desk for a company providing onsite and telephone support to customers with Microsoft\u00ae Excel\u00ae questions. On this particular day, you are presented with the following three situations:\t\u00a0\tSituation 1: A business professional wants to use Microsoft\u00ae Excel\u00ae to organize data for the monthly expense report. He has never used Microsoft\u00ae Excel\u00ae and is inquiring about the functions that would support him with this task.\t\u00a0\tSituation 2: A husband is having difficulties with his Microsoft\u00ae Excel\u00aespreadsheet. He has been trying to track his monthly grocery spending to find the daily average he spends on food. The spreadsheet is organized by day, and for the days in which no groceries were purchased, he enters zero. He is seeking assistance to calculate the correct monthly average.\t\u00a0\tSituation 3: A local grocery store owner has created a spreadsheet containing the types of inventory she carries within the store. The spreadsheet contains 235 different kinds of inventory, defined by price, quantity on hand, ordered quantity, and category. She loses her placement every time she scrolls through the data set. She wants to know how to effectively scroll through the data sheet and manage this large data set.\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Team-up with another student assigned by the facilitator.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Discuss how to diagnose and troubleshoot the situations.\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Write a 1-page response for each of the three situations. Include the following in each response:\t\u00a0\to\u00a0\u00a0\u00a0 Identify a general approach for facilitating the customer over the telephone. What are possible challenges in the given situation? What strategies would help you overcome the challenges?\t\u00a0\to\u00a0\u00a0\u00a0 If causes to the problem or question described by the customer are unclear in the situation, explain how you would further diagnose the problem or question.\t\u00a0\to\u00a0\u00a0\u00a0 Once the causes are identified, describe a step-by-step troubleshooting process to help the customer complete the task.\t\u00a0\to\u00a0\u00a0\u00a0 If the customer has problems understanding or following your instructions, briefly explain an alternative solution.\t\u00a0\t\u00b7 \ufffd\u00a0\u00a0\u00a0 Complete your written responses individually.<\/p>\n","protected":false},"excerpt":{"rendered":"
1.\u00a0\u00a0\u00a0\u00a0 Assignment: Excel\u00ae Exercise “\ufffd Due Day 7 \u00a0 \u00b7 \ufffd\u00a0\u00a0\u00a0 Complete the following tasks by using the Microsoft\u00ae Excel\u00ae document provided in Course Materials: \u00a0 o\u00a0\u00a0\u00a0 Format appropriate cells for currency. o\u00a0\u00a0\u00a0 Merge title cells. o\u00a0\u00a0\u00a0 Construct a bar Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-225492","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/225492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=225492"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/225492\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=225492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=225492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=225492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}