What is a spreadsheet?
✓ A program that displays data (text & numbers) in a table called a worksheet
Uses of Spreadsheet
✓ Prepare budgets
✓ Financial statement
✓ Inventory management
✓ Create charts
What is a worksheet?
✓ A grid with columns & rows; the term worksheet is used interchangeably with spreadsheet
What is a worksheet?
✓ A grid with columns & rows; the term worksheet is used interchangeably with spreadsheet.
What is a cell?
✓ The intersection of a row and column.
What 3 things can you type into a cell?
✓ Label = words or letters
✓ Value = numbers
✓ Formula – statement that performs a
calculation
What is a cell range?
✓ A group of cells that are closely together
What are columns?
✓ Vertical arrangements of cells; identified by letters
What are rows?
✓ Horizontal arrangement of cells; identified by numbers.
What is a worksheet tab?
✓ A tab that identifies each open worksheet in a spreadsheet program, located in the lower left corner of the screen.
Excel 2003 vs. Excel 2007
✓ 256 Columns 16,384 Columns
65,536 Rows 1,048,576 Rows.
What is a Cell Address (Reference)?
✓ This Sort Ascending – arranges records from A to Z or smallest to largest
Sort Descending – arranges records from Z to A or largest to smallest
a column letter & row number combination, such as A1, B2.What is a name box?
✓ Displays the name of the active cell or range
What is a formula bar?
✓ Displays the data or formula stored in the active cell
What is an active cell?
✓ The cell in which you are currently working (normally the cell is surrounded by a black border)
What is a function?
✓ A built-in formula that is a shortcut for common calculations such as addition and average.
What are Operation Symbols?
✓ Instruct the computer as to what mathematical operations to perform
Operation Symbols :
✓ Addition (+)
✓ Subtraction (-)
✓ Multiplication (*)
✓ Division (/)
How do you key a formula?
✓ You combine numbers,
cell addresses (references),
Operation symbols
and/or functions
Ex: =4 + 5; =B1 * B2
What is a column width tool?
✓ Tool that changes the width of the columns on a spreadsheet.
What is a row height tool?
✓ Tool that changes the height of rows on a spreadsheet.
What is the Fill Handle Tool?
✓ Used to copy data & formulas to another cell; and create a series
What is Auto Sum Tool?
✓ Automatically creates a formula to add a series of numbers in a spreadsheet.
What is a Chart ?
✓ Graphic representations used to compare & contrast worksheet data
What is sorting?
✓ Organizing or rearranging data in either ascending or descending order
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