In: Computers and Technology

Submitted By whitewolff
Words 1723
Pages 7
Spreadsheet Exercises
The exercises below are to introduce concepts and features of a spreadsheet program such as Excel. Please note that there are alternative ways of creating a solution and your solution may be different from others.
Single argument and user developed functions
The table lists some functions that are commonly used in basic spreadsheet applications

function | purpose | =sum(B12:B18) | Add contents of range in B12 to B18 | =average((B12:B18) | Average the range | =count((B12:B18) | Count non zero values | =max(B12:B18) | Display the largest value | =min(B12:B18) | Display the smallest value | =B4*C4 | Multiplies the values | This is not an exhaustive list. See Excel menu command fx for a complete list of functions | User created | (…)+-*/^ | Mathematic operations brackets sum, subtract, multiplydivideexponentiation (power)=(3*(A5+B5)-C5)/2+D5^1.5 |
Exercise 1
Example 1 Kroenke p 387

Example 2
The table shows green grocery sales for a four quarter period

Weight of each sold (kg) | | oranges | apples | bananas | QTR1 | 237 | 215 | 125 | QTR2 | 211 | 341 | 228 | QTR3 | 312 | 418 | 421 | QTR4 | 432 | 121 | 121 |

Using features of Excel and including any additional rows or columns you may need, calculate the following: 1. The total weights sold for each fruit for the four quarters
The average quarterly sales for each fruit 2. The average selling price/kg for each fruit is $3.25 for oranges, $4.99 for apples and $15.25 for bananas, Revenue from each product | | oranges | apples | bananas | QTR1 | | | | QTR2 | | | | QTR3 | | | | QTR4 | | | |

3. calculate the revenue earned for: i. Each type of fruit ii. Quarterly revenue earned iii. Total amount earned
If the cost price/kg is $2.15/kg for oranges, $2.50/kg for apples and $6.99 for bananas, determine the…...

Similar Documents


...THE INFLUENCE OF SOCIAL NETWORKING SITES ON THE READING INTEREST OF FOURTH YEAR HIGH SCHOOL STUDENTS IN MABINI COLLEGES A Research Paper Presented to Jamila M. Macapundag Instructor, English 2 Mabini Collges Daet, Camarines Norte In Partial Fulfillment of the Requirements for English 2 Writing in Discipline By: Michelle O. Ojo Lizel I. Calderon James Paolo B. Belgica December 17, 2011 Chapter 1 THE PROBLEM AND ITS SETTING Introduction Social Networking Sites (SNS) are of the most popular topics being talked by all the people. Examples of Social Networking Sites are Facebook, Twitter, Friendster, Yahoo Messenger, Plurk, Tumblr. Social Networking Sites help us to communicate with our friends, classmates, and relatives but they also allow us to communicate with other people who share common interests with us. Through these SNS, how it will affect the reading interest of fourth year high school students in Mabini Colleges. Social network theory differs from traditional sociological studies. In traditional theories, attributes of individual actors are assumed to matter the most. Social network theory takes a different approach, where individual attributes are less important than their relationships and ties with others within the network1. As the world becomes more complex reading interest is in increasingly important to individuals today than ever. It is vital to be informed, to succeed and to be fulfilled personally. When a child has no......

Words: 3135 - Pages: 13


...Introducing the “Seven Habits of Highly Effective Teens” (by Sean Covey) Habit 1 – Take responsibility for your life (Be Proactive) Defective Habit: Be Reactive Blame all of your problems on your parents, your stupid teachers, your lousy neighborhood, your boy-or girlfriend, the government, or something or somebody else. Be a victim. Take no responsibility for your life. Act like an animal. If someone yells at you, yell back. If you feel like doing something you know is wrong, just do it. ( in the book the Covey talks about humans having self-awareness, a conscience, an imagination whereas animals do not – there is a nice example comparing a dog’s thoughts to a human’s thoughts) Effective Habit: Be Proactive I am the force. I am the captain of my life. I can choose my attitude. I am responsible for my own happiness or unhappiness. I am in the driver’s seat of my destiny, not just a passenger. Scene One: You overhear your best friend bad-mouthing you in front of a group. She doesn’t know you overheard the conversation. Just five minutes ago, this same friend was sweet-talking you to your face. Reactive Choices 1. Tell her off and then smack her. 2. Go into a deep depression because you feel so bad about what she said. 3. Decide that she is a two-faced liar and give her the silent treatment for 2 months. 4. Spread vicious rumors about her. After all, she did it to you. Proactive Choices 1. Confront her and calmly......

Words: 617 - Pages: 3


...Escudero Sponholtz José Antonio Logística Internacional 1:00 – 1:50 pm Escudero Sponholtz José Antonio Logística Internacional 1:00 – 1:50 pm Puertos marítimos Mexicanos. Puertos marítimos Mexicanos. * Introducción. Introducción. ¿Qué es un puerto? L a Real Academia Española, nos define un puerto como el lugar en la costa o en las orillas de un río que por sus características, naturales o artificiales, sirve para que las embarcaciones realicen operaciones de carga y descarga, embarque y desembarque. * ¿Cuál es su importancia? L a importancia de los puertos reside en la conexión que ofrecen al Comercio Internacional desde el inicio de las prácticas del mismo, a pesar de que hoy en día exista un medio competente al marítimo para conectar territorios divididos por cuerpos de agua, el medio marítimo, sigue siendo óptimo en condiciones de costos y de capacidad de carga de mercancías en cuanto a volumen y de peso.  Son ejes claves en las operaciones de la Cadena Logística y dada sus características, se valora el nivel de accesibilidad y conectividad que comporta su grado de articulación con el comercio y las relaciones internacionales. * ¿Cuáles son los puertos más importantes en la actualidad? Singapur | Singapur | Shangai | China | Shenzhen | China | Hong Kong | China | Busan | Corea del Sur | Rotterdam | Países Bajos | Dubái | Emiratos Árabes | Kaohsiung | China | Hamburg | Alemania | Qingdao | China | Un poco de......

Words: 5754 - Pages: 24


...Danielle Justine Primeau 225 N Park Ave Tucson, AZ 85719 Mrs. Wen Chi Chien Manger of Human Recourses Zen Institute 5210 E. Pima, Suite 110 Tucson, AZ 85712 June 17, 2023 Dear Mrs. Chien, I am applying for the position of an art therapist, which was presented to me by the Zen Institute web site. I believe that with my set of skills, experience, and education I will be a good match for you and your institute. To be an art therapist you must have experience and education in the art field. I began my art experience at my high school (North Warren Central School). There I took all of the art classes available (studio art, Drawing and painting, advanced drawing and painting, sculpture, pottery, Independent portfolio, and a full year of photography). I did this throughout 7th grade to 12th. I also took an art class online through virtual high school programs and excelled thought the course. After college I then set off to work at Scottsdale Hospital in Arizona. At Scottsdale I gained much experience working with younger adults and helping them relieve their stress. I have helped many people using my art methods at Scottsdale and I hope to help your patients too. I have had the experience and education needed to gain this position. I have been a student of Russell Sage Colleges for 6 years now and I have been experienced in art therapy for a while now. I believe that my education could benefit the Zen Institute. I have my...

Words: 327 - Pages: 2


...Acknowledgments Portions of this Apple Software may utilize the following copyrighted material, the use of which is hereby acknowledged. Beman Dawes ( Boost ) Copyright © 2003 Beman Dawes ( Boost ) Boost Software License - Version 1.0 - August 17th, 2003 Permission is hereby granted, free of charge, to any person or organization obtaining a copy of the software and accompanying documentation covered by this license (the "Software") to use, reproduce, display, distribute execute, and transmit the Software, and to prepare derivative works of the Software, and to permit third-parties to whom the Software is furnished todo so, all subject to the following: The copyright notices in the Software and this entire statement, including the above license grant, this restriction and the following disclaimer, must be included in all copies of the Software, in whole or in part, and all derivative works of the Software, unless such copies or derivative works are solely in the form of machine-executable object code generated by a source language processor. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR ANYONE DISTRIBUTING THE SOFTWARE BE LIABLE FOR ANY DAMAGES OR OTHER LIABILITY, WHETHER IN CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE......

Words: 7898 - Pages: 32


...Coco Q: How does the character of Jack help bringing out the comical aspect of the other characters (Algernon, Lady Bracknell and Gwendolen) in act 1? Jack, as the central character of the play, plays an important role of comic-bringer. His characteristics, quotes, even his deceptions all entertain the readers, and helps the readers to explore the comical aspects of other characters as going through Act 1 deeper and further. At the very beginning of Act 1, Jack starts to bring out the comical aspects of Algernon as he visits Algernon’s house and tells him that he’s going to propose to Gwendolen. As Jack said “I have come up to town expressly to propose to her.”, Algy denies his opinion with a scornful and playful tone “I thought you had come up for pleasure? I call that business.” “I really don’t see anything romantic in proposing… If I get married, I’ll certainly try to forget the fact.” Algernon’s opinion towards marriage is desperate and absurd. However, Jack’s viewing on the opposite, and revealingly complaining “How utterly unromantic you are!” These two young men’s different view on marriage creates strong sense of humor, their arguments towards marriage also bring their comical aspects to the audience. Another comical aspect of Alernon is when he’s eating the cucumber sandwiches, which were prepared for Lady bracknell, he stopped Jack from taking one of the sandwiches, and suggested him to take some bread and butter. When Jack was puzzled, and asked for the reason,...

Words: 655 - Pages: 3


...Andreia Isabela P. Dita F2-6 Reaction Paper Farsighted Purpose “Interior Design” is a segment of a three-film movie directed by Michel Gondry. (Dagdagan pa about sa director). The story begins with the arrival of a young filmmaker, Akira and his girlfriend, Hiroko in Tokyo, Japan to find stable careers. Akemi, Hiroko's old friend, gave a hand and offered them her apartment until they have enough money to accommodate for their own. As Akira starts to become obsessed with his ambition to become a successful filmmaker, it's Hiroko who is having a hard time in knowing her purpose and goals in life. Until one morning she woke up with a very strange physical changes that made the story unusual and extraordinary. The story shows an economic issue that gives me the idea of what it feels like to be a “small fish in a big pond”. When the young couple moved to Tokyo, they struggled in coping up with how people live there. Because they don't have enough money to accommodate their own apartment, Akira and Hiroko searched for a part-time job. But sadly, it was Akira who was hired at the wrapping store. This pushed Akira to do his best and earn money for them to put up their own apartment and for their future. He used his job as a stepping stone in reaching his dream of becoming successful filmmaker and also proved that he can also be one of those successful filmmakers in Tokyo. Social issue was also tackled in the film. There was a part when Hiroko heard Akemi and her......

Words: 730 - Pages: 3


... "You are so sweet you could put Hershey’s out of business." Every woman wants to know that she is sweet. This line tells her she is sweet than chocolate. There is nothing sweeter than that. That is a very flattering pickup line.  "Whenever I think of the finer things in life, I think of expensive cars, fine wine…and you." If you tell her that is considered a fine thing in your life, you are going to get major points with her. It is very sweet and flattering.  "They must have been crazy to let an angel as beautiful as you out of heaven. " If you let her know that you think she is as beautiful as an angel, that is saying a lot. Making her feel like a beautiful angel will make you seem like the sweetest man. Very flattering and sweet pickup line.  "Your father must have been an alien because there is nothing else like you on this earth." Every woman wants to think she is one of a kind. If you tell her there is nobody on this Earth that compares to her, she will swoon. This is something she will never forget.  "You know, you might be asked to leave soon. You are making the other women look really bad." When a woman is in a room with other women, she wants to look the best. If you tell her she is making other women look bad, that is the ultimate compliment. A woman is always going to love you telling her she is more beautiful than other women.  "I never believed in heaven until I saw you." This is a very sweet and flattering pickup line. Letting her know that she...

Words: 524 - Pages: 3


...My portfolio in elementary algebra Submitted By: Valenzuela city science high school Submitted to: Mr.timothy a. acana Linear equations in two variables Forms for 2D linear equations Linear equations can be rewritten using the laws of elementary algebra into several different forms. These equations are often referred to as the "equations of the straight line." In what follows, x, y, t, and θ are variables; other letters represent constants (fixed numbers). General form where A and B are not both equal to zero. The equation is usually written so that A ≥ 0, by convention. The graph of the equation is a straight line, and every straight line can be represented by an equation in the above form. If A is nonzero, then the x-intercept, that is, the x-coordinate of the point where the graph crosses the x-axis (where, y is zero), is −C/A. If B is nonzero, then the y-intercept, that is the y-coordinate of the point where the graph crosses the y-axis (where x is zero), is −C/B, and the slope of the line is −A/B. Standard form where A and B are not both equal to zero, A, B, and C are coprime integers, and A is nonnegative (if zero, B must be positive). The standard form can be converted to the general form, but not always to all the other forms if A or B is zero. It is worth noting that, while the term occurs frequently in school-level US algebra textbooks, most lines cannot be described by such equations. For instance, the line x + y = √2 cannot be described by a......

Words: 1226 - Pages: 5


...Tutorial 2 Question: As a newly-appointed Project Manager of a research team, you believe that you will be able to manage the project virtually from your office in London, even though the other six members are located in Munich. This will solve your personal dilemma as your family does not want to be relocated. The project has a six-month deadline. What factors should you consider in order to make this virtual assignment effective? Answer: First of all, virtual assignments is where the employees and managers are located in different areas as in this case, the Project Manager’s office is in London whereas the other six team members are in Munich. Thus, the Project Manager has to rely heavily on communication technologies such as telephone, email or video conference. In my opinion, the factors that has to be taken into consideration include effective use of technology, invest time in building relationships and trust, provide specific intercultural training and arrange face-to-face meeting occasionally. To bring a success to virtual assignments, I will need to be aware of the full range of technology tools available to us and become practices and proficient in their use. Without familiarizing the technology, it is difficult for managers to keep in touch with the team and it might end up slowing down the team performance. For instance, it will be a waste of time discovering the function of Skype tools during the virtual meeting. Besides that, as a newly-appointed......

Words: 491 - Pages: 2


...N9-512-011 SEPTEMBER 6, 2011 THALES S. TEIXEIRA ALISON CAVERLY Pepsi-Lipton Brisk In September 2010, Mary Barnard and Marisol Tamaro returned to their offices at Pepsi Headquarters after a meeting with their new advertising agency, Mekanism. One month ago, Mekanism had been hired to work on the re-launch of Brisk Iced Tea, a brand that had had its glory days in the ‘90’s and then later had become stagnant. As of 2009, Brisk had a 10% market share in the fast growing ready-to-drink tea category, despite having virtually no advertising support. Mekanism presented four concepts created for a television commercial, one of which had to be chosen to be produced for the 2011 Super Bowl. But what really made Barnard and Tamaro ponder was the agency’s proposal to create additional versions of the same ad concept and launch them online, without purchasing media space, and instead leverage the power of social media to disseminate the ads on the web. Barnard, Vice President at PepsiCo and the General Manager of the Pepsi-Lipton Tea Partnership (PLP), owner of Brisk, was in charge of the final decision and conferred with Tamaro, Brand Building Director for Brisk, on what to do. With only a few months to produce the Super Bowl ad and create a campaign around it to support the re-launch of Brisk, time was running out and a decision needed to be made. “We don’t have time to do copy testing of the concepts,” explained Tamaro. And despite a few attempts within Pepsi to......

Words: 9051 - Pages: 37


...Chris Richard A. Bencio Sept. 14,2015 John Michael Betonio TH11R MW(9:00-10:30 A.M) RA 1024/ Health Promotion of Workers This act is about on how to promote workers regarding their health. Every workers should need to be healthy and capable in doing their jobs which is essential for the emplyers and also for the employees. That’s why a workers health can affect their performance especially in their work, employers should care for their workers and know if they’re okay or not which can build a bond to you and to your workers. This act also plans to develop health education and disease management programs that encourage the workers to take responsibility for their own health. This act let the employers should give their workers what they need that can distribute health and safety information regulary, along with appropriate protective equipments for them to maintain their heath safety. RA 3601/ Prevention of Occupational Diseases RA 3601 well this act talks about the concerned with the safety,health and welfare of the people that engaged in their work or employment. It also includes to inhibit safe and healthy workplace or a clean environment. Workplace should need to have a clean or healthy environment so that the workers will enjoy working their jobs and it can also promotes their company’s workplace health safety to their workers and for the future applicants. RA 1234/ Roles and Responsibilities of Occupational Health Professionals This acts observes......

Words: 913 - Pages: 4


...Lalala without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completely without life completelywithout life completely without life completely witout life completelywithout life completel without life complete without life completely without life completely without life completely without life completely without life completelyv without life completely without life completely without life completely withou t life completely without life completely without life completely without life completely without life completelyv without life completely without life completely without life completely withou t life completely without life completely without life completely without life completely without life completely without life completelyv without life completely without life completely without life completely withou t life completely without life completely without life completely without life completely without life completelyv without life completely without life completely without life completely withou t life completely without life completely without life completely without life completely without......

Words: 341 - Pages: 2


...G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg gg g g g gg gg ggg g gg ggggg G G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg gg g g g gg gg ggg g gg ggggg G g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg g g g g g g g g g g g gg g g ggggg g gg g g g gg gg ggg g gg ggggg ...

Words: 487 - Pages: 2


...Alexis Brown Mrs. Persichetti Chemistry 02 May 2011 Global Warming The Earth is warming and human activity is the primary cause. Climate disruptions put our food and water supply at risk, endanger our health, jeopardize our national security, and threaten other basic human needs. Impacts such as: record high temperatures, melting glaciers, and severe flooding and droughts, are becoming increasingly common around the world. In the movie, An Inconvenient Truth, Al Gore discusses his efforts to make the issue of global warming a recognized problem worldwide. Al Gore, former U.S. Vice President, clearly states the current issues with the planet and explains if no changes are made soon, it will lead to disaster. In the beginning of Al Gore’s presentation, he displays one of the first pictures of earth from space; the moonlight provided enough light to be able to see a crisp and distinct picture of earth’s spherical shape. Topics such as: Infrared radiation, high temperatures and Carbon Dioxide remained the key points throughout the documentary. Infrared radiation, above average temperatures, and Carbon Dioxide are all causes or effects of global warming. Not only is infrared radiation harmful to the earth, but it can be beneficial as well. The same infrared radiation that destroys the beautiful ice caps in the artic is also responsible for keeping the earth's temperature relatively constant over time. The amount of Carbon Dioxide (CO2) intake has literally topped the charts....

Words: 669 - Pages: 3