Excel and Word
Select all box
A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet
Legend
A chart element that identifies the patters or colors that are assigned to the categories in the chart
Show formulas
A command that displays the formula in each cell instead of the resulting value.
Freeze panes
A command that enables you to select one or more rows or columns and locks them into place.
Date & Time
A command with which you can automatically insert the current date and time into a document in a variety of formats
Cover letter
A document that you send with your resume to provide additional information about your skills and experience
AutoCorrect
A feature that corrects common typing and spelling errors as you type, for example changing teh to the.
Function
A formula that Excel has already built for you
Row
A horizontal group of cells in a worksheet
Complimentary Closing
A parting farewell in a business letter
SUM Function
A predefined formula that adds all the numbers in a selected range of cells.
Thesaurus
A research tool that provides a list of synonyms
Drag-and-drop
A technique by which you can move selected text from one location in a document to another.
Column
A vertical group of cells in a worksheet
Enclosures
Additional documents included with a business letter
Auto Fill
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.
Workbook
An Excel file that contains one or more worksheets.
AVERAGE Function
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
MAX Function
An Excel function that determines the larges value in a selected range of values.
MIN Function
An Excel function that determines the smallest value in a selected range of values
MEDIAN Function
An Excel function that finds the middle value that has as many values above it in the group as are below it
Table
An arrangement of information organized into rows and columns
Formula bar
An element in the Excel window that displays the value or formula contained in the active cell; here you can also enter or edit values or formulas
Name box
An element of the Excel window that displays the name of the selected cell, table, chart, or object.
Formula
An equation that performs mathematical calculations on values in a worksheet.
Template
An existing document that you use as a starting point for a new document
Spreadsheet
Another name for a worksheet
X-axis
Another name for the horizontal axis
Y-axis
Another name for the vertical axis
1.08
Default line spacing in Word 2013
Content control
In a template, an area indicated by placeholder text that can be used to add text, pictures, dates, or lists.
Normal Template
Serves as the basis for all new Word documents.
Cell
The box at the intersection of a row and column in a Word table
Active Cell
The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.
Custom Word Templates
The default folder location in which Word stores templates
Calibri
The default font in Word 2013
Single Spacing - 1.0
The default spacing for a table. There is no extra space before or after a paragraph.
Dateline
The first line in a business letter that contains the current date and which is positioned just below the letterhead
Chart
The graphic representation of data in a worksheet; makes the data easier to understand than a table of numbers
Salutation
The greeting line of a business letter
Cell reference
The identification of a specific cell by its intersection column letter and row number.
Cell
The intersection of a column and a row
Ctrl+A
The keyboard shortcut used to select an entire document
Sheet tabs
The labels along the lower border of the Excel window that identify each worksheet.
Inside address
The name and address of the person receiving the letter
Writer's identification
The name and title of the author of a letter, placed near the bottom of the letter under the complimentary closing. AKA Writer's signature block
Letterhead
The personal or company information that displays at the top of a letter
Worksheet
The primary document that you use in Excel to work with and store data
Sort
The process of arranging data in a specific order based on the value in each field.
Filter
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify.
Fill handle
The small black square in the lower right corner of a selected cell.
Placeholder text
The text in a content control that indicates the type of information to be entered in a specific location
Body
The text of a letter
Range
Two or more selected cells on a worksheet
Ctrl+Tab
What you press to move to a tabbed location with a cell and not to the next cell.
Synonyms
Words with the same or similar meaning