Integrated Business Apps FINAL EXAM STUDY GUIDE

¡Supera tus tareas y exámenes ahora con Quizwiz!

Numbers that extend beyond a cell's width appear as _____ in the cell.

####

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use _____ for two or more characters.

*(asterisk)

Templates have a _____ file extension.

.potx

A zoom percentage of _____ shows the document at its normal size.

100%

Which document percentage below would make Amanda's document the largest?

100%

Caitlyn would put the word "red" in the box labeled with the number _____.

2

Christina is listing ten beliefs in her paper, and wants to put a double strike-through for the beliefs she does not support. Which of the font effects above illustrate a double strike-through?

2

The Office Clipboard is a special clipboard on which you can collect up to _____ selections.

24

Christina now needs to add a superscript to an entry in her bibliography. Which example illustrates a superscript?

3

If Caitlyn wants to replace every instance of "red" with the word "crimson," she would select the option labeled with the number _____.

5

To check only spelling in the document, click the _____ in the Spelling and Grammar dialog box to deselect it.

Check grammar check box

You can use the _____ command to clear manual formatting and styles.

Clear Formatting

To close the document without exiting Word, click the Office Button, and then click _____.

Close

You can close a workbook by clicking the Office Button to display the Office menu and clicking _____.

Close

Unlike other Microsoft Office 2007 programs, the Publisher program does not have a _____ button in the top-right corner.

Close Window Button

Peter wants to his biography, which is in the front of the book, to the last page, too. He has highlighted his biography in the front of the book, and now needs to add it to the last page. He should use the _____ command(s).

Copy and Paste

Using the Find command, you can quickly search a document for every occurrence of a specific word or phrase you type in the _____ box.

Find what

Leah's boss thinks the word "new" is overused and asked Leah not to use it in her presentation. She will search for it in her presentation by filling in the word "new" in the _____.

Find what text box

Some font effects are available in the _____ group on the Home tab, and others are available only in the Font dialog box.

Font

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the _____ group, click the arrow next to the Font box to display a gallery of available fonts.

Font

To change the font, locate the _____ group on the Home tab on the Ribbon.

Font

The colored bar on the Font Color button changes to reflect the last color selected. If the colored bar is the font color you want to apply, you can simply click the _____ button to apply that color.

Font Color

If you want to copy the format to more than one block of text, double-click the _____ button.

Format Printer

The _____ task pane allows you to change the color scheme, font scheme and page size of a publication.

Format Publication

Josh wants to get to the Cell Style gallery. How does he navigate to the Cell Style gallery?

In the Styles group on the Home tab of the Ribbon, click the Cell Styles button

To insert a symbol, on the Ribbon, click the _____ tab. Then, in the Symbols group, click the Symbol button. Commonly used symbols appear on the menu.

Insert

When you find the Design Gallery Object you would like to use, click _____ in the Design Gallery.

Insert Object

The _____ shows where text will appear when you begin typing.

Insertion point

Lacy has dragged her pointer over text while holding down the left mouse button. The Mini Toolbar appears transparent. What does this mean?

Lacey needs to move the pointer over the Mini toolbar for it to come into full view

As you format cells, _____ shows the results of the different formatting options you can choose.

Live Preview

When you hover over a theme, the name of the theme appears, and the selected slide will show a _____ of the effect of the theme on the slide.

Live Preview

_____ lets you see how a gallery option affects your file without making the change.

Live Preview

You can also look up a word in the Thesaurus or dictionary by right-clicking a selected word and choosing _____ on the shortcut menu.

Look Up

You can also center cell contents across several columns. Select the cells, and then click the _____ button in the Alignment group on the Home tab of the Ribbon.

Merge & Center

To start Word, click the Start button on the taskbar. Click All Programs on the Start menu, click _____ on the submenu, and then click Microsoft Office Word 2007.

Microsoft Office

_____ is a collection of software programs.

Microsoft Office 2007

To open the Help window, click the _____ button located near the upper-right corner of the program window.

Microsoft Office Help

If you drag and select text, then move the mouse back over the select text, the _____ appears.

Mini toolbar

_____ allow you to use the predefined paths for the movement of an object.

Motion Paths

To name your style and add it to the Quick Styles gallery, open the Quick Styles gallery, and then click _____ on the menu at the bottom of the gallery.

Save Selection as a New Quick Style

The Sales Managers also wanted to be able to switch the Microsoft Internet Explorer, which would be another open program on their computer, during the presentation. Nathan directed them to use the _____ command.

Screen

The colors in the palettes all have names. You can see the names by pointed to each color to see its _____.

Screen Tip

A _____ is a box that appears with descriptive information when you point to a button.

ScreenTip

The Spelling and Grammar dialog box gave Sela the suggested spelling of "Employs. What should Sela do next?

Scroll down to the word "Employees"

_____ when you right-click something in the program window.

Shortcut menus appear

To determine the reading level of the document, which option would Gabriel choose?

Show readibility statistics

The best view to use when you work on the transition is _____ since you can see all the slides at one time.

Slide Sorter

To set up the animation, Cindy should use PowerPoint's _____ view.

Slide Sorter

You use _____ view to set slide timings, transitions, and animations.

Slide Sorter

_____ view gives you can overview of all the slides in a presentation.

Slide Sorter

In addition to checking your spelling and grammar as you type, you can use the _____ dialog box to check a document's spelling and grammar after you finish typing.

Spelling and Grammar

_____ refers to the way each new slide appears on the screen.

Transition

The _____ command is useful because it reverses recent actions.

Undo

If Sam wants to move to the previous line, he should press the _____ key(s).

Up arrow

In Normal view, PowerPoint places the new slide _____, using the same layout as the selected slide.

after the selected slide

The easiest way to create your own Quick style is to format text with _____, and then make changes until you are satisfied with the final look.

an existing Quick Style

Because Office is _____, the programs can be used together.

an integrated program

Once you create a publication by clicking the Create button, the publication will _____.

appear in the document window

Pressing the Enter key creates a new paragraph with _____.

blank space between it and the paragraph above it

Text _____ can be as small as one character or as large as an entire document.

blocks

With Automatic spell checking, a _____, wavy underline indicates that a word might be misused.

blue

Horizontal alignments do NOT include

bottom

Unless you specify otherwise, numbers you enter in a cell are lines up along the _____ side of the cell.

bottom-right

A _____ is a collection of information about an individual, such as name, company name and address.

business information set

Gavin is in the Preview group of the Print Preview tab. He wants to preview the next page of the worksheet. What should he do?

click the Next Page button

PowerPoint will allow Cindy the option of having the animation pause until she starts it manually by _____.

clicking her mouse, pressing the spacebar, pressing the right arrow key

The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a _____.

colon

_____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

columns

By clicking a button to choose a(n) _____, you give the program instructions about what you want to do.

command

Since Kyle is having the newsletter professionally printed, when he is faced with the four check types available in Design Checker, he should choose _____.

commercial printing

The _____ always appear in the Formula Bar.

contents of the active cell

When you _____ selected text, it remains in its original location and a copy of it is placed on the Clipboard.

copy

When you _____ selected text, it is removed from the document and placed on the Clipboard.

cut

When you select text in a placeholder, the border of the placeholder is a _____.

dashed line

The Design Gallery provides a collection of _____ that can be used to further enhance a publication's appearance and functionality.

designs and text placeholders

Design Checker has four different check types that do not include _____.

desktop printing

If you want to specify a precise column width, use the Column Width _____.

dialog box

Brad wants to copy the formatting to more than one block of text. He should _____ the Format Painter button.

double-click

The easiest way to change the zoom percentage is to _____.

drag the slider

To select text with the mouse, position the I-beam pointer to the left of the first character of the text you want to select. Hold down the left button on the mouse, drag the pointer to the end of the text you want to select, and release the button. This is called _____.

dragging

To replace cell contents, type the new data, and then enter the data by clicking the Enter button on the Formula Bar or by pressing the _____.

enter key or tab key

In Slide Show view, each slide _____.

fills the entire screen

Examples of text _____ are adding bold, italics, or underlining to words to emphasize them.

formatting

The appearance of text is called _____.

formatting

A _____ shows you thumbnails of a theme or effect that will be applied.

gallery

Templates may fall into one or more _____, such as Classic Designs or Newer Designs.

groups

The commands on each tab are organized into _____.

groups

The Show/Hide paragraph command allows you to see _____.

hidden formatting marks

The Show Advanced Timeline feature displays the time of the animation as a _____.

horizontal line graph

There is a slide master and associated _____ for each theme in the presentation.

layout masters

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the _____ to decrease the zoom percentage.

left

A(n) _____ is text (often colored and underlined) or a graphic that you click to "jump" to another location or Web page.

link

A(n) _____ is a symbol that is designed to help customers remember a business and its products.

logo

When you are highlighting text, if no text is selected, the pointer changes to the Highlighter pointer, an I-beam pointer with a _____ on it, when you position it on top of text in the document.

marker

A _____ is a list of other command related to the button.

menu

The _____, or cell reference area located below the Ribbon, displays the cell reference of the active cell.

name box

The Header and Footer dialog box has two tabs, one for slides and one for _____.

notes and handouts

On the _____, include any text or formatting that you want to appear on all your speaker notes.

notes master

In a new paragraph, for example, if you type the number 1 followed by a period, and then press the Tab key, Word assumes that you are trying to create a _____.

numbered list

The area _____ of the status bar shows which slide is displayed in the Slide pane and the total number of slides on the presentation.

on the left side

The Slide pane shows _____ at a time.

one slide

If you are changing the format of a single paragraph, the insertion point must be located somewhere in that _____.

paragraph

Once you have placed text on the Clipboard, you can then _____ into the document whatever is stored on the Clipboard.

paste

Most documents are printed in _____ orientation.

portrait

If you select a plural noun or a verb in a form other than its base form (the infinitive form), a list of _____ appears in the list in the task pane.

related words

Leah found the word "new" in two places in her presentation and wants to replace it with word "innovative." She will fill in the word "innovative" in the _____.

replace with text box

You can resize a graphic by selecting it then dragging a _____.

resizing handle

To clear the active cell, use the _____.

ribbon, mouse, or keyboard

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the _____ edge of one of the selected column headings.

right

Excel _____ all numbers.

right-aligns

Mark found a word with a waxy red line and wants to check the spelling. The first thing he does is _____ on the word to display the shortcut menu with other spelling options.

right-click

To correct an error that has been identified with a wavy underline, _____ the flagged word or phrase to open a shortcut menu with a list of suggestions to replace the possible error.

right-click

You can rename a folder by _____ the folder, and then clicking Rename on the shortcut menu.

right-clicking

One way to see all the text stored in a cell is to wrap text. The _____ adjusts automatically to include additional lines until all the text is visible.

row height

Each cell is identified by a unique cell reference, which is formed by combining the cell's column letter and _____.

row number

_____ appear horizontally and are identified by numbers on the left side of the worksheet window.

rows

If a word appears twice in a row, the _____ will be underlined with a red, wavy underline.

second word

The name of each worksheet appears in the _____ at the bottom of the worksheet window.

sheet tab

Data can be indented (or _____) within cells to help distinguish categories or set data apart.

shifted to the right

When a sound is on a slide, you will see the sound icon on the _____.

slide

The _____ is how objects are placed on a slide.

slide layout

Changing the _____ affects the appearance of all of the slides in a presentation associated with that master slide or master layout.

slide master

To change the appearance of the bullets throughout a presentation, make the changes on the _____.

slide master

The _____ at the bottom of the document window displays that object size and position of the selected object.

status bar

If you apply a style and then apply manual formatting, when you change to a new theme, the manual formatting will _____.

still be applied

A(n) _____ is a set of formatting options that have been named and saved.

style

A _____ is a word with a similar meaning for a word in your document.

synonym

The Clipboard is available to all the programs on your computer, and it is sometimes called the _____.

system Clipboard

If a content placeholder appears on a slide, you can choose from _____.

table, clip art, movie

Modifications to a Publisher publication are made using the _____.

task panes and toolbars

Unless you have a particular reason for creating a presentation from a blank document, it is easier and less time consuming to use a _____ already containing placeholders.

template

Business information sets are stored in Publisher and are associated with _____.

templates

You can add, delete, move, rotate, and scale _____.

text boxes and graphics

Objects are _____.

text, graphics and illustrations, tables and charts

A _____ is a preset collection of deign elements, including fonts, colors, and other effects.

theme

The _____ determines the default font, the color of headings formatted in the Heading Quick styles, and other features of the document.

theme

You can use a(n) _____ to change the appearance of your slides without changing the content.

theme

When Excel starts, the program window displays a blank workbook titled Book1, which includes _____ blank worksheets.

three

The _____ slide introduces your presentation to your audience.

title

The _____, at the top of the window, identifies the window as a PowerPoint window and lists the name of the open presentation.

title bar

A command that you use by turning a feature on or off is sometimes known as a _____ command.

toggle

Some buttons are like light switches: one click turns on the feature and the next click turns it off. This is often referred to as a _____.

toggle

A _____ contains buttons that you can click to perform common tasks.

toolbar

When Jane chooses a template by clicking on it in the middle pane, she will see a thumbnail image of it in the _____ of the window.

top-right corner

Using the Handouts option you can print handouts with _____ slides per page.

two or three, nine, four or six

When you select the Merge & Center button, on the the contents from the cell in the _____ corner of the range are kept. All other content is deleted from the worksheet.

upper-left

To exit Word, click the Close button in the _____ corner of the document window.

upper-right

To switch between views, you can click on of the _____ buttons at the bottom-right of the document window, to the left of the Zoom slider.

view

Automatic spell checking identifies misspellings and words that are not in PowerPoint's dictionary by underlining them with a _____ immediately after you type them.

wavy red line

When using _____ software such as Word, you can easily create and edit documents, such as letters an reports.

word processing

In Excel, a computerized spreadsheet is called a _____

worksheet

When using Design Checker, Publisher creates a list of errors that _____.

you can fix or you can leave as is

If Sela wants to change this instance of the spelling of the word only, she would highlight the correct spelling she wants, and then press _____.

Change

To use the Replace command, in the _____ group on the Home tab of the Ribbon, click the Find & Select button, and then click Replace.

Editing

The Slide Show menu item called Screen _____.

Either can display a black to white screen or can switch to another open program

Click the Home Page button to load your _____ page, which is the first page that opens when you start your browser.

Either home or start

Gavin wants to magnify the view of the worksheet to double-check some of the figures. What would he do to magnify the view?

Either in the Zoom group, click the Zoom button or click the pointer which becomes a magnifying glass

Neil is connected to the Internet. He clicks the Address Bar, types in the URL, and then needs to press the _____ to go to the Web page.

Either the GO button or enter key

If you want to use a font size that is not on the drop-down menu of the Font Size box, type the point size directly in the Font Size box, and then press the _____ key.

Enter

If you are writing a paper that includes mathematical equations, you can insert mathematical symbols and equations using the _____ button in the Symbols group.

Equation

To edit the data directly in a cell, make the cell active and then press the _____ key or double-click the cell.

F2

You can select a different theme for you workbook. Click the _____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

Page Layout

The _____ includes tools for formatting pictures, such as setting transparency and adjusting brightness and contrast.

Picture Toolbar

The _____ tab includes buttons that allow you to adjust the picture's contract, color and brightness, set a transparent color, or compress the picture.

Picture Tools Format

The Sales Managers wanted to have the ability to make notes on the actual slide as they were giving a presentation. Nathan directed them to use the _____ command.

Pointer Options

Lacey wants to display a shortcut menu after she has selected some text. What steps does she take to get the menu to appear?

Right-click the selected text

The _____ command lets you save a file with a new name or a new location.

Save As

The first time you save a publication, the _____ dialog box appears in which you name the publication.

Save As

To start an Office program, click the Start button on the taskbar, click _____, and then click Microsoft Office.

All Programs

_____ is text, objects, graphics, or pictures that have motion.

Animation

With _____, after you type the first four letters, AutoComplete suggests the complete word.

AutoComplete

_____ determines the best width for a column or the best height for a row, based on its contents.

AutoFit

AutoCorrect corrects common capitalization, spelling, grammar, and typing errors as you type.

Autocorrect

Pressing the _____ key deletes the character to the left of the insertion point.

Backspace

You can reorder slides by dragging the thumbnail in the _____ tab.

Both Slides and Outline

_____ are document parts that you can create, store, and reuse.

Building blocks

You can create business information sets using the _____ command on the Edit menu or the Business Information task pane.

Business Information

To select blocks of text that are not next to each other, select the first block of text, press and hold down the Ctrl key, and then use the mouse to select additional blocks of text.

Ctrl

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the _____ keys.

Ctrl+1

To change text to italic, press the _____ keys.

Ctrl+I

Press the _____ keys to apply underlining.

Ctrl+U

Press the Keyboard shortcut _____ to go to the beginning of the next word.

Ctrl+right arrow

Peter realizes he can improve his book if he deletes one chapter. He highlights the text in the chapter, and chooses the _____ command.

Cut

To insert the current date into a document, on the Ribbon, click the Insert tab. Then, in the Text group, click the _____ button.

Date & Time

You can change font size by using the Font Size box on the _____ toolbar or on the Mini toolbar.

Formatting

_____ view replaces the Ribbon by a small bar called a toolbar that contains only a few relevant commands.

Full Screen Reading

_____ allows you to jump to a specific part of a document.

Go To

To increase or decrease the font size by small amounts, click the _____ Font or Shrink Font button in the Font group on the Home tab or on the Mini toolbar.

Grow

Neil is ready to get his computer hooked up to the Internet. How can he do this?

High-speed connection through a cable company

Press the Keyboard shortcut _____ to got to the beginning of the line.

Home

To change the alignment of a cell, select the cell, and then click an argument button in the Alignment group on the _____ tab of the Ribbon.

Home

To move to the beginning of the document, Sam should select the _____ keyboard shortcut.

Home

Brad, first selects the text with the format he wants to copy, and then clicks the Format Painter Command. The pointer changes to a(n) _____.

I-beam pointer with a paintbrush to its right

The Spelling and Grammar dialog box for spelling errors option called _____ leaves all instances of the word untouched in the document and jumps to the next flagged error.

Ignore All

Dori also needs to find an entry she made that was labeled witht the name of the president of the company, Kim Stearns. She cannot remember if she capitalized the president's first and last name and she may have even misspelled "Stearns" as "Stearn." Which search option should Dori choose?

Neither check match case or check match entire cell contents

A new folder appears in the list with the temporary name "_____" highlighted in blue.

New Folder

You can remove the borders from a selected cell by clicking _____ in the border style menu.

No Border

When you use the _____ Quick Style, you change a paragraph format so there is no space after it.

No Spacing

Josh previews some of the styles and clicks one to apply it to the cell. He now wants to remove it. To remove a style from the selected cell, she should simply click _____ in the Good, Bad, and Neutral section of the Cell Styles gallery.

Normal

The default style for text is the _____ Style.

Normal Quick

When you remove a style, the _____ Style is automatically applied.

Normal Quick

You can view a presentation four different ways that does NOT include _____.

Notes Page

To add speaker notes, click in the Notes pane below the slide and begin typing, or switch to _____.

Notes Page view

By default, the _____ theme is applied to each workbook.

Office

Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this?

On the Home tab, in the Editing group, click the Find & Select button, and then click Replace.

Once the Find and Replace dialog box appears, with the Replace tab displayed, what buttons should Tessa click to expand the dialog box so that she can enter in the formatting styles she wants to find and replace?

Options

The Spelling and Grammar dialog box option for grammar errors option called _____ opens the Proofing section in the Word Options dialog box to allow you to change default spelling and grammar check settings.

Options

To change text orientation, select the cells whose contents you want to rotate. Click the _____ button in the Alignment group on the Home tab of the Ribbon.

Orientation

To run Design Checker, Kyle should click the _____, and then click Design Checker.

Other Task Panes list arrow

_____ is the program used to send and receive e-mail messages and to organize information about people, appointments, and to-do lists.

Outlook

The presentation program is _____, and is used to create electronic slides that usually accompany a verbal presentation.

PowerPoint

To switch to Print Preview, click _____ in the Print dialog box.

Preview

The _____ allows you to see how your publication will print before you click the print button.

Preview window

The _____ dialog box enables you to select a printer, the number of copies to print, the parts of the worksheet to print, and the way the printed worksheet will look.

Print

In Print Preview, the Ribbon changes to show only the _____ tab.

Print Preview

The _____ command enables you to look at a document as it will appear when printed.

Print Preview

Mark wants to turn Automatic Spell Checking on. He does this by clicking the Office Button, clicking the PowerPoint Options button, then clicking _____.

Proofing

A first step for Jane would be to click the Award Certificates category in the _____ list.

Publication Types

_____, the desktop publishing program, helps you design professional-looking documents such as newsletters and brochures.

Publisher

_____ a presentation to a Web server gives other access to your presentation through a Web browser.

Publishing

The _____ contains buttons (icons) for three common commands, and you can add traditional Toolbar buttons to it.

Quick Access Toolbar

_____ are settings that affect the way text looks in the document and that you can apply by clicking a button on the Ribbon.

Quick Styles

When you want to open as existing presentation that you have recently viewed, you can choose the presentation from the _____ list.

Recent Documents

The list of _____ Templates contains the template files that were last opened.

Recently Used

Gabriel wants to run through his document one last time, and wants to reset the spelling and grammar check so that words he chose to ignore will be flagged again. Which option should he choose?

Recheck document

The _____ command reverses an Undo action.

Redo

The _____ command repeats the most recent action.

Repeat

The _____ command allows you to replace a word or phrase with another word or phrase you key in the Replace with box.

Replace

To start Microsoft Publisher 2007, click the _____ button, point to All Programs, click Microsoft Office, and then click Microsoft Publisher 2007.

Start

To highlight text, click the arrow next to the _____ button in the Font group on the Home tab.

Text Highlight Color

To save a presentation as an HTML file that can be views in a browser, choose the _____ type of file in the Save As dialog box.

Web Page

To view Web pages, you need special software called a _____.

Web browser

_____ view stimulates the way a document will look when it is viewed as a Web page.

Web layout

Dori knows that she has entered an incorrect value of 4,231 in one of the cells and wants to find it. She would choose "cell contents" as her place to search in the _____ search option section.

Within

Find out the number of characters, paragraphs, and lines in a document by opening the _____ dialog box.

Word Count

The _____ is a system of computer that share information by means of links on Web pages.

World Wide Web

The key elements of the screen in Print Layout view are the Ribbon, Quick Access Toolbar, insertion point, status bar, view buttons, and _____.

Zoom slider

If you try to close a workbook that contains changes you haven't saved, _____.

a dialog box asks you whether or not you want to save the file

At any time, you can print _____ from a document on the screen.

a full document, a single page, multiple pages

The tilde over the n in some Spanish words is considered to be _____.

a symbol


Conjuntos de estudio relacionados

History 1301 13-15 Chapter Give me Liberty

View Set

Semester 1 APUSH FINAL //mr. Summers

View Set

Chapter 12: Differential Analysis - The Key to Decision Making

View Set

Human growth and Development quiz 2

View Set