Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now

Excel Assignment 2 Use the spreadsheet created in Excel Assignment 1 Center the spreadsheet title (Global Transport) and the subtitle (Semiannual Customer Sales Analysis) over the spreadsheet as shown in the example Make the title 16 point font Make the subtitle and the title bold Insert 8 rows Create the lookup table as shown in the example spreadsheet Center the table heading over the table Use 12 point, bold font for the table heading Create the Rankings column Enter the function that you learned about in this week’s lesson that use the lookup table to put the correct ranking for each company Use conditional formatting to make the percentages over 20% display in red Insert a 3-D bar chart with a depth of 200% below the spread sheet as shown in the example Use a gradient fill Blue Accent 1, 40% lighter Insert a blank row under the subtitle. Sort the data in the spreadsheet on the Customer’s name in ascending order. Save the file using a different file name from your first Excel assignment.

Excel Assignment 2

Use the spreadsheet created in Excel Assignment 1 Center the spreadsheet title (Global Transport) and the subtitle (Semiannual Customer Sales Analysis) over the spreadsheet as shown in the example Make the title 16 point font Make the subtitle and the title bold Insert 8 rows Create the lookup table as shown in the example spreadsheet Center the table heading over the table Use 12 point, bold font for the table heading Create the Rankings column Enter the function that you learned about in this week’s lesson that use the lookup table to put the correct ranking for each company Use conditional formatting to make the percentages over 20% display in red Insert a 3-D bar chart with a depth of 200% below the spread sheet as shown in the example Use a gradient fill Blue Accent 1, 40% lighter Insert a blank row under the subtitle. Sort the data in the spreadsheet on the Customer’s name in ascending order. Save the file using a different file name from your first Excel assignment.

Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now