Published on January 19, 2016
FOR MORE CLASSES VISIT www.it206tutorials.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.