SPREADSHEETS

UNIT 9. SPREADSHEET

Tutorial: http://homepage.cs.uri.edu/tutorials/csc101/pc/excel97/excel.html#excel

We use spreadsheets for numerical or logical data. You can link cells with other cells and do arithmetic, statistical and finalcial calculations.

Excel is the spreadsheet application in the Windows Microsoft Office package. 

The cells are arranged in a grid. Each cells has a name, with the letter of the column and the number of the row.

When a cell is activated, a black frame appears around it.

To select a row or colum, click on the corresponding number or letter. If you want to select several cells, rows or columns, use Control or Shift keys.

Before entering any data into the spreadsheet, it is a good idea to format the cell using the formatting bar or formanting menu formato.

You can enter numerical data into a cell and/or refer to the number in another cell. For example, =100*F6 multiplies the value or cell F6 by 100.

When you enter data, it appears simultaneosly in the corresponding cell in the formula bar. Once you have entered the data, press Enter to confirm.

A formula is an expression that refers to another cell or cells in a spreadsheet an carries out operations using the data in those cells. To enter a formula, click on the formula bar or the cells and type the equals sign (=) following by the operation required.

Funtions, for example =PROMEDIO(A2:D2) calculates the average or the numbers in cells in the range A2:D2, that is in cells A2, B2, C2 and D2.

To make charts in Exell, all you have to do is folow the instructions given by the wizard, and choose your options according to your needs. You can change any part of the chart alfter is has been created. To do this, right click on the part of the chart you can to change.

LINKS FOR THE ACTIVITIES:
  SPREADSHEET
  SPREADSHEET. PROBLEMS.
  SPREADSHEET. INVOICE.
  SPREADSHEET. HEIGHT, WEIGHT, AGE.
  SPREADSHEET. AVERAGE MARK.