Spreadsheets

The people that use spreadsheets are as follows: accountants, teachers, engineers, sales people, scientists, supermarkets and market researchers.

Spreadsheets are for storing, organizing, and manipulating data. spreadsheets can be used in many different calculations.

A spreadsheet (or worksheet) is an arrangement of cells in columns, and rows used to organize, analyze, calculate, and report information, usually in numerical form.

Many businesses use spreadsheets for  financial statements for a business profits and  loss.

Cell: individual locations on a spreadsheet like an intersection of a row or column.

Column: identified by letters of the alphabet vertically  

Row: identified by numbers horizontally  

A column is set up vertically with the contents A, B, C, and D at the top of the spreadsheet. The row is set up horizontally with the contents 1, 2, 3, and 4 on the side of the spreadsheet.  

Cell Range:

  • A4:A16 refers to a group of adjacent cells
  • A Range is a group/block of cells.
  • Example: A6:E16 refers to a range of cells in a specific spreadsheet.
  • Cell Address:
  • Cell A4 = Cell address
  • It is the Column letter and Row number.
  • The cell address is also called the cell reference.
  • Comment Stream