Flashcards
Spreadsheet Terminology
Flashcards do conjunto (25)
- 1SpreadsheetSpreadsheet- An application that can be used to calculate, analyze and present data.
- 2Active Cellthe thick-bordered cell where you can enter numbers or formulas
- 3Cellthe space at the intersection of a row and a column
- 4Cell Addressthe location of a cell on the spreadsheet identified by the column letter and row number
- 5Cell Rangea group or block of cells in a spreadsheet. Operations can be performed on a range of cells. The range highlighted below is B3 through D4. It is written as B3:D4
- 6Cell Reference ErrorIf a formula is not correctly entered in a spreadsheet the error message #REF will appear in the cell.
- 7Chart/GraphVisual representation of data in a spreadsheet
Types of charts and what they are used for
Line Graph - used to display trends over a period of time.
Pie Graph - shows relationship of one set of data to the entire data set.
Bar Graph - Used to compare individual or sets of values to each other. - 8Columnthe vertical (up and down) divisions in a spreadsheet that are named with an alphabetical letter
- 9Column Headingthe lettered box at the top of a column in a spreadsheet, used to highlight an entire column
- 10Formula Bar or Data Entry Barthe bar at the top of the spreadsheet used to enter data into the cell that you have selected
- 11Gridblank setup of rows and columns in a spreadsheet on which data is to be entered
- 12Gridlinesthe vertical and horizontal lines displayed in the body of a spreadsheet; the intersections of the gridlines forms cells
- 13Legendtext that explains the meaning of colours and patterns used in a graph/chart also called the key
- 14Rowthe horizontal divisions in a spreadsheet named with a number
- 15Row Headingthe numbered box at the beginning of a row in a spreadsheet, used to highlight an entire row
- 16Sortarranging information in a specific order (usually ascending and descending)
- 17Ascending Orderorganizing or sorting information in order from smallest to largest, or A-Z or 1-9.
- 18Descending Orderorganizing or sorting information in order from largest to smallest, Z-A, or 9-1
- 19Data - Labelthe term given to the data entered as text in a spreadsheet
Most people just use the more common word - text. - 20Data - Valuesthe term give to the data entered as numbers in a spreadsheet
Many people prefer more common word - numbers. - 21Data - FormulasFormulas are used to perform calculations. They can range from basic mathematical operations, add & subtract, to complex engineering and statistical calculations.
- 22FormulasFormulas always begin with =
- 23Data• data is a collection of information
gathered by observation, questioning or measurement.
• data is often organised in graphs or charts for analysis and
may include facts, numbers or measurements. - 24WorksheetOne page of a spreadsheet
- 25WorkbookMany worksheets in one file
Informações
- Descrição
- Foundation Technologies FlashCards sobre Spreadsheet Terminology, criado por Judy Stephenson em 10-01-2018.
- Criado por
- Judy Stephenson
- Visualizações
- 637
- Tags
- Avaliação