on the plate

Saturday, September 20, 2014
1:38 PM

0 comments

Microsoft Office Word

A full-featured word processing program

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) __________.

1:36 PM

0 comments

1 exam

an ... is a home key that helps you return each finger to its home-key position after reaching for another key

anchor

the ... located at the bottom of the key board, is used to insert spaces between letters and words, and after punctuation

space bar

the enter key moves the ... (blinking line) to the beginning of a new line

insertion point

true or false? space after periods ending sentences, abbreviations, commas, colons, and semi colons

true

true or false? space after slashes, periods within abbreviations, and hyphens

false

the standard indentation for a paragraph is ... inches

0.5

study charts on your own

the default settings for margins in microsoft word are (number of inches)

1 inch

..., ..., and ... are three main components of hardware

input device, processing/ storage device, and output device

..., ..., ..., ..., ..., ..., and ... are seven different input devices

keyboard, mouse, touchscreen, stylist pens, joy sticks, voice activation, and scanner

in the ... (CPU) the computer ... and ... the information given

computer processing unit; interprets and processes

a ... is the amount of memory required to hold a single piece of information

byte

1 kilobyte= ...

1,024 bytes

1 megabyte= ...

1,024 kilobytes

1 gigabyte= ...

1,024 megabytes

... memory only works when the computer is on

random access memory (RAM)

... information in memory cannot be changed

read only memory (ROM)

data can be stored in a ..., ..., ..., ..., or an ...

c-drive, SD card, USB flash drive, network, or an external hard drive (sky drive pro)

the four output devices include ..., ..., ..., and ...

monitors, printers, modems/ fax modems, and DSL lines

... is the set of instructions that drives a computer's operation (makes the hardware work)

software

two types of software are ... and ...

operating systems software and applications software

1:35 PM

0 comments

exam11

The table move handle has what symbol inside it?
a. Check mark
b. Two-headed arrow
c. Four-headed arrow
d. X

C. Four-Headed arrow

The table move handle is located:
a. Just outside the top left corner of the table
b. On the table menu
c. In the bottom left corner of the table
d. In the bottommost, rightmost cell of the table

A. Just outside the top left corner of the table

The rows of a table are automatically sized to match:
a. The width of the page
b. The default row size
c. The height of the columns
d. Line spacing at the point the table is inserted

D. line spacing at the point the table is inserted

T or F: Row height increases automatically as you enter more text into a cell than will fit on a line.

True

The default sort order in WORD is
a. Descending
b. Ascending

B. Ascending

Putting calculations into table cells make the table function similar to a:
a. Spreadsheet
b. Database
c. Presentation
d. Macro

A. Spreadsheet

Which type of tab would you use to align a column of dollar values
a. Center
b. Decimal
c. Right
d. Bar

B. Decimal

To delete the entire table:
a. Choose Table Tools, Layout, Delete, Table
b. Table Tools, Layout, Edit, Table, Delete
c. Choose Table Tools, Layout, Remove
d. Choose Table Tools, Design, Delete

A. Choose Table Tools, Layout, Delete Table

A font face that has curved or extended edges is:
a. Times New Roman
b. Script
c. Serif
d. San serif

C. Serif

Calculations are performed in tables by entering:
a. Formulas
b. Formatting
c. Fractals
d. Fields

A. Formulas

If you want a table's title to be centered across the entire first row of the table, select the row and click _____.
a. Table tools, Layout, Center
b. Table tools, layout, AutoFit
c. Table tools, layout, merge cells
d. Table, center

C. Table Tools, layout, merge cells

Which of these is NOT an alignment choice for a table on a page?
a. Left
b. Justified
c. Right
d. Centered

B. Justified

T or F: Column width increases automatically as you enter more test into a cell than will fit on a line.

False

Text in table cells can be aligned:
a. Horizontally but not vertically
b. Vertically but not horizontally
c. Vertically and horizontally
d. Neither vertically nor horizontally

C. vertically and horizontally

To move from one cell of a table to the next cell to the right, you press:
a. Enter
b. The spacebar
c. Tab
d. Shift + Tab

C. Tab

To resize a table, drag the:
a. Move icon on the Tables and Borders toolbar
b. Table move handle (table anchor)
c. Gridline at the bottom of the first row
d. Sizing handle

D. Sizing Handle

Using the Draw table too, you can draw:
a. Vertically and horizontally, but not diagonally
b. Vertically, horizontally, and diagonally
c. Horizontally and diagonally, but not vertically
d. Vertically and diagonally, but not horizontally

A. Vertically and Horizontally, and diagonally

When you insert a new row in a table using the Table Tool, Layout tab:
a. It insets it below the selected row
b. You choose either Rows Above or Rows Below
c. It inserts only one row regardless of the number of rows selected

B. choose either Rows Above or Rows below

To select an entire column with the mouse:
a. Positions the mouse below the bottom of the column and click
b. Double-click any cell in that column
c. Position the mouse over the top of the column and click
d. Triple-click any cell in that column

positions the mouse below the bottom of the column and click

T or F: A column is always inserted to the left of any existing columns

False

At the right margin of a cell, text automatically:
a. Shrinks to fit the cell
b. Moves to the next cell
c. Wraps to the next line
d. Stops

C. wraps to the next line

The default font style in WORD is:
a. Serif
b. Script
c. Times New Roman
d. San Serif

D. San Serif

T or F: if you delete a column or row, the data within that column or row is deleted too.

True

An example of san serif is:
a. Times New Roman
b. Brush Script MT
c. Broadway
d. Calibri

D. Calibri

T or F: A row can be inserted either above or below existing rows.

True

A grid made up of rows and columns

table

A feature to help fit contents in table cells

AutoFit

A formattable line around the edge of a cell

border

Nonprinting lines that you can display around the edge of cells

gridlines

The area formed at the intersection of a table column and row

cell

Column _______ and row height are measured in inches

width

The ______ command divides a cell into multiple celll

split

The ______ command combines cells into larger cell

merge

By default, word puts a ______ around all cells in a table

border

Apply ________ to add color or pattern to fill the background

shading

A _________ is an application used for setting up mathematical calculations

spreadsheet

A table is a gird composed of horizontal ______

rows

A table is a grid composed of vertical

columns

T or F: a return address is needed on a Business Letter in block style

False

The style of letter in which all lines of the letter start at the left margin is called:
a. Standard business
b. Modified block
c. Block
d. Salutation

C. Block

When creating an envelope in WORD with a document open, WORD uses the _____ as the delivery address.
a. Return address
b. Letter address
c. Your address
d. Inside address

D. Inside address

Is the body of the letter double spaced or single-spaced?

single spaced

What punctuation is used in a closing?

a comma

To save a file with a new name, open the Office Button and Choose:
a. Save As
b. Rename
c. Save
d. Save All

A. save as

An inside address is:
a. The sender's address
b. The return address
c. Not necessary if you are using stationary
d. The address of the person to whom the letter

D. the address of the person to whom the letter is being sent

Default Word margins are set for______ inch(es) on the top and bottom of the page

one inch

How many enters after a closing before the typed name of the sender of the letter?

four

T or F: A standard envelope measuring approximately 9 ½ by 4 is referred to as a No. 8 envelope

False

The main text of a letter is called the ______

body

The main style feature of a block letter is that______
a. All lines start at the left margin
b. All lines are flush with the right margin
c. None of the above
d. All margin are equal

A. All lines start at the left margin

When marking up a document with proofreader's marks, what does a triple-underline under a character mean?
a. Make bold
b. Delete
c. Italicize
d. Capitalize

D. Capitalize

T or F: an envelope's delivery address is placed in the upper left corner

False

T or F: Not all letters need the Enclosure notation

True

If you make a mistake while moving test, use ______ to reverse the action
a. Undo
b. AutoFix
c. Reapply Normal
d. Paste Normal

A. Undo

T or F: the reference initials are needed on a personal letter

False

"Dear Mr. Smith" is an example of a ______ in a business letter
a. Body
b. Salutation
c. Senders name
d. Closing

B. Salutation

What punctuation is use at the end of the salutation?

colon

The word "Dear" followed by the name of the person who you are writing is the ______ in a letter.
a. Salutation
b. Body
c. Heading
d. Closing

A. Salutation

the top margins on all letter is _____ inch(es)

Two

When you set line spacing in word, what are controlling?
a. horizontal space between letters
b. horizontal width of the characters in the line proportion to their height
c. vertical space between one paragraph and another
d. vertical space between lines within the paragraph

D. Vertical space between lines within the paragraph

if you are including another item with a letter, you will need to key a special notation at the end of the letter called _______
a. enclosure notation
b. copy notation
c. closing
d. body

A. Enclosure notation

T or F: A letterhead paper is not needed for personal business letter in block style

True

When you press the Tab key, the insertion point is indented:
a. To the next tab stop
b. Ten spaces from the left
c. Five spaces
d. None of the above

B. Ten spaces from the left

T or F: The works cited page does not need a title

False

When the current page is not yet full and you want to start a new page, you insert:
a. Spaces
b. A hard page break
c. A section break
d. A soft page break

B. A Hard page Break

By default, headers print ______ from the top of the page and footers the same distance from the bottom.
a. 2"
b. 1"
c. 0.5"
d. 1.5"

C. 0.5"

any color you want it to be

What is WordArt

text that is curved or stretched like a graphic

The Send Backward command moves the selected object

behind all other subjects

What type of icon indicates an object's anchor location in the document

anchor

Flip an object from left to right

flip horizontal