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;
44 Cards in this Set
- Front
- Back
|
A computer application program that arranges data into rows and columns, usually used to work with numbers and calculations.
|
SPREADSHEET
|
|
|
What comuter application program can be used by accountants to keep track of current money available for spending.
|
SPREADSHEET
|
|
|
A cell that is selected is _____________
|
ACTIVE
|
|
|
The name and location of a cell on a spreadsheet designated by the column letter and row number.
|
CELL ADDRESS
|
|
|
When giving a cell an address, you should always list what first?
|
COLUMN LETTER
|
|
|
The vertical divisions of a spreadsheet which are labeled alphabetically.
|
COLUMN
|
|
|
The lettered box at the top of a column in a spreadsheet.
|
COLUMN HEADING
|
|
|
The page setup that allows the document to be printed horizontally , the width is greater than the height.
|
LANDSCAPE
|
|
|
The page setup that allows the document to be printed vertically, the height is greater than the width.
|
PORTRAIT
|
|
|
The horizontal divisions of a spreadsheet, labeled numerically.
|
ROW
|
|
|
The numbered box at the beginning of a row in a spreadsheet.
|
ROW HEADING
|
|
|
What would be the cell address of data that is located in the first three columns in the first row?
|
A1:C1
|
|
|
What do rows have as headings?
|
NUMBERS
|
|
|
What do columns have as headings?
|
LETTERS
|
|
|
In a cell address for a row, the range will always have the same ________
|
NUMBER
Example: A1:C1 |
|
|
In a cell address for a column, the range will always have the same __________?
|
LETTER
Example: A1:A8 |
|
|
A number entered into a cell is called a ___________
|
VALUE
|
|
|
Numbers in order are called?
|
ORDERED VALUES
|
|
|
A page number in the footer of a report is an example of an ____ _______
|
ORDERED VALUE
|
|
|
A formula always begins with what?
|
AN EQUAL SIGN (=)
|
|
|
Formulas that are already built into a spreadsheet program.
|
FUNCTIONS
|
|
|
What function would you use to find the smallest value in selected cells?
|
MINIMUM
|
|
|
What function would you use to find the total value of selected cells?
|
SUM
|
|
|
What symbol is used for multiply when creating a formula?
|
*
|
|
|
What symbol is used for divide when creating a forumula?
|
/
|
|
|
Another way to write, add cells B1, B2, B3, B4, B5, B6, B7, B8, and B9 as a formula.
|
=SUM(B4:B10)
|
|
|
What type of chart is best for showing percentages of a whole?
|
PIE CHART
|
|
|
What type of chart is best for showing trends over time?
|
LINE CHART
|
|
|
What type of chart is best for showing comparisons?
|
BAR CHART
|
|
|
What is the function of a chart legend?
|
TO EXPLAIN OR CLARIFY THE CHART
|
|
|
When deleting multiple rows, you should click and drag on what?
|
ROW HEADINGS
|
|
|
What software application can be used to create charts?
|
SPREADSHEET
|
|
|
C5:C20 is an example of what?
|
A RANGE OF DATA
|
|
|
How would you define how things like dates, time, and numbers are shown in cells of a spreadsheet?
|
FORMAT CELL, THEN CHOOSE THE FORMATTING STYLE
|
|
|
What type of cell reference follow the same directional instructions regardless of the starting position?
|
RELATIVE CELL REFERENCE
|
|
|
What type of cell reference always points to the same cell?
|
ABSOLUTE CELL REFERENCE
|
|
|
What symbol do you add to a cell address to make it an absolute cell reference?
|
$
|
|
|
If #REF! appears in a cell, what is this telling you?
|
THAT YOU HAVE A CELL REFERENCE ERROR - FORMULA IS NOT CORRECT.
|
|
|
What do you call the spreadsheet feature that generates a series of values based on the value in an active cell that helps copy or generate data quickly?
|
FILL SERIES
|
|
|
Which cell type would you choose if you had the following data in a column?
1/2/2009 1/5/2009 |
DATE (MM/DD/YYYY)
|
|
|
Which cell type would you choose if you had the following data in a column?
1999 2000 2001 |
DATE (YYYY)
|
|
|
Numbers can be formatted in a spreadsheet by choosing what command?
|
FORMAT, CELLS
|
|
|
What spreadsheet feature allows you to create a spreadsheet that has cells that can not be changed?
|
CELL PROTECTION
|
|
|
What function would you choose to get the mean value of a series of cells?
|
AVERAGE
|
