How can we help?

You can also find more resources in our Help Center.

active cell

Location in the worksheet that will display typed data or that will be affected by a command

formula bar

Displays the contents stored in te active cell

name box

Displays the active cell address or name assigned to active cell

sheet tabs

Identifies worksheets in the workbook

Use these tabs to change the active worksheet

Use these tabs to change the active worksheet

spreadsheet

is a table used to store variouys types of data

The data is arranged in rows and columns to make it easier to store, organize and analyze the information

The data is arranged in rows and columns to make it easier to store, organize and analyze the information

workbook

Information created in a worksheet and saved in a file called workbook. A workbook can contain a number of worksheets

cell

Intersection of row and Column

cell address

Location in the worksheet . It is represented by column first and row second

Example woould be: A1

Example woould be: A1

range

is a group of adjacent cells used in formulas and formatting

Contains the starting cell and the ending cell

Example would be (A1:D14)

Contains the starting cell and the ending cell

Example would be (A1:D14)

function

is a preprogrammed formula such as

SUM

AVERAGE

MAX

MIN

SUM

AVERAGE

MAX

MIN

formulas

are entered into a cell to preform mathematical calculations within a worksheet .

A formual always begins with an equal sign after the equal sign is the function then the argument

A formual always begins with an equal sign after the equal sign is the function then the argument

autosum

This action completes text entries as you start to type a new entry in a cell, a function that automatically adds selected cells

label (text)

is an entry that helps the reader relate to the values in corresponding column/row

equal sign

Prepares a cell for entry of a formula.

symbol used for multiplication

* the asterik is used for multiplication

order of operations

Paranthesis

Exponents

Multiplication

Division

Addition

Subtraction

Exponents

Multiplication

Division

Addition

Subtraction

row

appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window

column

appears vertically in a worksheet and is identified by letters at the top of the worksheet window

merge center

the process of merging cells and centering the data in the cells

wrap text

When the words wrap to the next line without hitting enter.

chart

a visual display of information

graph

a visual display of information or data

gridlines

The lines appearing around the cells in a table.

merge

combine cells into a single cell

calculate

the process of adding, subtracting multiply divide number by using a formula

white cross

use this cross to copy formulas to another cell

black cross

use this cross to copy data exactly

autofill

Copies content and formats from a cell or range into an adjacent cell or range

sparklines

mini charts that you can insert into a cell

axes

the vertical line along the left side of the graph and the horizontal line along the bottom of the graph

legend

Labels that identify the different data series in a chart.

sort

To arrange a list of words or numbers in ascending or descending order

formula view

A view of the worksheet that displays formulas instead of the resulting values. (EX 46)

absolute cell reference

A cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and row number, such as $A$5.

value

numeric characters that can be calculated in a spreadsheet

calculate

make a mathematical calculation or computation

entry bar

enter or edit the information to a cell.

function

a built-in formula included in most spreadsheet programs that makes it easy for you to perform common calculations

Types of data entered into spreadsheet

values, labels, date/time