### Free Educational Resources

• > Excel Project GO E Capstone 1 - Front Range Action Sports 2.4
+

# Excel Project GO E Capstone 1 - Front Range Action Sports 2.4

##### Rating:
(0)
Author: matthew stock
##### Description:

http://homework.plus/excel-project-go-e-capstone-1-front-range-action-sports-2-4/

GO E Capstone 1 - Front Range Action Sports 2.4

Project Description:
In this project, you will work with multiple worksheets and enter formulas and functions to calculate totals, averages, maximum values, and minimum values. Additionally, you will create a summary sheet, format cells, insert charts, insert sparklines, and create a table in a workbook.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

0.000

2

On the Net Sales worksheet, in the range F4:F8, calculate the annual total sales for each state.

4.000

3

In the range B9:F9, calculate totals.

4.000

4

Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then fill the formula down through the range G5:G8.

4.000

5

Apply the Total cell style to the range B9:F9.

4.000

6

In cell H4, insert a Line sparkline using the data range B4:E4. Format the sparkline by applying the Sparkline Style Accent 2 (no dark or light). Copy the sparklines down to cell H8.

4.000

7

Insert a 3-D Pie chart using the nonadjacent ranges A4:A8 and G4:G8. Change the chart style to Style 7. Reposition the chart so that the top left corner of the chart is centered in cell A10. Change the width of the chart to 6.5 inches.

4.000

8

Change the chart title to Annual Net Sales by State and add data labels to the chart that display only the Category Name and Percentage positioned in the Center. Change the data labels Font color to Black, Text 1 and apply Bold Italic. Remove the Legend from the chart.

5.000

9

Change the angle of the first slice of the pie to 200, and then explode the red New Mexico slice of the pie by 10%. Change the solid fill color of the orange Colorado slice to Tan, Accent 6.

5.000

10

On the Seattle Inventory worksheet, in cell G14, enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should display OK. Copy the function down through cell G19.

4.000

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial