Excel Unit 8 Flashcards
Excel
electronic spreadsheet within Microsoft Office
Electronic spreadsheet
program used to preform numeric calculations and analyze and present numeric data
Calculations are updated automagically
worksheet
each individual spreadsheet you work in
Workbook
file of several worksheets
File extension: .xlsx
What if analysis
using a worksheet to ask a question
Templates
predesigned, formatted files
You can use spread sheet to;
- Preform calculations
- represent values graphically
- Generate reports
- Organize Data
- Analyze Data
- create what if scenarios
Name box
displays the active cell address (A1)
formula bar
allows you to enter or edit data in worksheet
Cell
intersection s column and a row
Cell address
unique location identified by the coordinated of the intersecting column and row
Cell pointer
dark rectangle that outlines the cell in which you are working
Active cell
the cell that is outlined
Sheet tabs
below the worksheet grid - lets you switch from sheet to sheet in a workbook
Sheet tab srolling buttons
let you navigate to additional sheet tabs when available
Status Bar
at the bottom, provides brief description of the active command or task in progress
Mode indictor
in bottom - left corner of the status bar - provides additional info. About certain tasks
Range
a selection of two or more cells is a range
Formula
equation in a worksheet
Addition
+ =a5+a7
Subtraction
- =a5-10
Multiplication
- =a5*a7
Division
/ =a5/a7
Percent
% =35%
