COMPUTER PT 2 QRT 3

• Spreadsheet application made by ms


  Excel
• Combi of the column header and the row number

  Cell address
• When we click a box

  Active cell
• Intersection of a row and column

  Cell
• Predefined formulas that perform calculation

  Function
• Expression that operates on value


  Formula
• Adjacent to the cell

  Colon
• Specific cell only


  Comma
• Cell range of the cells

  Cell reference
• Relative to the location of the cell

  Relative reference
• Addition of a dollar sign

  Absolute reference
• Both absolute and relative

  Mixed reference
• Keeps columns and rows visible

  Freeze panes
• Trends over time


  Line chart
• Horizontal in nature 


  Bar chart
• Shows part of a whole

  Pie
• Runs along vertically 


  Column
• Default view of worksheet 


  Normal view
• Changes location of worksheet

  Page break view
• Visualizes how workbook looks

  Page layout view
• Allows us to find value


  Sorting data
• File hosting service made by ms

  One drive
• Used to apply styles


  Condition formating
• Narrows down 


  Filtering data
• Collection of cells in excel

  Worksheet