Download to read offline
All about Microsoft Excel: Parts, Formulas
- 1.
- 2. Spreadsheet A program thatdisplays data (text & numbers) in a table called a worksheet
- 3. Uses of Spreadsheet Preparebudgets Financial statements Inventory management Create charts
- 4. Worksheet A grid withcolumns & rows; the term worksheet is used interchangeably with spreadsheet
- 5. Cell The intersection ofa row and column
- 6. 3 things canyou type into a cell Label = words or letters Value = numbers Formula – statement that performs a calculation
- 7. Cell range A groupof cells that are closely together
- 8. Columns Vertical arrangements of cells;identified by letters
- 9. Rows Horizontal arrangement of cells;identified by numbers
- 10. Worksheet tab A tabthat identifies each open worksheet in a spreadsheet program, located in the lower left corner of the screen
- 11. Excel 2003 vs.Excel 2007 256 Columns 16,384 Columns 65,536 Rows 1,048,576 Rows
- 12. Cell Address (Reference) Thisis a column letter & row number combination, such as A1, B2
- 13. Name box Displays thename of the active cell or range
- 14. Formula bar Displays thedata or formula stored in the active cell
- 15. Active cell The cellin which you are currently working (normally the cell is surrounded by a black border)
- 16. Function A built-in formulathat is a shortcut for common calculations such as addition and average.
- 17. Operation Symbols Instruct thecomputer as to what mathematical operations to perform
- 18. Operation Symbols Addition (+) Subtraction(-) Multiplication (*) Division (/)
- 19. How do youkey a formula? You combine numbers, cell addresses (references), Operation symbols and/or functions Ex: =4 + 5; =B1 * B2
- 20. Order of Operations Completes formulas in this order: 1. Parentheses 2. Exponents 3. Multiplication 4. Division 5. Addition 6. Subtraction Example: Formula: 5+2*7 Result: 19 Formula: (5+2)*7 Result: 49
- 21. Column width tool Toolthat changes the width of the columns on a spreadsheet
- 22. Row height tool Toolthat changes the height of rows on a spreadsheet
- 23. Fill Handle Tool Usedto copy data & formulas to another cell; and create a series
- 24. Auto Sum Tool Automaticallycreates a formula to add a series of numbers in a spreadsheet
- 25. Chart Graphic representations used tocompare & contrast worksheet data
- 26. Sorting Organizing or rearranging datain either ascending or descending order
- 27. Definitions…. Sort Ascending –arranges records from A to Z or smallest to largest Sort Descending – arranges records from Z to A or largest to smallest