Excel Dawson
Help!
|
|
||||
|---|---|---|---|---|---|
| Active Cell | An active cell is the cell you are currently working in.
🗑
|
||||
| Auto Sum (GReek E) | A formula that will add up a column of numbers
🗑
|
||||
| Cell Reference | The column number and the row letter of a cell Ex. D9
🗑
|
||||
| Cell | Each individual box on the spreadsheet where a column and row meet
🗑
|
||||
| Chart Title | A title given to to the chart or graph being made
🗑
|
||||
| Column | The vertical referencess identified by letters
🗑
|
||||
| Formula | Calculation for cell that always starts with "=" sign
🗑
|
||||
| Graph | A visual representation of data
🗑
|
||||
| Gridlines | The horizontal and vertical lines on the spread sheet
🗑
|
||||
| Labels | Titles given to data placed ina spreadsheet
🗑
|
||||
| Row | The horizontal references identified by numbers
🗑
|
||||
| Sheet tabs | Tabs that identify the worksheets in a workbook
🗑
|
||||
| Spreadsheet | A grid that organizes data
🗑
|
||||
| Value | A number that can be entered into a cell as data and used in calculations
🗑
|
||||
| Workbook | The Excel file containing many worksheets
🗑
|
||||
| Worksheet | One spreadsheet page in the Excel workbook
🗑
|
||||
| X-Axis Title | Title given to the horizontal axis of the chart
🗑
|
||||
| Y-Axis Title | Title given to the vertical axis of the chart
🗑
|
||||
| Column | Most used to show data, trends, comparisons, and changes over time in years, months, and quarters.
🗑
|
||||
| Bar | A column chart that runs horizontal and works well with a larger number of values or information to show
🗑
|
||||
| Line | Line graphs work well with showing long periods of time or multiple groups of data at once.
🗑
|
||||
| Pie | have only one column of data to show proportions and ratios of things occurring at specific times
🗑
|
||||
| Scatter | normally used to display scientific data
🗑
|
||||
| Donught | Looks like a pie chart with a hole in the middle and allows to display a series of information.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
mrspowell
Popular Computers sets