Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/47

Click to flip

47 Cards in this Set

  • Front
  • Back
Active Cell
The cell that is currently selected and open for editing
Alignment
The manner in which a cell's contents are arranged within that cell (left,center,right)
Arguements
specific data a function requires to calculate a value
Autofill
the ability to extend a series of values based on the contents of a single cell
Autofilter
a microsoft excell tool that you can use to create filters
Autoformats
predefined formats that can be applied to a worksheet
cell
the box at the intersection of a row and column
cell range
a group of cells
cell reference
the letter and number combination that identifies the row and column intersection of a cell
charts
visual summaries of worksheet data, also called graphs
columns
cells that are on the same verticle line
conditional formats
formats that are applied only when cell contents meet certain criteria
data list
one or more columns of data depicting multiple instance of a single thing
embed
to save a file as part of another file, as opposed to linking one file to another
error code
a brief message that appears in a worksheet cell, describing a problem with a formula or a function
field
a column in a data list
fill handle
the square at the lower right corner of a cell you drag to indicate other cells that should hold values in the series
fill series
the ability to extend a series of values based on the contents of 2 cells, where the 1st cell has the starting values for the series and the 2nd shows the increment
filter
a rule that excel uses to determine which worksheet rows to display
formats
predefined sets of characteristics that can be applied to cell contents
formula
an expression used to calculate a value
freeze
to assign cells that will remain at the tip of a worksheet regardless of how far down the worksheet a user scrolls
function
a predefined formula whose mathematical or logical operators have been incorporated into a function name
goal seek
an analysis too that finds the value for a selected cell that would produce a given result from a calculation
graphs
visual summaries of worksheet data, also called charts
hyperlink
a reference to a file on the internet
link
formula that has a cell show the value from another cell
locked cells
cells that cannot be modified if their worksheet is protected
merge and center
an operation, initiated by clicking the button, that combines a group of cells into 1 cell. and vice versa
named range
a group of related cells defined by a single name
paste options
a button, which appears after you paste an tiem from the clipboard, that lets you control how the item appears in the workbook
query
a statement that locates records in a database
range
a group of related cells
refresh
to update the contents of 1 document when the contents of another document are changed
relative reference
a cell reference in a formula that refers to a cell that is a specific distance away from the cell that contains the formula.
rows
cells that are on the same horizontal line in a worksheet
sheet tab
the indicator for selecting a worksheet, located in the lower left corner of the workbook window
sort
to reorder the contents of a worksheet based on a criterion
split bar
a line that defines which cells have been frozen at the top of a worksheet
subtotals
partial totatls for related data in a worksheet
tables
data lists in a database
tags
marks used to indicate display properties or to communicate data about the contents of a document
template
a workbook used as a pattern for creating other workbooks
validation rule
a test that data must pass to be entered into a cell without generating a warning message
what-if analysis
analysis of the contents of a worksheet to determine the impact that specific changes have on your calculations
workbook
the basic excel document consisting of one or more worksheets
worksheet
a page in an excel workbook