Name:     ID: 
 
Email: 

Office 2 Final Exam

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 1. 

To select nonadjacent text, select the first item, hold the ____ key, and then select the subsequent items.
a.
SHIFT
c.
ALT
b.
CTRL
d.
END
 

 2. 

Pressing ____ instructs Word to change the line spacing of a cell to be single-spaced, instead of 1.15 spacing.
a.
CTRL+2
c.
CTRL+1
b.
ESC+1
d.
ESC+4
 

 3. 

If you want to see the current margin settings, display the ruler and then hold down the ____ key while pointing to the margin boundary where the blue meets the white on the ruler.
a.
ALT
c.
SHIFT
b.
CTRL
d.
ESC
 

 4. 

Records can be merged based on the contents of a specific ____.
a.
record
c.
header
b.
field
d.
row
 

 5. 

One way to print the contents of the data source is to merge all the data records in the data source into a single document called a(n) ____.
a.
master list
c.
index
b.
directory
d.
glossary
 

 6. 

To add dashes or hyphens, you can use the ____ tab in the Symbols dialog box.
a.
Punctuation
c.
Special Characters
b.
ANSI
d.
Character Options
 

 7. 

In a formula, to use a cell name that is made up of two or more words, replace any space with the ____.
a.
ampersand character (&)
c.
plus sign character (+)
b.
hyphen (-)
d.
underscore character (_)
 

 8. 

Excel automatically creates an empty row in the table so that you are ready to enter the first ____ in the table.
a.
formula
c.
record
b.
field
d.
cell
 

 9. 

Excel will update links automatically if ____.
a.
the linked workbooks are open
c.
the formulas are correct
b.
the woksheets are open
d.
he functions are correct
 

 10. 

In the accompanying figure, the small box or bar to left of each field is called the ____.
a.
row selector
c.
field bar
b.
field selector
d.
current field bar
 

 11. 

If the Field Size for a field whose data type is Number is set to ____, the field size will be an integer value in the range of 0 to 255.
a.
Byte
c.
Least
b.
Smallint
d.
Integer
 

 12. 

Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.
a.
combine
c.
merge
b.
concatenate
d.
join
 

 13. 

To quit Access, click the ____ button on the right side of the Access title bar.
a.
Quit
c.
Stop
b.
Exit
d.
Close
 

 14. 

To change the caption for a field in a query, click the field in the design grid, click the _____ button on the Design tab, click the Caption box, and enter the new caption.
a.
Property Sheet
c.
Query
b.
Caption
d.
Format
 

 15. 

With a ____, you vary the value in one cell and then Excel calculates the results of one or more formulas and fills the data table with the results.
a.
two-input data table
c.
one–input data table
b.
function
d.
formula
 

True/False
Indicate whether the statement is true or false.
 

 16. 

When a document is inserted, Word inserts the document at the location of the insertion point.
 

 17. 

A container for text that allows the text to be positioned anywhere on the page is a frame; this is placed around a letter when you drop cap that letter.
 

 18. 

One form of the IF field is called an If…Then…Else: If a condition is true, then perform an action; else perform a different action.
 

 19. 

It is good practice to test the formulas in a worksheet over and over again until you are confident they are correct.
 

 20. 

Excel allows sorting on a maximum of 256 fields in a single sort operation.
 

 21. 

To find all clients whose names begin with Be, enter Be? in the Criteria row of the design grid.
 

 22. 

The Find button is available only in Form view.
 

 23. 

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.
 
 
nar001-1.jpg
Figure 4-2
 

 24. 

In the accompanying figure, after you set the print area and save the workbook, Excel remembers this setting the next time you open the workbook.
 

 25. 

The ampersand character (&) is the concatenation operator.
 

 26. 

Only the fields that appear in the design grid are included in the results of the query.
 

 27. 

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).
 

 28. 

Parameter queries are useful for summarizing data.
 

 29. 

The Find button is available only in Form view.
 

 30. 

The number of digits is one of the arguments in the ROUND function.
 



 
         Start Over