Microsoft Word
software produced by the Microsoft company to produce text document such as letters,essays, resumes, reports etc.
Microsoft Excel
software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns
ribbon
an area at the top of an office program window that contains commands for working with the open file; the commands are organized under tabs.
blank document
A new blank document opens each time you start word. The word document has a temporary name, such as document 1. When you finish typing in the document, you can save it with a new name
cursor/insertion point
point on a display screen where the next character or space is entered.
red underline
Means the flagged text is not in Word's dictionary
green underline
Indicates the text may be incorrect grammatically
blue underline
correctly spelled word used inappropriately
Home Tab
called the primary tab, contains the more frequently used commands
Default page margins
1" top and bottom, 1 1/4" left and Right, this refers to the amount of non-printable space on a page.
Formatting Marks
special symbols that represent spaces, tabs, and paragraphs, that do not appear on paper when a document is printed
Undo button
A button on the Quick Access toolbar that you can click to undo (or reverse) your last action.
Quick Access Toolbar
A toolbar located in the upper-left corner of the program window, which displays the Save, Undo, and Repeat buttons by default but can be customized to include any command.
Word AutoCorrect Options
An automatic feature in software that corrects common spelling and capitalization errors, and can replace certain designated characters with special symbols
Microsoft Clipboard
It allows you to copy up to 24 multiple text and graphical items from Office documents or other programs and paste them into another Office document. By using it, you can arrange the copied items the way that you want in the document.
double-space
Pressing the enter key twice (2) leaving one blank line. This can also refer to line spacing using the word processing feature to leave one blank line between each line of text.
footer or footnote
a printed note placed below the text on a printed page
Hanging Indent
a paragraph format in which the first full line of text is not indented but the following lines are indented
header
text that is printed at the top of each page
line spacing
The amount of space between lines of text
right-aligned
flush with right margin with ragged left edge
thesaurus
A feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing
works cited page
a list of all the sources cited in a research paper (sources you acknowledge by including parenthetical citations/internal citation)
resume
a summary of your academic and work history
template
a feature that includes pre-made documents that allow the user to fill-in-the blanks to create new documents, such as calendars, invoices, reports, resumes, etc.; enhances user's efficiency and creativity
letterhead
the area on a sheet of stationery where the name, address and other information is printed
Quick parts
items you can insert include fields, such as current date, author, title, will update automatically
paragraph formatting
the process of changing the appearance of a paragraph
Application window
the main window that serves as the primary interface between the user and the application.
document window
occupies most of the screen
file
a saved document
file compatibility
the ability to open and work with files without a format conflict.
folders
hold and organize files and other folders in your computer
I-beam
the shape the mouse pointer takes when it is positioned on text in a document
Ribbon
An area at the top of an Office program window that contains commands for working with the open file; the commands are organized under tabs.
save a document
To store a document on a disk or other storage medium (control S)
Screentip
A balloon containing information that is displayed when you rest your mouse pointer on certain screen elements
alignment
The placement of text or graphics on a line (right, left, center, or justified)
drag-and-drop editing
The action of using a mouse to drag a selection from its original location and drop it in a new location.
edit
prepare for publication or presentation by correcting, revising, or adapting
first line indent
first line of paragraph is indented but not the others
font
the typeface or design of the text
format (Word)
To change the appearance or look of text.
Format Painter
a button on the Home tab that allows you to copy formatting from a selected object or cell and apply it to another object or cell
indent
the space left between the margin and the start of an indented line
landscape orientation
a page layout in which documents are printed across the length of a page, making the page wider than it is tall
manuel line break
A paragraph mark created by pressing the Enter key.
manual page break
A command inserted by the user to force a page break at a specific location.
margin
the blank space that surrounds the text on a page
portrait orientation
A page layout in which documents are printed across the width of a page, making the page taller than it is wide
default settings
settings used unless another option is chosen
word wrap
The process of breaking lines of text automatically to stay within the page margins of a document or window boundaries.
comment
An electronic note that the author or a reciever adds to a document.
hard copy
A printed copy of a document
markup
the revision marks and comments that appear in a document
Portable Document Format (PDF)
format developed by Adobe Systems designed to preserve the visual appearance and layout of each page and enable fast viewing and printing
read-only document
users can open and view the document, but they won't be able to make any changes to the document
soft copy
a digital copy of data
ascending order
lists data alphabetically or sequentially
cell
The intersection of a column and a row in a table or worksheet.
descending order
Organizing or sorting information in order from largest to smallest, Z-A or 9-1
gridlines
boundary lines in a table used for layout purposes; they show on the screen, but they do not print
merging cells
in excel, combining multiple cells by removing the boundaries between the cells, usually done to create a title or informational text for the worksheet
quick tables
built-in tables with sample data & table formats
Spreadsheet
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns
Row
Horizontal line of cells
Cell
the intersection of a column and a row; the "boxes
Column
A vertical line of cells
Cell Address
The column and the row number of a cell, e.g. C13; F27;
Formula Bar
A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking in this, or when you type an equal (=) symbol in a cell, this
: (the colon)
Range operator: Means inclusive; including all the cells. For Example; B3:B37 means b3,b4, b5,...to b37,
785003166
Adding two cells
#NAME?
the basic formula for most computations; autosum
Range
2 or more cells that are selected to create a source to be used in a formula
Sort
Putting data in order
Max
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
Average
the sum of all numbers divided by the amount of numbers. =Average(A15:A37)
median
The number in the middle. =MEDIAN(D2:D17)
Min
The lowest number, =MIN(F14:F55)
######
column is not wide enough
#name?
error in your formula
#div/0!
You need numbers in your cells. You can't divide by zero,
AutoFill
Completes previously typed words when you begin to repeat the typing
Format (Excel)
Making a change in the default settings
Charts (Column, pie, bar, and line)
Graphic representation of data
Worksheet
A single sheet within a workbook
Workbook
An Excel document; contains worksheets
Merge
Combining two or more cells into one
Number format
Formatting option that changes the way data looks in a cell.
Fill handle (cursor)
The black square in the lower-right corner or the active cell or range that you drag over the cells you want to fill.
Absolute cell reference
Do not change when copied or moved to a new cell; indicated by $; =($D$2+C3)
Label
Words or text in Excel; "January" or "Sales
Values
Numbers in Excel; "$1234" or "58%
Formula
The equation used to calculate values in a cell.
Function
The given formulas within Excel, such as AutoSum or AVERAGE
Conditional Formatting
Formatting based on specific rules or criteria
Nested
A formula within a formula
Resizing cursor
This cursor allows you to change the size of rows and columns.
Google Sheets
The Google version of Microsoft Excel
Google Docs
The Google version of Microsoft Word