Hi this is me Essay

Submitted By kirk5000
Words: 700
Pages: 3
Open Document
Excel Commands

Part 1:
1. Relative and Absolute Cells:
Relative Cells: Relative cells are used the most in excel formulas. They are basic cell references that adjust and change when they are copied or when using the autofill function.
Absolute Cells: There are times when the situation may arise where one would want the cell to remain the same when it is copied or when autofill is being used. The dollar sign is used to hold a column and/or row constant.
2. Examples:
Relative Cells: The thing that a relative cell does that an absolute cell does not is it changes and adjusts when the cell is copied or auto filled. Example, =SUM(B2:B7), as shown below, changes to =SUM(C2:C7) when copied across to the next cell.

Absolute Cells: When you do not want a cell to change when copying the formula down and want both the column and the row to remain the same so you can refer to that exact cell.

$A1
Allows the row reference to change, but not the column reference.
A$1
Allows the column reference to change, but not the row reference.
$A$1
Allows neither the column nor the row reference to change.

Part 2:
1. Research and Define the Excel commands below.
a.i) =RAND() In Microsoft Excel, the RAND function returns a random number that is greater than or equal to 0 and less than 1. The RAND function returns a new random number each time your spreadsheet recalculates. Example: The RAND() command can be used to simulate 564 shots against Roberto Luongo in the 2011 NHL playoffs.
a.ii) =if( ) is a command that consists of a logical test, a value true statement, and a value false statement. The logical test part is any number referring to a cell that can result in a true or false answer (Ex. B2 = 5). Furthermore, the true and false statements are inserted in the brackets with quotations around each statement that will result in only one of the true and false statements when the command entered. Example: This command is used to determine whether or not a value in a certain cell is true or false to the logical test. An example of this function would be to determine if we had enough baseballs for a Red Socks game.
a.iii) =sum( ) is a command entered into the worksheet to determine the sum of numbers in various columns or rows. Example: The SUM command can be used to determine the total amount of numbers in a column or row. An example of =sum( ) would be to find out the total profits from a year of sales.
a.iv) =countif( )is a command in excel
Show More

Related Documents: Hi this is me Essay

400 Word Journal

granted one wish. Knowing that Santa is almost pure magic himself, it would not be hard to believe the truth of this. It is a difficult task because Santa does not take kindly to any interruptions on the busiest night of his year. But, if you are sincere and do not make a ruckus at his appearance it is possible…

Words 863 - Pages 4

Creative Writing: A Deaf Reaper

Reaper Draft “. . . !” Tyson hovers over me on all fours, his arms and knees pinning me down like a beast. It's pitch black, and I can't see a thing. It's just that Tyson's indistinct figure is in front of me. It's so dark that I can't see his face. But I can hear the low growl and see the white glint in his eyes glaring down at me. A lukewarm liquid drips down from Tyson's mouth onto my face. “Tyson. . . !” Suddenly taken by fear, I call out his name. It's Tyson, but its not. What do I…

Words 1772 - Pages 8

Sir Gawain Challenges

was challenged by the Green Knight and the journey it took to complete his challenge. In this journey, I faced the temptation of lust from a man’s fair wife and I faced the challenge of producing the courage to keep to my word and accept the Green Knight’s jest with grace. I take the knight’s code very seriously and have struggled through certain parts of these challenges. The difficulty of this conquest was momentous and forced me to represent Arthur’s knights with strain. The first substantial challenge…

Words 672 - Pages 3

Charles Child Observation

of children. With this being true we gain access to being able to see if children are on tract developing. It is a nice thing for parents to be able to have access to this information. I was able to observe Charles. Charles is a 21-month old boy full of energy. It was interesting to be able to use the knowledge I have gained from this class to observe his development. I wanted to observe him in a natural location so I observed him in his house, with his father present. I chose this location because…

Words 1858 - Pages 8

My Boyfriend Is Supernatural Essay

My boyfriend is supernatural By: Kayla Evans Chapter one. Have you ever met a boy that you like some much you didn’t care about his flaws or how he may be? You might want to think that over because your life will change forever. This story is about how I gain eternal life with my eternal lover. My name is Koumi, Koumi shin. I use to live in japan Tokyo city. There people called miss match girl, especially in school. No it’s not because I wear miss match clothes or wore miss match socks. It was…

Words 2317 - Pages 10

Essay on Life memior

Strother from Hilliard, Ohio messages me out of nowhere kind of flattered me and bothered me. “Hi,” I responded back. What a lame thing to say back to this really cute stranger. “What’s up? What are you doing?” “Nothing much, listening to music.” That made me feel dumber. I sounded like I have no friends, no life, which I don’t but a few. Well, I don’t, especially after my boyfriend of six long months cheats on me and dumps me out of nowhere and goes from me, a 10, to some wana-be-black, flat, white…

Words 2721 - Pages 11

Parental Expectations In Star Food By Ethan Canin

What do they want from me? At just the small age of four, I was placed in Soccer Shots,Little League Baseball, and Tiny Tots Hockey. All of this was courtesy of my father who was looking to raise a star athlete after the athletic disappointment that was my brother.Once I was able to start school, my mother had me placed in the best, most expensive, private school in the whole state of Ohio. I spent majority of my childhood trying to please my mother academically and my father athletically.I find…

Words 629 - Pages 3

Boring: Eliza Dushku and Message Essay

searching went by when someone grabbed me and threw me into his van. He took me to his house and beat me with a axe until I died. No one could find my body because he buried me in a dessert. I then later returned as a ghost 8 years later when Hello my name is Jackson. On my fourth birthday we went to a fair. I got lost and could not find my parents. 1 hour of searching went by when someone grabbed me and threw me into his van. He took me to his house and beat me with a axe until I died. No one could…

Words 1628 - Pages 7

Law Enforcement Officer: A Career As A Law Enforcement Officer

justice.” This is first and most important sentence of the code of ethics that every law enforcement officer has to obey and follow throughout his career. Many people ask me why would I want to work for the Orange County Sheriffs Department, a career that is hated by many and supported by so little this generation. This answer is simple, law enforcement is for people who want to make a impact in the community around them. People need to understand that law enforcement personnel don't do this for the…

Words 932 - Pages 4

Lawrence Otis Grahams Article Analysis

titled “I taught my black kids that their elite upbringing would protect them from discrimination. I was wrong.” This article was very significant because it gave me a foundation for the topics covered in my class, Writing, Literacy, and Discourse and helped me become a self-reflective writer. Grahams article is about his life, his family and a racist incident that involved his son. He and his wife raise their children in an upscale New York suburb and send their children to New York city private schools…

Words 342 - Pages 2