Due: 09-13-24
E115 Excel Independent Assignment Instructions
**This document is for instruction ONLY and will not be submitted**
Fill out and format the spreadsheet as requested and submit it as excelia_completed.xlsx.
Only use the functions given by our textbook! Do not use the implicit intersection operator @.
A) Format the given Excel Spreadsheet to the following standards:
1. Bold all data column titles in the data table. The data table spans from A1 to K45.
2. Set all font to Times New Roman 11 pt.
3. Add a fill color to every other row of the data table. This must be done with conditional
formatting which applies to $A$2:$K$45.
4. Add your Name, Unity ID, and Course and Section Number (must be formatted as
“E 115 ###”, including spaces) underneath the data table. These must be in red and bolded.
5. Add a dashed border around the Question/Answer section below the data table.
6. Add a thick border around the outside of the data table.
Please complete Sections B, C, and D in Excel. The questions in Sections B and C have been
duplicated below the data table in cells A52:A62.
B) Use an Excel function to find:
1. The average bill length of all the penguins (in millimeters).
2. Out of all the penguins, what is the shortest flipper length (in millimeters)?
3. Out of all the penguins, what is the greatest mass (in grams)?
4. What is the total mass of all the penguins (in grams)?
5. The total number of penguins.
C) Use an Excel conditional statement to find:
Note: Only question 6 requires nesting of conditional statements!
1. The total number of male penguins.
2. The total mass of penguins on Biscoe Island (in grams).
3. Whether a penguin is a Male Adelie. (Hint: you should auto-fill your answer down Column H.
Do not use an IF statement.)
4. Whether a penguin has a Flipper Length greater than 190 mm or a Body Mass less than 3500
g. (Hint: you should auto-fill your answer down Column I. Do not use an IF statement.)
5. If a Flipper Length is greater than 190 mm, then it is "Too long", otherwise it's "Just the right
length". (Hint: you should auto-fill your answer down Column J.)
E115 Fall 2024 1
Due: 09-13-24
6. If a penguin has a Body Mass less than 3500 g, then it is “Featherweight”; if it is greater than
4000 g, then it is “Heavyweight”; otherwise, it is “Middleweight”. (Hint: you should auto-fill
your answer down Column K. You should use nested IF statements.)
D) Graphing
Is there a correlation between a penguin's gender, species, or habitat and how long its bill is? Use
the summarized data below the data table to graph this correlation.
1. Create a column or bar graph below the data table where "Penguin Category" is your
independent variable and "Average Bill Length (mm)" is your dependent variable.
2. Include a title for your graph. Provide horizontal and vertical axis titles and labels. (Hint:
Axis labels are included by default, just don’t delete them!)
3. Add data labels to your graph and give your graph a border.
E115 Fall 2024 2
