Docstoc

terminology

Document Sample
terminology Powered By Docstoc
					MICROSOFT EXCEL
                                                      TERMINOLOGY

          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)
                                                                    Print: ctrl-p
                                                                    Find: ctrl-f
                                                                    Replace: ctrl-h
                                                                    Insert Name in Formula: F3
                                                                      (function key)
                                                                    Save: ctrl-s

  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.)
                                                                                                                                   forms
                            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.
                                                                                                                           examples
  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.




   \rfiske\06fc3194-dff0-4200-b41e-8c4d12e6ed21.xls                                                                                     2004
                                                     42
                                                     23
                                                     66

                                                                 881 345   6




  ARGUMENT 1                         FORMULA              YOU TRY IT
              6.3                   2.50998008



ARGUMENT 1            ARGUMENT 2
G1:G3                H5:J5                 1363



ARGUMENT 1
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
an operator.
MICROSOFT EXCEL
                                                                  TERMINOLOGY
        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
                                                                                function.

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.




       \rfiske\06fc3194-dff0-4200-b41e-8c4d12e6ed21.xls                                                                          8/2/2012
MICROSOFT EXCEL
                                                               TERMINOLOGY
     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.
                   appear here.

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.



    \rfiske\06fc3194-dff0-4200-b41e-8c4d12e6ed21.xls                                                                           8/2/2012

				
DOCUMENT INFO
Categories:
Tags:
Stats:
views:19
posted:8/1/2012
language:Unknown
pages:5