BIS155 Practical Exam Solution- Super Shoes
Click Link Below To Buy:
Complete the tasks below using Microsoft Excel. You may refer to your notes, the textbook, or other resources such as the WebYou may not get interactive help from any other person (either inperson or via email, text messaging, instant messaging, or other communications channels).I strongly recommend that you save your work frequently.
You have 4 hours to complete this exam.
Note: Be sure to spell check on every worksheet and correct all spelling errors.
a. Open Excel (either on your desktop or in Citrix)
b. If you are using Citrix, you need to upload the spreadsheet to your virtual drive before you can open it in Excel
c. Open the Practical Exam spreadsheet you downloaded from the Exam page in eCollege.
Save the spreadsheet as Lastname_FirstInitial Week8 FinalExam.xlsx. (i.e., if your name were Jane Doe, your file name would be: DoeJ Week8 FinalExam.xlsx)
1. Formatting and charts (TCOs 1 and 3; 40 points).
a. Enter your name and today's date on the Documentation sheet.
b. Select the Q1&Q2 sheet, and adjust the widths of the columns as needed.
c. Center the title "Super Shoes, Inc. Sales by Product"across columns A-D, increase the font size to 16 and change the font color to blue.
d. Bold the column headings "Product", "Unit Price", "Quantity", and "Total Sales".
e. Add formulas to the Total Sales column to calculate the total sales for each product.
f. Add a grand total at the bottom of the Total Sales and Quantity columns. Format totals and column headings so that they are easily read.
g. Format the numbers in the Unit Price and Total Sales columns as accounting or currency format with a dollar sign and two decimal places.
h. Create a 3-D column chart on a separate sheet(Chart1)that displays the total sales for each product. (Do not include the grand total in the chart!) Make the title of...