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!
|
|
||||
---|---|---|---|---|---|
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 | An Excel file that contains one or more worksheets
🗑
|
||||
Workbook window | The program window that is currently being worked on.
🗑
|
||||
Cell | A spreadsheet cell is analogous to a field in database management systems. Individual cells are usually identified by a column letter and a row number.
🗑
|
||||
Sheet tab | A sheet tab appears at the bottom of your worksheet. It has the name of the worksheet on it, which can be changed and you can also change its colour.
🗑
|
||||
Active worksheet | The active sheet is the worksheet you are working on.
🗑
|
||||
Workspace | Group of Workbooks
🗑
|
||||
Columns | Colums are a fundamental part of any spreadsheet program such as Excel and Google Spreadsheets. Colums run vertically in a worksheet.
🗑
|
||||
Rows | Rows run horizontally in an Excel worksheet. Each row is identified by a number in the row header.
🗑
|
||||
Headings | The column header is the colored row of letters used to identify each column within the sheet, or workbook.
🗑
|
||||
Cell Reference | A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
🗑
|
||||
Name Box | The Name Box normally displays the cell reference of the active cell. If a name has been defined for a cell or range of cells, the Name Box displays that name if the correct range is selected in the worksheet.
🗑
|
||||
Formula Bar | A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts
🗑
|
||||
Formula | Self-defined instructions for performing calculations.
🗑
|
||||
Relative Reference | By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
🗑
|
||||
Absolute Reference | Absolute references remain constant, no matter where they are copied.
🗑
|
||||
Mixed Reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column.
🗑
|
||||
Active Cell | The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.
🗑
|
||||
Enter Data | The process of entering data into a spreadsheet
🗑
|
||||
Range | A group or block of cells in a worksheet that have been selected or highlighted.
🗑
|
||||
Grid lines | Gridlines are the faint lines that appear around cells in Excel. They are used to distinguish cells on the worksheet.
🗑
|
||||
Individual cells are usually identified by a column letter and a row number. | True
🗑
|
||||
The selected cell in which data is entered when you begin typing is a Cell Reference. | False
🗑
|
||||
Absolute references remain constant, no matter where they are copied. | True
🗑
|
||||
An Excel file that contains one or more worksheets is a Spreadsheet. | False
🗑
|
||||
A group or block of cells in a worksheet that have been selected or highlighted are Grid lines. | False
🗑
|
||||
A cell reference refers to a cell or a range of cells on a worksheet. | True
🗑
|
||||
Range are the faint lines that appear around cells in Excel. | False
🗑
|
||||
Formulas are self-defined instructions for performing calculations. | True
🗑
|
||||
The selected cell in which data is entered when you begin typing is an Active Cell. | True
🗑
|
||||
By default, all cell references are relative references. | True
🗑
|
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:
ShinozakiKara
Popular Computers sets