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;
18 Cards in this Set
- Front
- Back
|
DEFINE SPREADSHEET
|
an organized display of numerical information
|
|
|
WHAT ARE THE TWO DIFFERENT TYPES OF SPREADSHEETS?
|
1) manual
2) electronic |
|
|
DEFINE MANUAL SPREADSHEET
|
a spreadsheet done by hand
|
|
|
DEFINE ELECTRONIC SPREADSHEET
|
a spreadsheet where you still have to input all the data but the computer does all the math for you :)
|
|
|
WHAT ARE THE TWO PRIMARY PURPOSES OF A SPREADSHEET?
|
1) record keeping
2) forecasting |
|
|
DEFINE CELL
|
the intersection of the rows and columns of the spreadsheet
|
|
|
DEFINE CELL ADDRESS
|
the column letter and the row number of the cell such as A7
|
|
|
DEFINE WORK AREA
|
the area where the cells are located
|
|
|
DEFINE DISPLAY AREA
|
tells you what cell your cursor is at and what type of information is in that cell (label, value, or formula)
|
|
|
DEFINE LABELS
|
allows you to identify the items in a spreadsheet such as months, spending categories, totals, etc.
|
|
|
DEFINE VALUES
|
the numbers which you want to manipulate such as income, expenses, calories, aerobic points, etc.
|
|
|
DEFINE FORMULAS
|
tell the spreadsheet what calculations to perform on the values you enter
|
|
|
DEFINE FUNCTIONS
|
one-step shortcut formulas such as =sum(A1..A9)
|
|
|
DEFINE ARGUMENT
|
the information inside the parentheses after the function name
|
|
|
DEFINE MACRO
|
a series of commands stored in a single keystroke
|
|
|
DEFINE TEMPLATE
|
a spreadsheet with only formulas and labels put into it that can be saved and then copied for use many times afterwords
|
|
|
DEFINE REFERENCE CELLS
|
the place that you put key values in a forecasting spreadsheet
|
|
|
WHAT ARE THE THREE STEPS FOR GENERALIZING A SPREADSHEET?
|
1) think about what you want to know before beginning your spreadsheet
2) establish reference cells 3) use only cell locations in your spreadsheet not actual values of figures |
