excel
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| used for storing, organizing and manipulating data. | Spreadsheet
🗑
|
||||
| an Excel file that contains one or more worksheets. | Workbook
🗑
|
||||
| an Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. | worksheet
🗑
|
||||
| a single unit on excel | cell
🗑
|
||||
| tabs where you select for worksheet and changes their names | name tab
🗑
|
||||
| worksheet that you are currently using | active worksheet
🗑
|
||||
| the unit that you selected | work space
🗑
|
||||
| units in the same lines going up-down | columns
🗑
|
||||
| units in the same lines going left-right | Rows
🗑
|
||||
| the name for the document | Headings
🗑
|
||||
| coordination for the cell. | Cell reference
🗑
|
||||
| boxes that contain the name for the worksheet | Name Box
🗑
|
||||
| When you put in formula, it shows the list of formula | Formula bar
🗑
|
||||
| start with an = and automatically do calculation on numbers and fractions | Formula
🗑
|
||||
| the coordination on the formula with out a $ | Relative reference
🗑
|
||||
| the coordination on the formula with one $ | mixed reference
🗑
|
||||
| the coordination on the formula with 2 $ | absolute reference
🗑
|
||||
| cell that were highlighted | Active cell
🗑
|
||||
| the difference between two numbers | range
🗑
|
||||
| lines that separate cells | Grid lines
🗑
|
||||
| Is this a absolutes location ? ($A$2) | True
🗑
|
||||
| is this a mixed location? (A$2) | True
🗑
|
||||
| Is this the formula for adding? =Sum | True
🗑
|
||||
| Is this the formula for dividing? =Quotation | False
🗑
|
||||
| Is this the formula for multiplying? =Produce | False
🗑
|
||||
| Bar graph is the best for comparing various data | True
🗑
|
||||
| circle graph is the best for showing percentage | True
🗑
|
||||
| Line graph is best for showing the changes over time | True
🗑
|
||||
| In order to change a graph you must start over again | False
🗑
|
||||
| The graph will change with the changes in data | True
🗑
|
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:
lxcstevenliang
Popular Languages sets