BIM I Spring Final

Is this your test? Login to manage it. If not, you can generate a quiz just like it.

This is a non-interactive preview of the quiz content.

1.
2 points
Use the ___________ command to locate specific instances of text in your presentation.
2.
2 points
To include a photo image with each record in a table use a field with this data type:
3.
2 points
To copy text to the Clipboard and not remove it from the document, you would use the _________ command.
4.
2 points
To highlight cells with values in the top 10% of the select range, use ______________ conditional formatting.
5.
2 points
A Total row can be used to quickly calculate the _________ of all the values in a column.
6.
2 points
A group of formatting options, including font, color, backgrounds, and effect styles, that you apply to a presentation is known as a _________
7.
2 points
Dotted lines that appear when you move an object on a slide that help you align the object with other slide objects are known as ____________
8.
2 points
The __________ placeholder is a special type of placeholder that gives you a quick way to add a variety of a material to your presentations.
9.
2 points
A __________ is a special report view that summarizes data and calculates the intersecting totals.
10.
2 points
The default size for slides is:
11.
2 points
A ___________font does not have an embellishment at the end of each stroke.
12.
2 points
When giving a presentation, you can write on slides and save annotations by using PowerPoint’s pen options, which include the __________ tool
13.
2 points
________________ are the numbers at the left of rows and the letters at the top of columns.
14.
2 points
When you are entering data in a new record in a form, the Undo command will
____________________
15.
2 points
Identify the Pv argument in this formula: =-PMT(B2/12,B3,B4)
16.
2 points
__________ rearranges the rows in your worksheet by the data in a column or columns.
17.
2 points
If you want a slide to remain in a presentation but not show by default when you are in Slide show view, you should _____________ the slide.
18.
2 points
What is the definition of concatenate?
19.
2 points
you can undo a record deletion.
20.
2 points
To hide the sound icon and play an audio file across the entire presentation, click the _______________.
21.
2 points
The ___________ command lets you enter a designated value for a formula and specify an input cell that can be modified in order to reach that goal.
22.
2 points
___________ are small messages you add to slides for others to read that are not meant to be a part of the presentation.
23.
2 points
Each column in a table represents a specific data value called a ______________
24.
2 points
__________ are the basic building blocks of a database.
25.
2 points
Where is the Set Print Area command located
26.
2 points
A(n) __________ is the cell containing a formula that references the value or formula in the selected cell.
27.
2 points
Selecting a cell and pressing delete clears
28.
2 points
To rename a field __________
29.
2 points
To view your presentation as your audience will see it, use _____________
30.
2 points
To group worksheets that are not next to each other, select the first worksheet and press the _________ key, and then click the other sheet tabs you want included in the group.
31.
2 points
__________ charts represent data as parts of a whole.
32.
2 points
A _____________ is text or a graphic that, when clicked, takes you to a new location.
33.
2 points
To align text along the upper edge of a text placeholder, use the ____________ command
34.
2 points
When you hide a row or column, the data remains in your workbook. They are no longer displayed on-screen but will be part of the printed workbook.
35.
2 points
Use ___________ to create smaller groups of slides within your presentation to help you better organize your work.
36.
2 points
To count the number of cells that contain text or numerical values, but not blanks, use which function?
37.
2 points
The currency field format is the same as the Currency data type
38.
2 points
The design principle of using elements on your slides to guide your audience’s eyes from one point to another in a natural progression is known as ___________.
39.
2 points
A ____________ is a set of color variations and backgrounds you can change for a theme.
40.
2 points
A(n) __________ is an effect that occurs when one slide leaves the screen and another one appears.
41.
2 points
Identify the Value_if_true argument in this formula: =IF(A1>50,”bonus”,”no bonus”)
42.
2 points
A table’s primary key must ______________
43.
2 points
Text that includes predefined graphic styles, such as shadows, reflections, and glows is known as _____________.
44.
2 points
Which paste option pastes formulas and number formatting but none of the cell formatting?
45.
2 points
A _______ is text that appears at the bottom of every page just above the margin.
46.
2 points
A ____________ is a printout of your presentation with anywhere from one to nine slides per page and with areas for taking notes.
47.
2 points
If your worksheet is wide, you may want to use portrait orientation where the height of the page is greater than the width.
48.
2 points
If you need to display items in a list in a particular order, use a _____________.
49.
2 points
To apply the Double Underline accounting underline format:
50.
2 points
All data entered into a form are stored in the underlying _____________