SPREADSHEETS
Terms
undefined, object
copy deck
- 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