COSC-1335.701 Computers And Problem Solving Final Exam Preparation

Access is a ________ product.

  Microsoft 

What view normally appears when you double-click a table?

  Datasheet view 

What database object organizes your data by rows and columns?

  Table 

A customer's cell phone would be an example of a ________.

  field 

What are the two ways you can view a table?

  Design and Datasheet views 

Which of the following is not a way to create a multitable query?

  Adding a table in the Relationships window 

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?

  Allow Zero Length 

Which wildcard character matches a single character in the same position as the wildcard?

  ? 

What field property increases the speed at which searches can be performed?

  Indexed 

What field property would you use to automatically enter "PA" in a state field?

  Default Value 

Filters do not delete data or records.

  True 

Creating a database from a template can help you get started more quickly.

  True 

Using the Back Up Database utility only saves the structure of the database, not the content.

  False 

Searching a website to help you find just the right product involves database technology.

  True 

You always know when you are using a database.

False

Access provides a wizard for easily importing Excel data into Access.

True  

A good way to know what fields you will need is to think of what reports you might need later.

  True 

The Enforce Referential Integrity box should normally be checked.

  True 

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

  True 

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

  True 

A ________ is the basic element of PowerPoint

slide

A(n) ________ is miniature view of a slide that is displayed in the Slides pane.

  thumbnail 

A group of slides is called a ________.

deck

A slide ________ determines the position of placeholders in various locations on a slide.

layout

Title Slide, Blank, and Picture with Caption are examples of slide ________.

layouts

Which of the following is not true about cropping a picture?

  You cannot crop to a specific dimension.

Which of the following is the default PowerPoint workspace view?

  Normall

Which of the following views would you use to deliver a presentation using two monitors simultaneously?

Presenter

The opening slide in a presentation uses the ________ layout.

Title Slide

Which of the following views would you use to simultaneously display multiple slides and easily change the order of the slides, or to delete one or more slides?

  Slide Sorter 

You can use the Notes Page view to enter and edit large amounts of text.

  True 

After the last slide in a slide show displays, the audience sees a blank slide.

False

When using Normal view, you cannot hide the left pane that shows the thumbnails.

  False

When creating a presentation, you should use full sentences for your bulleted items.

  False 

A PowerPoint presentation is an electronic slide show that can be edited or delivered in different ways.

True

Use a numbered list if the items are non-sequential in nature.

  False 

To limit the amount of text on a slide, the textbook recommends that you follow the 8 x 8 guideline.

False

Sizing handles only appear in the four corners after selecting an object.

False

The owner of a copyright may sell or give up a portion of his or her rights.

  True 

Blank is an example of a slide layout.

  True 

Which of the following panes is displayed in Normal view?

B) Slides

The ________ is the main workspace and displays the current slide

B) Slide pane

Which of the following is not true about the Slide Sorter view?

D) It does not allow you to delete slides in this view

Which of the following views would you use to enter and edit large amounts of text that you can look at when presenting?

C) Notes

Which of the following is not true about speaker notes?

C) You are limited to 500 characters in your speaker notes.

In Normal view, the Notes pane can be displayed ________ the Slide pane.

B) below

A(n) ________ is a visual map of a presentation that displays the content of each slide in the slideshow.

C) storyboard

When making the transition from a storyboard to a PowerPoint presentation, which of the following is not suggested in the textbook?

D) Follow the 6 x 6 guideline of no more than six words per line and six lines per slide

A ________ is a designer-quality appearance that includes coordinating colors, matching fonts, and effects such as shadows.

D) theme

A ________ is an object that holds specific content, such as text or images.

A) placeholder

Which of the following slide layouts is often used to put text on one side of a slide and graphic content on the other side.

D) Two Content

When delivering a presentation, which of the following actions does not advance to the next slide?

D) Right-clicking the mouse

When delivering a presentation, which of the following actions returns to the previous animation?

D) Clicking the left arrow on the screen

Which of the following is not an option when printing a PowerPoint presentation?

B) Annotations

Which of the following handout printing options places thumbnails of the slides on the left and lines on which the audience can write on the right side?

C) Three slides per page

Which of the following is not an option when printing handouts?

A) Five slides per page

Which of the following is not true about QuickStarter?

A) It creates a finished presentation.

Where is the rotation handle found in relation to an image?

C) top of the placeholder

What does a rotation handle look like?

B) circular arrow

What do sizing handles look like?

B) white circles

What punctuation is used to separate the two cell references in a range?

 

Colon (:)

An icon is a graphic image, like a drawing or photograph.

 

False

The Quick Access Toolbar gives you one-click access to commonly executed tasks such as saving a file or undoing recent actions.

 

True

Microsoft Office's Ask me anything box enables you to search for help and information about a command or task.

 

False

The COUNTA function only counts text entries. It does not count calculable values or blank cells.

 

False

Calculated Field

A user-defined field that performs a calculation based on other fields in a PivotTable.

Columns Area

A section within the PivotTable Fields task pane used to display summarized data in vertical columns for the selected field(s) in a PivotTable.

Data Mining

The process of analyzing large volumes of data to identify trends and patterns in the data.

Data Model

A collection of related tables that contain structured data used to create a database.

Filters Area

A section within the PivotTable Fields task pane used to place a field so that the user can then filter the data by that field.

GETPIVOTDATA function

A function that returns a summary value from a PivotTable.

Grouping

A process of joining related rows or columns of related data into a single entity so that groups can be collapsed or expanded.

Outline

A hierarchical structure of data that you can group related data to summarize.

PivotChart

A graphical representation of aggregated data derived from a PivotTable.

PivotTable

An interactive table that uses calculations to consolidate and summarize data from a data source to enable a person to analyze the data in a dataset without altering the actual data.

PivotTable Fields task pane

A window that displays the fields in a dataset and enables a user to specify what fields are used to create a layout to organize the data in columns, rows, values, and filters in a PivotTable.

PivotTable Style

A set of formatting that controls bold, font colors, shading colors, and border lines within a PivotTable.

PivotTable Timeline

A small window that starts with the first date and ends with the last date in the data source. It contains horizontal tiles that you can click to filter data by day, month, quarter, or year.

Relationship

An association created between two tables where both tables contain a common field of data.

Rows Areas

A section within the PivotTable Fields task pane used to group data into categories in the first column based on selected field(s) in a PivotTable.

Slicer

A window listing all unique items in a field so that the user can click a button to filter data by that item or value.

Slicer Caption

The text or field name that appears as a header or title at the top of a slicer to identify the data in that field.

Subtotal

A summary calculation of values for a category.

Subtotal Row

A row that contains one or more aggregate calculations for each category within a dataset.

Values Area

A section within the PivotTable Fields task pane used to place a field to display summary statistics, such as totals or averages in a PivotTable.

You used the Subtotal feature on a dataset containing states, major cities within each state, and populations. You intended to create one subtotal for each state; however, a subtotal row displays below each city. What caused this result?

b. The data was sorted by state and further sorted by city.

Why would you click the collapse outline symbol above a column of outlined data?

b. You want to hide the detailed columns to focus on the result column.

After creating a blank PivotTable, you click a check box for a field that contains categorical data, such as state names, in the PivotTable Fields task pane. Where does Excel place that field?

c. Values area

You created a PivotTable that shows total number of customers per day; however, you want to display the average number of customers per day. What would you do to change the PivotTable results?

b. Use the Subtotal feature to select the Average function.

You created a PivotTable and changed some values in the dataset from which the PivotTable was created. How does this affect the PivotTable?

b. Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.

You created a PivotTable for a major department store that lists department names (Shoes) in the first column and total weekly sales in the second column. How can you exclude Sunday sales from being reflected in the second column?

d. Set a filter for the Weekday field and deselect the Sunday check box in the filter menu.

Which of the following is not used when creating a calculated field in a PivotTable?

a. A cell reference to a value outside of the PivotTable

What settings should you select to apply a different color scheme and display a fill color for every other row or horizontal lines within the PivotTable?

a. Banded Rows and Banded Columns check boxes

You want to create a PivotTable that uses fields from two Excel tables. What is the first step?

b. Create a relationship on a common field between the two tables.

When you create a clustered column PivotChart from a PivotTable, the field that was in the Rows area of the PivotTable Fields task pane creates what part of the PivotChart?

d. Category axis

Margin

A(n) ________ is the area of blank space that displays to the left, right, top, and bottom of a document.

Power point

Which of the following Microsoft Office applications is used to create dynamic presentations to inform and persuade audiences?

Word

Which of the following Microsoft Office applications is used to produce documents, including memos, newsletters, forms, brochures?

Footer

A ________ consists of one or more lines at the bottom of each page.

Ask me anything

Microsoft Office's ________ box enables you to search for help and information about a command or task.