IT 206 Entire Course (UOP)
For more course tutorials visit
www.tutorialoutlet.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 CheckPointAnalyzing 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(Uop)
For more course tutorials visit
www.tutorialoutlet.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...