Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
9 Cards in this Set
- Front
- Back
|
Cell Format |
Can be changed to a different data type e.g currency or date/time and a cell can be formatted by giving it a full colour, changing font, font size. |
|
|
Locking Cells |
Cells can be locked to protect data or formula or functions from being edited. |
|
|
Data Validation |
Restricts the data being entered e.g number of people will only accept a number in between 1-40. It will also trap errors. |
|
|
Fill |
If you fill down a formula and functions, it saves time. The cell reference will increase each time by 1 |
|
|
Mathematical Functions |
=, sum, comma, |
|
|
Graphs and Charts |
Can be created in Microsoft excel to show the results. Charts are a professional way of displaying results. A chart should have a legend and data labels. |
|
|
Legend |
A Legend allows you to identify the data and its associated values, shows what each part of the chart represents. |
|
|
Lookup Functions |
This Function will look up data from a cell range or another sheet and display it. (Automatically dates itself, better than copying and pasting.) |
|
|
Macros |
Can be recorded and is set up to carry out a number of steps to automate a task/make it easier. Can be set up using a button on keyboard short cut. |
