click below
click below
Normal Size Small Size show me how
Excel
Vocab
Term | Definition |
---|---|
Spreadsheet | also called a workbook |
Workbook | made up of three worksheets |
Worksheet | a grid of cells consisting of 65,536 rows by 256 columns |
Workbook Window | a single spreadsheet that contains cells organized by rows and columns |
Cell | is an intersection of a column and row |
Sheet Tab | the current worksheet that is being displayed |
Active Worksheet | the sheet that you are working on in a workbook |
Workspace | a file that saves display information about open workbooks. So that you can later resume work with the same window sizes, print areas, screen magnification, and display settings |
Columns | each excel spreadsheet contains 256 columns. Each column is name by a letter or a combination of letters |
Rows | Each spreadsheet contains 65,536 rows. Each row is named by a number. are referenced by numbers that appear on the left and then run down the Excel screen |
Headings | the title at the head of the page |
Cell Reference | the set of coordinates that a cell occupies on a worksheet |
Name Box | the formula bar that is used for creating a workbook name |
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 | used to perform calculations on values entered and stored in the program |
Relative Reference | changes in position of rows and columns |
Absolute Reference | rows and columns stay the same |
Mixed Reference | it is either an absolute column and relative row or absolute row and relative column |
Active Cell | the cell that receives the data or commands you to give it |
Enter Data | information that is stored in any spreadsheet program such as Excel and Google worksheets |
Range | a group of selected cells |
Gridlines | Faint lines that divide cells |