Excell Unit 8 Flashcards
Excell
electronic spreadsheet within Microsoft Office
Electronic spreadsheet
program used to perform numerical calculations and analyze and present numeric data calculations are updated automatically
Worksheets
each individual spreadsheet you work in
Workbook
file of several worksheets, File extension: .xlsx
What is analysis
using a worksheet to ask a question
Templates
predesigned, formatted files.
You can use spreadsheets to
Perform 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 of a column and row
Cell address
unique location identified by the coordinated of the intersecting column & 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 scrolling buttons
let you navigate to additional sheet tabs when available
Status bar
at bottom, provides brief description of the active command or task in progress
Mode indicator
in bottom-left corner of the status bar - provides additional info.
About certain task.
Range
a selection of 2 or more cells is a range
Formulas
equations in a worksheet.
Addition
+ =a5+a7
Subtraction
-
Multication
*
Division
/
Percent
%
