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