About Me

My photo
I am a freshman at West Grand High School in Kremmling, CO. I work at my parents coffee shop and enjoy being outdoors

Thursday, December 8, 2011

Arguments:)

An argument in Excel is an equation and/or mathematical function. They play a role in my spreadsheet, by doing the math for me.

Wednesday, December 7, 2011

The Difference.

A function refers to a formula. You put a function inside a formula to make that cell do what you want it to do. Such as SUM= or =SUM.

Tuesday, December 6, 2011

Circular Reference.

A circular reference is a pattern, were you put the cell address of another cell into that cell. So you would put B2 into B1 and so on and so forth. You don't want to do this in your spreadsheet, because you change one number and the rest of the numbers change as well.

Monday, December 5, 2011

Why You Don't!

Three reasons that you don't want to hard code a number in a cell are the following: You would be repeating yourself over an over again, you may forget to apply it to on column and/or row (messing you up in your excel document), and last but not least if you put it somewhere and forget the formula than you have to pretty much restart. 

Thursday, December 1, 2011

Hard Code Numbers

You don't want to hard code numbers, because then it will mess your entire excel document. Instead you want to just enter the numbers into one cell, so then if something goes wrong in the equation it won't mess up the entire document just a section, which is very easy to fix.