Name:     ID: 
 
Email: 

MOA Final Exam - Spring 2012

 1. 

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

 2. 

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

 3. 

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

 4. 

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

 5. 

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

 6. 

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

 7. 

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

 8. 

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

 9. 

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

 10. 

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, they are printed in a larger size than when you choose Slides.
b.
Handouts can be printed so that many are placed on a single sheet of paper.
c.
There is no advantage.
d.
When you choose Handouts, you can specify which slides to print, but when you select Slides, you must print the entire presentation.
 

 11. 

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
 

 12. 

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

 13. 

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

 14. 

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

 15. 

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

 16. 

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

 17. 

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

 18. 

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
 

 19. 

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

 20. 

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

 21. 

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

 22. 

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

 23. 

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

 24. 

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

 25. 

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

 26. 

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

 27. 

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

 28. 

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

 29. 

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

 30. 

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

 31. 

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; copy
d.
paste; cut
 

 32. 

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

 33. 

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

 34. 

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.
dragging the resize handle at the lower-right corner of the table to include the new row
c.
double-clicking the last cell in the table
d.
choosing Page Layout>Themes>Themes
 

 35. 

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

 36. 

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

 37. 

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.
chart
b.
table
d.
SmartArt diagram
 

 38. 

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

 39. 

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

 40. 

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

 41. 

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

 42. 

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

 43. 

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

 44. 

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

 45. 

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

 46. 

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

 47. 

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

 48. 

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

 49. 

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

 50. 

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



 
         Start Over