Excel Vocab.
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
Active Cell | The cell in your worksheet
that has been selected. It will have bolder
gridlines around it.
🗑
|
||||
AutoFill | A feature that allows you to
quickly apply the contents of one cell to
another cell or range of cells selected.
🗑
|
||||
AutoSum | A function that automatically
identifies and adds ranges of cells in your
worksheet.
🗑
|
||||
Cell | The rectangular shaped area on a
worksheet that is created by the intersection
of columns and rows.
🗑
|
||||
Cell Address | The name of the cell is
determined by the name of the row and the
column intersecting, such as A8.
🗑
|
||||
Cell Grid | The lines on your worksheet
that separate the columns and rows.
🗑
|
||||
Column | In a worksheet, the vertical
spaces with headings A, B, C, and so on
🗑
|
||||
Drag | When you move the mouse while
holding down the mouse button (usually the
left) to select a range of cells.
🗑
|
||||
File | A document that is stored on your
computer. In Excel, a file is also known as a
workbook.
🗑
|
||||
Fill Down | A feature that allows you to
copy information in an active cell to another
cell or range of cells selected vertically.
🗑
|
||||
Fill Right | A feature that allows you to
copy information in an active cell to another
cell or range of cells you have selected
horizontally.
🗑
|
||||
Formula | A combination of numbers and
symbols used to express a calculation.
🗑
|
||||
Formula Bar | A command line above the
worksheet where text, numbers, and formulas
are entered into a worksheet.
🗑
|
||||
Function | A drop-down menu item and a
button on the standard toolbar that allows
you to select a formula that you wish to apply
to data in your worksheet.
🗑
|
||||
Headings | The identifying letters and
numbers for columns and rows. Columns are
identified with letters, rows with numbers.
🗑
|
||||
Label | The identifying name that reflects
the information contained in a column or row
in a worksheet, such as name or date.
🗑
|
||||
Row | In a worksheet, the horizontal spaces
with the headings 1, 2, 3, and so on.
🗑
|
||||
Sheet Tabs | Tabs you see at the bottom
of your workbook file, labeled Sheet 1, Sheet
2, and so on. You can rename the tabs. They
represent worksheets within the workboo
🗑
|
||||
Workbook | An Excel file that contains
individual worksheets. Also called a
spreadsheet file.
🗑
|
||||
Worksheet | A “page” within an Excel
workbook that contains columns, rows, and
cells.
🗑
|
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:
AwesomeSausce
Popular Computers sets