1 / 26

Spreadsheets

What is a Spreadsheet?. SpreadsheetsA document, or table that is made up of rows and columns.Table Columns and rows of cells that can be filled with text, used to organize informationSpreadsheet programs, such as Excel, allows you to use calculations, formulas, graphs, charts, and sorting.. Why

joann
Download Presentation

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 Ms. Scales

    2. What is a Spreadsheet? Spreadsheets A document, or table that is made up of rows and columns. Table Columns and rows of cells that can be filled with text, used to organize information Spreadsheet programs, such as Excel, allows you to use calculations, formulas, graphs, charts, and sorting.

    3. Why use Spreadsheets? Makes working with numbers more efficient To arrange and organize information To calculate totals, %, budgets, grades, etc…

    4. Parts of a Spreadsheet Cell The space at the intersection of a row and column in a spreadsheet Row The horizontal division in a spreadsheet named with a number Column The vertical division in a spreadsheet named with a Letter

    5. Parts of a Spreadsheet

    6. Parts of a Spreadsheet Active Cell Thick bordered cell you are currently working in or entering numbers/formulas Entry Bar The field where information or data is entered into

    7. Entry Bar

    8. Cells Label The term given to the words entered on a spreadsheet usually naming a column Value The term for a number in a spreadsheet that can be added (+), subtracted (-), multiplied (*), or divided (/). Data Information or numbers

    9. Labels and Values

    10. Cells… Cell Reference The cell’s location in the spreadsheet, also known as cell address. It is the combination of the row and column letters and numbers, ex. B5. Cell Format This determines such things as alignment, number style, borders, fonts, etc..

    11. Cell Format: Number and Alignment

    12. Format Cells Font and Border

    13. Sorting Sort Arranging information in a specific order. Ascending Order Organizing or sorting information in order from smallest to largest, or A-Z or 1-9. Descending Order Organizing or sorting information in order from largest to smallest, or Z-A or 9-1.

    14. Sorting

    15. Formulas Calculate The working of mathematical equations. Formulas that are usually used in spreadsheets allow the computer to automatically perform calculations. Formula A mathematical calculation on a set of cell. A typically starts with =.

    16. Parts of a Formula

    17. Functions Function A formula that is already built into the spreadsheet software. AutoSum A built in function that automatically calculates the sum of a series of values.

    18. Function Examples =Average Calculates the average number of all the numbers in a range =Count Counts up the number of cells containing numbers in a range =Sum Adds all the numbers in the range

    19. Functions

    20. Parts of a Function

    21. Chart Chart A way to present information from a spreadsheet Circle Chart A picture showing the relationship of two or more sets of data using a circle Bar Chart A type of chart showing the relationship of data using parallel bars to compare data and changes of data over time Pictogram On certain types of bar charts, pictures can be substituted in the place of the bars.

    22. Graph Graph A picture shows the relationship of one or more sets of numbers to each other Pie Chart Circle graph divided into pieces that look like portions of pie, usually in % Line Graph A graph used to display trends and compare data Axis A feature of a graph/chart on which you can plot numbers. The horizontal line is called the X axis and the vertical line is called the Y axis.

    23. Chart vs. Graph Charts vs. Graphs Charts compare different information to each other Ex. like the heights of different plants Graphs shows the changes of a set of information Ex. like changes in time

    24. Using Chart Wizard

    25. Using Chart Wizard

    26. Graph Examples

More Related