TERM DEFINITION NOTE OR COMMENT sequence
Operators Operators are symbols that define There are also comparison operators 7 Go to sheet
the type of calculation that you want (=, >, <, etc.) and a text operator (&). Blank Sheet
to perform within a formula. The (operators)
simplest ones are for doing basic
math (+, -, *, /, ^)
Marquee This is a "moving-dots" marking In the case of Copy & Paste, the 7
around a cell or range that you have marquee stays visible so you can do
temporarily marked for some another paste operation. If it bothers
purpose (such as Copy & Paste or you, hit the Esc (escape) key on your
selecting a reference for inclusion keyboard.
into a formula).
Scrolling panes A way of dividing a window into two Horizontal split: drag the "split box" 7
separate sections that scroll above the vertical scroll bar.
independently. Vertical split: drag the "split box" to
the right of the horizontal scroll bar.
Shortcut key These are key strokes or key EXAMPLES: 8
combinations on the keyboard that Copy: ctrl-c
can trigger a command. Usually Paste: ctrl-v
faster than using the mouse. Format: ctrl-1
Save As: F12 (function key)
Insert Name in Formula: F3
Function A predefined formula that calculates The arguments have a specific order 8 Go to the sheet
a result using one or more values & other restrictions. This is called Blank
called "arguments". the function's "syntax". (functions.)
Argument An expression, constant or cell The argument list is specific for each 8
reference that occupies a position in function. Many functions use a Click here for more
a function's "argument list" and single argument. Others use multiple
detail about argument
produces a value that is appropriate arguments. (See Function.)
for that position.
Order of Rules of priority concerning Note: you can override these rules by 8
operations operators. These rules determine using parentheses. Click here
the "pecking order" in which Excel to see
does operations in formulas.
Logical Test An expression that has a value of This is essential to using the IF 9
either True or False. function to choose between two
courses of action.
Status bar The shaded area below the sheet Selecting a range containing 9
tabs. It shows what activity you are numbers displays "summary
performing or it gives brief statistics" (on the right side). Right
instructions about the next step in a click on the status bar to customize
procedure (on the left side). it.
881 345 6
ARGUMENT 1 FORMULA YOU TRY IT
ARGUMENT 1 ARGUMENT 2
G1:G3 H5:J5 1363
I'll see you later 18
ARGUMENT 1 ARGUMENT 2
If you've seen 26 If you've
one, you've seen one,
seen them all. you've
This is what a simple math formula looks like in Excel:
= something + something
The "thing" between the two "somethings" is called
TERM DEFINITION NOTE OR COMMENT
Cell A space in a spreadsheet that can contain information Each cell has a reference or address, such as D5
(text, numbers, formulas, hyperlinks, etc.) (column D, row 5).
Cursor Graphic element that indicates where the user is pointing Different shapes (fat plus, arrow, I-beam, 4-headed
with the mouse. Used to select, activate or move objects. arrow) indicate when the cursor will perform a different
Gridlines Gray lines that show cell boundaries. Not the same as Don't show up on printed spreadsheets (unless you tell
borders. Excel to print them).
Menu (Excel A list of commands that can be accessed by clicking on a You know, File, Edit, View, Insert, and so on…
2003) category in the Menu Bar.
Ribbon (Excel A horizontal strip of commands (shown as icons) that is The main categories are Home, Insert, Page Layout,
2007, 2010) positioned at the top of the Excel window. Formulas, Data, Review & View.
Active cell The cell that is selected and has a highlight border around (Note: in a range, the active cell is the one that does
it. You may modify the contents of the active cell. not appear to be shaded.)
Active sheet In a workbook with multiple worksheets, this is the one The tab for the active sheet looks white. The tabs for
you are currently using. inactive sheets look gray or colored.
Range This is when you select more than one cell (by click-and- Tab and Enter will move within the range. Arrow keys
drag or by shift-click). or mouse clicks will cancel the range.
Row & column The letters at the top of the spreadsheet columns and the (See "Cell".)
headers numbers at the left of spreadsheet rows.
Workbook An Excel file. The workbook may contain multiple objects (See "Worksheet".)
(spreadsheets, charts, etc.).
Worksheet A spreadsheet in an Excel Workbook. Each worksheet has a "file folder tab" with its name at
the bottom of the window.
Formula bar The white region above the column headings where the You can edit the text in the FB in the same way you
contents of a cell can be observed or edited. edit other text documents.
Operators Operators are symbols that define the type of calculation There are also comparison operators (=, >, <, etc.) and
that you want to perform within a formula. The simplest a text operator (&).
ones are for doing basic math (+, -, *, /, ^)
Sheet tab The bottom part of a worksheet that shows the name of Double-click on the sheet tab to change its name.
that sheet. It looks like the tab on a manila folder.
Toolbar (Excel A collection of icons that are grouped together at the top, The Standard and Formatting toolbars should always
2003) side or bottom of the Excel window. be visible. If you don't see them, click on the View
menu and point at Toolbars.
Border A printing border you put around a cell, a range or all the The Borders tool on the Formatting toolbar give a
cells in a range. variety of options.
If you use Format>Cells… and choose the Border tab,
there are even more options.
TERM DEFINITION NOTE OR COMMENT
Marquee This is a "moving-dots" marking around a cell or range In the case of Copy & Paste, the marquee stays visible
that you have temporarily marked for some purpose (such as long as you don't do a non-copy operation. If it
as Copy & Paste or selecting a reference for inclusion into bothers you, hit the Esc (escape) key on your
a formula). keyboard.
Office This is the cute (?) animated figure that appears when you Usually it allows you to type a question or phrase to get
assistant select "Show the Office Assistant" in the Help menu. information from the built-in Help system. Other times
it may make suggestions as you work.
Format A section of the Format>Cells… menu command that Cells start out with the General format (meaning no
Number allows you to display a number as a date, a time, a specific format has been set). Also, you can format
number, a currency, an accounting figure, etc. cells that are empty.
Scroll bar The region at the right or bottom of a window that allows There are many ways to scroll
you to "slide the window" to view parts of the sheet that - tiny arrows
are outside its edges. - click-and-drag the bar
- click above or below the bar
- roll the wheel on the mouse
- click the wheel on the mouse
Name box The white box to the left of the formula bar. If you have Note: if you start composing a formula, the name box
selected a cell or range that has a name, that name will will turn gray, and it becomes a function browser.
Named cell or A label that you create to represent one or more cells. Recommendation: put the label in one cell and the
range Much easier to use in formulas than the row+column cells to name next to or below that label. Then use this
references. menu path: Insert>Name>Create…
Order of Rules of priority concerning operators. These rules Note: you can override these rules by using
operations determine the "pecking order" in which Excel does parentheses.
operations in formulas.
Scrolling A way of dividing a window into two separate sections that Horizontal split: drag the "split box" above the vertical
panes scroll independently. scroll bar.
Vertical split: drag the "split box" to the right of the
horizontal scroll bar.
Logical Test An expression that has a value of either True or False. This is essential to using the IF function to choose
between two courses of action.
Argument An expression, constant or cell reference that occupies a The argument list is specific for each function. Many
position in a function's "argument list" and produces a functions use a single argument. Others use multiple
value that is appropriate for that position. arguments. (See Function.)
Function A predefined formula that calculates a result using one or The arguments have a specific order & other
more values called "arguments". restrictions. This is called the function's "syntax".
Nested Using a function as an argument within another function. This happens when an argument for a function can't be
functions typed as a static value. Rather, the argument must be
calculated using another function.
Shortcut key These are key strokes or key combinations on the For example, Ctrl-1 is the same as the Format>Cells
keyboard that can trigger a command. Usually faster than command.
using the mouse.
Status bar The gray border below the sheet tabs. It shows what Right-clicking on the status bar allows you to choose a
activity you are performing or it gives brief instructions numerical "status function" that gets displayed
about the next step in a procedure (on the left side). (towards the right side) when you select a range.