Final for CIT 105
Click ____ to move a stacked object toward the top of the stack.
bring forward
Click ____ to move a stacked object toward the top of the stack.
bring to front
Which of the following calculations multiplies 23 by 0.01?
23%
What effect does the Comma Style format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
A ___________ is a specific design with coordinating colors, fonts, and special effects
document theme
A _______ is a prewritten formula that is built into Excel.
function
_________ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
goal
________ is one color shade gradually progressing to another shade of the same color or to another color.
gradient fill
A _______ is text and graphics that print at the top of each page.
header
A _________ IF function is one in which the action to be taken for the true of false case includes yet another IF function
nested
You can type and format notes in the ____ pane.
notes
You can type comments to yourself in the ____ for a specific slide while working in Normal view.
notes pane
To print a range of cells in the active worksheet, click ________ in the Settings area in the Print gallery.
print selection
A ________ chart provides a simple way to show trends and variations in a range of data within a single cell.
sparkline
To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.
square brackets [ ]
The _________ introduces the presentation to the audience.
title slide
Which of the following formulas contains an absolute cell reference?
$B$4
WordArt ____ in the interior of a letter can consist of a solid color, texture, picture, or gradient.
fill
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
Combining two or more selected cells into one cell is called ____ cells.
merging
Charts can either be embedded in a worksheet or placed in a separate ____.
chart sheet
To order the records in the answer to a query in a particular way, you ____ the records.
sort
A word with a meaning similar to that of another word is called a ____.
synonym
_____ allows you to see through the background, so that any text on the slide is visible.
transparency
PowerPoint's ____ feature allows you to set the timing for a video clip.
trim video
A unique identifier is also called a primary key.
true
Form view displays a single record at a time.
true
In Access, the columns in a table are called fields.
true
To omit duplicates from a query, use the property sheet and change the Unique Values property to ________.
yes
The _________ function display the highest value in a range.
MAX
The ____ function is useful when you want to assign a value to a cell based on a logical test.
IF
To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ________ on the ribbon, and then click the Report Wizard button.
CREATE
________ is the difference between the darkest and lightest areas of an image.
contrast
In a multilevel bulleted list slide, creating a lower-level paragraph is called ______ the text.
demoting
Which comparison operator means "not equal to"?
<>
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
Press ____ to select the entire worksheet.
CTRL+A
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
To export data from a query to Excel, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Excel button.
EXTERNAL DATA
The copy button copies the contents and format of the source area to the Office _________, a temporary storage area in the computer's memory.
clipboard
To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.
colon (:)
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
colon (:)
__________ effects determine how slide elements first appear on a slide.
entrance
To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.
false
You can include ____ in calculations to indicate which calculation should be done first.
parentheses ( )
The box on a slide that has a dotted or hatch-mark border and that contains the insertion point is a text ___________.
placeholder
A _______ reference is an adjusted cell reference in a copied and pasted formula.
relative
A field whose data type is ____ can contain any characters.
short text
A slide ____ is a special effect used to progress from one slide to the next in a slide show.
transition