MICROSOFT EXCEL Flashcards
program that displays data (text and numbers) in a table called a worksheet
Spreadsheet
- grid with columns & rows
- Is used interchangeably with spreadsheet
Worksheet
intersection of a row and column
Cell
3 Things you can put in a cell
Label- words or letters
Value- number
Formula- statement that performs a calculation
group of cells that are closely together
Cell range
vertical arrangements of cells; identified by letters
Columns
horizontal arrangement of cells, identified by numbers
Rows
tab that identifies each open worksheet in a spreadsheet program, located in the lower left corner of the screen
Worksheet tab
column letter and row number combination, such as A1, B2
Cell Address (Reference)
displays the data or formula stored in the active cell
Formula Bar
the cell in which you are currently working (normally the cell is surrounded by a black border)
Active Cell
a built-in formula that is a shortcut for common calculations such as addition and average
Function
instruct the computer as to what mathematical operations to perform
Operation Symbols
Operation Symbols
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
Orders of Operations
PEMDAS
tool that changes the width of the columns on a spreadsheet
Column Width Tool
tool that changes the height of rows on a spreadsheet
Row Height Tool
used to copy data & formulas to another cell; and create a series
Fill Handle Tool
automatically creates a formula to add a series of numbers in a spreadsheet
Auto Sum Tool
graphic representations used to compare & contrast worksheet data
Chart
organizing or rearranging data in either ascending or descending order
Sorting
Sorting
Sort Ascending
Sort Descending
Uses of Spreadsheet
Prepare budgets
Financial statements
Inventory management
Create charts
Occurs when column is not wide enough to display the contents of the cell
(Railroad Tracks Error)
Occurs when the cell reference is not valid because the cell may have been deleted or pasted over incorrectly
REF!
Occurs when a misspelling has occured in a function name
NAME
EXCEL
Is the MS Office Application program used for creating spreadsheets
Use to enter all sorts of data and perform financial, mathematical, or statistical calculations
EXCEL
is composed of a number of worksheets (could be more than 200)
Excel file or a workbook
each tab represents a different worksheet in the workbook
Sheet tabs
is the selected cell, and has a thicker black border around it
The Active Cell
displays the active cell address or the name of the selected cell, range, or object
Name Box
displays the data or formula stored in the active cell
Formula Bar
PARTS OF EXCEL
Excel file or a workbook
Sheet tabs
Active Worksheet
Row Headers
Column Headers
The Active Cell
The Name Box
Formula Bar
