# Shared Flashcard Set

## Details

Excel Functions
41
Computer Science
04/17/2012

Term
 PMT
Definition
 Payment of a loan based on constant payments/rate=PMT(rate,nper,pv)
Term
 median
Definition
 Mean list of values=median(range)
Term
 counta
Definition
 Count non empty cells=counta(range)
Term
 mode
Definition
 Most frequently occurring number in a list=mode(range)
Term
 If
Definition
 Change the contents of a cell based on criteria=if(logical test, (true value), (false value)
Term
 vlookup
Definition
 Information returned from a table=vlookup(lookup value, table array, independent number)
Term
 Conditional formatting
Definition
 Change the appearance of a cell based on criteria
Term
 Trunc
Definition
 Eliminate a decimal part of a number=trunc(number)
Term
 Now
Definition
 Displays date and time=now()
Term
 min
Definition
 find the lowest number in a range=min(range)
Term
 max
Definition
 find the highest number in a range=max(range)
Term
 Today
Definition
 Displays date and time=today()
Term
 Countif
Definition
 Count cells based on criteria=countif(range,criteria)
Term
 Sumproduct
Definition
 Return the sum of products of the corresponding ranges or arrays=sumproduct(range,range)
Term
 Count
Definition
 Count the number of cells that contain numbers=count(range)
Term
 Round
Definition
 Format number to specific digits=round(number,number)
Term
 Goal seeking
Definition
 Finding the right insput when you know the result you want
Term
 Concatenate
Definition
 Join several text strings togetherconcatenate=(text 1, text 2, text 3)
Term
 Cell ref
Definition
 The unique address of a cell
Term
 Normal View
Definition
 The default view
Term
 Left
Definition
 Text is ___ aligned
Term
 Right
Definition
 Numbers are ___ aligned
Term
 Merge
Definition
 Join several cells into one
Term
 Function
Definition
 A prewritten formula built into excel
Term
 Range Filter
Definition
 Check which cells are reference sin the formula assigned to the active cell
Term
 Point Mode
Definition
 Allows you to select cells for use in formula with a mouse
Term
 Accounting
Definition
 Format for fixed dollar sign
Term
 Currency
Definition
 Format for Floating dollar sign
Term
 Page Layout View
Definition
 Allows you to create or modify a worksheet while viewing what it looks like printed
Term
 Ctrl + Accent
Definition
 Display the formulas version
Term
 Move
Definition
 Clears date and resets format when used
Term
 Copy
Definition
 Leaves format and data intact
Term
 Above
Definition
 Rows are inserted ___
Term
 Column
Definition
 ___ is inserted to the left
Term
 Freeze Titles/Pane
Definition
 Keeps titles on the sreen no matter how far you scroll
Term
 Number
Definition
 A date is just a ___ since 1/1/1900
Term
 Absolute
Definition
 Addressing mode that keeps the column and row the same as you copy the formula
Term
 Mixed
Definition
 Addressing mode that keeps the column the same as you copy the formula
Term
 Relative
Definition
 Addressing mode that adjusts the column and row as you copy the formula
Term
 Goal Seeking(2)
Definition
 Feature that scrutinizes the impact of changing values in cells mthat are references by a formula in another cell
Term
 Fill handle
Definition
 Black square located in the lower right corner of an active cell
Supporting users have an ad free experience!