unit 8 Flashcards
electronic spreadsheet within Microsoft office
excel
program used to perform numeric calculations and analyze and present numeric data
electronic spreadsheet
each individual spreadsheet you work in
worksheet
file of several worksheet
workbook
using a worksheet to ask a question
what if analysis
predesigned formatted files
templates
use a spreadsheet to
perform calculations
represent values graphically
generate reports
organize data
analyze data
create what if scenarios
displays the active address
name box
allows you to enter or edit data in worksheet
formula bar
intersection of a column or a row
cell
unique location identified by the coordinated of the intersecting column n row
cell address
dark rectangle that outlines the cell in which you are working
cell pointer
the cell is outlined
active cell
below the worksheet grid - lets you switch from sheet to sheet in wokrkbook
sheet tabs
let you navigate to additional sheet tabs when available
sheet tabs scrolling buttons
at bottom, provides brief description of the active command or task in progress
status bar
in bottom-left corner of status bar and provides additional info
mode indicator
a selection of 2 or more cells
range
equations in a worksheet
formula
entries that contain text & numerical info not used in calculations
labels
numbers, formulas, and functions used in calculations
values
built in formula
function
info. necessary to calculate and answer
arguments
double click it
edit
indicate what type of calculations you want to perform on the sales
calc. operators
perform mathematical calculations
arithmetic operators
work done in virtual environemnt
cloud computing
enables you to use range in calculations
reference operators
shows the worksheet wo including certain detail
normal view
provides more accurate view of how it will look when printed
`page layout view
indicates print area
dotted line
