For more course tutorials visit
Tutorial
Purchased: 4 Times, Rating:A+
1. Assignment: Excel®
Exercise – Due Day 7
·
Complete
the following tasks by using the Microsoft® Excel®
document provided in Course Materials:
o Format appropriate cells for currency.
o Merge title cells.
o Construct a bar graph using the existing data and provide labels
and a legend.
o Insert a border around data.
o Freeze the first column of the data set.
o Sort the daily spending amounts in ascending order.
o Using the Tools menu, set the Excel spreadsheet to be protected.
o Calculate the sum of the entire data set.
o Calculate the average of the entire data set.
o Delete any empty cells between the data cells to condense the
data.
·
Read the
following scenario:
You are working at a support desk for a company providing onsite
and telephone support to customers with Microsoft® Excel®
questions. On this particular day, you are presented with the following three
situations:
Situation 1: A business
professional wants to use Microsoft® Excel® to organize
data for the monthly expense report. He has never used Microsoft® Excel®
and is inquiring about the functions that would support him with this task.
Situation 2: A husband is having difficulties with his Microsoft® Excel
spreadsheet. 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.
Situation 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.
·
Team-up with
another student assigned by the facilitator.
·
Discuss how
to diagnose and troubleshoot the situations.
·
Write a
1-page response for each of the three situations. Include the following in each
response:
o 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?
o 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.
o Once the causes are identified, describe
a step-by-step troubleshooting process to help the customer complete the task.
o If the customer has problems
understanding or following your instructions, briefly explain an alternative
solution.
·
Complete
your written responses individually.
No comments:
Post a Comment