Intro to Computers Final

There are ______ basic types of animation schemes.

4

When selecting multiple slides, holding the _______ key allows you select slides that are not next to each other.

Ctrl

To calculate a payment using PMT, you need to know the following:

interest rate, number of payments, amount of loan

Although you create and work with a single Access database file, inside the file, there are multiple _______.

objects

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

primary key

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

The Clear All Formatting command removes any formatting that has been applied to _______.

text

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

worksheet

Use the _______________ feature to fill a group of cells with the same data or to extend a data series.

AutoFill

The keyboard shortcut for center alignment is _______.

Ctrl+E

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

Ctrl+Enter

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

Ctrl+V

The keyboard short cut for the Cut command is _______.

Ctrl+X

If you type a $ before a number, Excel automatically applies the _______ number format.

Currency

Which mouse operation will select an entire word?

Double-Click

The AutoSum button is found on the Home tab, in the ___________ group and enters the SUM function arguments using the most likely range of cells based on the structure of the worksheet.

Editing

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

Enter

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

Field Properties

You can use _______ to copy the formatting of one object to another.

Format Painter

The Clear All Formatting button is located on the ____ tab of the Ribbon.

Home

To switch to another view, click the _______ tab and then select your view from the View button arrow.

Home

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

IF

The ___________ displays the address of the selected cell and can be used to navigate to a specific cell in the worksheet by typing the cell address.

Name Box

To insert slides from a Word outline, click the arrow below the _______ button and select the Slides from Outline option.

New Slide

Click the _______ button during a presentation to select among the Arrow, Pen, and Highlighter.

Pointer Options

What does a blue, wavy line under text represent?

Possible grammatical error

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

Record

A(n) __________ reference is a cell reference that adjusts to the new location in the worksheet when the formula is copied.

Relative

The _______ command in Word allows you to locate specific instances of text in your document and replace them with different text.

Replace

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

Show/Hide

You can resize a placeholder by entering the width and height of the placeholder in the Width and Height boxes in the _______ group.

Size

Which mouse operation will select an entire paragraph?

Triple-Click

In Presenter view, you can use _______ monitors to display your presentation.

Two

If you clear the formatting from text and then decide that you want to keep the formatting that was removed, you can use the _______ command to apply to the previous formatting to the text.

Undo

If you make a mistake when working on a presentation, the _______ command allows you to reverse the last action you performed.

Undo

Click the _______ option in the Header and Footer dialog to pull the current date from the computer''s system clock.

Update automatically

The _______ argument is the text string or value in the IF function that will be displayed or the formula that will be calculated if the Logical_test argument is true.

Value_if_true

If the ruler is not displayed, click the _______ tab and select the Ruler check box in the Show group.

View

To enter a formula, the first step after selecting the cell is to enter a ________.

[=]

A(n) _______________ reference is a cell reference whose location remains constant when the formula is copied.

absolute

Presenter view allows you to use two monitors to display your presentation. One monitor shows the presentation _______, while the other includes presentation tools, navigation tools, and any notes that have been added to slides.

as your audience sees it

A cell's address, its position in the workbook, is referred to as a ________________ when it is used in a formula.

cell reference

When creating a table, you need to select the number of _______ that you need to display.

cells

A _______ is a group of predefined colors that work well together in a document.

color theme

Access is a relational database¿objects in your database are related to one another through relationships defined by common _______ between tables.

fields

Displaying the _______ allows you to easily see if there are extra line breaks.

formatting marks

If you want the first line of a paragraph to be left-aligned and the remainder of the paragraph to be indented, use a _______ indent.

hanging

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

hard page break

If your workbook is wide, you may want to use _______ orientation to view more columns on one page.

landscape

The most obvious way to select a cell in a worksheet is to click it with the ____________.

mouse

After clicking the Format Painter button, your cursor transforms into a _______.

paint brush

Each slide contains _______ for you to add content to, such as text, tables, charts, or images.

placeholders

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

relational

To delete a field in Design view, select the field you want to delete by right-clicking the ______ to the left of the field name, and select Delete Rows.

row selector

To differentiate even more between paragraphs you can add additional _______ above or below a paragraph.

space

Word displays a number of color sets for you to choose from. These color sets are based on the color _______ applied to the document.

theme

Themes include all of the following except _______.

transitions

A tab stop is a location along the horizontal ruler that indicates how far to indent text when the Tab key is pressed.

true

True or False. When you use the Source Formatting paste option, Word pastes the text and any formatting that was applied to the copied text.

true