Excel Chapter 1 Terms
Auto Fill Options
Button that allows you to copy values with or without formatting, or the format only.
Category Axis or X-Axis
the horizontal axis of a chart.
Enter
Excel is in the process of accepting data through the keyboard into the active cell
Ready
Excel is ready to accept the next command or data entry.
Colon
Placed between the starting value and ending value when defining a range.
Apostrophe
Used to enter a number as text.
Insertion Point
a blinking vertical line that indicated where the next typed character will appear.
Cell Reference
a cell is referred to by its unique address, which is the coordinates of the intersection of a column and a row. For example, D11, is located in column D and row 11.
Key Tip
a code letter for a command.
Theme
a collection of cell styles and other styles that have common characteristics, such as a color scheme and font type. The default theme for an Excel workbook is the Office theme, which will put Cambria for headings and Calibri for body of the worksheet.
Column Heading
a column letter above the grid identifies each column.
Live Preview
a feature that allows you to point to a gallery choice and see its effect in the worksheet without actually selecting the choice.
Home Key
a key that selects the cell at the beginning of a row with the active cell
Microsoft Excel
a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.
Hard Copy or Printout
a printed version of the worksheet.
Row Heading
a row number on the left side of the grid identifies each row
File
a saved workbook.
Range
a series of two or more adjacent cells in a column or row or a rectangular group of cells
Gallery
a set of choices, often graphical, arranged in a grid or in a list.
Point Size
a single point is about 1/72 of one inch in height.
Fill Handle
a small black square located in the lower-right hand corner of the heavy border around the active cell. Placing the mouse pointer in the lower-right hand corner of the heavy border around the active cell, the mouse pointer will change to a black cross, left-click and drag and Excel will fill the cells.
Folder
a specific location on a storage medium
Task Pane
a window that contains additional commands and can stay open and visible while you work on the worksheet.
Format
a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
Four major parts of Excel are:
a. Workbooks - a collection of worksheets. Worksheets - allow users to enter, calculate, manipulate, and analyze data such as numbers and text. The terms worksheet and spreadsheet are interchangeable. There are three worksheets with each new Excel workbook. b. Charts - Excel can draw a variety of charts. c. Tables - organize and store data within worksheets. Once a user enters data into a worksheet, an Excel table can sort the data, search for specific data, and select data that satisfies defined criteria. d. Web Support - allows users to save Excel worksheets or parts of a worksheet in HTML format, so a user can view and manipulate the worksheet using a browser. Excel Web support also provides access to real-time data, such as stock quotes, using Web queries.
SUM function
adds all of the numbers in a range of cells, provides a convenient means to accomplish adding.
Splitting a merged cell
after you have merged multiple cells to create one merged cell, you can unmerge, or split, the merged cell to display the original cells on the worksheet. You do this by selecting the merged cell and clicking Merge & Center button.
. Relative Reference
an adjusted cell reference.
Bold
an entry in a cell to emphasize it or make it stand out from the rest of the worksheet.
Enhanced Screen Tip
an on-screen note that provides the name of the command, available keyboard shortcuts, a description of the command, and sometimes instructions for how to obtain Help about the command.
Mini Toolbar
appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet.
Formula Bar
appears below the Ribbon and shows the current text within an active cell.
Shortcut Menu
appears when you right-click an object, is a list of frequently used commands that relate to the right-clicked object.
Standard Properties
are associated with all Microsoft Office documents and include author, title, and subject
Insert Mode
as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.
Edit Mode
by double-clicking into a cell containing an error will change the mode. Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell.
Overtype Mode
by pressing the INSERT key this turns this feature on and off. Excel overtypes, or replaces, the character to the right of the insertion point.
Home Tab
called the primary tab contains groups with the more frequently used commands.
Number
can contain only the following characters: 0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e
AutoCalculate Area
can easily obtain a total, an average, or other information about the numbers in a range by using the AutoCalculate area on the status bar
Metadata
can include such information as the project author, title, or subject.
Cancel Box
cancels an entry for a cell. Located on the formula bar.
Surface Chart
chart used to compare data from three columns in a three-dimensional manner.
Line Chart
chart used to illustrate changes in data over time.
Pie Chart
chart used to show the contribution of each piece of date to the whole.
Enter Box
completes an entry for a cell. Located on the formula bar.
Menu
contains a list of commands
Dialog Box
contains additional commands and options for the group. When presented with a dialog box, you make selections and must close the dialog box before returning to the worksheet.
Document Information Panel
contains areas where you can view and enter document properties.
Backstage View
contains commands to manage files.
Font
defines appearance and shape of letters and numbers
Font Color
defines the color of the characters.
Document Properties
details about a file.
Name Box
displays the active cell reference on the left side of the Formula Bar.
Sheet Tab
each worksheet has a sheet name that appears at the bottom of the workbook. As a default, Excel names them Sheet1, Sheet2, and Sheet3. These sheets can be renamed to something descriptive about that individual sheet.
Snaps
holding down the ALT key while you drag a chart snaps (aligns) the edge of the chart area to the worksheet gridlines. If you do not hold down the ALT key, then you can place an edge of a chart in the middle of a column or row.
Legend
identifies the colors assigned to each bar in the chart.
Automatically Updated Properties
include file system properties, such as the date you create or change a file, and statistics, such as the file size.
Requirements document
includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet, such as charting and Web support
Font Style
indicates how the characters are emphasized. Common font styles include regular, bold, underline, or italic.
Merging Cells
involves creating a single cell by combining two or more selected cells.
Submenu
is a list of additional commands associated with the selected command
. Quick Access Toolbar
located by default above the Ribbon, provides easy access to frequently used commands
AutoCorrect feature
of Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell. AutoCorrect makes three types of corrections for you: i. Corrects two initial capital letters by changing the second letter to lowercase. ii. Capitalizes the first letter in the names of days. iii. Replaces commonly misspelled words with their correct spelling.
Active Cell
one cell on the worksheet where the heavy border surrounds the cell is the one into which you can enter data into
ScreenTip
only displays the name of the command
Font Type
or font face, defines the appearance and shape of the letters, numbers, and special characters.
Key Tip Badge
or keyboard code icon, by pressing the ALT key on the keyboard you can use the keyboard to maneuver around the worksheet instead of the mouse. To remove the Key Tip badges from the screen, press the ALT key or the ESC key on the keyboard until all Key Tip badges disappear
Status Bar
presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.
Green Computing
reducing the environmental waste generated when using a computer by printing files out instead of sending electronic documents which then saves paper and printer supplies.
In-Ribbon Gallery
shows common gallery choices on the Ribbon rather than in a drop down list
Font Size
specifies the size of the characters on the screen. Font size is gauged by a measurement system called points.
Mode Indicators
such as Enter and Ready, appear on the Status Bar and specify the current mode of Excel.
Keyboard Indicators
such as Scroll Lock, show which toggle keys are engaged. Keyboard indicators appear to the right of the mode indicator.
Source Area or Copy Area
the cell being copied.
Ribbon
the control center in Excel. The Ribbon consists of tabs, groups, and commands. a. Tab - surrounds a collection of groups. b. Groups - contains related commands. c. Commands - includes buttons, boxes (text boxes, check boxes, etc.), and galleries.
Normal Layout View
the default (preset) view of Excel that shows worksheets as continuous rows and columns
Gridlines
the horizontal and vertical lines on the worksheet itself. As a default, these gridlines do not print.
Cell
the intersection of each column and row. A basic unit of a worksheet into which you enter data.
Dialog Box Launcher
the lower-right corner of some groups on the Ribbon has a small arrow, that when clicked displays a dialog box or a task pane.
Right-aligned
the numeric value cell entry is positioned in the far right of a cell.
Worksheet Window
the portion of the worksheet displayed on the screen.
Destination Area or Paste Area
the range of cells receiving the copy.
Active Tab
the tab currently displayed.
Left-aligned
the text value cell entry is positioned at the far left in the cell.
Value Axis or Y-Axis
the vertical axis of a chart. Excel derives the chart scales based on the values in the worksheet and then displays the scale along the vertical axis.
Tab Split Box
to increase or decrease the view of the sheet tabs. When you decrease the view of the sheet tabs, you increase the length of the horizontal scroll bar, and vice versa.
Selecting a Cell
to use the mouse to move the block plus sign mouse pointer to the cell and then click. You know a cell is selected or active, when a heavy border surrounds the cell and the active cell reference appears in the Name box on the left side of the formula bar.
Scroll Bars, Scroll Arrows, and Scroll Boxes
use to move the worksheet window around to view different parts of the active worksheet
File Tab
used to display Backstage view.
Text
used to place titles, such as worksheet titles, column titles, and row titles, on the worksheet. Any set of characters containing a letter, hyphen (as in a telephone number), or space is considered text. Examples: 401AX21, 921-231, 619 321, 883XTY
In-cell Editing
when Excel is in the Edit mode it allows you to edit the contents directly in the cell.
Embedded Chart
when a chart is drawn/inserted on the same worksheet as the data.
Tool or Contextual Tabs
when you perform certain tasks or work with objects such as charts or tables.
Excel Help
where you can find answers to questions and display information about various topics through Excel.
Keywords
words or phrases that further describe the document.
Worksheet tabs
worksheet names can be up to 31 characters (including spaces) in length.
