Excel Vocabulary
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 application used to store and analyze data.
🗑
|
||||
Workbook | An excel file.
🗑
|
||||
Worksheet | Sheets in an excel workbook.
🗑
|
||||
Workbook Window | The active workbook that is open.
🗑
|
||||
Cell | The intersection of a row and column.
🗑
|
||||
Sheet Tab | Used to display a worksheet.
🗑
|
||||
Active Worksheet | In a spreadsheet program such as Excel or Google Spreadsheets, the active sheet is the worksheet you are working on.
🗑
|
||||
Workspace | A file that memorizes the current layout of all open windows and workbooks.
🗑
|
||||
Columns | Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD.
🗑
|
||||
Rows | Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576
🗑
|
||||
Headings | Row numbers and column letters.
🗑
|
||||
Cell Reference | The column letter and row number that identify a cell such a B3.
🗑
|
||||
Name Box | Displays the cell reference of the active cell. Located at the top of the worksheet.
🗑
|
||||
Formula Bar | Displays the active cell’s contents. Located above the cells.
🗑
|
||||
Formula | Mathematical statement used to calculate a value. A formula must always begin with an equals sign.
🗑
|
||||
Relative Reference | A cell reference that reflects the row or column it has been copied to.
🗑
|
||||
Absolute Reference | A cell reference the remains constant no matter where they are copied.
🗑
|
||||
Mixed Reference | A cell reference that is either an absolute column and relative row or absolute row and relative row.
🗑
|
||||
Active Cell | The cell displayed with a bold border. Also called the selected cell.
🗑
|
||||
Enter Data | Entering data into excel, you can add by selecting a cell and begin typing.
🗑
|
||||
Range | Entering data into excel, you can add by selecting a cell and begin typing.
🗑
|
||||
Gridlines | Solid lines that mark off the rows and columns in a worksheet.
🗑
|
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:
Cleton
Popular Computers sets