Want to create interactive content? It’s easy in Genially!

Get started free

Spreadsheet Terms

Leslie Pirtle

Created on February 5, 2023

Start designing with a free template

Discover more than 1500 professional designs like these:

Smart Quiz

Essential Quiz

Practical Quiz

Akihabara Quiz

Pixel Challenge

Math Calculations

Piñata Challenge

Transcript

Spreadsheet Terms

start

The cell in the spreadsheet that is currently selected for data entry

Range

Active cell

Used to arrange information in a particular order

Sort

Cell Reference

To highlight a set of cells

Fill

Selecting

To fill a cell with color using the paint bucket tool

Value

Fill

The procedure to select certain information in a spreadsheet.

Filter

Fill

The horizontal and vertical lines on the spreadsheet

Grid Lines

Column

The column number and the row letter of a cell

Cell Reference

Active Cell

The cell in the spreadsheet that is currently selected

Cell Reference

Active Cell

Tabs that identify the worksheets in a workbook

Value

Sheet tabs

Predefined Formulas that are built into your spreadsheet software

Functions

Variables

The horizontal reference on the spreadsheet

Column

Row

One page of a spreadsheet

Cell

Worksheet

One page of a spreadsheet

Cell

Worksheet

Many worksheets

Graph

Workbook

A visual representation of data

Graph

Cell

A vertical collection of cells

Column

Enter

A spreadsheet data type that will calculate a result and display it in the active cell

Value

Formula

A formula that will add up a column of numbers

Range

Auto sum

A group of cells in a spreadsheet that have been selected

Range

Cell Reference

A formula that will add up a column of numbers

Range

Auto sum

To add up the range of cells directly above an active cell, you could use

Auto Sum

Auto fill

To compare parts to a whole, use a

pie chart

line graph

The best chart to measure a trend over a period of time is

Pie Chart

Line GRaph

On a spreadsheet, letters reference

rows

Columns

On a spreadsheet, numbers reference

columns

rows

On a spreadsheet, a letter with a number references

a worksheet

a cell

it's dinnertime!

watch out! you werewrong, caveman

back