Click Link Below To Buy:
Contact Us:
Hwcoursehelp@gmail.com
BIS155Practical Final Exam Instructions1 for Cool
Clocks, Inc. (v2)
Complete the tasks below using Microsoft Excel. You may refer to your notes, the textbook,
or other resources (for example, you may search the Web for information). You may not
get interactive help from any other person (either in person or via email, text
messaging, IM, or other communications channels). I strongly recommend that
you save your work frequently.
You have 4 hours to complete this exam.
NOTE: Be sure you SPELL CHECK on every worksheet
and correct all spelling errors.
If you encounter technical issues of any type during the
Final Exam, please notify your instructor and contact the appropriate helpdesk.
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 workbook you downloaded from the Exam page in eCollege.
d. Save
the workbook as Lastname_FirstInitial
Week8 FinalExam.xlsx.
1. Formatting
and charts (TCOs 1 & 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 "Cool Clock, Inc. Sales by
Product" across columns A-D, increase the font size to 20, and change the
font color to red.
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 column,
in cell D8.
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 pie chart on a separate sheet that displays the
percentage of total sales for each product& the product name. (Do not include the grand total in the pie
chart!).
i.
Make the title of the chart & the worksheet tab "Total
Sales by Product".
j.
Place each product percentage of sales inside its pie slice.
k.
Place a legend for all products on the right side of the
chart.
No comments:
Post a Comment