CIS 050 Microcomputer Applications SIMnet

To find records that meet more than one condition in the same field, enter both criteria separated by the word _______ in the Criteria row.

And

A(n) _______ field can include images, Word documents, or almost any other type of data file.

Attachment

Which of the following removes text to the left of the cursor?

Backspace

Which of the following functions counts the number of cells that are not blank within a specified range of cells.

COUNTA

What is the keyboard shortcut for inserting a hard page break?

Ctrl+Enter

Use _______, the keyboard shortcut, to paste text or objects into a Word document.

Ctrl+V

Tables open in _______ where you can enter, sort, and filter data.

Datasheet view

The _______ property allows you to add a preset value to a field.

Default Value

Which of the following removes text to the right of the cursor?

Delete

Select _______ to resize all the rows in a table so they have the same height.

Distribute Rows

Pressing _______ on the keyboard after entering text will move the cursor down one cell.

Enter

The _______ allows you to select any color from your screen and apply it to an object.

Eyedropper

In Design view, the bottom pane is the _______ pane which displays details about the selected field.

Field Properties

The Animation Painter works similarly to the _______.

Format Painter

If your worksheet has both a header row and a column of labels in the first column use the _______ option to freeze the worksheet at the selected cell, so the rows above the cell and the columns to the left of the cell are always visible.

Freeze Panes

The _______ logical function returns one value if a condition is true and another value if the condition is false.

IF

The _______ property ensures that users enter data in a particular format. For example, a field for social security numbers can force users to enter numbers in the format 123-45-6789.

Input Mask

To add a sound to your presentation, click the _______ button on the Insert tab.

Insert Audio

To add a video to your presentation, click the _______ button on the Insert tab.

Insert Video

_______ alignment evenly spaces the words, aligning the text on the right and left sides of the printed page.

Justified

Forms and Reports also offer _______ where you can modify some (but not all) structural elements.

Layout view

_______ is the white space between lines of text.

Line spacing

_______ cells entails combining multiple cells into one.

Merging

All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.

Navigation

To remove an animation, on the Animations tab, in the Animations group, click the _______ option in the gallery.

None

The _______ option will print a copy of the slide with its associated note, if there is one.

Notes Pages

_______ converts the text string so that the first letter in each word is capitalized.

PROPER

PowerPoint's _______ feature allows you to copy and package all the elements of your presentation to a folder.

Package for CD

One method to open the Insert Picture dialog is for you to click the _______ icon in the content placeholder.

Pictures

If you want to include a field in your query, but do not want that field to show in Datasheet view, click the _______ box to remove the checkmark for the field you want to hide.

Show

To display formatting marks in a document, click the _______ button.

Show/Hide

To hide slides, click the Hide Slide button on the _______ tab of the Ribbon.

Slide Show

_______ view displays thumbnail pictures of the slides in your presentation and is useful in rearranging the order of slides in a presentation.

Slide Sorter

Clicking a thumbnail in the Thumbnails pane will make that slide appear in the _______.

Slide pane

A _______ form combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.

Split

A quick way to insert a new row at the end of a table is to place the cursor in the last cell in the last row and then press the _______ key(s). A new row is automatically added to the table.

Tab

Pressing _______ on the keyboard after entering text will move the cursor to the right one cell.

Tab

The _______ displays thumbnails of all the slides in the presentation.

Thumbnails pane

One way to start a new form is to begin with a blank form and _______ fields from tables and queries manually.

add

Most functions require you to provide input called the _______.

arguments

To change the order of your slides, select a thumbnail and _______ until the slide appears where you want it in the slide order.

click and drag

When you edit a formula, any referenced cells are highlighted in the same _______ as the cell reference in the formula.

color

To print individual pages, type each page number you want to print separated by a _______.

comma or semicolon

The Fill Handle tool is located at the upper left of the selected cell.

false

Each column in a table represents a specific data value called a(n) _______.

field

By applying a(n) ________ to a database object, you display a subset of records that meet your criteria.

filter

A(n) _______ is text that appears at the bottom of every page, just below the bottom margin.

footer

A _______ displays data from an underlying table and allows database users to enter, edit, and delete data in a user-friendly format.

form

A _______ is an equation used to calculate a value.

formula

When you select a cell that contains a formula, the formula bar displays the _______.

formula

A(n) _______ is a printout of your presentation with anywhere from one to nine slides per page and with areas for taking notes.

handout

You can manually force text to a new page by inserting a _______.

hard page break

When you _______ a row or column, the data still remain in your workbook, but they are no longer displayed on-screen and are not part of the printed workbook.

hide

A _______ is text or a graphic that, when clicked, opens another page or file.

hyperlink

You should add transitions to a presentation only where they will _______ your presentation.

improve

When you first add a picture to your document, Word inserts the picture at the _______ point and displays the picture in line with the text.

insertion

What chart element identifies which data point or data series is represented by each color in the chart?

legend

The _______ is the field that contains data unique to that record.

primary key

Each row in a table contains all the data for a single _______.

record

A(n) _______ database is a group of tables related to one another by common fields.

relational

When you add text to placeholders, PowerPoint will automatically _______ the text to fit within the placeholder.

resize

If you want to adjust the width of a column manually, move your mouse over the _______ column boundary and click and drag until the column is the size you want.

right

When you type text in a cell, the text will appear to continue to the __________ as far as it can until there is another cell that contains data.

right

A(n) _______ appears behind selected text.

shaded background

After clicking the New Slide button arrow, you will be asked to select a _______ from the New Slide gallery.

slide layout

When text or graphics have filled a page, Word inserts a _______ and goes on to a new page.

soft page break

The _______ bar appears at the bottom of the Excel window and displays information about the current worksheet.

status

A _____, which is organized by rows and columns, helps you organize information for effective display.

table

When you use a form to enter data, you are actually adding data to the underlying _______.

table

A _____ is a file with predefined settings that you can use as a pattern to create a new presentation of your own.

template

A(n) _______ is a group of formatting options that you apply to a presentation.

theme

As you roll over the list of fonts, the Live Preview feature in Word gives you a preview of how your document text will look with the new font applied.

true

In Excel, you can use the CONCAT function to combine the text values of cells or cell ranges.

true

The _______ feature places text on the next line when the right margin of the page has been reached.

word wrap

Each Excel _______ is made up of rows and columns of data on which you can perform calculations.

worksheet

To enter a formula, the first step after selecting the cell is to enter a(n) _______.

=

To align objects on a slide, select more than one object and then click the _______ button in the Arrange group on the Picture Tools Format tab.

Align

_______ refers to how text and numbers are positioned within the cell both horizontally and vertically.

Alignment