Java Games: Flashcards, matching, concentration, and word search.

Excel 5-7 review

AB
Argumentvalue, cell ref., range or text that acts as an operand in a function formula
Outlinesuseful in summarizing large worksheets
financial functionused to analyze loans and investments
Mindisplays the smalles number
Maxdisplays the largest number
Ifname of the logical function we used in class
Averagedisplays the average of a range
Drawing toolsused to insert lines and objects
function formulasspecial formulas that do not use operators
REPTdisplays the text a specific number of times
Linkingdata changed on the original file is updated in the destination file
SQRTsquare root
Function nameprecedes the argument in a function formula
FVdisplays future value
Paste Functionused to open the function dialog box
Integrationusing data between applications
DATEdisplays the date
COUNTDisplays the number of cells with numerical values in the argument range
PMTdisplays the payment per period
Sortingreorganizing data to place it in order
Destination FileFile to which something is linked
ROUNDDisplays the rounded value
Cell CommentA message that explains or identifies information contained
HTMLHypertext Markup Language
VARdisplays the variance for the numbers contained in the range
Math/Trig Formulasmanipulates quantitative data
Format PaintingAllows you to copy the format of a worksheet cell without copying the content of a cell.
STDEVStandard Deviation
NOWdisplays the current date or time based on the computer's clock
Conditional Formattingapplied font, border, or pattern to a cell when certain conditions exist in that cell
PVdisplays the present value
Statistical Functionsused to describe large quantities of data
Logical functionsused to display text or values if certain conditions exist
Source Fileoriginal file


Business Education Teacher
Lehighton High School

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities