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;
18 Cards in this Set
- Front
- Back
|
A series of two a more at adjacent cells and a column or row or a rectangular group of cells |
Range |
|
|
Combining 2 or more cells together is called |
merging cells |
|
|
Causes cells with 2 decimal places to align vertically correctly |
Accounting Number Format |
|
|
Causes the cells to display with 2 decimal places and commas as thousands separators |
Comma Style Format |
|
|
Commands to insert a chart are located on the |
insert tab |
|
|
Specify the column letter 1st, follow by the row number |
To identify a cell |
|
|
When text is longer than the width of a column |
Excel displays the overflow characters in adjacent cells to the right |
|
|
Text entered in a cell can be |
realigned |
|
|
Gives the sum total of several cells |
Sum |
|
|
Gives the average number of several cells |
Average |
|
|
Gives the minimum/smallest number of several cells |
MIN |
|
|
Gives the maximum/largest number of several cells |
MAX |
|
|
When a major error is made when typing data in a cell |
Click the cancel box in the formula bar or press the ESC key to erase the entire entry and, then re enter the data from the beginning |
|
|
Microsoft office excel |
Is a powerful spreadsheet program that allows users to organize data, complete calculations ,make decisions, graph data ,develop professional looking reports, published organize data to the web, and access real time data from websites |
|
|
The horizontal and vertical lines on the Worksheet are called... and make it easier to see and identify each cell |
gridlines |
|
|
As you type |
Excel displays the entry in the formula bar, and also displays the active cell reference in the name Box on the left |
|
|
When cell references are copied each cell reference that excel automatically adjust for the new position is called |
Relative Reference |
|
|
Arithmetic operators that you can use in excel formula are: |
- ÷ * / % ^ |
