Computers and Things
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.
🗑
|
||||
Formula Bar | A command line above the worksheet where text, numbers, and formulas are entered into a worksheet
🗑
|
||||
AutoFill | A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
🗑
|
||||
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.
🗑
|
||||
AutoSum | A function that automatically identifies and adds ranges of cells in your worksheet.
🗑
|
||||
Headings | The identifying letters and numbers for columns and rows. Columns are identified with letters, rows with numbers.
🗑
|
||||
Cell | The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
🗑
|
||||
Label | The identifying name that reflects the information contained in a column or row in a worksheet, such as name or date
🗑
|
||||
Cell Address | The name of the cell is determined by the name of the row and the column intersecting, such as A8.
🗑
|
||||
Row | In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.
🗑
|
||||
Cell Grid | The lines on your worksheet that separate the columns and rows.
🗑
|
||||
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 workbook
🗑
|
||||
Column | In a worksheet, the vertical spaces with headings A, B, C, and so on
🗑
|
||||
Workbook | An Excel file that contains individual worksheets. Also called a spreadsheet file.
🗑
|
||||
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.
🗑
|
||||
Worksheet | A “page” within an Excel workbook that contains columns, rows, and cells.
🗑
|
||||
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
🗑
|
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:
jdredden
Popular Computers sets