# NC Online Computer Skills Test Spreadsheet

NC Computer Skills Test

## Terms

undefined, object

copy deck

- Chart
- A way to present information from a spreadsheet in the form of graphs or tables.
- Row
- The horizontal divisions in a spreadsheet named with a number.
- Ascending order
- Organizing or sorting information in order from smallest to largest, or A-Z or 1-9
- Active Cell
- The thick-bordered cell where you can enter numbers or formulas in a spreadsheet.
- Table
- Columns and rows of cells that can be filled with text that are used to organize information
- Graph
- A picture shows the relationship of one or more sets of numbers to each other. Some types are line, bar, area, and pie.
- Axis
- A feature of a chart, on which you can plot numbers. The horizontal line is called the X-_____, and the vertical line is called the Y-_____.
- Line Graph
- A graph used to display trends and compare data.
- Cell
- The space at the intersection of a row and column in a spreadsheet.
- Sort
- Arranging information in a specific order (usually ascending and descending).
- Circle graph
- A picture showing the relationship of two or more sets of data using a circle.
- Calculate
- The working of mathematical equations. Formulas that are usually used in spreadsheets allow the computer to automatically perform calculations.
- Pictogram
- Pictures used to create a bar graph chart
- Pie graph
- Circle graph divided into pieces that look like portions of a pie.
- Entry bar
- The field where information is entered in a spreadsheet.
- Value
- The term for a number in a spreadsheet that can be added, subtracted, multiplied or divided.
- Label
- The term given to the words entered on a spreadsheet, usually naming a column.
- Bar graph
- One type of graph developed from spreadsheet data that uses parallel bars to compare data and changes in data over time.
- Descending order
- Organizing or sorting information in order from largest to smallest, Z-A or 9-1
- Spreadsheet
- An application that can be used to do calculations, analyze and present data. It includes tools for organizing, managing, sorting and retrieving data and testing "what if " statements. It has a chart feature that displays numerical data as a graph.
- Column
- The vertical divisions in a spreadsheet that are named with an alphabetical letter
- Probe ware
- Computer assisted data collection tools