Term | Definition |
Spreadsheet | presents tables of values arranged in rows and columns that can be manipulated manually using both basic and complex arithmetic operations and functions. |
Workbook | A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages. |
Worksheet | A sheet used to store, manipulate, and display data. |
Workbook window | A workbook is an Excel file that contains one or more worksheets. Each of the wordbook worksheets are in separate tabs on the bottom of the Excel window. |
Cell | A cell is the intersection point of a vertical column and a horizontal row. |
Sheet Tab | is the current worksheet that is being displayed. Every Excel file is capable of having multiple worksheets. |
Active Worksheet | The worksheet you are working on. |
Work Space | Workspaces allow you to manage which windows are on your screen. You can imagine workspaces as being virtual screens, which you can switch between at any time. |
Column | Columns run vertically in the worksheet. Each column is identified by a letter in the column header. |
Rows | Rows run horizontally in the worksheet and is identified by a number in the row header. There are over one million rows in one worksheet. |
Heading | the column header is the colored row of letters used to identify each column within the sheet. In Excel, the row header is the grayish - colored column containing the numbers used to identify each row in the worksheet. |
Cell reference | Cell reference identifies the location of the cell or a group of cells in the worksheet. Sometimes referred to as a cell address. |
Name Box | The Name Box is located next to the formula bar above the worksheet area. The Name Box normally displays the cell reference of the active cell. |
Formula Bar | Located above the work area. Formula bar displays the data or formula stored in an active cell. Can also be used to edit of enter the data in the cell. |
Formula | Formulas are used to perform calculations on values stored and entered in the program. Formulas can range from basic mathematical problems- to complex engineering. |
Relative Reference | An Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group of cells. |
Absolute Reference | an absolute cell reference, like other cell references, identifies the location of a cell or group of cells and is used in such things as formulas, functions, and charts. |
Mixed Reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row. |
Active Cell | the cell that is currently being worked on. |
Enter Data | Data is stored in cells in a worksheet. Generally, each cell holds a single item of data. |
Range | A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by an outline or border. |
Gridine | Worksheet gridlines are the lightly-colored horizontal and vertical lines that appear around cells in a worksheet. These gridlines are used to define the boundaries of cells, columns, and rows in a worksheet. |
I can create graphs/charts on excel. True/False | True |
It is impossible to change the color of the cell on Excel. True/False | False |
On Excel you're not allowed to rename the sheet. True/False | False |
On Excel you can change the dimension of a row/column. True/False | True |
You can calculate numbers on Excel using auto sum. True/False | True |
On Excel you're not allowed to insert more than one graph/chart on one sheet. True/False | False |
On Excel you're limited to only 3 sheets per document. True/False | False |
On Excel There are only 26 rows. True/False | False |
On Excel there are only 10 columns. True/False | False |
On Excel you can change a decimal to a percent using the percentage button. | True |