Excel Unit A Flashcards
Built in formula
Function
An application you use to perform numerical calculations and analyze and present numerical data
Electron Spreadsheet
An electronic spreadsheet you work in
Worksheet
A file where worksheets are stored
Workbook
Any time you use a worksheet to ask what if
What-if Analysis
A predesigned format file
Templates
Location of a cell
Cell Address
Box containing the cell address of the active cell
Name Box
The bar that allows you to format data in a cell
Formula Bar
Window containing the columns and rows in excel
Worksheet Window
Dark rectangle that surrounds the cell you are working on
Cell Pointer
The cell you are working on
Active Cell
Tabs that let you switch from sheet to sheet
Sheet Tabs
Bar containing a brief description of the active command or process
Status Bar
Area in the bottom left corner containing more information about certain tasks
Mode Indicator
A selection of two or more cells
Range
An equation in a worksheet
Formula
Entries in a cell that contain text and numerical data not used in calculations
Labels
Numbers and formulas that can be used in calculations
Values
The information necessary to perform a calculation
Arguments
Changing the contents
Edit
A feature of excel that allows you to recover unsaved information in the case of a problem
Autoreciever
A feature of excel that allows you to recover unsaved information in the case of a problem
Formula Prefix
Operators that indicate what type of calculation you want to perform
Calculation Operators
Operators that join strings of text in different cells
Text Concatenation Operators
Operators that allow you to use ranges in calculations
Reference Operators
View of the worksheet that leaves out page information such as headers and footers
Normal Veiw
View that shows all the information as if it was going to be printed
Page Layout View
A printing option that allows you to print large amounts of data on a single sheet of paper
Scale-To-Fit
Operators that perform mathematical calculations
Arithmetic Operators