click below
click below
Normal Size Small Size show me how
Computer Apps 8
vocabulary list
| Term | Definition |
|---|---|
| active cell | the cell that is currently selected. Has thick black border around it. |
| active sheet | the sheet the user is currently working on in a workbook. The name of the tab of the active sheet is bold. |
| asterisk symbol | the multiplication symbol in a spreadsheet |
| autofit | automatically resizes the column to fit the widest entry. |
| border tool | formatts lines around a cell |
| cell | the intersection of a row and column. Cells hold data and perform functions |
| cell address | the column letter and row number of a cell |
| column | vertical part of the worksheet identified by letters. |
| equals sign | the first thing that must be entered in a formula |
| fill color | the paint bucket. fills a cell with a color. |
| fill handle | small square in the lower right corner of a selection. |
| fill series | tool to complete a series such as dates or days of the week |
| format painter | copies formatting from a selected cell onto new cells |
| formula | an equation that makes calculations based on the data in your spreadsheet |
| formula bar | displays the active cells content. Located directly above the cells. |
| insert chart - bar | used to compare data |
| insert chart - line | used to show changes over time |
| insert chart - pie | used to show the percent of a whole |
| insert image | used to insert images from the computer or a web search |
| labels/headings | the words or titles used in spreadsheet. |
| range | selection of two or more cells. |
| row | horizontal part of the worksheet identified by numbers. |
| sorting tool | arranges data into meaningful order so that you can analyze it more effectively |
| sum function | used to add a long column of numbers. |
| text box | places text over the worksheet so it can be moved around |
| view-freeze | allows you to freeze rows or columns |
| workbook | a single spreadsheet file with a collection of worksheets. |
| wrap text | makes the text fit into the width of the cells by adjusting the cell height |
| conditional formatting | allows you to apply specific formatting to cells that meet certain criteria |