Create a worksheet for the assistant director of athletics

Assignment Help Basic Computer Science
Reference no: EM131054326

Sports Programs

Project Description:

In this project, you will create a worksheet for the Assistant Director of Athletics at Laurel College to analyze the available sports programs. To complete the project, you will sort and filter data, subtotal and group data, and apply themes to multiple worksheets.

Instructions:

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

Step Instructions

1 Start Excel. Download, save, and open the Excel workbook named GO_e05_Grader_h3.xlsx.

2 Sort the values in the Campus column using a custom sort order list. Use the following order: Valley, Park, and then West.

3 Sort the Sport Group column in ascending order as a second level sort in the table, and then sort the Program Name column in ascending order as a third level sort in the table.

4 Convert the table to a range.

5 Display the Sports Season Comparison worksheet. Name the range A2:F3 using the nameCriteria. Name the range A6:F15 using the name Database, and then name the range A18:F18 using the name Extract.

6 In cell D3, type Fall and in cell E3, type Summer. Create an advanced filter that will copy all records from the Database range with Fall as their primary season and Summer as their secondary season to the range A18:F18.

7 Display the Stipends by Group worksheet. Sort the data in ascending order first by Group and then by Coach Stipend.

8 Subtotal the data on the Stipends by Group worksheet at each change in Group using the Sum function. Add the subtotals to the Coach Stipend column.

9 Collapse the outline so that the Level 2 summary information is displayed, and then autofit columns C:D.

10 Select all three worksheets and modify the page setup so that each worksheet fits on one page and is centered horizontally.

11 With all worksheets still selected, change the theme to Slice.

12 With all worksheets still selected, change the font theme to Corbel.

13 With all worksheets still selected, add the Sheet Name element to the center section of the footer, using the PAGE LAYOUT tab.

14 Ungroup the worksheets and display the Valley-Park-West worksheet. In cell J1, insert a hyperlink to the downloaded e05G_Coach_Information.xlsx workbook. Enter the text Click here for contact information as the ScreenTip for the hyperlink.

15 Change the font color for cell J1 to Orange, Accent 5, Darker 25%.

16 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Valley-Park-West, Sports Season Comparison, Stipends by Group. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

Attachment:- e_ch05_gov2_h3.zip

Reference no: EM131054326

Questions Cloud

How many participated in only campus sports : A survey of 180 college men was taken to determine participation in various campus activities.  Forty-three students were in fraternities, 52 participated in campus sports, and 35 participated in various campus tutorial programs. How many particip..
Isoelectric point of the amino acid : Consider a 0.141 L solution of the amino aspartic acid (0.825 M), which has a carboxylic acid group (pKa = 2.10), an amine group (pKa = 9.82), and a carboxylic acid side chain (pKa = 3.86). How many liters of 2.63 M NaOH would you need to add to r..
Determine the direction for equilibrium : Write balanced equation for proton transfer reaction. Indicate the conjugate pairs and determine the direction for each equilibrium
Oxidizing agent and as a reducing agent : In the reaction Cl2+AgNO3+H2Oyelids AgCl+HCIO3+HNO3 chlorine acts both as an oxidizing agent and as a reducing agent. How is this possible?
Create a worksheet for the assistant director of athletics : In this project, you will create a worksheet for the Assistant Director of Athletics at Laurel College to analyze the available sports programs.
Activation energy than the reverse reaction : How can endothermic reactions be at equilibrium if the forward reaction has a higher activation energy than the reverse reaction, thus having different rates?
Unshared pairs of electrons : Based on what you know about VSEPR theory, what is the geometry of PF3? How many shared and unshared pairs of electrons can be found around the central atom?
Size of atoms of the elements : Describe what happens to the size of atoms of the elements as you go across a row and down a column in the periodic table. Explain why each of these trends exist.
Platyhelminthes from other worms : What is the main external morphological feature that differentiates platyhelminthes from other worms (nematodes)?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  How do you define a constructor in java

How do you call Inherited Class Members in Java? Provide an example.

  Analyze the recent

U.S. > Analyze the recent (since Summer '14) decrease in the price of oil. How has supply and demand affected the price of oil today? Looking at the demand and supply determinants, what will most likely happen to the price by mid this year?

  Economy from a supply and demand standpoin

Discuss the sharing economy from a supply and demand standpoint. How do companies like Uber and Airbnb affect supply and demand in the markets for shared rides (taxis, limos, etc.) and rented rooms, respectively?

  Is it possible free internet content might one day replace

Is it possible that free Internet content might one day replace textbooks

  Perform the arithmetic encoding and decoding

Perform the arithmetic encoding and decoding of the following message ABBCAB$.

  How many legal combinations are there for memory reads

How many legal combinations are there for memory reads, and how many pins are needed to express them? Give two answers and make a case for each one.

  Describe two or three techniques that you would propose

Relate what you believe to be the most common biases among yourself and your colleagues on typical projects within your organization, and discuss the associated impact to the risk identification and risk analysis processes.

  Create an n by m array

Create an n by m array (n, m input by user). Initialize all cells in array to 0. The bug starts at cell 1,1. The bug can jump from its cell to any neighboring cell (left, right, up, down, diagonal) -- so there are at most 8 neighboring cells. Thou..

  Process computer uses to convert data into information

Write down a 200 word paper which explains the distinctions of data and information and in short describe the process a computer uses to convert data into information.

  Explain difference between virtual circuit and packet switch

Explain the differences between virtual circuits and packet switching.

  Write a program that asks for the amount of the bill

Write a program that asks for the amount of the bill and percentage tip and calculates the tip. The program should use variables for each of the quantities and display the outcome in a text box with a label. Test the program on a bill of $20 and a..

  Describe systems which make numeric predictions

So far we have been concerned with measuring performance of classifiers. I.e. systems which forecasts nominal variables. Describe about systems which make numeric predictions?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd