Vocab Finals Flashcards
relational database management software
Acess
The current cell in a worksheet
Active Cell
A program that can be added
Add-in
placement of data within cell boiundaries
Alignment
A feature that enable you to copy the content of a cell
Auto Fill
A statistical function that calculate mean or average
AVERAGE Function
A function that calculate the average
AVERAGE IF function
copy of a file
backup
line that surrounds a cell
border
insertion of a column and row
cell
unique identifier of a cell
cell address
set of formatting options
cell style
visual representation of numerical datea
chart
electronic illustration
clip art
temporarily holds selections that have been cut or stored
clipboard
Pointer to a cell in another worksheet
3-D reference
Used to store files
Cloud storage
A number format values with commas
Comma style
A text file that uses commas
Comma separated value(CSV) file
A tool that detect data that’s not compatible with previous versions
Compatibility checker
Process of duplicating an item from the original location
Copy
Statistical function that tallies the number of cells in a range
COUNTA function
A statistical function that counts the number of cells
COUNTIF function
Process of removing an item from the original location
Cut
Identifies that shows the exact value of a cell
Data label
Group of related data points
Data series
Office setting that remain in effect
Default
Character used to separate data a text file
Delimiter
Software application used to organize records,financial information in the form of worksheets.
Excel
Smallest data element in a table
Field
Directory into which you place data files
Folder
A formula that use the equal sign
Formula
Shows the content of the active cell
Formula bar
Process of keeping rows
Freezing
Predefined computation that simplifies creating a complex calculation
Function
Tool that identifies the necessary input value
Goal seek
Tabular display of data frequencies
Histogram
Electronic market to another location
Hyperlink
Logical function that evaluates a condition
IF function
Orientation that’s wider
Landscape
An office feature that provides a preview
Live preview
Expression that evaluate true or false
Logical test
Set of instructions that tells excel which commands
Macro
Statistical function that finds the highest value
MAX function
Finds the lowest value
MIN function
An identifier that display the address or range
Name box
Default view of a document
Normal view
Software that direct computer activities
Operating System(OS)
Set of rules that determine the sequence
Order of operations
Data will start on another printed page
Page break
Shows worksheet data and page break break
Page break preview
The process of placing a cut item in another location
Paste
A chart that shows each data point as a slice in a circle
Pie chart
Financial function in Excel
PMT Function
Orientation For displayed page;taller
Portrait
Creat dynamic presentations
PowerPoint
Range of cells within a worksheet
Print area
Sequence which the page are printed
Print order
Calculates the present value
PV function
A group of adjacent cells
Range
Group of fields
Record
Connection btw two or more tables
Relationship
The long bar of tabs
Ribbon
Visual element that shows a name of a worksheet
Sheet tab
Using snipping tool
Snip
Provides the ability to capture an image
Snipping tool
Electronic file that contains a grid of columns
Spreadsheet
Calculates the total of values
SUM function
Calculates the total of a range of values
SUMIF function
A component of the ribbon
Tab
Object used to store and organize data
Table
Collection of designs
Theme
Identifies the current file name
Title bar
Switching from one setting to another
Toggle
Changing variables observe how change affect calculated results
What-if analysis
Word processing software application
Word
Collection of one or more worksheets
Workbook
A single spreadsheet that contains descriptive lables
Worksheets
Makes data appear on multiple lines
Wrap text
