Excel 2010 Vocabulary

39 terms by drogers0510 

Create a new folder

Advertisement Upgrade to remove ads

Excel Terminology

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

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

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

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)

function

is a preprogrammed formula such as
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

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

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set