NEW
Font size
WorksheetsUnit 6 | Spreadsheet Vocabulary
Total questions: 20
Worksheet time: 7mins
Light gray lines that divide each of the cells, rows, and columns in a spreadsheet
Sparkline
Gridlines
Worksheet
Cell Location
A tool that allows you to copy animations or formatting easily from one object to another
Painter
Function
Autofill
Workbook
To format data in such a way that it can be used by another application
Autofill
Export
Import
Merge
To use data produced by another program
Filter
Import
Export
Sort
To combine into one
Sort
Filter
Import
Merge
A formula or equation used to generate an answer
Cell Reference
Function
Autofill
AutoSum
A tool which fills in a field or cells automatically
AutoSum
Import
Autofill
Merge
The vertical parts of a spreadsheet denoted by capital letters
Cell Location
Columns
Rows
Cell Reference
The horizontal parts of a spreadsheet denoted by numbers
Rows
Columns
Cell
Relative Reference
Referring to a rectangle on a spreadsheet by naming the column and then row in which it lies
Cell Location
Absolute Reference
Cell Reference
Sparkline
The rectangular fields you can type in on a spreadsheet formed when a column and row intersect
Worksheet
Cell
Workbook
Painter
The entire spreadsheet file you are working in. It can contain one or more worksheets
Workbook
Worksheet
Painter
Cell Reference
A part/page on a spreadsheet file you are working in
Workbook
Sparkline
Cell Location
Worksheet
A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes
Gridlines
Painter
Sparkline
Workbook
Automatically adds up values in a row or column
AutoSum
Autofill
Import
Export
To put in order
Merge
Function
Filter
Sort
To remove unwanted pieces of data from view in a table
Sort
Merge
Filter
Autofill
A spreadsheet cell that does not change regardless of its attributes
Relative Reference
Cell Reference
Absolute Reference
Cell Location
A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on
Relative Reference
Cell Reference
Absolute Reference
Cell Location
Refers to a cell or range of cells on a worksheet and can be used in a formula so the program can find the values or data you want a formula to calculate
Relative Reference
Cell Reference
Absolute Reference
Cell Location
