IT 206 UOP Course Tutorial / Uoptutorial

IT 206 UOP Course Tutorial / Uoptutorial


IT 206 Entire Course

For more course tutorials visit
www.uoptutorial.com



IT 206 Week 1 CheckPoint Formatting Issues
IT 206 Week 1 DQ 1 and DQ 2
IT 206 Week 2 CheckPoint Knowing Where You Placed Your Document
IT 206 week 2 Assignment Microsoft Word Exercise
IT 206 Week 3 CheckPoint Simplifying Your Excel Usage
IT 206 week 3 DQ 1 and DQ 2
IT 206 Week 4 CheckPoint The Risk of Macros
IT 206 Week 4 Assignment Microsoft Excel Exercise
IT 206 Week 5 CheckPoint Mail Merging
IT 206 Week 5 DQ 1 and DQ 2
IT 206 Week 6 CheckPoint Analyzing Data
IT 206 Week 6 Assignment Microsoft Access Exercise
IT 206 Week 7 CheckPoint Other Uses for PowerPoint
IT 206 Week 7 DQ 1 and DQ 2
IT 206 Week 8 CheckPoint Pitfalls to a Presentation
IT 206 Week 8 Assignment Microsoft PowerPoint Exercise
IT 206 Week 9 capstone DQ
IT 206 Week 9 Final Project Common Microsoft Office Errors


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

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

Similar Essays