Microsoft Office Word
A full-featured word processing program
Saturday, September 20, 2014
1:38 PM
1:38 PM
Word window
The main elements of the ________ include the Ribbon, Mini toolbar, and Office Button
insertion point
The _________ is a blinking vertical bar that indicates where text, graphics, and other items will be inserted.
ribbon
The _______ is the control center in Word.
gallery
A(n) ___________ is a set of choices, often graphical, arranged in a grid or in a list.
task pane
A __________ is a window that can remain open and visible while you work in the document.
home
The ______ tab contains the more frequently used commands.`
tab
Each ________ on the Ribbon surrounds a collection of groups, and each group contains related commands.
content control
A(n) __________ contains instructions for filling areas of a template.
grow font
Word provides a(n) ________ button, which increases the font size of selected text each time you click the button.
Quick Access toolbar
The _________ provides easy access to frequently used commands.
enhanced screen tip
A(n) ___________ is an on-screen note that
provides the name of the command, available keyboard shortcut(s), a
description of the command, and sometimes instructions for how to obtain
help about the command.
red X
When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a __________.
font
The _________, or typeface, defines the appearance and shape of letters, numbers, and special characters.
ENTER
The paragraph mark is a formatting mark that indicates where the ________ key wad pressed.
No
Are you supposed to press the ENTER key when the insertion point reaches the right margin?
footnotes; endnotes
When using the MLA style, position
explanatory notes either at the bottom of the page as __________ or at
the end of the research paper as ____________.
ENTER
Each time the ______ key is pressed, the
paragraph formatting in the previous paragraph is carried forward to the
next paragraph.
mini
The _________ toolbar contains commands related to changing the appearance of text in a document.
double; 1st line
Footnote text is _________-spaced, the same font size as the rest of the research paper, and has a ___________ indent.
thesaurus
A(n) ___________ is a book of synonyms.
Works Cited
According to MLA style, the _________ is a list of sources that are referenced directly in a research paper.
clipboard
The __________ is a temporary Windows storage area.
horizontal ruler
Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ______.
1
The rule is to press the spacebar _______ time(s) after periods, colons, and other punctuation marks.
footnote
A note reference mark signals that an explanatory note exists at the bottom of the page as a(n) _________.
mini toolbar
When you move the mouse pointer into the transparent _________, it changes to a bright toolbar.
Clip art
_________ is a predefined graphic.
centered
On the horizontal ruler, an upside down T indicates a _________ tab stop.
objective; contact info; educational background; work experience
At a minimum, your resume should present _________, __________, _________, and ____________.
AutoCorrect
Word has a list of predefined typing, spelling, capitalization, and grammar errors that _________ can detect and correct.
block
In the _______ letter style, all components of the letter begin flush with the left margin.
style set
A ___________ consists of a group of frequently used styles formatted so they look pleasing when used together.
date line; inside address; message; signature block
Essential business letter elements include the ____________, _____________, ___________, and ____________.
salutation
In a business letter, the _________, if present, begins two lines below the last line of the inside address.
TAB
To advance rightward from one cell to the next in a table, press the __________ key.
bullet
A(n) ____________ is a dot or other symbol positioned at the beginning of a paragraph.
SHIFT+ENTER
In Word, press __________ to create a line
break, which advances the insertion point to the beginning of the next
physical line, ignoring any paragraph formatting instructions.
spreadsheet
Excel is a powerful __________ 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.
Workbooks
________ are a collection of worksheets.
cell
The intersection of each column and row is called a _______.
row #
In Excel, to identify a cell, specify the column letter first, followed by the _________.
text
In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered _________.
range
A ________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
double click
In Excel, to verify a formula in a cell by using Range Finder, _________.
chart
A _________ is a graphical representation of data from the worksheet.
merging
Combining two or more cells together is called ____________ cells.
embedded
A(n) _________ chart is drawn on the same worksheet as the data.
format
You _________ a worksheet to emphasize
certain entries, change the font size, add color to areas, and make the
worksheet easier to read and understand.
fill handle
The small black square located in the lower right corner of the heavy border around the active cell in Excel is the ________.
formula bar
As you type, Excel displays the entry in the ______ and also displays the active cell reference in the Name box on the left.
worksheets
Excel opens a new workbook with three ___________.
ribbon
The ________ located near the top of the Excel window is the control center in Excel.
home
The ________ tab is called the primary tab of the Ribbon.
web query
To import data stored on a Web site use a ____________.
$
You can apply Accounting Number format by
clicking the Accounting Number style button on the home tab which
appears as a _______.
Insert
The commands to insert a chart in Excel are located on the _________ tab.
AutoCalculate
By using the ____ area on the status bar,
you can easily obtain a total, an average, or other information about
the numbers in a range.
ALT+ENTER
In Excel, to start a new line in a cell,
press __________ after each line, except for the last line, which is
completed by clicking the Enter box, pressing the ENTER key, or pressing
one of the arrow keys.
conditional
You can apply _________ formatting that appears only when the value in a cell meets conditions that you specify.
29
When Excel follows the order of operations, the formula 9*3+2 equals _________;.
destination
In Excel, the cell being copied is called the source area. The range of cells receiving the copy is called the _____.
recalculates all
Every time you enter a value into a cell in the worksheet, Excel automatically _________ formulas.
Best fit
___________ means that the width of the column will be increased or decreased so the widest entry will fit in the column.
active
The cell into which data is being entered is referred to as the ___________ cell.
CTRL+`
To toggle between the values verson and the formulas version of a worksheet, hold down the _________ keys.
Increase Decimal
Using the ______ button on the Ribbon instructs Excel to display additional decimal places in a cell.
formulas version
The _______ of the worksheet shows the actual formulas you have entered, rather than the resulting values.
debugging
The process of finding and correcting errors in a worksheet is called ___________.
decrease; increase
If you drag the fill handle to the left or up, Excel will ________ the series rather than ________.
NOW
When assigned to a cell, the ____ function
returns a number that corresponds to the system date and time beginning
with December 31, 1899.
relative
A formula using the ____ cell reference
B20 instructs Excel to adjust the cell reference as it copies it to the
destination area.
absolute
A formula using the ________ cell
reference B20 instructs Excel NOT to adjust the cell reference as it
copies it to the destination area.
IF
The ________ function is useful when you want to assign a value to a cell based on a logical test.
exploded
A pie chart with one or more slices offset is called a(n) __________ pie chart.
redraws
When yo change a value on which a chart is dependent, Excel _______ the chart.
what-if analysis
Using Excel to scrutinize the impact of
changing values in cells that are referenced by a formula in another
cell is called ___________.
Goal Seek
If you know the result you want a formula
to produce, you can use ______ to determine the value of a cell on which
the formula depends.
database management
Access is a __________ program.
records
In Access, the rows in a table are called ________ and contain information about a given person, product, or event.
primary key
The key symbol indicates that a field is the __________ for a table.
query
A ________ is simply a question that is presented in a way that Access can process.
Currency
In Access, if a field is assigned the _________ data type, it can only contain monetary data.
text
In Access, a field that is assigned the ________ data type can contain any characters up to a maximum of 255.
Create
To create a report using the Report Wizard, click ____________ on the Ribbon and then click the Report Wizard button.
database
A(n) _________ describes a collection of organized, useful data.
task pane
A(n) _____________ is a window that can remain open while you work in the database object.
records
The rows in the tables are called _______.
fields
The columns in a table are called ___.
Redundancy
________________ means storing the same fact in more than one place.
access; retrieve; use
With a database, you can ________, _________, and ________ the data.
Microsoft Office PowerPoint
__________ is a complete presentation graphics program that allows you to produce professional-looking slide shows.
less is more
When choosing word for PowerPoint slides, use the _______ principle.
normal
The _________ view is the default view when a user opens PowerPoint.
slide
The basic unit of any PowerPoint presentation is a(n) _________.
placeholder
What is the box with the dotted or hatch-marked borders that is displayed when you create a new slide known as?
Notes
Information that you would like to share with your audience but not appear on the slide can be written in the __________ pane.
mini toolbar
What is initially transparent, disappears if not used, but is bright in appearance when the mouse is moved over it?
F5
The ____________ key is used to view the PowerPoint presentation in full screen view.
normal; slide sorter; slideshow
The three main views for a PowerPoint presentaiton are ________, ___________, and __________.
maximum
The 7 x 7 rule states that each slide should have a __________ of 7 lines of text and 7 words per line.
slides; outline
The Tabs pane consists of a(n) _________ tab and a(n) ________ tab.
transition
A special animation effect used to progress from one slide to the next is a(n) __________.
your description here