IT 206 UOP Course Tutorial / Uoptutorial

IT 206 UOP Course Tutorial / Uoptutorial

  • Submitted By: jayajaM5A1
  • Date Submitted: 12/17/2014 4:00 AM
  • Category: English
  • Words: 586
  • Page: 3
  • Views: 1

IT 206 Week 1 CheckPoint Formatting Issues

For more course tutorials visit
www.uoptutorial.com

• Consolidate all the sections of the Currency Conversion development documentation: menu selection, requirements, design, and testing.
• Incorporate any changes recommended by the instructor.
• Post the assignment as an attachment.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

IT 206 Week 4 Assignment Microsoft Excel Exercise

For more course tutorials visit
www.uoptutorial.com


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...

Similar Essays