Introduction to Spreadsheets
Introduction
A spreadsheet is a specialized electronic document that allows for data to be placed in rows and columns. They were modeled after financial accounting paper books, but quickly became a popular way to manage numeric data, dates, and even text. Information is organized into cells, which is a field for data placed where a specific row and column meet. Better yet, spreadsheets can calculate data using formulas; these can pull data from other documents or other cells in the same spreadsheet. That way, people can enter data in one cell and have the computer calculate all sorts of complicated math automatically. Text and numbers can be made easier to see, too: Spreadsheets can turn your data into graphs and charts, and they can be used to display text information, too, with the ability to change fonts and cell sizes.
Watch
- Google Sheets: Getting Started with Spreadsheets: https://bit.ly/3HyJXrS Links to an external site. (YT 2:55)
- Excel 2016: Getting Started with Excel: https://bit.ly/3VasHw5 Links to an external site. (YT 4:20)
- An Introduction to Formulas in Numbers: https://bit.ly/4lFnJlU Links to an external site. (YT 6:11)
Visit
- Wiki Kidz Search -- Spreadsheets: https://bit.ly/4lxtK41 Links to an external site.
- Mashable -- 9 Amazing Projects Made in Microsoft Excel: https://bit.ly/477OQCI Links to an external site.
- Zapier.com -- Google Sheets 101: The Beginner's Guide to Online Spreadsheets: https://bit.ly/4660Qm7 Links to an external site.
Key Ideas
- Spreadsheets help you format and calculate with numbers, but also can be used to organize text data.
- Popular spreadsheet apps include Microsoft Excel, Google Sheets, and Apple Numbers.
- You can also use spreadsheet apps to create charts and graphs from your number data.
Apply
How about building a budget with a spreadsheet? See if you can follow these directions with either Excel or Google Sheets: https://bit.ly/3VaOP9G Links to an external site.