Excel Vocabulary and True or False
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
Spread Sheet | computer program that stores, analyzes, and organizes, date in tabular form
🗑
|
||||
Workbook | another word for excel file
🗑
|
||||
Worksheet | collection of cells that keeps and manipulates the data
🗑
|
||||
cell | the point where vertical columns and horizontal rows intersect
🗑
|
||||
sheet tab | the current worksheet that is being displayed
🗑
|
||||
active worksheet | worksheet that is currently being worked on
🗑
|
||||
workspace | a group of workbooks
🗑
|
||||
columns | vertical series of cells in a chart
🗑
|
||||
rows | horizontal series of cells in a chart
🗑
|
||||
headings | rows that contains letters that shows the locations of the cells
🗑
|
||||
cell reference | the location-based cell in a spreadsheet that consists of a column letter and the row that intersects at the cell's location
🗑
|
||||
name box | box located left of the formula bar that shows the cell that is currently selected in the spreadsheet
🗑
|
||||
formula bar | bar that displays the contents of the current cell and creates/views formulas
🗑
|
||||
formula | expression that ells the computer which mathematical operation should be performed upon a specific value
🗑
|
||||
relative reference | cell reference that reflects the function's new location
🗑
|
||||
absolute reference | cell reference that does not change when a formula or function is copied to other cells
🗑
|
||||
mixed reference | cell reference that is a combination of relative and absolute reference
🗑
|
||||
active cell | rectangular box that highlights the cell
🗑
|
||||
enter data | click on cell and enter data
🗑
|
||||
range | group of cells in a row or a column
🗑
|
||||
gridlines | light gray lines that divide cells, rows, and columns
🗑
|
||||
Numbers are used as column headings. | False
🗑
|
||||
An equal sign is needed to begin a formula. | True
🗑
|
||||
Microsoft Excel provides a spelling checker. | True
🗑
|
||||
Absolute cell references are indicated with a # sign. | False
🗑
|
||||
Once a chart is made, it cannot be edited. | False
🗑
|
||||
The name of the worksheet can be renamed. | True
🗑
|
||||
An extra column/row cannot be added or removed. | False
🗑
|
||||
You are able to change the data after you form a chart. | True
🗑
|
||||
Excel automatically calculates the data. | True
🗑
|
||||
Texts cannot be added in a chart. | 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:
yewon1027
Popular Computers sets