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