1 / 4

Spreadsheets

Spreadsheets. Basic terms and structures. A worksheet. Columns (letters). Rows (numbers). Text labels. Text labels. Numeric data. Each cell has a unique cell reference e.g. B17. Column letter B Row number 17. Formulae can also be viewed and edited here in the formula bar.

lydia-olsen
Télécharger la présentation

Spreadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheets Basic terms and structures

  2. A worksheet Columns (letters) Rows (numbers) Textlabels Text labels Numeric data Each cell has a unique cell reference e.g. B17 Column letter B Row number 17

  3. Formulae can also be viewed and edited here in the formula bar. Start with = then create the formula Formula When you press Enter, the formula will automatically be calculated. What do you think the answer will be?

  4. The data can be sorted in alphabetical or numerical order – using the AZ icons The data can be displayed on a chart, using the Chart Wizard icon By dragging the fill handle, you can copy and paste the formula into other cells What formula should have been generated in cell D13? See the fill handle (black square in bottom right of cell) B13+C13

More Related