Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

why


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove Ads
Don't know
Know
remaining cards
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
Retries:
restart all cards




share
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

SPREADSHEETS

SPREADSHEET TERMINOLOGY

TermDefinition
Cell Formatting Changing the appearance of the data or cell.
Workbook A spreadsheet file containing 1 or more worksheets
Worksheet A page(s) within a workbook
Worksheet Tab A tab at the bottom of a worksheet
Toolbar Ribbon A ribbon at the top of the screen
Toolbar Tab Takes you to a different ribbon containing various icons and groups.
Icon Button to allow you to select an option
Group Groups together objects of a similar nature
Data Alignment Data alignment within a cell
Text Wrap Allows cells with large headings to be wrapped within a cell
Centre and Merge Centre and merge data across a number of columns or rows
Data Formatting Formats data into different categories
Conditional Formatting Changes the appearance of data within a cell
Find/Replace Search for a word or number and replace with an alternative
Page Layout Set the layout of page including margins
Cell Manipulation Cut, copy, move or paste data
Autofil Allows you to copy a series of data across columns or down rows
Replicate Copy formula across columns or down rows
Cell Protection Protects a cell or numerous cells from being edited by a user
Linking Cells Use of cell references to perform calculations or add data from cells in another worksheet or workbook
Graph/Chart Data can be converted from a table into a graph or chart which is easy to analyse
Pie Chart Shows data from 1 series in segments of a pie chart
Bar/Column Chart Shows data from 1 or more series in vertical columns or horizontal bars
Line Graph Shows data from 1 or more series in horizontal lines
Chart title Name of the chart
Axis Titles Horizontal X Axis or Vertical Y Axis titles explaining contents of graph
Legend Shows series of data being compared
Data Labels Gives values, percentages or labels on graphs and charts
Data Manipulation Manipulating data within worksheets
Sorting Sorts data in alphabetical or numerical ascending or descending order
Filtering Filters data within columns e.g. groups categories together
Operators Used within formulae or functions to show greater than, less than, equal to etc
Data Entry Form Uses Visual Basic to create a form which feeds into a spreadsheet table.
Freeze Panes Freeze columns and rows so that the labels are always visible when scrolling up and down and left and right
Split Window Split a worksheet into 4 sections
Formulae Creating calculations using cell references
Relative Cell Referencing Uses formulae or functions relative to the row or column they are making the calculation in
Absolute Cell Referencing Uses formulae or functions to perform calculations using a cell which will not change and locks the cell in the calculation using dollar signs
BODMAS Order of precedence of performing calculations
Two Stage Calculations Using brackets and signs to perform one part of calculation before the other
Named Ranges Naming a column or row of cells which can then be used in formulae to perform calculations
Functions A pre-set group of formulae
VLOOKUP/HLOOKUP A function used to return values in one table taking data from another table
Logical Function Uses a function to return a value dependent upon certain criteria
Created by: donnaowen