Stuff
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Spreadsheet | an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
🗑
|
||||
| Workbook | a single file containing different types of information as separate worksheets
🗑
|
||||
| Worksheet | a data file created and used by a spreadsheet program, which takes the form of a matrix of cells when displayed
🗑
|
||||
| workbook | the window which displays which workbook you are currently working on
🗑
|
||||
| cell | a field in a spreadsheet in which you can input data that is usually text, a numeric value, or a formula.
🗑
|
||||
| sheet tab | the current worksheet being displayed
🗑
|
||||
| active worksheet | a single spreadsheet that contains cells organized by rows and columns.
🗑
|
||||
| workspace | group of workbooks
🗑
|
||||
| columns | cells that run vertically
🗑
|
||||
| rows | cells that run horizontally
🗑
|
||||
| headings | the colored row of letter or numbers that identify each column or row on the sheet.
🗑
|
||||
| cell reference | it refers to a cell or range of cells on a worksheet and can be used in a formula.
🗑
|
||||
| Name Box | the box left of the formula bar that displays the cell that is currently selected in the spreadsheet.
🗑
|
||||
| Formula bar | a toolbar at the top of the Microsoft excel spreadsheet window that you can use to eo enter or copy an existing formula in to cells or charts.
🗑
|
||||
| formula | self-defined instructions for performing calculations
🗑
|
||||
| relative reference | a cell in a spreadsheet that is a location based cell reference
🗑
|
||||
| absolute reference | a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell.
🗑
|
||||
| mixed reference | it is either an absolute and relative row or absolute row and relative column
🗑
|
||||
| active cell | a cell in spreadsheet that is currently selected
🗑
|
||||
| enter data | ways to put information and save them on excel
🗑
|
||||
| Range | the term used for the cells selected.
🗑
|
||||
| gridlines | lines that define the boundaries of cells, columns, and rows in a worksheet
🗑
|
||||
| T or F:you can print more than one sheet on a single page | True
🗑
|
||||
| T or F:You can change the data in your chart after creating it | True
🗑
|
||||
| T or F:You have to manually do your own calculations | False
🗑
|
||||
| T or F:You have to manually type down formulas | False
🗑
|
||||
| T or F:You cannot create borders on your data | False
🗑
|
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:
joloberueco
Popular Computers sets