BIS155 Practical Exam Solution- Super Shoes
Click Link Below To Buy:
Contact Us:
Hwcoursehelp@gmail.com
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.
Getting
started
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)
Questions/Problems
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 the chart "Total Sales by Product".Put
the sheet with the column chart immediately after the Q1&Q2 sheet.
i.
Remember to save your work often.
No comments:
Post a Comment