Advertisement Upgrade to remove ads

Review Questioons

A collection of information, such as a Microsoft Word document, stored on a computer under a single name is a

File

A container where files are stored is a

folder

The Windows Explorer program allows the user to __________ the organizing structures of Windows.

Navigate

A __________ is a rectangular area on the screen where programs and content appear; it can be moved, resized, minimized, or closed

Window

The opening screen in Windows that simulates a work area is called the

Desktop

A collection of items, such as files and folders, assembled from various locations is called a

Library

A picture, known as a(n) __________, represents a program, a file, a folder, or some other object

Icon

__________ is used to navigate the organizational structure of Windows

Windows Explorer

The __________ is the area along the lower edge of the desktop that contains the Start button and an area to display buttons for open programs

Windows taskbar

The Windows feature ____________ allows you to choose which program to sue to start different kinds of media, such as music CDs

AutoPlay

The Word feature that determines whether the next word in the line will fit within the established right margin is called

Wordwrap

Which of the following is NOT an example of a text effect?

Italics

How do you deselect an image?

Click outside the image

Drawing objects include all of the following EXCEPT:

Photographs

Which of the following is a correct statement about sizing handles?

Using square sizing handles may distort an image

What is the difference between an inline object and a floating object?

A floating object can be moved independently of the surrounding text characters

Graphic objects may be either

Inline or floating

Effects that include borders, shadow, and reflections are:

Picture styles

Which of the following is a small movable container for text or graphics?

Text box

Lines, arrows, callouts, and banners are examples of

Shapes

When a table has been added to a Word document and is active, what two tabs are added to the Ribbon?

Design and Layout

Which key is used to move from cell to cell in a Word table?

Tab

When typing reaches the right border of a cell in a table, wordwrap

Moves the test to the next line within the same cell

The default line spacing within a Word table is

Single spacing with not space before or after paragraphs

Formatting a Word table can include any of the following EXCEPT

Creating graphics within the table

In a table, to move to a tabbed location within the cell and not to the next cell, press:

Ctrl + Tab

simple border edges can be added using the Border button from which group?

Paragraph

When creating a table with four columns, the size of the each column will

Be of equal width

When inserting bullets into a cell, which of the following is NOT true?

The bullet will appear centered vertically in the cell

Which button is used to merge cells so that you can position the table title across the columns?

Merge Cells

Which of the following is NOT one of the standards for MLA style?

Arial, 12 pt font

Which line spacing is used for research papers and reports using MLA style?

Double-spaced

Which of the following is a field that can be automatically inserted into a document folder?

The file name

In which dialog box are you able to control line spacing?

Paragraph

Which of the following is a traditional non-numeric footnote symbol?

§

Which of the following is NOT necessary for footnotes according to MLA style?

Calibri font

With Microsoft's default settings, if a footnote is inserted into body text that is 14 pt Arial font, which of the following is NOT true?

The footnote font size increases with the size of the document font

Which of the following is a statistic automatically tracked by Word?

Number of revisions to the document

In MLA style, citations that refer to items in the Works Cited page are referred to as

Parenthetical references

To position Works Cited entries onto a new page,

Insert a manual page break

An Excel document is called a

Database

The individual pages of an Excel document are called

Workbooks

A _____________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.

Spreadsheet

A _____________ is created when a row and a column intersect

Cell

The _____________ allows the user to enter or edit the value or formula contained in the active cell.

Formula Bar

The _____________ allow(s) the worksheet to be split into two vertical views of the same worksheet.

Vertical window split box

The _____________ displays the name of the selected cell, table, chart, or object.

Name Box

The current cell mode, the page number, and the view and zoom buttons are displayed on the

Status bar

Anything a user types into a cell is known as

Cell content

A text value is also known as a

Label

A predefined formula is called a

Function

The values that an Excel function uses to perform operations are called

Arguments

Excel's _____________ function finds the middle value in a range.

Median

Which Excel function would be used to find the middle value of a list of test scores

Median

Which Excel function would be used to calculate the total points a student earned on a series of tests?

Sum

The Excel function _____________ would be used to find the lowest score on a series of student test scores.

Min

Excel's _____________ function adds all of its arguments then divides the sum by the number of arguments

Average

The _____________ function adds all of the numbers in a range of cells

SUM

Excel's _____________ function finds the largest value in a selected range of cells.

Max

The functions AVERAGE and MEDIAN are examples of _____________ functions, which are useful when the user needs to analyze a group of measurements

Stastitical

A _____________ shows the relationship of each part of the data to the whole.

Pie Chart

Which type of chart would be the best to chart the number of votes each candidate received compared to the total number of votes cast

Pie Chart

A(n) _____________ refers to a cell by its fixed position in the worksheet.

Absolute cell reference

A cell address used in a formula using a(n) _____________ will be adjusted appropriately when the formula is copied to another cell.

Relative cell reference

65. A _____________ is a value that originates in a worksheet cell and is represented in a chart

Data point

Each pie slice displayed on a pie chart is an example of a

Data marker

On a pie chart, the _____________ determines the size of each pie slice

Data series

The _____________ identifies patterns and colors assigned to categories in the chart.

Legend

A workbook sheet that contains only a chart is called a(n)

Chart sheet

One way to tell which slice of pie on a pie chart goes with which set of data is to look at the

Legend

A flat database

Is not related to any other collection of data

Raw data that has been organized so as to become useful is also known as

Information

Which of the following is NOT a benefit of avoiding redundancy in a database?

Prevents unauthorized manipulation of data

Good database design does NOT include

Accessible coding so that users can alter the structure

Each table row contains all the categories of data pertaining to one entity and is called a

Record

In Microsoft Access, all data is stored in one of more

Tables

An Access record is saved when you

Move to the next record

Which of the following is NOT a characteristic of the Currency data type?

Data must be displayed with two decimal places

To rename a table, you can

Right-click the table name in the Navigation Pane

Before populating a table, which is the correct sequence of steps?

Create and name the database, save the database, create and name the table

Which of the following is NOT true regarding security alerts?

They can be resolved permanently by most college users in the Trust Center

Where can you view the security and privacy settings for Access?

Trust Center

If you accidentally place two copies of the same table list in the Relationship window, the correct method for removing the extra table?

Right-click the table, and select Hide Table

When establishing a relationship, common fields do NOT necessarily need to have

The same field name

Which of the following is possible if referential integrity is enforced within a one-to-many relationship?

Deleting a record from the many table if there is a related record in the one table

In Datasheet view, which of the following is NOT true when a one-to-many relationship exists?

Plus signs indicate that the many table has related records

Sorting a table in descending order by a Last Name field would NOT

Sort ONLY the Last Name field, thus mixing up the records

If you want the records in a table to be sorted by last name then by first name within each last name, you would need to

Sort Lastname as the outermost field in ascending order

Which of the following is NOT a true statement regarding a select query?

A complex select query should be create using the Query Wizard

Which is the primary advantage of creating a new query?

It saves time if your new query uses the same fields as the existing query

Access forms can

Be based on multiple tables

Using a form for data entry can increase the usefulness of a database by increasing

Accuracy

Which is NOT true concerning forms?

Every table must have at least one form

Form Layout view differs from Design View in that

Only Form Layout View allows modifications while viewing data

When you delete records in Access

Any records deleted by mistake must be reentered

To print just one record from a form, which of the following would you choose in the Print dialog box?

The Selected Record(s) option

Compared to the Form tool, the Form Wizard

Allows more flexibility in the layout and design of the form

In Layout view, the _____________ is a small symbol displayed in the upper left corner used to move the entire group of controls.

Layout selector

The advantage of resizing control in Layout view rather than Design view is

By seeing the content of the fields in Layout View, you can visually determine that the space allotted is adequate

Resizing sections in a form must be done in

Design View

The primary editing view in PowerPoint where the user can write and design presentations is

Normal view

When PowerPoint displays a new presentation, the user is presented with one slide, the _____________ slide

Title

PowerPoint's _____________ is displayed below the Slide pane and provides and area for the user to enter information concerning the active slide

Notes pane

A large image of the active slide is displayed in the

Slide pane

The _____________ displays the presentation either in the form of thumbnails or as an outline

Slides/Outline pane

The PowerPoint _____________ allow(s) you to control the look of the presentation window with a set of commands

View Buttons

The current slide number, number of slides in the presentation, and theme are among the items displayed in the

Status bar

The _____________ provides an introduction to the topic covered in the presentation

Title Slide

A PowerPoint presentation is made up of one or more _____________ that can contain text, pictures, tables, charts, and other objects

Slides

A _____________ is a box on a slide with dashed or dotted borders that holds titles and body text, or other content such as charts, tables, or pictures

Placeholder

Changing bulleted and numbered styles on a slides is an example of

Formatting

A box that appears on a slide with dotted or hatched-marked borders where text, charts, tables, or pictures can be placed is called a(n)

Placeholder

When you see a _____________ border around a placeholder, you know that you can edit the placeholder text

Dashed

A _____________ border around a placeholder means that any formatting commands will be applied to all of the text within the placeholder

Solid

The color of the numbers in a numbered list is determined by the presentation

Theme

You can customize a bullet by changing any of the following EXCEPT

Its intensity

A button that turns on and off is called a _____________ button.

Toggle

A _____________ is a single media file including art, sound, animation, or movies

Clip

When you use the Clip Art command on the Ribbon to insert clip art, PowerPoint inserts the image

In the center of the slide

When an object is selected, it is surrounded by _____________, which allow you to change the size of the object

Sizing handles

_____________ are a set of coordinating colors that are applied to the backgrounds, objects, and text in a presentation

Theme colors

A presentation's _____________determine the fonts applied to the two types of slide text: headings and body.

Theme fonts

A Presentation's _____________is applied to the slide titles.

Headings font

A presentation's _____________ is applied to all text except the slide titles

Body font

A(n) _____________ is a sound or visual effect added to an object or text on a slide.

Animation

An animation that highlights an object or text that is already displayed is called a(n)

Emphasis effect

Animations that bring a slide element onto the screen are called

Entrance effects

A(n) _____________ is used to move an object off the screen.

Exit effect

In the Animation group, the _____________ control the direction and sequence in which an animation plays

Effect Options

Using _____________ allows you to indicate an animation should begin either on the click of a mouse, at the same time as the previous animation, or after the previous animation has finished

Timing options

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set