...1 Microsoft Excel 2010 Tutorial Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts. The Ribbon Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features. Home Tab This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style. Insert Tab This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers. Page Layout Tab This tab has commands to adjust page such as margins, orientation and themes. Created By: Amy Beauchemin Source: office.microsoft.com 1/13/11 2 Formulas Tab This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any formula or function...
Words: 7496 - Pages: 30
...Constructing Formulas for Mathematical Operations in Excel (Basic Tips and Techniques) Michelle A. Applequist Computer Information Systems (CIS105) Professor Hari Dhungana Strayer University September 1, 2009 Constructing Formulas for Mathematical Operations in Excel Microsoft Excel uses formulas to construct mathematical operations in a worksheet. After data have been entered into the worksheet, you can perform calculations, analyze data, and create charts. An Excel formula (calculations you create) and functions (formulas pre-existing in Excel) calculates the data entered in the worksheet. Formulas calculate numbers in a particular order. “Excel has one of the most comprehensive set of formulas, not only to perform calculations but also to manage data and records. It also has the ability to instantaneously re-calculate the results as the raw data changes” (Khoo, 2006-9, para. 2). To construct a formula after you have entered data, you must click in the cell that you want the results to appear in, and then type the formula. You can construct formulas by using the sum function, and editing numbers in a cell. It is stated that: Sum is an Excel function—a prewritten formula. Sum indicates the type of calculation that will take place (addition). When the sum function is activated, Excel looks above the active cell for a range of cells to sum. If there is no range above the cell, Excel will look to the left for a range of cells to sum...
Words: 694 - Pages: 3
...+ 0.35 - 0.20 = 0.7 For any two event X and Y with P(Y) ≠ 0, the condition of probability of X given Y is as follows: P( X ∩ Y ) = P(Y | X) x P(X) = 0.40 x 0.75 = 0.3 a. P(A1) = 3/10 = 0.3 The probability of P(A1) is 0.3/10 b. P(B1/A2) = 2/6 / 1/3 = 0.33/0.33 = 1 The probability of P(b1/A2) is 1/10 c. P(B0/A0) = 0/0 = 0 The probability of P(b0 and A0) is zero 44. Berdine’s Chicken Factory has several stores in the Hilton Head, South Carolina, area. When interviewing applicants for server positions, the owner would like to include information on the amount of tip a server can expect to earn per check (or bill). A study of 500 recent checks indicated the server earned the following amounts in tips per 8-hour shift. Amount of Tip Number $0 up to $ 20 200 20 up to 50 100 50 up to 100 75 100 up to 200 75 200 or more 50 Total 500 a. What is the probability of a tip of $200 or more? .10 or 10% b. Are the categories “$0 up to $20,” “$20 up to $50,” and so on considered mutually exclusive? They are mutually exclusive because the 0-20 does no effect on the 20-50 group. One group has no causal...
Words: 477 - Pages: 2
...Simon sometimes tastes or senses the medication in his food and spits them out, but sometimes the medication goes undetected. He always wonders why he feels tired most of the time without doing any activities that may cause such feelings. Covert medication is described by Kala (2012, p. 1) as, ‘the practice of hiding medication in food or beverages so that it goes undetected by the person receiving the medication.’ Latha (2010) states that covert medication is one of the greatest challenges for healthcare professionals. The report goes on to state that healthcare professionals often covertly medicate service users because they refuse to take their prescribed medication when offered. In addition, the Royal College of Psychiatrists (2011) reported...
Words: 265 - Pages: 2
...I believe that being a Resident Assistant is far more than just a job that requires monitoring a floor or even unlocking doors, those things are only the tip of the iceberg. To be a Resident Assistant means to be a role model, an advisor, a therapist, a problem solver, and a great deal of other responsibilities are expected of such a person. Even though this is my first semester at Governors State University and I am considered a new student here, I am not new to college. My first experience with learning what a Resident Assistant was, was when I attended SIU in Edwardsville, during my freshman year of college. My RA that year was very personable and down to earth. She made certain hours throughout the day available in her room, if a student needed to ask questions, share comments, or even make suggestions. She also hosted different miniature gatherings on the floor, so we could get to know our fellow peers. Those encounters with my RA at the time, inspired me to want to be in a position where I could contribute to or even create that same environment for other students. When I saw the opportunity posted to become a Resident Assistant at GSU, I was eager to apply. I feel that my personal experiences and challenges I have faced during my years of college and the way I have recovered from those experiences, shows adversity, goal-orientation, and determination. I am willing to shed light on those experiences and help other incoming students who may struggle with getting acclimated...
Words: 462 - Pages: 2
...bambooimport.com A short film commissioned by INBAR for the World Expo in Shanghai, profiling bamboo - and its many innovative uses as a strong, lightweight, sustainable, carbon capturing material, including surfboards, bikes and building materials. The challenges we face today is to further improve and innovate the uses of bamboo. Since bamboo is the fastest growing plant on earth and a sustainable building material, it could easily substitute all known wood applications without having to cut down entire bamboo groves or plantations. Better yet, bamboo continuously grows after harvest without having to re-plant it. Bamboo also converts about 35% more CO2 into oxygen than a regular tree. The bamboo products we see on the market today, are just the tip of the iceberg, we predict that more and more innovative bamboo applications will enter the consumer markets rapidly. Therefore it is an exciting era to live in if you are also a firm believer of how bamboo can contribute to a greener and cleaner environment. We can't change our consumption based economy, but we can certainly change the resources we use and the way we manufacture our products! Below is a list of common uses for bamboo. Please note that not all bamboo species are suited for every single application. Some species are edible while most are not, some can be used as structural timber while other only...
Words: 357 - Pages: 2
...The tip that I learned in the video that will help me and my classmates to be successful at University of Phoenix are very helpful, I learned a lot that I didn’t know just watching the videos, a lot of helpful information became clear to me, however I do realize I still have a lot to learn, and it can be overwhelming to try and keep everything all at one time, but I am still hopeful. The Introduction video I learned the difference and the importance of the Forums, also the importance of the Syllabus and materials to stay organized. The Classroom: I learned the importance of the Course Outline to help me organize my week, also I learned that I can go here to obtain the week by week to do list. I learned how important it is to view each link and the policies which apply to all classes, also the Tutorial are available to me. And that I should read over the objectives. Discussion: Main Forum is where I discuss course topics with my classmates, and the importance of keeping the topic related to the topic or reply. Assignments: Are the most important part of our grades. I learned that I can view and submit my assignments from anywhere. And all the weekly assignment is at my fingertip. I learned where to go to see what I submitted so for and where to find my grades, also I learned about the success message. The Online Library: I learned about the different resources. The Center for Writing Excellence in order to help perfect a paper I will be asked to write...
Words: 315 - Pages: 2
...Assume that dispense of the gum/glue is done automatically when it comes under the contact of the objects. For appropriate amount of glue to be applied, the robot should run at a constant speed of 200m/s during application. Before doing that the tip of the robot should be filled with glue at filling station/part. For this wait 10 seconds at the filling station and precautions should be taken so that the tip doesn’t get bend or brake while dipping the tip inside the object. Basic terminology Movie J – This command is used when the tip of the robot arm moves from one object to another in an undefined manner. The robot is designed in such a manner that it will try to take the shortest path possible to reach its destination. Move L – This command is used when the user wants the tip of the robot to follow a linear path. It’s specially used when the object tends to be more complicated or the user is taking some precautions from random movement of the tip normally when moving along the edges of the object. Move C – This code is used when the users wants the tip of the robot to move in a curve manner of the object. It is done in a way that three points are defined and then the tip of the robot assume that as a...
Words: 1264 - Pages: 6
...Tho Pham ESL 51 First Draft Tip or Not? It is a beautiful Sunday night; your family chooses a famous Italian restaurant in the area to have dinner. As you are very pleased with the service, you decide to write down 20% of the bill to give to the waitress as tips. This happens every day around the country. Although there are some dissidents of this long-standing tipping custom whose reason is tipping provokes conflict between servers, tipping should continue because it gives servers an incentive to work hard. In America’s restaurants, the custom is giving a 15% tip (To Insure Promptitude) to the servers. Every year 42 billion dollars of tips were granted to American servers, whose income greatly depends on tips. Recently a manager of a famed California restaurant, Jay Porter, decided to prohibit tipping. The price then included the tip, which is 18%, 15% of which belonged to the servers and the rest went to the kitchen staff. Research reveals that 80% of American diners favor tipping as they think tips incentivize servers to do good service and they feel guilty being served. From 10% in the early 20th century, the tipping rate has increased to18.9% today. While most of Mr. Porter’s customers accept the new policy, very few diners were still obliged to tip and that money went to the charity. Nonetheless, Porter’s restaurant is the only pioneer in the area and it will not likely draw many followers. Some opponents of tipping say that tipping does not create incentive but...
Words: 572 - Pages: 3
...Darria Nance Mrs. Hake English 111 26 April 2015 Essay 4. Restaurant Review Erio's Restaurant Review Erio's restaurant is located in Woodson Square, 4434 Woodson Rd, St. Louis, Mo. 63134. It is a small, friendly restaurant that is quiet easy to miss except for it's huge sign in the parking lot. It's the perfect place to dine if you like Italian cuisine. It sits just across from Columbia College and is convenient for the campus students and staff. It's interior is gorges with its vintage type theme in the artwork that hangs on the walls. The restaurant buzzed with excitement and energy and quickly filled with seemingly satisfied customers. The noise level was appropriate for the number of guest that were in pleasant conversation. This restaurant was a selection of ours as we were given the task of performing a restaurant review. Our party of guests was a large one of about 10-12 including our English Professor Mrs. Hake. We were accommodated by tables that were neatly joined together with decorative cloths. The waitress introduced herself and offered drinks as we awaited the arrival of the rest of our party. I couldn't help but notice how clean the restaurant was and that the aroma was that of Italian seasoning. Silverware sat at your elbows neatly wrapped besides the menu that was placed at my fingertips. There were several selections ranging from Pizza, soup, salad and sandwiches, stuffed pasta, and baked entrees. My selection was the baked mostaccioli with the...
Words: 496 - Pages: 2
...Bojangles, it’s a new restaurant in the neighborhood, which on the recommendation of a friend are planning to go dine a group of friends and me. I have great interest in this restaurant because after reading an article in the Daily Disappointment I was fascinated. After analyzing all options menu, the choices of drinks, desserts options and options for the tip. I concluded that I have a wide variety of options for choosing many of which are very similar in cost. Background Because we do not know the total amount of budget you have to spend that night, but what if I am sure it is a night where the costs are not so high. What I have done is a graph which is detailed each of the options for dinner that night; I have detailed each option for each meal, for each drink, for each dessert and for each tip. I need to figure out your costs depending on the decisions that I make. For instance: 1. Do I have a drink before dinner – accost; or do I not – a savings? 2. Do I have a drink at dinner – a cost or a savings? 3. Which entrée do I select – each with a cost? 4. Which dessert do I select – each with a cost? 5. How much do I tip the wait staff? These are the points I have to take into account to make the best decision and the best option, I know what I’ll pick the best because with the recommendations and what I read in this restaurant the food is very good, now what needed is to choose the menu and have a good cost. Decision In the tree I have detailed all the possible options...
Words: 451 - Pages: 2
...her, one hand gently trailing up her side outlining her soft curves, moves her hair to the sides and leans in kissing her neck softly while whispering "thanks for the tip sexy" while her other hand slides around her waist and grips her ass tight hops off her pole floats across the stage around Lizzy, nibbleing her sweet tender ears tugs it playfully whraping my leg around her sweet tender wasit pulls her closer “mmmm.rawr...” trailing my nail around “mmmm...” slides my hands down to her breast line give her a playfuly sqeeze walking towards the sexy Malsavis strokeing his long scaley tail whraping it around my wasit and my leg rise around her wasit pulls him closer while my body press down against him pin to him down to the wall licking his sweet muzzle pulling his lower lip. slides my sweet wet tongue inside his hawt warm maw grinz at him kissing him tenderly with passion purrs with pleasure with my firmed soft hands whraping around her neck pressing my lips longer to his lips slowly release the kiss smiles warmly .steps back swings her self around ''poofs gets bk in the pole''blows him a gentle heaven kiss on Malsavis nose moves across the floor to Wildong, sliding hands up his chest tangling fingers thru his hawk, gripping tightly pulling him down to her, kisses his cheek softly whispering "thanks for the tip sexy" jumps onto the bar swings herself around feeling the hard pole...
Words: 1235 - Pages: 5
...Alyssa Pimentel English 1301-232 Ms. Bullard October 20th 2013 Journal 2 – Tip Jar There are many dollars out there but none of them have the same serial number as me, That is why I am unique. Luckily I am not very old, only a couple years old. I have had plenty of homes in my short lifetime. I have almost been caught in a fire, I almost even drowned once. But the day I was finally taken out of the tip jar was the greatest adventure I have ever had. December 30th 1999, I was taken out of an old rusty can tip jar. As I was being stuffed into an envelope I screamed in excitement! “I’ll never have to smell this old bar again.” After being stuffed into the envelope I was thrown into a box, which was eventually tossed into the back of a plane. I thought, “This is going to be a great journey!” The air was hot and musty in the cargo I was flying in. I wished there were other dollars like me to talk to, but all there was were old hundred dollars bills and a couple of checks. The old hundred dollar bill seemed way to high class, hence he didn’t speak to me once, and dollar bills never dare speak to checks. So there I was, all alone in long, hot, boring plan ride. The sun was blazing when a ten year old took me out of his envelope. I lasted about twenty minutes in the hands of this child before I got completely drenched in ice cream. I was handed to an old man immediately after suffocating in ice cream. I was placed into a very old register, it smelt quite...
Words: 883 - Pages: 4
...Counted all my mistakes and there's only one Standing up on a list of the things I've done All the rest of my crimes don't come close To the look on your face when I let you go So I built you a house from a broken home Then I wrote you a song with the words you spoke Yeah, it took me some time but I figured out How to fix up a heart that I let down Now I'm searching every lonely place Every corner calling out your name Trying to find you but I just don't know Where do broken hearts go? Where do broken hearts go? Get a taste of your lips on the tip of my tongue It's at the top of the list of the things I want Mind is running in circles of you and me Anyone in between is the enemy Shadows come with the pain that you're running from Love was something you never heard enough Yeah, it took me some time but I figured out How to fix up a heart that I let down Now I'm searching every lonely place Every corner calling out your name Trying to find you but I just don't know Where do broken hearts go? Are you fixing it by yourself? Or are you giving it to someone else? Trying to find you but I just don't know Where do broken hearts go? Where do broken hearts go? Tell me now, tell me now Tell me where you're going Will you be afraid? Where do broken hearts go? Tell me now, tell me now Tell me will you ever love me again? Love me again? Now I'm searching every lonely place Every corner calling out...
Words: 325 - Pages: 2
...Monologue 7/19.15 Monologue He was a man, cold like his steal knife. I could still feel it on the tip of my skin…so sharp…so lifeless. The blood dripping down my flesh, tears streaming down my face. He could have got me? Oh no…he could have. But did he? She was the first one to go. Who’s she you ask? Hmph…That does not matter anymore. I could hear her screaming as she called for help she grew limp, her voice cracking as he dragged her away. Do you think I am crazy? Doctor. Do you? The blood, the lives. Oh no but she came back, she came back but I knew it wasn’t her. The skin was there, but it was being worn by someone else, someone whom wanted to be her. I knew he wanted to smile, but her skin wouldn’t let him. He wore it, he wore what was hers. I stayed silent as he played dress up. The mirror he stared at was covered in dust, and each day I stared with him. He must have forgot about me? Though he enjoyed her skin a lot more than the others. He continued to wear it as if he knew I was watching, dolling her up as if she was his own. As he was her. This man wasn’t the prettiest, the lights dimming down on his harsh features, even with someone else’s face he couldn’t achieve beauty for he was a monster. How long did it take me to leave you ask? You tell me Doc am I really here or are you the one who’s...
Words: 276 - Pages: 2
