Spreadsheets

• A spreadsheet is a table consisting of cell
• Columns are the vertical lines that separate data from different categories or variables
• Rows are the horizontal lines that separate individual data entries in the spreadsheet
• Cells are the basic unit of a spreadsheet, representing a single data entry or value
• The name box is a feature that allows users to assign names to cells or a range of cells or other spreadsheet objects
• The fill handle is a small, clickable icon that appears in the bottom right hand corner of a cell or a range of cells
• A formula is a mathematical  expression or function that a user can enter into a cell to automatically calculate and display a value based on the context of other cells
• A function is bulit in procedure in a spread sheet program that performs a specific task or calculation
• Cell address is the reference to a specific cell in a spreadsheet
• Cell address is used to identify and select individual cells for various operations
• A range of cells is a continuous block of cells that are adjacent
• Range of cells is identified by specifying its first and last cell addresses separated by a colon (:)
• A range of cells share the same formatting
• A workbook is a file that contains a spreadsheet or multiple spreadsheets
• A worksheet is a single spreadsheet that contains data and fourmlas
• Primary Role of spreadsheets

  To organize and categorize data into a logical format
• Spreadsheets are an essential business and accounting tool
• Relative Addressing

  the address changes to refelct it's current position when a fourmula or function is applied to it
• Absolute Addressing

  making a cell fixed therefore it will not change when a fourmula is copied
• To make a cell absolute, the dollor symbol should be placed infront of the column heading and the row heading
• A value is the data entered into a cell in a spreadsheet is referred to as a value.
• Different Functions

  1. SUM
  2. IF
  3. MAX
  4. MIN
  5. AVERAGE
• The SUM function adds all the numbers in a range of cells.
• The IF function checks whether a condition is met and returns one value if true and another value if false
• The IF THEN ELSE structure in Excel is typically achieved using nested IF functions to evaluate multiple conditions in a sequence
• The MAX function returns the largest value in a set of values.
• The MAX function returns the largest value in a set of values.
• The MIN function returns the smallest value in a set of values
• The AVERAGE function calculates the arithmetic mean of a set of values.