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

Excel Review Activity

AB
Function FormulasSpecial formulas that do not use operators to calculate a result.
ArgumentA value, cell reference, range or text, that acts as an operand in a function formula
an arrangement of text or numbers in rows and columns similar to a spread sheet.Table
A selected group of cellsRange
How can you browse thorugh the available functions?Insert, Formula
What does rotate do?Turn the desired words or pictures.
Located on far left side of formula bar it is the cell reference area that identifies the active cell.Name Box
How does Excel recognize a formula?When there is an = sign.
A collection of related worksheets.Workbook
A grid of rows and columns containg numbers, text, and formulas.Spreadsheet
Appear in the lower right corner of the columns.Auto Filter Arrows
How do you insert a Hyperlink?Select the text, Click Insert, and Click Hyperlink
When Excel starts, what is the BLANK worksheet titled?Book 1
What are Rows?They appear horizontally and are identified by number on the left side of the worksheet.
what is a Statistical Function?It is used to describe large quantities of data.
Mathematical FunctionManipulate Quantative data in the worksheet.
Financial FunctionUsed to analyze loans and investments.
Logical FunctionCan be used to display text or values if certain conditions exist.
What does the now function do?It displays the current date or time based on the computer's clock.
Can you print part of a worksheet?Yes
WorksheetA term Excel uses to refer to computerized spreadsheets.
HidingTemporarily removes a row or column form the screen.
Active CellThe cell that contains the higlight
Formula BarAppears below formatting toolbar; displays a formula when cell contains a calculated value.
HighlightThe entry point which appears on the screen as a dark border aorund a cell.
The range of letters used in the formulaOperands
CellThe intersection of a row and a column
AutofilterDisplays a subset of the data that meets a criteria.
Mathematical and TrigonometricSQRT and ROUND are examples of what types of functions?


Computer Applications Instructor
Camden Ninth Grade Center
Kingsland, GA

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