1 / 6

Understanding Spreadsheets: A Comprehensive Guide to Formulas and Charts

A spreadsheet is an Excel worksheet that functions like a large calculator, making it simple to perform calculations, percentages, and data organization. It presents information in a grid format of rows and columns and leverages formulas to process data efficiently. Learn to create various charts, such as bar graphs, line charts, and pie charts. Formulas are vital for performing calculations, and they start with an equals sign (=). This guide simplifies working with symbols, rows, columns, and creating engaging visual data representations through charts.

sibley
Télécharger la présentation

Understanding Spreadsheets: A Comprehensive Guide to Formulas and Charts

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. All about spread sheets By Ashvi Daia

  2. What is a spread sheet? • A spread sheet is a worksheet on Excel. It’s like a big calculator that makes it easy to work out calculations, it’s comes in handy in working out sums or working out percentages and many, many other things. It sorts data in a huge grid with many rows and columns. Spread sheets work things out when you use formulas. You can make charts, like bar charts, line graphs, pie charts and many other things…

  3. Formulas • You write Formulas to work out, it’s like the instructions you give to work out something. You use symbols to do this. • Here’s what I learnt: You always use a equals sign(=)when you start a formula. If you want to write a formula to add two numbers from two cells you use the plus sign and for subtract a minus sign. On the other hand if you want to times you use a star, and for divide, a slash.

  4. Symbols

  5. Rows and columns

  6. Charts

More Related