Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/44

Click to flip

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