350 likes | 702 Views
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
E N D
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 CellsFont 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