IT 206 UOP Course Tutorial / Uoptutorial

Free Essays

IT 206 Week 1 CheckPoint Formatting IssuesFor 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 ExerciseFor 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…

Leave a Reply

Your email address will not be published. Required fields are marked *