Basic Word and Excel

Restore Button

The button in the middle of the three buttons located at the right end of the title bar on a maximized window. It restores the minimized window to its previous size.

cell style

Used to apply several formats at once to a selected cell or cell range

scroll bars

located along the right side of the window and below the document, if necessary. You use them to bring unseen parts of the document in to view.

body text

main text

first line indent

moves the first line of a paragraph in from the remaining lines

value

numeric and can be used in calculations

task pane

or dialogue box holds additional options related to the group

center alignment

places text equally between left and right edges.

double-click

pressing the left mouse button twice in quick succession.

landscape orientation

prints across the longest side of the paper

portrait orientation

prints along the shortest side of the paper

workbook

refers to the entire excel file.

Font

refers to the typeface, size, and style for a character.

crop

removes unwanted edges from a photo

rulers

run along the left and top of the document area show the size of the paper and are useful for alignment purposes

row

run horizontally and are identified with numbers

column

run vertically and are identified with letters

status bar

runs along the bottom of the window in the lower left of the status bar is a page count, word count, and a proofing errors indicator. On the right side is a zoom slider you can use to change the magnification of your document.

selected cell

see active cell

Point

size of the characters and letters

left alignment

typical for letters, research papers, and general communication. text with this alignment lines up on the left, with a jagged right edge

bulleted list

used for items of equal importance uses box characters to provide a checklist

numbered list

used for items that should be in a specific order.

right alignment

used in advertisements and image captions. text with this alignment lines up on the right with a jagged left edge

input device

used to communicate with an application. input devices you'll most likely use are the keyboard, mouse, touch pad, and stylus.

column

used to control length in publications with a lot of texts, such as newspapers, brochures, and newsletters.

label

used to identify the purpose of a worksheet

timestamp

when you insert a date, word actually inserts a code called a timestamp, which can include either a date, a time, or both.

chronological order

(Time Order) Events are arranged in the order in which they happened

office clipboard

An area of memory where cut or copied text is placed

legal size

8 1/2 x 14 paper size

manual column break

A command inserted by the user to adjust where a column ends.

word art

A feature within Microsoft Word that creates decorative effects with a string of text.

pointer

A graphic image displayed by the mouse

Application Interface

A set of subroutine definitions, communication protocols, and tools for building software. In general terms, a set of clearly defined methods of communication between various companies.

worksheet

A single sheet within a workbook file; also, the entire area within an electronic spreadsheet that contains a grid of columns and rows.

Word processor

A software application that creates, stores and prints documents. Word Processors are categorized as application software created to accomplish specific tasks as needed by the user.

clipboard

A storage area that temporarily stores the items for a user to paste in another location of the document or office file.

cell name

Also called the cell reference; made up of the cell's location in a column & row, for example A1

conditional formatting

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.

word wrap

A tool that automatically wraps text to the next line as it reaches the right margin.

scroll

A way to view locations on the worksheet without changing the active cell.

Quick Access Toolbar

A windows office feature that contains a set of predefined or commonly used commands that may be used and generated across all environments. located in the upper left-hand corner of an Office application and may be displayed above or below the ribbon.

Absolute cell reference

Cell reference that does not adjust to the new cell location when copied or moved

nameplate

The banner on the front page of a newsletter that identifies the title and date of the publication.

descending order

In order from the highest value to the lowest. e.g. 9-1 or Z-A.

ascending order

In order from the lowest value to the highest. e.g. 1-9 or A-Z.

sheet

One page of a worksheet

PDF file

Portable Document Format maintains the formatting and layout of your file, but cannot be easily changed.

right-click

Pressing and releasing the right mouse button quickly

click

Pressing the left mouse button and releasing it quickly

handles

Small boxes that appear along the perimeter of a selected object and are used to change the size of an image.

formatting marks

Symbols used to represent characters not normally displayed as text, such as paragraph marks, spaces, and tabs. these are sometimes called 'invisibles'

editing

The process of changing contents of a document almost always involves adding and removing text.

Pagination

The process of determining where one page ends and another begins.

page layout

The way text, graphics, and space are organized on a document page.

Active cell

also called the selected cell, it has a bold border and is where the data you type will appear.

drag

When you move the mouse while holding down the mouse button (usually the left) to select a range of cells.

hanging indent

leaves the first line in place while moving the remaining lines in used for lists

insertion point

a blinking line/cursor that indicates the location where the next character typed will appear

Minimize Button

a button that hides a window so that only its program button is visible on the taskbar. represented by a dash in the top right corner of the window.

thesaurus

a feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing

clip art

a feature that includes pre-made illustrations, drawings, pictures, and other graphic that can be inserted into a document

tab stop

a formatting feature that allows the user to control where a line of text will be entered and how the text will be aligned; so that when the tab key is pressed, the insertion point will move to that location

theme

a named set of colors, fonts, and effects.

style

a named set of formats

Manual page break

a page break you insert to start a new page

Tell me box

a search tool and help feature. Click when you cant locate a command, or when you just want to learn how to preform an action

Argument

a statement of the meaning or main point of a literary work

cell reference

a unique identifier for a cell which is formed by combining the cell's column letter and row number

tab leader

add a repeated character between items separated by a tab

justified alignment

adjusts the space between words to align on both the right and left edges. most commonly used in news papers, magazines, and books. sometimes it can look awkward if there's a short line and a lot of space is added.

continuous section breaks

allows multiple sections on the same page

section break

allows the same document to have multiple page formats

creative commons license

allows you to use images for free for non-commercial use.

footer

appears at he bottom of every page in a document.

header

appears at the top of every page in a document

painting device

applies copied formats to multiple paragraphs or sections of text

text boxes

can be placed anywhere on a page much like a graphic, can be sized, shaded, and have borders and other graphic elements

close button

click to close the application window upper right hand corner

file tab

click to display the backstage view with options for opening, saving, printing, sharing, and choosing a file.

checkbox

click to either select or clear the option.

ribbon

contains word commands

date and time

data type used to arrange and sort data chronologically, often used with the input mask field property

sans serif

doesn't have the strokes as serif does

next page section break

ends a section and starts a new section on a new page

range

group

smartart

is an organization graphic used by Microsoft Word to help communicate information

screen tip

small boxes that pop up when you hover the mouse over a command on the ribbon or other features on the word document window display information about a feature, including keyboard shortcuts for executing the feature without having to remove your hands from the keyboard

selected text

text highlighted

orientation

the direction in which a page will be printed

cell

the intersection of a row and column and has a cell name, such as A1.

boundary

the line between columns or rows

Typeface

the name of the design of the letters and other characters.

ergonomics

the scientific study of people at work. it's goal is to reduce stress, strain, and fatigue.

serif

the small stroke or lines at the end of a letter, which draw the letters of a word together for easier reading.

letter size

the standard 8 1/2 x 11 paper size

margins

the white space around the text on a page