Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Spreadsheet
Computer skills terms that deal with spreadsheets
| Question | Answer |
|---|---|
| A computer application program that arranges data into rows and columns, usually used to work with numbers and calculations. | Spreadsheet |
| What computer 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 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 |
| In a cell address for a column, the range will always have the same __________? | Letter |
| A number entered into a cell is called what? | Value |
| Numbers in order are called what? | Ordered Values |
| A page number in the footer of a report is an example of what? | 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 formula? | / |
| What would be the easiest way to write a formula to add cells B1, B2, B3, B4, B5, B6, B7, B8, and B9? | =SUM(B1:B9) |
| What type of chart is best for showing percentages of a whole? | Pie Charts |
| What type of chart is best for showing trends over time? | Line Charts |
| What type of chart is best for showing comparisons? | Bar Charts |
| Information that is given to explain or clarify a chart is called what? | Legend |
| 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 |
| 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? | 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 (1/2/2009) in a column? | Date (MM/DD/YYYY) |
| Which cell type would you choose if you had the following data(2010)in a column? | Date (YYYY) |
| 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 |
Created by:
eblanchard
Popular Computers sets