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;
25 Cards in this Set
- Front
- Back
Range |
A series of two or more adjacent cells in a column or row or a rectangular group of cells. |
|
SUM Function |
Adds all of the numbers in a range if cells. |
|
Fill Handle |
Is the small black square located in the lower-right corner of the heavy border around the active cell. |
|
Relative Reference |
An address or pointer that changes when the target item is moves or the relationship to it has changed. |
|
Bold |
An entry in a cell to emphasize it or make it stand out from the rest of the worksheet. |
|
Merging Cells |
Involves creating a single cell by combining two or more selected cells. |
|
Document Properties |
Also known as metadata, can include information such as the project author, title, subject, and keywords. |
|
Keyword |
Is a word or phrase that further describes the document. |
|
Insert Mode |
Excel inserts the character and moves all characters to the right of the typed character one position to the right. |
|
Overtype Mode |
Excel replaces the character to the right of the insertion point. |
|
Function |
Is a prewritten formula that is built into Excel. |
|
Order of Operations |
When more than ine arithmetic operator is involves in a formula, Excel follows the same basic order of operations that you use in algebra. |
|
Point Mode |
Allows you to select cells for use in a formula by using a mouse. |
|
AVERAGE Function |
Sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range. |
|
MAX Function |
Displays the highest value in a range of cells. |
|
MIN Function |
Determines the lowest number in a range of cells. |
|
Range Finder |
Used to check which cells are referenced in the formula assigned to the active cell. Allows you to make immediate changes to the cells referenced in a formula. |
|
Conditional Formatting |
Let's you applt formatting that appears only when the value in a cell meets conditions that you specify. |
|
Formula Bar |
Displays the data or formula stored in the active cell. |
|
Best Fit |
Means the width of a column will be increased or decreased so that the widest entry will fit in the column. |
|
Page Layout View |
Allows you to create or modify a worksheet while viewing how it will look in printed format. |
|
Excel |
A powerful spreadsheet program that allows users to organize data, complete calculations, make decisiins, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites. |
|
Worksheet |
Allows users to enter, calculate, manipulate, and analyze data such as numbers and text. |
|
Workbook |
Is like a notebook. A collection of worksheets. |
|
Cell Reference |
Thw coordinates of the intersection of a column and row. |