1 / 48

Let’s Learn About Spreadsheets

Let’s Learn About Spreadsheets. Start. What is a Spreadsheet?. A spreadsheet is used for storing information and data. Calculations can be performed on the data in a spreadsheet. Microsoft Excel is the most common spreadsheet application, although there are other spreadsheets available.

adanne
Download Presentation

Let’s Learn About 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. Let’s Learn About Spreadsheets Start

  2. What is aSpreadsheet? A spreadsheet is used for storing information and data. Calculations can be performed on the data in a spreadsheet. Microsoft Excel is the most common spreadsheet application, although there are other spreadsheets available.

  3. Parts of aSpreadsheet This is aCOLUMN. Columns are labelled with letters.

  4. Parts of a Spreadsheet This is aROW Rows are labelled with numbers.

  5. Parts of a Spreadsheet This is aCELL Each cell has a unique CELL REFERENCE

  6. Parts of a Spreadsheet The CELL REFERENCEof this cell is E 4

  7. Parts of a Spreadsheet The cell that you are currently clicked in is called the ACTIVE CELL.It has a thick black line around it. Any text you type will go in this cell.

  8. Parts of a Spreadsheet A LABEL is a piece of TEXT that you add to a spreadsheet to help describe the numbers.

  9. Parts of a Spreadsheet These are all LABELS.

  10. Parts of a Spreadsheet A VALUE is a NUMBER that you type into a spreadsheet. It is a number that you already know.

  11. Parts of a Spreadsheet These are all VALUES.

  12. Cell Referencing Quiz Start

  13. Put Scooby in cell B4 Check Answer

  14. B4 Next Question

  15. Put Bart in cell G9 CheckAnswer

  16. Next Question G9

  17. Put Bugs in cell H6 Check Answer

  18. H6 Next Question

  19. Put Homer in cell C9 Check Answer

  20. Next Question C9

  21. Put Buzz in cell I3 Check Answer

  22. I3

  23. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3

  24. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign

  25. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell

  26. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell +

  27. Using Formulae in Spreadsheets Let’s add the numbers in cells A3 and B3 All formulae start with an = sign Then put the cell reference of the first cell + The cell reference of the second cell

  28. Using Formulae in Spreadsheets The correct answer will now be displayed when you press ENTER

  29. Using Formulae in Spreadsheets 10 If you change one of the numbers used in the calculation

  30. Using Formulae in Spreadsheets 10 16 If you change one of the numbers used in the calculation The answer is automatically updated

  31. Using Formulae in Spreadsheets

  32. Using Formulae in Spreadsheets

  33. Using Formulae in Spreadsheets

  34. Using Formulae in Spreadsheets

  35. Quiz on Formulae Start

  36. Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell C4 / - + = * Check Answer B3 B3 A1 A4 C4 D6 B4 B5

  37. A4 B4 + Drag the correct symbols and cell references onto the spreadsheet. Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell C4 / - + = * Next Question B3 A1 B3 A4 C4 D6 B4 B5

  38. Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell D5 / - = + * Check Answer C4 A2 D5 B3 A4 D6 B4 D6

  39. A2 + C4 Create the formula to ADD the two numbers in the spreadsheet and put the answer in cell D5 / - + = * Next Question D5 B3 A2 A4 C4 D6 B4 D6

  40. Create the formula to SUBTRACT the lowest number in the spreadsheet from the higher number and put the answer in cell A6 / - + = * Check Answer D5 B2 A2 A4 D4 D6 B4 A6

  41. B2 - D4 Create the formula to SUBTRACT the lowest number in the spreadsheet from the higher number and put the answer in cell A6 / - + = * Next Question D5 B2 A2 A4 D4 D6 B4 A6

  42. Create the formula to MULTIPLY the two numbers in the spreadsheet and put the answer in cell D6 / - + = * Check Answer A3 B2 A2 A4 D4 D6 C4 A6

  43. A3 * C4 Create the formula to MULTIPLY the two numbers in the spreadsheet and put the answer in cell D6 / - + = * Next Question A3 B2 A2 A4 D4 D6 C4 A6

  44. Create the formula to DIVIDE the number in A1 by the number in B2. Put the answer in cell C3 / - + = * Check Answer A3 B2 A1 A4 D4 D6 C3 A6

  45. A1 B2 / Create the formula to DIVIDE the number in A1 by the number in B2. Put the answer in cell C3 / - + = * Next Question A3 B2 A1 A4 D4 D6 C3 A6

  46. Create the formula to ADD all the numbers in the spreadsheet. Put the answer in cell D1 / - + = + * Check Answer A3 B2 B3 A4 C4 D6 D5 D1

  47. B3 C4 + + D5 Create the formula to ADD all the numbers in the spreadsheet. Put the answer in cell D1 / - + = + * A3 B2 B3 A4 C4 D6 D5 D1

  48. Quiz Complete

More Related