or

or

taken

why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

Don't know
Know
remaining cards
Save
0:01
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

### Computer skills terms that deal with spreadsheets

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
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