Computer final

You should press the SPACEBAR to clear a cell.

False

A(n) __ data type can store a variable amount fo text or combination of text and number where the total number of characters may exceed 255.

Long text

To save the changes to the layout of a table, tap or click the Save button on the ____.

Quick Access Toolbar

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

Rename Field

A unique identifier is also called a primary key.

True

By default, PowerPoint ends a slide show with a black slide.

True

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

True

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

True

A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.

presentation

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

reserved

A field whose data type is ____ can contain any characters.

short text

PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.

slides

___ properties are associated with all Microsoft office files and include author, title, and subject.

standard

Excels __ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

sum

PowerPoint assumes every new slide, except for a blank slide, has ____.

title

____ is/are used to place worksheet, column, and row titles on a worksheet.

to text

An Excel ____ allows data to be summarized and charted easily.

worksheet

A field within the __ data type can store a unique sequential number that access assigns to a record. Access will increment the number by 1 as each new record is added.

AutoNumber

___ are boxes with border that are displayed when you create a new slide.

Placeholder

A(n) ___ contains information about a given person, product, or event.

Record

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

True

If each cell in a selected range is adjacent to a row of numbers. Excel assigns the SUM function to each cell when you click the Sum button.

True

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

True

When Access first creates a database, it automatically creates a table.

True

To undo the most recent change to a table structure, tap or click the ___ button on the Quick Access Toolbar.

Undo

A field within the ___ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

AutoNumber

Which of the following is the ribbon path to the cell styles button?

(HOME tab | Styles group)

Excel remembers the last ____ actions you have completed.

100

To define an additional field in Datasheet view, tap or click the ____ column heading.

Click to Add

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

Compact and Repair

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.

Delete Field

A pie chart with on or more slices offset is referred to as a(n) ____ pie chart.

Exploded

To import data to a table, tap or click the ___ tab on the ribbon.

External Data

The Notes pane is located above the Slide pane and is an area where you can type notes and additional information.

False

When making a presentation to an audience using PowerPoint, you use Notes Page view.

False

When you click the decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

False

You cannot format an entire column at once.

False

A slideshow is another name for a PowerPoint presentation.

True

In a multilevel bulleted list, a lower -level paragraph is a subset of a higher-level paragraph.

True

Printing handouts is useful for reviewing a presentation.

True

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

attachment

The ___ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

average

When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

caption

To enter data in a cell, you must first select the ____.

cell

The / arithmetic operator indicates ____

division

An accompanying ____ gives audience members reference notes and review material for your presentation.

handout

Which of the following keys moves the insertion point to the beginning of data in a cell?

home

A field whose data type is ____ can store text that can be used as a hyperlink address.

hyperlink

A _____ specifies the arrangement of placeholders on slide.

layout

The active cell reference appears in the ____________________ on the left side of the formula bar.

name box

The default PowerPoint view is ____ view.

normal

In a(n) ___ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

relational

A ____ reference is an adjusted cell reference in a copied and pasted formula.

relative

The most common error when entering a formula is to reference the wrong cell in the formula.

True

The ____ is a blinking vertical line that indicates where the next typed character will appear.

insertion point

By default, slides in a new presentation are in ____ orientation.

landscape

All of the following are valid Excel arithmetic operators EXCEPT____.

>

Which of the following happens when you enter the formula =G15 into a cell?

Excel assigns the value in cell G15 to the active cell

Which of the following keys can you press to run a slide show starting with slide 1?

F5

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

False

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

False

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

False

In Access, the columns in a table are called records.

False

In data sheet view, a table is represented as a collection of rows and columns called a list.

False

Unlike clip art, you cannot resize a photograph using sizing handles.

False

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

Design View

What effect does the Comma Style format have in the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

What effect does the Accounting Number Format have on the selected cells?

Displays cell contents with two decimal places that align vertically

A __ is a specific design with coordinating colors, fonts, and graphical effects.

Document theme

The ____ is a small square in the lower-right corner of the active cell or active range.

Fill handle

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Format

PowerPoint displays smart ___ automatically when a picture, shape, or other object is moved and is close to lining up with another slide element.

Guides

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

Insert Field

The ___ function displays the highest value in a range.

Max

When you ___ cells, you combine multiple adjacent cells into one larger cell.

Merging

To add a record to a table, tap or click the ____ record button.

New (blank)

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Operations

When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.

Title and Content

A level is a position within a structure, such as an outline, that indicates the magnitude of importance.

True

A paragraph is a segment of text with the same format that begins when you press the ENTER key and ends when you press the ENTER key again.

True

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

True

With Excel in Edit mode, you can edit cell contents directly in the cell.

True

You can advance slides during a slide show by pressing the PAGE DOWN key.

True

____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.

Zooming

Access is a ___.

database management system

The process of sliding or dragging and then dropping a thumbnail in a new location is called ____

drag and drop