Name:     ID: 
 
Email: 

MOA Final Exam - Spring 2012

 1. 

To place text on a slide, click the mouse button to position the ____ and then key the text.
a.
placeholder
c.
insertion point
b.
text box
d.
outline
 

 2. 

It is a good idea to always examine your slides in ____ immediately before printing them.
a.
Print Preview
c.
Slide Sorter View
b.
Normal
d.
Slide Show View
 

 3. 

If you do not want a worksheet’s gridlines to be printed, choose ____.
a.
View>Show/Hide and deselect Gridlines
b.
Page Layout>Sheet Options and deselect Gridlines
c.
View>Show/Hide and click Hide
d.
Home>Cells>Format and click Hide
 

 4. 

You can apply a theme by choosing ____.
a.
Home>Styles>Cell Styles
c.
Page Layout>Themes>Themes
b.
Home>Cells>Format
d.
Home>Styles>Format as Table
 

 5. 

You can access a button’s ScreenTip by ____.
a.
choosing Home>ScreenTip
b.
placing the pointer on the button
c.
choosing View>Presentation Views>ScreenTip
d.
right-clicking the button
 

 6. 

The first slide in a presentation ____.
a.
always contains the author’s name
b.
usually contains a bulleted list
c.
is usually the title slide
d.
must always be the first slide in the slide show
 

 7. 

If you want to move backward and forward through a presentation, click the ____.
a.
scroll bar
c.
Office button
b.
QAT
d.
status bar
 

 8. 

Horizontal alignment is used to align the contents of a ____.
a.
cell
c.
worksheet
b.
column
d.
row
 

 9. 

Which of the following is not a category of options that appears when you choose Home>Cells>Format?
a.
Cell Size
c.
Visibility
b.
Font Color
d.
Organize Sheets
 

 10. 

If you want to know the name of the presentation on which you are working, look at the ____.
a.
title bar
c.
QAT
b.
Slides tab
d.
status bar
 

 11. 

The Print dialog box lets you specify____.
a.
how many of a database’s tables will be printed
b.
the order in which table records will be printed
c.
the number of copies to be printed
d.
the name of the table to be printed
 

 12. 

Why must you fill in a worksheet before you can create a chart?
a.
To tell PowerPoint how to format the chart.
b.
To indicate the location of the chart on the slide.
c.
To specify the data PowerPoint should use to create the chart.
d.
To specify the type of chart to be created.
 

 13. 

Which of the following cannot have Quick Styles applied to it?
a.
a chart
c.
a table
b.
a SmartArt diagram
d.
a Clip Art image
 

 14. 

To use Hide & Unhide, choose Home>Cells>Format, and look under ____.
a.
Cell Size
c.
Organize Sheets
b.
Visibility
d.
Background
 

 15. 

Which of the following is a tab that appears on the Ribbon when a datasheet is open?
a.
Table Tools
c.
Sort
b.
Format
d.
Query
 

 16. 

Which tab in the Format Cells dialog box contains the option to change a word’s color?
a.
Font
c.
Number
b.
Border
d.
Patterns
 

 17. 

If you want to move a pie chart from one slide to another, you can ____ the chart from its original location and ____ it into the new spot.
a.
copy; paste
c.
cut; paste
b.
paste; cut
d.
paste; copy
 

 18. 

You can create a new folder in the ____ dialog box.
a.
Open
c.
Database Properties
b.
Access Help
d.
Print
 

 19. 

You can press ____ to move from the first field to the second field of a record.
a.
[SHIFT]+[TAB]
c.
[TAB]
b.
[BACKSPACE]
d.
[SHIFT]
 

 20. 

PowerPoint can be used to create professional-looking ____.
a.
business letters
c.
presentations
b.
graphics
d.
workbooks
 

 21. 

When you are in Normal View, the PowerPoint screen is divided into two sections: the ____ and the ____.
a.
Slide Show pane; slide pane
c.
Slides and Outline tab; slide pane
b.
Notes Page pane; slide pane
d.
Slide Sorter pane; slide pane
 

 22. 

____ alignment lets you align the contents of a cell to its top, center, or bottom.
a.
Page
c.
Vertical
b.
Gridline
d.
Horizontal
 

 23. 

Which of the following is true concerning background styles?
a.
They are applied only to those slides that you specify.
b.
They are applied to all slides in the presentation.
c.
They include art and graphics.
d.
They include font and font styles.
 

 24. 

Which of the following cannot be specified on the Font tab in the Format Cells dialog box?
a.
Font color
c.
Font alignment
b.
Font size
d.
Font style
 

 25. 

To set up a slide show, choose ____.
a.
Office>New>Blank Presentation
b.
View>Presentation Views>Slide Sorter
c.
Slide Show>Set Up>Set Up Slide Show
d.
View>Presentation Views>Slide Show
 

 26. 

Which of the following is a major advantage of choosing Handouts rather than Slides in the Print what box in the Print dialog box?
a.
When you choose Handouts, you can specify which slides to print, but when you select Slides, you must print the entire presentation.
b.
There is no advantage.
c.
When you choose Handouts, they are printed in a larger size than when you choose Slides.
d.
Handouts can be printed so that many are placed on a single sheet of paper.
 

 27. 

When you ask Access to locate every customer in a database who has more than three items on order, you are ____ the database.
a.
compacting
c.
splitting
b.
navigating
d.
querying
 

 28. 

If you are currently at slide 14, which of these methods will take to you slide 15?
a.
Pressing the [PAGE UP] key.
b.
Clicking the up arrow on the scroll bar once.
c.
Clicking Slide 15 on the status bar.
d.
Clicking the Next Slide button.
 

 29. 

Which of the following is not a task that the Design tab allows you to perform?
a.
Add a Function.
c.
Add a Header Row.
b.
Add a Total Row.
d.
Add a Last Column.
 

 30. 

If you want to create a chart, you must first create a(n) ____.
a.
datasheet
c.
object
b.
template
d.
table
 

 31. 

Before you can use the pointer to widen a column in a datasheet, the pointer must become a(n) ____.
a.
vertical line
c.
arrow
b.
downward-pointing arrow
d.
two-headed arrow
 

 32. 

One important feature of the QAT is that it ____.
a.
can be used to display slide shows
b.
allows you to move quickly among slides
c.
lets you reorganize slides as needed
d.
can be customized
 

 33. 

If you needed to create a grid showing which class you had for each hour each day of the week, your best choice would be to create a ____
a.
shape
c.
table
b.
SmartArt diagram
d.
chart
 

 34. 

____ is not an example of a font style.
a.
Bold
c.
Underline
b.
Italic
d.
Border
 

 35. 

Which of the following is not a database object?
a.
Query
c.
Table
b.
Report
d.
Field Property
 

 36. 

Extra text that appears in the PowerPoint window, such as comments, is referred to as ____.
a.
SmartArt
c.
WordArt
b.
markup
d.
diagrams
 

 37. 

When you are in Print Preview, you can zoom in and out by ____.
a.
clicking the slide
c.
pressing [ENTER]
b.
pressing [ESC]
d.
choosing Zoom in/out
 

 38. 

An important reason that you might want to view several queries at once would be to ____.
a.
reorder the records in the queries
b.
print them all together
c.
compare them with one another
d.
create a new table based on these queries
 

 39. 

What are two ways you can rearrange the order of slides on the Slides tab?
a.
by dragging and by using the Mini Toolbar
b.
by dragging and by using the status bar
c.
by using the Mini Toolbar and by cutting and pasting
d.
by dragging and by cutting and pasting
 

 40. 

You can exit a slide show by ____.
a.
choosing Office>Save
c.
clicking Stop on the Home tab
b.
pressing [ESC]
d.
pressing the spacebar
 

 41. 

Which of the following situations would be best suited to using SmartArt?
a.
You want to place a picture of a computer on a slide.
b.
You want to create a chart showing the number of customers each day.
c.
You want to create a logo.
d.
You want to create a graphic showing the structure of your company.
 

 42. 

When a worksheet is hidden, ____.
a.
you can click the Select All button to make it visible again
b.
you can use the Unhide Sheet command to make it visible again
c.
it has been erased from the workbook
d.
its tab is still visible at the bottom of the workbook
 

 43. 

In a school’s database, each student’s ____ would include related fields, such as his or her name, address, GPA, and so forth.
a.
record
c.
query
b.
table
d.
field
 

 44. 

Each individual item within a PowerPoint presentation is called a ____.
a.
screen
c.
note
b.
file
d.
slide
 

 45. 

If you apply a table style to a range of cells and then add an additional row of data, you can increase the table size by ____.
a.
choosing Home>Cell Style>New Cell Style
b.
choosing Page Layout>Themes>Themes
c.
dragging the resize handle at the lower-right corner of the table to include the new row
d.
double-clicking the last cell in the table
 

 46. 

If you were spell-checking a document and wanted the Spell Checker to skip a word one time, you would click ____.
a.
Ignore All
c.
Continue
b.
Change
d.
Ignore
 

 47. 

Changing font color affects ____.
a.
only the contents of the currently selected cells
b.
all of the worksheets in the current the workbook
c.
only the tab color of the current worksheet
d.
all of the cells in the current worksheet
 

 48. 

The Shapes button is on the ____ tab.
a.
Design
c.
Insert
b.
Layout
d.
Home
 

 49. 

Which of the following is not a button contained on the View tab?
a.
Slide Show
c.
Normal
b.
Print Preview
d.
Slide Sorter
 

 50. 

If you want a row to be just tall enough so that all of its contents are visible, ____.
a.
choose Home>Alignment>Center
b.
choose AutoFit Row Height in the Format list on the Home tab
c.
choose Home>Alignment>Bottom Align
d.
double-click the row heading’s top edge
 



 
         Start Over