comp 2-5-07
Terms
undefined, object
copy deck
- formulas have to be entered with
- = sign
- used to enter, calculate, manipulate, and analyze data such as numbers and text.
- worksheet
- basic unit of file storage for Excel. acts like a notebook with worksheets inside(3 sheets is the defalut)
- workbook
- organize and store data
- lists
- how mnay columns
- a-iv
- present data in organized fashion so it easy to read
- excel purpose
- adjust rows down and up
- realtive cell addressing
- located below the horizontal scroll bar on the right side of the status bar. used in place of a calculator or formula to view the sum, average, and other types of totals of a slected group of cells in a worksheet
- auto calculate area
- every cell has a
- address
- columns labeled with?
- letters
- how many rows
- 65,536
- classified as a spreadsheet program that can create worksheets, charts, lists, and web support.
- Microsoft office excel 2003
- 5 components of worksheet
- main title, column titles, new tables, data, and charts
- each worksheet has a sheet name that appears on a tab at the bottom of the workbook
- sheet tab
- rows labeled with
- numbers
- everything in excel is a _________ every book has _________--
- book &&sheet
- shows the contents of the active cell. may also enter or wdit data using this
- formula bar
- a row of numbers on the left side of the grid taht identifies each row
- row heading
- intersection of row and column
- cell
- horizontal and vertical lines on a worksheet
- gridlines
- when click on cell contents where does it appear
- in formula bar
- seperate window that enables users to carry out some Excel tasks more efficently
- task pane
- graphical representation of data in a worksheet. embedded oron a seperate sheet.
- chart
- a cell on the worksheet that is the one in which you can enter data. outlined with a heavy border on the gridlines
- active cell
- unique address that a cell is referred toby which is the coordinates of the intersection of a column and a row
- cell reference
- 2 common charts
- pie &&bar
- contains buttons that allow you to speak commands and dictate text
- language bar
- function 3 parts
- 1.= sign 2. name of function3. range of function
- column letter above the grid that identifies each column
- column heading