Excel vocab

will appear in the Name Box

A1

perform mathematical calculations

Arithmetic operators

compare values for the purpose of true/false results

Comparison operators

allows you to enter or edit data in the worksheet

Formula Bar

displays the active cell address

Name Box

enable you to use ranges in calculations

Reference operators

join strings of text in different cells

Text concatenation

the cell that is being worked in. The column, row and headings are highlighted to show where you are working.

active cell

the information necessary to calculate an answer

arguments

include what type of calculation you want to perform on the cells, ranges or values

calculation operators

the intersection of a column and a row and can contain text, numbers, formulas, or a combination of all three

cell

each has its own unique address; identified by the coordinates of the intersecting column and row

cell address

a dark rectangle that outlines the cells you are working it

cell pointer

work done in a virtual environment

cloud computing

labeled alphabetically

columns

changing the contents of an active cell

edit

an equation in a worksheet

formula

built in formula

function

a blinking vertical line that appears on the formula bar at the location where new text will be inserted

insertion point

entries that contain text and numerical information not used in calculations

labels

an area on the left end of the status bar that indicates the program's status.

mode indicator

a selection of two or more cells, such as B5:B14

range

labeled numerically

rows

the bar on the right edge (vertical scroll bar) or bottom edge (horizontal scroll bar) of the document window that is used to display different parts of the document in the document window

scroll bars

allow you to navigate to additional sheet tabs when available; located below the worksheet grid

sheet tab scrolling button

identify the sheets in a workbook and let you switch between sheets; located below the worksheet grid

sheet tabs

horizontal bar at the bottom of a program window that displays simple helpful information and tips

status bar

numbers, formulas, and functions that can be used in calculations

values

contains a grid of columns and rows

worsheet window