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