Computer

• Formula-user defined

  function-in built
• References- range of cells
• Every entered formula begins with =
• ctrl+shift+arrow keys- to select cells
• a range is a group of contiguous cells
• to change the name of range:

  select range of cells ->formulas tab ->defined names group ->define names-> enter name
• a cell address in a formula is known as cell reference
• A relative reference is the address of a cell with reference to the position of another cell
• absolute reference is when you do not want to change the address of the cell while copying the formula to another cell
• mixed reference is a combination of absolute and relative reference