excel unit A Flashcards
is a application you use to perform numeric calculations and to analyze and present numeric data.
electronic spreadsheet
the electronic spreadsheet you work in
worksheet
and it is contained in a file called a
workbook
any time you use a worksheet to ask the question “what if”
What -if analysis
displays the active cell address .”A1” appers in the
Name Box
allows you to enter or edit data in the worksheet.
formula bar
predesigned formatted files
templates
contains a grid of columns and rows.
worksheet window
the intersection of a column and a row
Cell
every cell has its own unique location
cell address
the dark rectangle that outlines the cell you are working in
cell pointer
the cell pointer outlines the cell A1 so A1 is the
active cell
below the worksheet grid let you switch from sheet to sheet
sheet tabs
lets you to navigate to additional sheet tabs when available
sheet tab scrolling button
is located at the bottom of the excel window it provides a breif decription of the active command or tasks in process
status bar
on the status bar now reads “Edit”
mode indicator
a build in formula
function
the information necessary to calculate an answer
arguments
you can change or the contents of acell
edit
excel worsheet starts with the equal sign
formula prefix
A selection of two or more cells such as B5:B14
Range
is an equation in a worksheet
formula
are entries that contains text and numerical information not used in calculation such as 2012 sales or Travel Exxpenses
Labels
are numbers formulas and function that can be used in calculations
Values
on the status bar now reads”edit”indicating you are in edit mode.
mode indicator
the information necessary to calculate an answer
arguments
You can change or the contents of an active cell any time
edit
Excel worksheet starts with the equal sign
formula prefix
indicate what type of calculation you want to perform on the cells ranges or values.
calculation operators
show the worksheet without including certain details like headers footers or tools like rulers
normal view
which join strings of test in different cells
text concatenation operators
which perform mathematical calculatons
arithmetic operators
