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;
39 Cards in this Set
- Front
- Back
|
Microsoft Excel 2016 |
A spreadsheet program used to enter, analyze, and present quantitative data |
|
|
Excel |
A spreadsheet program used to enter, analyze, and present quantitative data |
|
|
Spreadsheet |
A grouping of text and numbers in a rectangular grid or table |
|
|
Backstage view |
The File tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options |
|
|
Template |
A preformatted workbook with many design features and some content already filled in |
|
|
Keyboard shortcut |
A key or combination of keys that you press to access a feature or perform a command |
|
|
ScreenTip |
A box with descriptive text about a command |
|
|
Key Tips |
Labels that appear over each tab and command on the ribbon |
|
|
Touch Mode |
The mode in which the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or stylus to tap the button on a touchscreen |
|
|
Chart sheet |
A sheet that contains only a chart that provides a visual representation of worksheet data |
|
|
Cell reference |
The column and row location that identifies a cell within a worksheet |
|
|
Range reference |
The cell reference of the upper-left of the rectangular block and the cell reference of the lower-right cell separated by a colon |
|
|
Shortcut menu |
A list of commands related to a selection that opens when you click the right mouse button |
|
|
Text data |
Any combination of letters, numbers, and symbols |
|
|
Text string |
A series of text characters |
|
|
Numeric data |
Any number that can be used in a mathematical calculation |
|
|
Date |
A value in a recognized date format |
|
|
Time data |
A value in a recognized time format |
|
|
Edit mode |
The mode in which you can edit cell contents |
|
|
AutoComplete |
The feature that helps make entering repetitive text easier; as you type text into the active cell, Excel displays text that begins with the same letters as a previous entry in the same column |
|
|
Pixel |
A single point on a computer monitor or printout |
|
|
AutoFit |
The Excel feature that changes the column width or row height to display its longest or tallest entry within the column or row |
|
|
Point |
A unit of measure equal to approximately 1/72 of an inch |
|
|
Operators |
A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell |
|
|
Arithmetic operators |
A mathematical symbol representing the operations of addition, subtraction, multiplication, division, or exponentiation |
|
|
Order of operations |
The sequence in which operators are applied in a calculation |
|
|
Clipboard |
A temporary storage location for text and graphics |
|
|
Syntax |
A set of rules that specifies how a function should be written |
|
|
Drag and drop |
The technique to move a cell or range by selecting it, positioning the pointer over the bottom border of the selection, and then dragging the selection to a new location |
|
|
Deleting |
To remove both the data and the selected cells from the worksheet |
|
|
Clearing |
To remove the data from selected cells, but leave the blank cells in the worksheet |
|
|
Hiding |
A process by which a row or column is removed from a worksheet by essentially decreasing its height or weight to 0 pixels |
|
|
Unhiding |
A process by which a hidden row or column is redisplayed |
|
|
Flash Fill |
The Excel feature that enters text based on patterns in the data |
|
|
Formatting |
A process by which a workbook's appearance is changed to make it easier to read |
|
|
Page orientation |
The direction in which content is printed |
|
|
Portrait orientation |
The page orientation where the page is taller than it is wide |
|
|
Landscape orientation |
The page orientation where the page is wider than it is tall |
|
|
Scaling |
To change the size of the worksheet on the printed page |
