microsoft excel functions workbook, volume 2 (free preview)

8/4/2019 Microsoft Excel Functions Workbook, Volume 2 (FREE PREVIEW)

1/7

Microsoft Excel FunctionsWorkbook (Volume 2)

By

Derrick Brown

Copyright 2011 Derrick Brown ([email protected]) and KnowledgeBase, Inc. All Rights Reserved.

See our product catalog at http://bit.ly/tpt_db


2/7

About The Microsoft Excel Functions Workbook (Volume 2)

This is an Excel workbook collection of 15 project-based, problem solving spreadsheet exercises (with

complete keys) that help students learn to use the following powerful Microsoft Excel functions:

SUMAVERAGE

IF

COUNTIF

COUNTBLANK

Each exercise generally takes between 1 and 2 full class periods to complete. I take 10-15 minutes to explain

the problem, the deliverable, and the tools, and then let the students work independently or in small

groups.

I created these for the Microsoft Excel portion of my 9th-grade Computer Applications class, but also

integrated them into my Geomtery, Algebra 2, and Pre-Engineering classes as projects in later years.

Developing a Microsoft Excel skill set is just that important for college-bound students and teachers!




3/7

About The Author (Derrick Brown)

Derrick is a newlywed, having married the former Keisha Lanier on March 26, 2011. They reside

in Marietta, GA.

Derricks other passion is empowering people via methods that balance skill & will, analysis &

synthesis, ideas & execution, and activity & achievement.

He has published a digital catalog of more than 70 short films, learning games, visual dictionaries,

poems, essays, newsletters, inspirational posters, and projects.

He has also delivered more than 30 presentations, workshops, keynote addresses, and invited

lectures at conferences, high schools, colleges, universities, and churches.

From 2004-2010, he served as a founding faculty member, governing board representative,

Director of Corporate Relations, Dean of Students, and Assistant Principal of Tech High (Charter)School in Atlanta GA.

Derrick founded KnowledgeBase, Inc., in 1998, served as its full-time executive director until

2004, and still serves as its part-time Principal Consultant. KnowledgeBase's mission is to educate

and to empower people by creating content that enhances their reading, writing, math,

entrepreneurial, leadership, and critical thinking (problem solving) skills.




4/7

Microsoft Excel Functions Workbook, Volume 2.xls - BusinessMath1

Name:

Date:

Period:

BIZMATH

Syntax

=SUM(Cell1:Cell10) OR =SUM(Cell1,Cell3,Cell5,Cell6).

=AVERAGE(Cell1:Cell10) OR =SUM(Cell1,Cell3,Cell5,Cell6).

Problem

The time reports below must be completed so that I can pay my employees.

1. Compute the number of hours worked weekly by each employee, and their weekly salary.

2. Compute the average number of hours worked each day & week, as well as the average hourly and weekly salaries.

3. ANSWER THE QUESTIONS AT THE BOTTOM (Use the SORT command to help you); print your final time report and submit it.

L as tN am e Fir st Na me M on da y Tues da y W ed ne sd ay Thu rs da y Fri da y Sat ur da y H our s W or ke d H ou rl y Sal ar y W ee kl y Sal ar y

Andrel Jenny 2 2 4 4 3 3 8.50$Axford Michael 2 2 5 2 4 5 8.16$

Baker Justin 5 2 5 5 4 5 8.02$Barbour Claire 5 4 5 5 4 3 7.77$Barnett Brian 2 2 2 4 4 5 8.23$Beasley Jacob 2 2 2 5 4 2 8.93$

Becvarik Lisa 3 3 3 5 3 5 8.45$Belcher Lance 3 2 3 3 3 3 8.89$Bolton Annie 3 2 3 2 3 4 8.69$Bonney Melanie 2 3 5 2 5 4 7.32$

Bouton Leah 2 2 4 3 2 5 8.42$Brennan Terrence 3 3 5 3 2 2 8.07$Brown Sarah 4 2 2 2 5 2 8.15$

Bufton Laura 4 4 5 4 5 5 7.81$Burke Johnathan 3 4 2 4 5 5 8.75$Canty Ashley 5 4 3 5 4 5 7.04$

Chilvers Richard 2 2 4 2 5 2 8.20$

Coburn Erica 3 5 4 2 4 4 8.96$Cooke Erick 2 3 4 5 2 2 7.98$Cooler Taylor 5 2 5 4 5 2 8.25$Croft Dustin 2 4 3 4 2 4 8.94$

Davis Chris 2 2 4 3 4 2 8.77$Dawes Kimberlee 5 5 4 2 3 4 8.87$Dean Richard 3 5 3 2 4 3 7.99$

DeCarolis Lisa 3 5 2 3 5 2 7.32$

DeJager Michael 3 4 3 5 3 2 8.04$Dial Lauren 3 3 4 5 5 2 8.14$

Diaz Juan 4 3 2 4 2 3 8.39$Edgecomb Jessica 4 2 4 2 2 2 8.53$

Erbentraut Kristen 3 2 4 5 2 4 8.54$Eskew Branden 5 5 3 3 2 5 8.87$Farley Nicholas 3 3 5 3 3 5 7.99$

Farrell Jessica 3 5 5 5 2 5 8.51$Fishman Kaitlin 5 2 3 3 2 2 8.54$Fleming Andrea 2 4 4 2 3 2 8.97$Foster Brent 3 2 5 4 3 5 8.02$

Gildersleeve Kaitlyn 5 2 5 5 4 5 8.99$Green Alyssa 5 4 4 2 3 5 7.46$Gruner Isaac 5 4 2 2 2 5 8.11$

Hamilton Daun 3 4 5 2 2 3 7.11$

Hamilton Zachary 4 2 3 5 2 3 8.97$Harris Thomas 3 5 2 5 3 3 7.68$Hiss Allison 5 5 5 3 2 2 8.54$

Horace Patrick 5 5 5 3 3 3 8.90$

Huguenard Nick 5 4 2 3 5 5 8.18$Johns Eric 2 4 2 2 5 5 7.83$Kellert Emily 3 2 3 4 2 5 8.73$

Kroswek Joshua 5 2 3 5 3 4 7.94$

Langston Lauren 3 2 2 4 4 5 8.06$Lawrence Ashley 5 4 4 2 3 3 7.16$Losinger Sarah 3 2 3 5 3 2 8.49$Markman Melanie 2 3 2 5 4 2 7.85$

McClain Ian 3 4 4 4 5 2 8.32$McMillen Gabrielle 3 5 3 5 4 4 8.37$

McTiernan Ross 5 5 4 4 3 4 8.23$Messinger Maggie 4 2 5 5 3 4 7.32$

Montour Daphney 4 4 5 4 2 5 8.11$Morton Grace 5 3 3 5 3 4 8.19$

Newsome Shaneisa 5 2 5 2 5 2 8.13$Oswald Anna 3 2 2 3 3 3 8.22$

Pennington Anna 5 4 4 3 4 2 8.90$Penter Brian 4 4 3 4 3 4 8.79$

Potteiger Aileen 2 4 3 4 5 5 8.13$

Remter Clark 3 5 3 4 2 3 7.86$Revell Erin 5 4 5 3 3 5 7.23$Rice Sherri 3 2 2 2 4 3 7.96$

Richards Steven 2 4 2 2 2 2 8.01$Rodgers Hillary 4 5 2 5 4 4 8.32$

Rodriguez Jalise 4 2 3 4 3 5 8.61$Roell David 5 3 4 2 5 2 8.26$

Rostamy Brittanie 3 2 3 4 5 5 7.85$Rowley Callan 2 2 4 4 2 5 8.75$

Roy Brandon 5 2 5 5 4 5 8.46$Sabbatino Ashley 2 3 5 2 2 3 8.57$

Schulman Brooke 2 4 4 4 5 5 7.74$Schultz Lacey 3 5 5 3 3 3 8.49$

Scoggan Michael 4 4 3 4 4 2 8.56$Seaman Taylor 2 3 3 2 5 4 8.32$

Searan Wes 2 3 5 2 5 4 8.06$Shaw Sterling 2 3 2 5 3 3 8.70$

Shepard Taylor 4 3 2 5 2 2 7.82$Skavlan Travis 2 5 2 3 2 3 8.80$

Smith Kevin 5 4 2 3 2 4 8.68$Smith Randall 5 5 3 3 3 3 7.23$Smith Ryan 3 3 2 4 4 2 8.26$Spies Jacki 2 3 3 3 3 3 8.66$

Srikeow Kevin 2 5 5 4 5 3 7.31$Stokes Brandon 4 3 5 4 2 3 7.77$Tate Meredith 4 2 5 4 3 2 8.83$

Taylor Benjamin 3 5 3 4 3 3 8.31$Terrell Blake 2 5 3 2 2 4 8.20$Terrell James 4 5 2 4 2 3 8.27$

Tornatore Drew 3 2 5 4 3 3 7.41$Van Rooyen Jan-Karl (JK) 2 5 3 3 3 4 7.80$

Vargulic Kelly 3 4 3 3 5 4 8.26$Wagy Gregory 5 5 4 2 3 2 7.96$Wicker Brittany 4 3 5 4 4 3 8.41$

Williams Jacob 4 3 5 5 3 4 8.17$Wilson Kathleen 3 4 5 4 5 5 8.70$Yapp Austin 5 4 4 2 4 4 8.94$Young Ann 2 4 3 5 4 3 8.27$

Young Danielle 2 4 5 4 3 5 8.42$Zahran Ibrahim 5 2 4 4 3 4 8.86$

AVERAGES

QUESTIONS

1. What is the total amount that I must pay in salary?

2. Which student made the most money?

3. Which student made the least money?

4. Which student has the highest hourly salary?

5. Which student has the lowest hourly salary?




5/7

Microsoft Excel Functions Workbook, Volume 2.xls - BusinessMath1 (KEY)

Name:

Date:

Period:

BIZMATH

Syntax



Problem

The time reports below must be completed so that I can pay my employees.

1. Compute the number of hours worked weekly by each employee, and their weekly salary.

2. Compute the average number of hours worked each day & week, as well as the average hourly and weekly salaries.

3. ANSWER THE QUESTIONS AT THE BOTTOM (Use the SORT command to help you); print your final time report and submit it.

L as tN am e Fir st Na me M on da y Tues da y W ed ne sd ay Thu rs da y Fri da y Sat ur da y H ou rs W or ked H ou rl y Sal ar y W ee kl y Sal ar y

Canty Ashley 5 4 3 5 4 5 21 7.04$ 147.83$ =J21*K21Hamilton Daun 3 4 5 2 2 3 16 7.11$ 113.78$

Lawrence Ashley 5 4 4 2 3 3 16 7.16$ 114.49$Revell Erin 5 4 5 3 3 5 20 7.23$ 144.52$Smith Randall 5 5 3 3 3 3 17 7.23$ 122.96$

Srikeow Kevin 2 5 5 4 5 3 22 7.31$ 160.74$

Messinger Maggie 4 2 5 5 3 4 19 7.32$ 139.09$DeCarolis Lisa 3 5 2 3 5 2 17 7.32$ 124.47$Bonney Melanie 2 3 5 2 5 4 19 7.32$ 139.17$

Tornatore Drew 3 2 5 4 3 3 17 7.41$ 125.89$

Green Alyssa 5 4 4 2 3 5 18 7.46$ 134.31$Harris Thomas 3 5 2 5 3 3 18 7.68$ 138.24$

Schulman Brooke 2 4 4 4 5 5 22 7.74$ 170.32$

Barbour Claire 5 4 5 5 4 3 21 7.77$ 163.12$Stokes Brandon 4 3 5 4 2 3 17 7.77$ 132.11$

Van Rooyen Jan-Karl (JK) 2 5 3 3 3 4 18 7.80$ 140.44$Bufton Laura 4 4 5 4 5 5 23 7.81$ 179.64$

Shepard Taylor 4 3 2 5 2 2 14 7.82$ 109.49$Johns Eric 2 4 2 2 5 5 18 7.83$ 140.90$

Rostamy Brittanie 3 2 3 4 5 5 19 7.85$ 149.13$Markman Melanie 2 3 2 5 4 2 16 7.85$ 125.67$

Remter Clark 3 5 3 4 2 3 17 7.86$ 133.54$Kroswek Joshua 5 2 3 5 3 4 17 7.94$ 135.06$

Rice Sherri 3 2 2 2 4 3 13 7.96$ 103.44$Wagy Gregory 5 5 4 2 3 2 16 7.96$ 127.36$

Cooke Erick 2 3 4 5 2 2 16 7.98$ 127.70$Dean Richard 3 5 3 2 4 3 17 7.99$ 135.75$

Farley Nicholas 3 3 5 3 3 5 19 7.99$ 151.89$Richards Steven 2 4 2 2 2 2 12 8.01$ 96.14$

Baker Justin 5 2 5 5 4 5 21 8.02$ 168.37$Foster Brent 3 2 5 4 3 5 19 8.02$ 152.34$

DeJager Michael 3 4 3 5 3 2 17 8.04$ 136.68$

Langston Lauren 3 2 2 4 4 5 17 8.06$ 136.95$Searan Wes 2 3 5 2 5 4 19 8.06$ 153.18$

Brennan Terrence 3 3 5 3 2 2 15 8.07$ 121.00$Gruner Isaac 5 4 2 2 2 5 15 8.11$ 121.68$

Montour Daphney 4 4 5 4 2 5 20 8.11$ 162.26$Newsome Shaneisa 5 2 5 2 5 2 16 8.13$ 130.04$Potteiger Aileen 2 4 3 4 5 5 21 8.13$ 170.83$

Dial Lauren 3 3 4 5 5 2 19 8.14$ 154.74$

Brown Sarah 4 2 2 2 5 2 13 8.15$ 105.92$Axford Michael 2 2 5 2 4 5 18 8.16$ 146.93$

Williams Jacob 4 3 5 5 3 4 20 8.17$ 163.33$Huguenard Nick 5 4 2 3 5 5 19 8.18$ 155.34$

Morton Grace 5 3 3 5 3 4 18 8.19$ 147.44$Chilvers Richard 2 2 4 2 5 2 15 8.20$ 123.00$Terrell Blake 2 5 3 2 2 4 16 8.20$ 131.23$Oswald Anna 3 2 2 3 3 3 13 8.22$ 106.87$

Barnett Brian 2 2 2 4 4 5 17 8.23$ 139.97$McTiernan Ross 5 5 4 4 3 4 20 8.23$ 164.68$

Cooler Taylor 5 2 5 4 5 2 18 8.25$ 148.57$Vargulic Kelly 3 4 3 3 5 4 19 8.26$ 156.87$

Roell David 5 3 4 2 5 2 16 8.26$ 132.14$Smith Ryan 3 3 2 4 4 2 15 8.26$ 123.94$Young Ann 2 4 3 5 4 3 19 8.27$ 157.08$Terrell James 4 5 2 4 2 3 16 8.27$ 132.30$

Taylor Benjamin 3 5 3 4 3 3 18 8.31$ 149.65$McClain Ian 3 4 4 4 5 2 19 8.32$ 158.03$

Rodgers Hillary 4 5 2 5 4 4 20 8.32$ 166.40$Seaman Taylor 2 3 3 2 5 4 17 8.32$ 141.45$

McMillen Gabrielle 3 5 3 5 4 4 21 8.37$ 175.85$Diaz Juan 4 3 2 4 2 3 14 8.39$ 117.46$

Wicker Brittany 4 3 5 4 4 3 19 8.41$ 159.80$

Young Danielle 2 4 5 4 3 5 21 8.42$ 176.72$Bouton Leah 2 2 4 3 2 5 16 8.42$ 134.74$

Becvarik Lisa 3 3 3 5 3 5 19 8.45$ 160.49$

Roy Brandon 5 2 5 5 4 5 21 8.46$ 177.74$Schultz Lacey 3 5 5 3 3 3 19 8.49$ 161.35$Losinger Sarah 3 2 3 5 3 2 15 8.49$ 127.41$Andrel Jenny 2 2 4 4 3 3 16 8.50$ 136.05$

Farrell Jessica 3 5 5 5 2 5 22 8.51$ 187.28$Edgecomb Jessica 4 2 4 2 2 2 12 8.53$ 102.32$Fishman Kaitlin 5 2 3 3 2 2 12 8.54$ 102.48$

Erbentraut Kristen 3 2 4 5 2 4 17 8.54$ 145.22$

Hiss Allison 5 5 5 3 2 2 17 8.54$ 145.23$Scoggan Michael 4 4 3 4 4 2 17 8.56$ 145.45$Sabbatino Ashley 2 3 5 2 2 3 15 8.57$ 128.52$Rodriguez Jalise 4 2 3 4 3 5 17 8.61$ 146.39$

Spies Jacki 2 3 3 3 3 3 15 8.66$ 129.95$Smith Kevin 5 4 2 3 2 4 15 8.68$ 130.27$Bolton Annie 3 2 3 2 3 4 14 8.69$ 121.68$Wilson Kathleen 3 4 5 4 5 5 23 8.70$ 200.08$

Shaw Sterling 2 3 2 5 3 3 16 8.70$ 139.21$Kellert Emily 3 2 3 4 2 5 16 8.73$ 139.76$Burke Johnathan 3 4 2 4 5 5 20 8.75$ 174.93$

Rowley Callan 2 2 4 4 2 5 17 8.75$ 148.82$

Davis Chris 2 2 4 3 4 2 15 8.77$ 131.50$Penter Brian 4 4 3 4 3 4 18 8.79$ 158.27$Skavlan Travis 2 5 2 3 2 3 15 8.80$ 132.02$

Tate Meredith 4 2 5 4 3 2 16 8.83$ 141.30$Zahran Ibrahim 5 2 4 4 3 4 17 8.86$ 150.67$Dawes Kimberlee 5 5 4 2 3 4 18 8.87$ 159.59$Eskew Branden 5 5 3 3 2 5 18 8.87$ 159.61$Belcher Lance 3 2 3 3 3 3 14 8.89$ 124.45$

Pennington Anna 5 4 4 3 4 2 17 8.90$ 151.24$Horace Patrick 5 5 5 3 3 3 19 8.90$ 169.13$Beasley Jacob 2 2 2 5 4 2 15 8.93$ 133.94$

Croft Dustin 2 4 3 4 2 4 17 8.94$ 151.93$Yapp Austin 5 4 4 2 4 4 18 8.94$ 160.91$

Coburn Erica 3 5 4 2 4 4 19 8.96$ 170.23$Hamilton Zachary 4 2 3 5 2 3 15 8.97$ 134.48$

Fleming Andrea 2 4 4 2 3 2 15 8.97$ 134.57$Gildersleeve Kaitlyn 5 2 5 5 4 5 21 8.99$ 188.74$

AVERAGES 3.42 3.38 3.58 3.55 3.37 3.52 17.41 8.24$ 143.24$=AVERAGE(D21:D122)

=AVERAGE(E21:E122)

QUESTIONS

1. What is the total amount that I must pay in salary? 14,754.20$

2. Which student made the most money? Kathleen Wilson ($200.08)

3. Which student made the least money? Steven Richards ($96.14)

4. Which student has the highest hourly salary? Kaitlyn Gildersleeve ($8.99)

5. Which student has the lowest hourly salary? Ashley Canty ($7.04)




6/7

Microsoft Excel Functions Workbook, Volume 2.xls - BusinessMath2

Name:

Date:

Period:

BIZMATH

Syntax



Problem

You are placing a candy order for the members of your class.

1. Compute the total amount of money you need to collect from each class member.

2. Compute the number of bags of type of candy you must order.

3. ANSWER THE QUESTIONS AT THE BOTTOM; print your purchase order and submit it.

LastName FirstName Skittles Cost Per Bag M&M's Cost Per Bag Snickers Cost Per Bag Total Cost

EXAMPLE EXAMPLE 9 1.79$ 20 2.39$ 7 2.89$ 84.14$Canty Ashley 9 1.79$ 20 2.39$ 7 2.89$

Hamilton Daun 16 1.79$ 49 2.39$ 50 2.89$Lawrence Ashley 18 1.79$ 33 2.39$ 17 2.89$

Revell Erin 16 1.79$ 14 2.39$ 24 2.89$Smith Randall 32 1.79$ 32 2.39$ 33 2.89$

Srikeow Kevin 22 1.79$ 18 2.39$ 2 2.89$Messinger Maggie 35 1.79$ 7 2.39$ 24 2.89$DeCarolis Lisa 6 1.79$ 21 2.39$ 42 2.89$Bonney Melanie 20 1.79$ 13 2.39$ 19 2.89$

Tornatore Drew 7 1.79$ 40 2.39$ 48 2.89$Green Alyssa 29 1.79$ 9 2.39$ 5 2.89$Harris Thomas 14 1.79$ 28 2.39$ 42 2.89$

Schulman Brooke 11 1.79$ 11 2.39$ 12 2.89$

Barbour Claire 2 1.79$ 14 2.39$ 28 2.89$Stokes Brandon 24 1.79$ 8 2.39$ 10 2.89$

Van Rooyen Jan-Karl (JK) 9 1.79$ 19 2.39$ 28 2.89$Bufton Laura 37 1.79$ 2 2.39$ 27 2.89$

Shepard Taylor 5 1.79$ 3 2.39$ 40 2.89$Johns Eric 33 1.79$ 30 2.39$ 41 2.89$

Rostamy Brittanie 23 1.79$ 25 2.39$ 4 2.89$Markman Melanie 24 1.79$ 1 2.39$ 1 2.89$

Remter Clark 44 1.79$ 13 2.39$ 32 2.89$Kroswek Joshua 37 1.79$ 46 2.39$ 1 2.89$

Rice Sherri 42 1.79$ 21 2.39$ 22 2.89$Wagy Gregory 26 1.79$ 21 2.39$ 16 2.89$

Cooke Erick 49 1.79$ 12 2.39$ 15 2.89$

Dean Richard 11 1.79$ 15 2.39$ 35 2.89$Farley Nicholas 11 1.79$ 25 2.39$ 26 2.89$

Richards Steven 18 1.79$ 15 2.39$ 31 2.89$

Baker Justin 27 1.79$ 26 2.39$ 38 2.89$Foster Brent 1 1.79$ 26 2.39$ 41 2.89$

DeJager Michael 16 1.79$ 50 2.39$ 43 2.89$

Langston Lauren 4 1.79$ 4 2.39$ 10 2.89$Searan Wes 21 1.79$ 3 2.39$ 47 2.89$

Brennan Terrence 12 1.79$ 7 2.39$ 37 2.89$Gruner Isaac 19 1.79$ 36 2.39$ 42 2.89$

Montour Daphney 7 1.79$ 15 2.39$ 20 2.89$Newsome Shaneisa 21 1.79$ 14 2.39$ 10 2.89$Potteiger Aileen 44 1.79$ 9 2.39$ 12 2.89$

Dial Lauren 26 1.79$ 6 2.39$ 14 2.89$

Brown Sarah 37 1.79$ 21 2.39$ 8 2.89$Axford Michael 43 1.79$ 26 2.39$ 49 2.89$

Williams Jacob 2 1.79$ 44 2.39$ 6 2.89$Huguenard Nick 43 1.79$ 5 2.39$ 12 2.89$

Morton Grace 36 1.79$ 50 2.39$ 18 2.89$Chilvers Richard 23 1.79$ 46 2.39$ 46 2.89$Terrell Blake 8 1.79$ 10 2.39$ 39 2.89$Oswald Anna 16 1.79$ 49 2.39$ 14 2.89$

Barnett Brian 7 1.79$ 42 2.39$ 47 2.89$McTiernan Ross 45 1.79$ 15 2.39$ 30 2.89$

Cooler Taylor 47 1.79$ 27 2.39$ 50 2.89$Vargulic Kelly 26 1.79$ 17 2.39$ 11 2.89$

Roell David 31 1.79$ 47 2.39$ 22 2.89$Smith Ryan 39 1.79$ 35 2.39$ 22 2.89$Young Ann 38 1.79$ 10 2.39$ 28 2.89$

Terrell James 4 1.79$ 22 2.39$ 47 2.89$Taylor Benjamin 1 1.79$ 17 2.39$ 18 2.89$

McClain Ian 41 1.79$ 7 2.39$ 4 2.89$Rodgers Hillary 24 1.79$ 40 2.39$ 37 2.89$

Seaman Taylor 22 1.79$ 28 2.39$ 30 2.89$McMillen Gabrielle 7 1.79$ 42 2.39$ 32 2.89$

Diaz Juan 30 1.79$ 29 2.39$ 9 2.89$Wicker Brittany 6 1.79$ 19 2.39$ 28 2.89$

Young Danielle 3 1.79$ 34 2.39$ 36 2.89$Bouton Leah 30 1.79$ 11 2.39$ 8 2.89$

Becvarik Lisa 49 1.79$ 21 2.39$ 31 2.89$

Roy Brandon 18 1.79$ 1 2.39$ 29 2.89$Schultz Lacey 29 1.79$ 6 2.39$ 50 2.89$Losinger Sarah 27 1.79$ 12 2.39$ 17 2.89$Andrel Jenny 33 1.79$ 13 2.39$ 21 2.89$

Farrell Jessica 10 1.79$ 36 2.39$ 16 2.89$Edgecomb Jessica 23 1.79$ 29 2.39$ 45 2.89$Fishman Kaitlin 27 1.79$ 11 2.39$ 23 2.89$

Erbentraut Kristen 34 1.79$ 20 2.39$ 48 2.89$

Hiss Allison 29 1.79$ 10 2.39$ 23 2.89$Scoggan Michael 19 1.79$ 41 2.39$ 23 2.89$Sabbatino Ashley 33 1.79$ 41 2.39$ 25 2.89$Rodriguez Jalise 22 1.79$ 33 2.39$ 43 2.89$

Spies Jacki 12 1.79$ 2 2.39$ 12 2.89$Smith Kevin 19 1.79$ 10 2.39$ 30 2.89$Bolton Annie 39 1.79$ 20 2.39$ 30 2.89$Wilson Kathleen 7 1.79$ 17 2.39$ 32 2.89$

Shaw Sterling 33 1.79$ 46 2.39$ 27 2.89$Kellert Emily 40 1.79$ 38 2.39$ 4 2.89$Burke Johnathan 45 1.79$ 20 2.39$ 2 2.89$

Rowley Callan 49 1.79$ 5 2.39$ 3 2.89$

Davis Chris 28 1.79$ 34 2.39$ 13 2.89$Penter Brian 12 1.79$ 41 2.39$ 28 2.89$

Skavlan Travis 50 1.79$ 33 2.39$ 3 2.89$Tate Meredith 40 1.79$ 42 2.39$ 10 2.89$

Zahran Ibrahim 34 1.79$ 14 2.39$ 36 2.89$Dawes Kimberlee 18 1.79$ 48 2.39$ 38 2.89$Eskew Branden 22 1.79$ 49 2.39$ 30 2.89$

Belcher Lance 17 1.79$ 43 2.39$ 19 2.89$Pennington Anna 25 1.79$ 40 2.39$ 42 2.89$

Horace Patrick 25 1.79$ 11 2.39$ 49 2.89$Beasley Jacob 36 1.79$ 45 2.39$ 40 2.89$

Croft Dustin 40 1.79$ 37 2.39$ 21 2.89$Yapp Austin 34 1.79$ 15 2.39$ 47 2.89$

Coburn Erica 16 1.79$ 40 2.39$ 49 2.89$Hamilton Zachary 10 1.79$ 8 2.39$ 13 2.89$

Fleming Andrea 18 1.79$ 43 2.39$ 36 2.89$Gildersleeve Kaitlyn 22 1.79$ 6 2.39$ 33 2.89$

TOTALS N/A N/A N/A

QUESTIONS

1. How many bags of candy must we purchase to f ill this order?2. How much money would I save on this order if I found a supply of Skittles for $1.13 per bag?

3. How much money would I save on this order if I found a supply of M&M's for $1.67 per bag?4. Express the amount of money you would save in Question 2 as a percentage.5. Express the amount of money you would save in Question 3 as a percentage.




7/7

Microsoft Excel Functions Workbook, Volume 2.xls - BusinessMath2 (KEY)

Name:

Date:

Period:

BIZMATH

Syntax



Problem

You are placing a candy order for the members of your class.

1. Compute the total amount of money you need to collect from each class member.

2. Compute the number of bags of type of candy you must order.

3. ANSWER THE QUESTIONS AT THE BOTTOM; print your purchase order and submit it.

LastName FirstName Skittles Cost Per Bag M&M's Cost Per Bag Snickers Cost Per Bag Total Cost

EXAMPLE EXAMPLE 9 1.79$ 20 2.39$ 7 2.89$ 84.14$Canty Ashley 9 1.79$ 20 2.39$ 7 2.89$ 84.14$ =D21*E21+F21*G21+H21*I21

Hamilton Daun 16 1.79$ 49 2.39$ 50 2.89$ 290.25$Lawrence Ashley 18 1.79$ 33 2.39$ 17 2.89$ 160.22$

Revell Erin 16 1.79$ 14 2.39$ 24 2.89$ 131.46$Smith Randall 32 1.79$ 32 2.39$ 33 2.89$ 229.13$

Srikeow Kevin 22 1.79$ 18 2.39$ 2 2.89$ 88.18$Messinger Maggie 35 1.79$ 7 2.39$ 24 2.89$ 148.74$DeCarolis Lisa 6 1.79$ 21 2.39$ 42 2.89$ 182.31$Bonney Melanie 20 1.79$ 13 2.39$ 19 2.89$ 121.78$

Tornatore Drew 7 1.79$ 40 2.39$ 48 2.89$ 246.85$Green Alyssa 29 1.79$ 9 2.39$ 5 2.89$ 87.87$Harris Thomas 14 1.79$ 28 2.39$ 42 2.89$ 213.36$

Schulman Brooke 11 1.79$ 11 2.39$ 12 2.89$ 80.66$

Barbour Claire 2 1.79$ 14 2.39$ 28 2.89$ 117.96$Stokes Brandon 24 1.79$ 8 2.39$ 10 2.89$ 90.98$

Van Rooyen Jan-Karl (JK) 9 1.79$ 19 2.39$ 28 2.89$ 142.44$Bufton Laura 37 1.79$ 2 2.39$ 27 2.89$ 149.04$

Shepard Taylor 5 1.79$ 3 2.39$ 40 2.89$ 131.72$Johns Eric 33 1.79$ 30 2.39$ 41 2.89$ 249.26$

Rostamy Brittanie 23 1.79$ 25 2.39$ 4 2.89$ 112.48$Markman Melanie 24 1.79$ 1 2.39$ 1 2.89$ 48.24$

Remter Clark 44 1.79$ 13 2.39$ 32 2.89$ 202.31$Kroswek Joshua 37 1.79$ 46 2.39$ 1 2.89$ 179.06$

Rice Sherri 42 1.79$ 21 2.39$ 22 2.89$ 188.95$Wagy Gregory 26 1.79$ 21 2.39$ 16 2.89$ 142.97$

Cooke Erick 49 1.79$ 12 2.39$ 15 2.89$ 159.74$

Dean Richard 11 1.79$ 15 2.39$ 35 2.89$ 156.69$Farley Nicholas 11 1.79$ 25 2.39$ 26 2.89$ 154.58$

Richards Steven 18 1.79$ 15 2.39$ 31 2.89$ 157.66$

Baker Justin 27 1.79$ 26 2.39$ 38 2.89$ 220.29$Foster Brent 1 1.79$ 26 2.39$ 41 2.89$ 182.42$

DeJager Michael 16 1.79$ 50 2.39$ 43 2.89$ 272.41$

Langston Lauren 4 1.79$ 4 2.39$ 10 2.89$ 45.62$Searan Wes 21 1.79$ 3 2.39$ 47 2.89$ 180.59$

Brennan Terrence 12 1.79$ 7 2.39$ 37 2.89$ 145.14$Gruner Isaac 19 1.79$ 36 2.39$ 42 2.89$ 241.43$

Montour Daphney 7 1.79$ 15 2.39$ 20 2.89$ 106.18$Newsome Shaneisa 21 1.79$ 14 2.39$ 10 2.89$ 99.95$Potteiger Aileen 44 1.79$ 9 2.39$ 12 2.89$ 134.95$

Dial Lauren 26 1.79$ 6 2.39$ 14 2.89$ 101.34$

Brown Sarah 37 1.79$ 21 2.39$ 8 2.89$ 139.54$Axford Michael 43 1.79$ 26 2.39$ 49 2.89$ 280.72$

Williams Jacob 2 1.79$ 44 2.39$ 6 2.89$ 126.08$Huguenard Nick 43 1.79$ 5 2.39$ 12 2.89$ 123.60$

Morton Grace 36 1.79$ 50 2.39$ 18 2.89$ 235.96$Chilvers Richard 23 1.79$ 46 2.39$ 46 2.89$ 284.05$Terrell Blake 8 1.79$ 10 2.39$ 39 2.89$ 150.93$Oswald Anna 16 1.79$ 49 2.39$ 14 2.89$ 186.21$

Barnett Brian 7 1.79$ 42 2.39$ 47 2.89$ 248.74$McTiernan Ross 45 1.79$ 15 2.39$ 30 2.89$ 203.10$

Cooler Taylor 47 1.79$ 27 2.39$ 50 2.89$ 293.16$Vargulic Kelly 26 1.79$ 17 2.39$ 11 2.89$ 118.96$

Roell David 31 1.79$ 47 2.39$ 22 2.89$ 231.40$Smith Ryan 39 1.79$ 35 2.39$ 22 2.89$ 217.04$Young Ann 38 1.79$ 10 2.39$ 28 2.89$ 172.84$

Terrell James 4 1.79$ 22 2.39$ 47 2.89$ 195.57$Taylor Benjamin 1 1.79$ 17 2.39$ 18 2.89$ 94.44$

McClain Ian 41 1.79$ 7 2.39$ 4 2.89$ 101.68$Rodgers Hillary 24 1.79$ 40 2.39$ 37 2.89$ 245.49$

Seaman Taylor 22 1.79$ 28 2.39$ 30 2.89$ 193.00$McMillen Gabrielle 7 1.79$ 42 2.39$ 32 2.89$ 205.39$

Diaz Juan 30 1.79$ 29 2.39$ 9 2.89$ 149.02$Wicker Brittany 6 1.79$ 19 2.39$ 28 2.89$ 137.07$

Young Danielle 3 1.79$ 34 2.39$ 36 2.89$ 190.67$Bouton Leah 30 1.79$ 11 2.39$ 8 2.89$ 103.11$

Becvarik Lisa 49 1.79$ 21 2.39$ 31 2.89$ 227.49$

Roy Brandon 18 1.79$ 1 2.39$ 29 2.89$ 118.42$Schultz Lacey 29 1.79$ 6 2.39$ 50 2.89$ 210.75$Losinger Sarah 27 1.79$ 12 2.39$ 17 2.89$ 126.14$Andrel Jenny 33 1.79$ 13 2.39$ 21 2.89$ 150.83$

Farrell Jessica 10 1.79$ 36 2.39$ 16 2.89$ 150.18$Edgecomb Jessica 23 1.79$ 29 2.39$ 45 2.89$ 240.53$Fishman Kaitlin 27 1.79$ 11 2.39$ 23 2.89$ 141.09$

Erbentraut Kristen 34 1.79$ 20 2.39$ 48 2.89$ 247.38$

Hiss Allison 29 1.79$ 10 2.39$ 23 2.89$ 142.28$Scoggan Michael 19 1.79$ 41 2.39$ 23 2.89$ 198.47$Sabbatino Ashley 33 1.79$ 41 2.39$ 25 2.89$ 229.31$Rodriguez Jalise 22 1.79$ 33 2.39$ 43 2.89$ 242.52$

Spies Jacki 12 1.79$ 2 2.39$ 12 2.89$ 60.94$Smith Kevin 19 1.79$ 10 2.39$ 30 2.89$ 144.61$Bolton Annie 39 1.79$ 20 2.39$ 30 2.89$ 204.31$Wilson Kathleen 7 1.79$ 17 2.39$ 32 2.89$ 145.64$

Shaw Sterling 33 1.79$ 46 2.39$ 27 2.89$ 247.04$Kellert Emily 40 1.79$ 38 2.39$ 4 2.89$ 173.98$Burke Johnathan 45 1.79$ 20 2.39$ 2 2.89$ 134.13$

Rowley Callan 49 1.79$ 5 2.39$ 3 2.89$ 108.33$

Davis Chris 28 1.79$ 34 2.39$ 13 2.89$ 168.95$Penter Brian 12 1.79$ 41 2.39$ 28 2.89$ 200.39$

Skavlan Travis 50 1.79$ 33 2.39$ 3 2.89$ 177.04$Tate Meredith 40 1.79$ 42 2.39$ 10 2.89$ 200.88$

Zahran Ibrahim 34 1.79$ 14 2.39$ 36 2.89$ 198.36$Dawes Kimberlee 18 1.79$ 48 2.39$ 38 2.89$ 256.76$Eskew Branden 22 1.79$ 49 2.39$ 30 2.89$ 243.19$

Belcher Lance 17 1.79$ 43 2.39$ 19 2.89$ 188.11$Pennington Anna 25 1.79$ 40 2.39$ 42 2.89$ 261.73$

Horace Patrick 25 1.79$ 11 2.39$ 49 2.89$ 212.65$Beasley Jacob 36 1.79$ 45 2.39$ 40 2.89$ 287.59$

Croft Dustin 40 1.79$ 37 2.39$ 21 2.89$ 220.72$Yapp Austin 34 1.79$ 15 2.39$ 47 2.89$ 232.54$

Coburn Erica 16 1.79$ 40 2.39$ 49 2.89$ 265.85$Hamilton Zachary 10 1.79$ 8 2.39$ 13 2.89$ 74.59$

Fleming Andrea 18 1.79$ 43 2.39$ 36 2.89$ 239.03$Gildersleeve Kaitlyn 22 1.79$ 6 2.39$ 33 2.89$ 149.09$

TOTALS 2481.00 N/A 2435.00 N/A 2688.00 N/A 18,028.96 $

QUESTIONS

1. How many bags of candy must we purchase to f ill this order? 7604 =SUM(D124,F124,H124)2. How much money would I save on this order if I found a supply of Skittles for $1.13 per bag? 1,637.46$ =D124*E123-D124*1.13

3. How much money would I save on this order if I found a supply of M&M's for $1.67 per bag? 1,753.20$ =F124*G123-F124*1.674. Express the amount of money you would save in Question 2 as a percentage. 37% =(D124*E123-D124*1.13)/(D124*E123)5. Express the amount of money you would save in Question 3 as a percentage. 30% =(F124*G123-F124*1.67)/(F124*G123)



microsoft excel functions workbook, volume 2 (free preview)

Documents