Reading...
Play button
Play button
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;
28 Cards in this Set
- Front
- Back
|
The section of the window, called ___, can consist of any number of columns or rows along the top or left edge of the window.
|
Panes
|
|
|
_____ prevents the data in the pane from scrolling as you move to different areas in a worksheet.
|
Freezing Panes
|
|
|
____ is a technique used to evaluate the effects of changing selected factors in a worksheet.
|
What if Analysis
|
|
|
The ____ tool is used to find the value needed in one cell to attain a result you want in another cell.
|
\Goal Seek
|
|
|
____ is a tool used to perform what-if analysis to determine the effect of changing values in two or more cells, called the ____, on another cell, called the ____.
|
Solver
Adjustable Cell Target Cell |
|
|
A workbook ____ is a workbook file that contains pre-designed worksheets that can be used as a pattern for creating similar worksheets in new workbooks.
|
Template
|
|
|
The ____ feature controls what information can be changed in a workbook.
|
Protection
|
|
|
You can include a ____ that prevents any unauthorized person from either viewing or saving changes to the workbook.
|
Password
|
|
|
The ____ feature displays all open workbook files in separate windows on the screen, making it easy to view and work with information in different workbooks (tiled, vertical, horizontal, cascade).
|
Window Arrangement
|
|
|
A ____ creates a connection between files that automatically updates the linked data in one file whenever the data in the other file changes.
|
Link
|
|
|
The link between the workbook files is formed by entering an ____ in one workbook that refers to a cell in another workbook.
|
External Reference Formula
|
|
|
This workbook filed is called the ____. (relates to above answer)
|
Destination Workbook
|
|
|
The cell containing the external reference formula (the ____) refers to the cell (the ____) in the source file that contains the data to be copied.
|
Destination
Source Cell |
|
|
The workbook that supplies the data is called the ____.
|
Source Workbook
|
|
|
A ____ is a graphic object that can be used to illustrate concepts and to enhance your workbook.
|
Diagram
|
|
|
A ____ is a named set of input values that you can substitute in a worksheet to see the effects of a possible alternative course of action.
|
Scenerio
|
|
|
A ____ is a range of cells that is used to quickly calculate multiple what-if versions in one operation and to show the results of all variations in the worksheet.
|
Data Table
|
|
|
A ____ can contain one or more formulas, and each formula refers to one input cell.
|
One-Variable Data Table
|
|
|
An ____ is a cell in which a list of values is substituted to see the resulting effect on the related formulas.
|
Input Cell
|
|
|
Input values can be listed down a column ( ___ ) or across a row ( ___ ).
|
Orientated
|
|
|
A ____ uses only one formula that refers to two different input cells, one column and one row oriented.
|
Two Variable Data Table
|
|
|
A ____ is a series of keystrokes and commands that are stored as instructions in a unit or ____ of Microsoft Visual Basic, a programming language.
|
Macro
|
|
|
A ____ is a graphic object that is designed to help the user interact with the worksheet.
|
Control
|
|
|
The ____ automatically creates a macro by recording a series of actions as macro commands.
|
Macro Recorder
|
|
|
A ____ is a formatted worksheet with blanks spaces that can be filled in online on an individual computer or on a network.
|
Form
|
|
|
The ____ checks to see if certain conditions are met and then takes action based on the results of the check.
|
IF function
|
|
|
____ are symbols used in formulas that compare numbers in two or more cells or to a constant.
|
Logical Operators
|
|
|
A ____ is a note attaches to a cell that can be used to help clarify the meaning of the data, provide documentation, or ask a question.
|
Comment
|
