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

Excel 2 - Matching, Flashcards, Concentration, Word Search

Accouting Number formatExcel displays numbers with a dolloar sign to the left of the number, inserts a comma every three positions to the left of the decima point, and displays numbers to the nearest cent.
ArgumentsThe Value that you use with a function.
Asterisk(*) the arithmetic operator that directs Excel to perform the multiplication operation.
AVERAGE functionssums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range.
Best fitthe width of the column will be increased or decreased so the widest entry will fit in the column.
Blank Cella cell in Excel that has a numerical value of zero, which would have resulted in an error message.
Comma Style formatDisplays numbers with commas and no dollar signs.
Conditionmade up of two values and relational operator, is true of false for each cell in the range.
Conditional formattingmade up of two values and a relational operator, is true of false for each cell in the range.
Debuggingthe process of fingind a correcting errors in the worksheet.
Equal signalerts Excel that you are entering a formula or function and not text.
Fixed dollar signdisplays to the far left in the cell, oftern with spaces between it and the first digit.
Floating dollar signdisplays immediately to the left of the first digit with no spaces.
FormulaExcel will calculate the result.
Formulas versionshows the actual formulas you have entered, rather than the resulting values.
Funcitona prewritten formula that is built into Excel.
Hiding cellsa technique you can use to hide data that might not be relevant to a particular report or sensitive data that you do not want others to see.
Landscape orrientationthe printout is printed accross the length of the page.
MAX functionDispays the highest value in a range.
MIN functiondetermines the lowest (minimum) number in the range.
Normal viewThe default view that you have worked in.
Order of operationswhen using a formula with more than one operations use as follows: first negation (-), then all percentages (%), then all exponentiations (^), then all multiplications (*), and divisions (/), and finally, all additions (+) and subtractions (-).
Page layout viewallows you to create or modify a worksheet while viewing how it will look in printed format.
Pixel– a dot on the screen that contains a color.
Point modeAllows you to select cells for use in a formula by using the mouse.
Portrait orientationthe printout is printed across the width of the page.
Previewing the worksheetyou see exactly how it will look without generating a printout.
Range finderchecks which cells are referenced in the formula assigned to the active cell.
Relatie cell referenceswhen you copy a formula, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values.
Smart tag indicatora small purple triangle, indicating that smart tag is available.
Smart tagsExcel identifies certain actions to take on specific data in workbooks, such as: dates, financials symbols, people’s names, and more.
Spell checkerused to check the worksheet for spelling errors.
Themea predefined set of colors, fonts, chart styles, cell styles, and fill effects that can be applied to an entire workbook.
Values versionshows the results of the formulas you have entered, rather than an actual formula.
Web queryimporting data stored on a web site.

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