ACCHS Mathematics Major League Baseball Team Question

Question Description

I’m working on a mathematics question and need an explanation to help me understand better.

1 attachmentsSlide 1 of 1attachment_1attachment_1

Unformatted Attachment Preview

Page 1 of 6
MICROSOFT EXCEL TUTORIAL
Major League Baseball Team
A
Player
GP
H
1B
B
Arraez,
9
L
Raley,
9
L
Rooker,
9
B
Sawyer,
9
W
Wade,
9
L
8
Cave, J
Cesar,
8
R
Duda,
8
L

2B
3B
Homeruns
Walks
HB
P
S
F
AV
G
SL
G
OB
P
Go to https://www.mlb.com/ and pick a team. Click on “Stats” and “Sortable Player Stats”. Create an Excel
file similar to the one you see above:
You want 10 Players (1 being a pitcher), games played, at bats, hits, singles (create a formula using =hits-…),
doubles, triples, homeruns, walks, hit by pitch, sacrifice fly. You also want a column for hitting average (using a
formula), slugging percentage (using a formula) and on base percentage (using a formula).
*Note that each header on the website has an explanation of what the column shows/means.

Highlight cells A2 – J2. With the cells highlighted right click and select Format Cells…
Click on the alignment tab and set the Orientation to 90 degrees. Set the Horizontal to Center and the
Vertical to Bottom. Click OK, the labels should now be rotated and centered.
Note: To highlight multiple cells in a row or column, click on the first value, then hold control, shift and use
the arrow keys to select the other values in the row/column.
Page 2 of 6

Right click on the A in column A and change the width of column A to 20 (see screen shots below). Change
the widths of column B to J to 5 (note: you can select all the columns at once by left clicking on B and
dragging you mouse to J, then left click on any of the columns you selected).


Enter the formula for singles, average, slugging percentage, and on-base percentage.
Copy the formula so that the calculations are made for each player

Highlight the cells as
shown to the right

Click on the small square
in the bottom right and
drag to fill in the remaining
cells as shown to the right.
Page 3 of 6
Your spreadsheet should now look like:







Where you see ####### you will need to enter in a 0. Do you know why?
In cells A12-A15 type: Totals, Min, Max and Average (see below).
Do not fill in total, min, max, and average for columns if it doesn’t make mathematical sense to do so (ie
meaningless information).
In the Totals row determine the totals in cells B12, C12, D12, E12, G12, H12 and I12, using =SUM()
formula. For example, you would type in B12 =SUM(B3:B10).
In the Min row determine the minimum in cells B13 – J13, using =MIN() formula. For example, you would
type in B13 =MIN(B3:B10).
In the Max row determine the maximum in cells B14 – J14, using =MAX() formula. For example, you
would type in B14 =MAX(B3:B10).
In the Average row determine the average in cells B15 – J15, using =AVERAGE() formula. For example,
you would type in B15 =AVERAGE(B3:B10).
Your spreadsheet should now look like:

Highlight cells A2 to J2, right click and select Format Cells…
Select the Fill tab and choose the turquoise colour, and select OK.
Repeat for cells A3 to A10 and A12 to A15.

Highlight cells A2 to J10, right click and select Format Cells …
Select the Borders tab and choose Outline and Inside buttons under the presets, and select OK.
Page 4 of 6




Repeat for cells A12 – J15.
Shade all the cells that contain number values to a light grey colour.
Cells F12 and J12 will not be holding any information. Shade those two cells with a red colour.
Highlight cells A1 – J1 and click the arrow on the Merge & Center button, then select Merge & Center.


Click on the title; add an outside border and set the background colour to yellow.
Highlight cells A3 – J15 and center the data.
Your spreadsheet should now look like:

In the bottom left hand corner of the sheet right click on the word Sheet 1 and select Rename Sheet…
Type the name: Tiger’s Baseball
Page 5 of 6

In the Page Layout tab, select Margins and set to Wide. Select Orientation and set to Landscape.

Still under the Page Layout tab click on the small arrow beside Scale to Fit to open the Page Setup box.
Under the Margins tab check the Horizontally and Vertically boxes:
Page 6 of 6

Under the Header/Footer tab click on Custom Header… and complete the boxes as indicated (Use your last
name and today’s date):


Create a Custom Footer… with the Center section: MS Excel Tutorial
Click on File tab, and select print and you should see the following:

Save this file as lastname_firstinitial_excel_intro (for example reati_m_excel_intro) in your student
drive, and then put it in d2l dropbox.

***Make sure to ask if I received your assignment!

Purchase answer to see full
attachment

Tags:
Major League Baseball team

slugging percentage

Yasmani Grandal

American professional baseball organization

United States and Canada

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool’s honor code & terms of service.