Mr. Winter Office 1 Final Exam

Name: ID:

Email:

Ms. Davis Office 1 Final Exam - Even

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

In Word, the default alignment for paragraphs is __________.

a.	left-aligned, or flush margins at the left edge and jagged edges at the right edge
b.	centered, or equidistant from both the left edge and the right edge
c.	right-aligned, or flush margins at the right edge and jagged edges at the left edge
d.	justified, or flush margins at both the left and right edges

__________ is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.

a.	Document formatting	c.	Paragraph formatting
b.	Character formatting	d.	Object formatting

The first step in creating a data source is to __________.

a.	create the main document
b.	merge the data source with the main document
c.	generate the form letters
d.	decide which fields it will contain

Each row in a data source is called a __________.

a.	header row	c.	data field
b.	footer row	d.	record

To clear an entire worksheet, click the __________ and then press the DELETE key.

a.	Undo button on the Standard toolbar or press CTRL+U
b.	None button in the AutoCalculate area or press CTRL+N
c.	Cells button on the Formatting toolbar or press CTRL+C
d.	Select All button on the worksheet or press CTRL+A

The general name for the type of approach that Access uses for querying a database is QBE, which means __________.

a.	Query-By-Example	c.	Question-By-Entering
b.	Question-By-Example	d.	Query-By-Entering

In any of the four Chart Wizard dialog boxes, the __________ button can be clicked to return to the previous Chart Wizard dialog box.

a.	Cancel	c.	Next
b.	Back	d.	Finish

When an expression is entered for a calculated field, the field names used in the expression must be enclosed in __________.

a.	square brackets ([ ])	c.	quotation marks (“ “)
b.	curly braces ({ })	d.	parentheses (( ))

The __________ close Excel.

a.	Close button and Control-menu icon on the menu bar
b.	Minimize button and Restore icon on the menu bar
c.	Close button and Control-menu icon on the title bar
d.	Minimize button and Restore icon on the title bar

10.

Moving from left to right in a formula, the order of operations is as follows: first negation (-), then all __________.

a.	exponentiations (^), then all percentages (%), then all multiplications (*) and divisions (/), and finally, all additions (+) and subtractions (–)
b.	percentages (%), then all exponentiations (^), then all multiplications (*) and divisions (/), and finally, all additions (+) and subtractions (–)
c.	exponentiations (^), then all percentages (%), then all additions (+) and subtractions (–), and finally, all multiplications (*) and divisions (/)
d.	percentages (%), then all exponentiations (^), then all additions (+) and subtractions (–), and finally, all multiplications (*) and divisions (/)

11.

The thickness of a 3-D Pie chart can be controlled by entering a percent smaller or larger than the default 100% in the __________ in the 3-D View dialog box.

a.	Elevation text box	c.	Height text box
b.	Rotation text box	d.	Apply text box

12.

After you click the Draw Table button, the mouse pointer changes to the shape of a(n) __________.

a.	pencil	c.	crosshair
b.	eraser	d.	block arrow

13.

A field has the format < in the Format box. If you type me93 in the field it will display as __________.

a.	me93	c.	Me93
b.	ME93	d.	mE93

14.

Within the body of a newsletter, a heading, such as LUNCHEON in the accompanying figure, is called a(n) __________.

a.	subhead	c.	issue information line
b.	nameplate or banner	d.	run-around

15.

When the Tools button in the Save As dialog box is clicked, the __________ in the list that displays allows a backup copy of the workbook to be saved, a password to limit access to the workbook to be created, and other functions to be carried out.

a.	Add to Favorites command	c.	Properties command
b.	Web Options command	d.	General Options command

16.

A(n) __________ is a collection of data organized in a manner that allows access, retrieval, and use of that data.

a.	file management system	c.	integrated system
b.	database management system	d.	database

17.

In the AutoFormat dialog box shown in the accompanying figure, the __________ allows additional formats to be selected and assigned as part of the selected customized format.

a.	Cancel button	c.	Question Mark button
b.	OK button	d.	Options button

18.

The set of records that make up the answer to a query will be displayed in __________ view.

a.	Virtual	c.	Form
b.	Datasheet	d.	Dynamic

19.

To use a built-in statistic in a query, include the statistic in the _________ row in the design grid.

a.	Field	c.	Total
b.	Sort	d.	Criteria

20.

The Mail Merge Wizard is accessed through the _________ menu.

a.	File	c.	Format
b.	Insert	d.	Tools

21.

With Word’s AutoCorrect entries, to display an indifferent face (K) type __________.

a.	:)	c.	:\|
b.	:(	d.	:/

22.

To display the Language bar, point to the Speech command on the __________ and then click the Speech Recognition command on the Speech submenu.

a.	Edit menu	c.	Tools menu
b.	Insert menu	d.	Window menu

23.

A(n) __________ contains information about a given person, product, or event.

a.	attribute	c.	field
b.	column	d.	record

24.

To order records in the Customer table in ascending order by amount paid amount, click the Amount Paid field and then click the __________ button on the toolbar.

a.	Records Ascending	c.	Sort Ascending
b.	Order Ascending	d.	Sort Same

25.

Basic installations of Word support __________ types of main documents.

a.	one	c.	five
b.	three	d.	unlimited

26.

The shortcut keys for the __________ character formatting are CTRL+SHIFT+PLUS SIGN.

a.	case of letters	c.	superscript
b.	underline words, not spaces	d.	all capital letters

27.

If the result a formula should produce is known, the __________ on the Tools menu can be used to determine the value of a cell on which the formula depends.

a.	Track Changes command	c.	Share Workbook command
b.	Data Analysis command	d.	Goal Seek command

28.

When creating a hyperlink, as soon as the ENTER key is pressed after typing a Web address, the Web address is __________.

a.	italicized and colored red	c.	underlined and colored red
b.	italicized and colored blue	d.	underlined and colored blue

29.

The Word Count dialog box presents a variety of statistics about the current document, including number of __________.

a.	lines	c.	paragraphs
b.	characters	d.	all of the above

30.

When a text entry in the Office Clipboard gallery of the Office task pane is pointed to, __________.

a.	the first several characters of text in the item display as a ScreenTip
b.	the text entry is deleted from the Office Clipboard gallery
c.	the text entry is pasted into the document at the location of the insertion point
d.	all of the above

31.

The __________ in the Conditional Formatting dialog box can be used to remove one or more active conditions.

a.	Add button	c.	Cancel button
b.	Delete button	d.	Format button

32.

Each time the __________ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.

a.	ENTER	c.	CTRL
b.	SHIFT	d.	ALT

33.

A short horizontal line indicating the conclusion of a document is the __________.

a.	insertion point	c.	status indicator
b.	end mark	d.	scroll box

34.

To instruct Word to stop bulleting paragraphs, press the ENTER key __________ the Bullets button.

a.	once or click	c.	once or double-click
b.	twice or click	d.	twice or double-click

35.

To save an active document with a new file name, click __________ on the menu bar and then click Save As.

a.	Edit	c.	View
b.	File	d.	Tools

36.

Applying a gradient color to a WordArt drawing object is done by using the __________ toolbar.

a.	Picture	c.	WordArt
b.	Drawing	d.	Formatting

37.

Word 2002 includes a series of predefined graphics called __________ that can be inserted into a Word document.

a.	clip art	c.	captions
b.	hyperlinks	d.	bookmarks

38.

If formulas located in other cells reference cells in a deleted row or column, Excel displays the error message __________ in those cells to indicate a cell reference error.

a.	#VALUE!	c.	#NULL!
b.	#N/A!	d.	#REF!

39.

In the accompanying figure, the __________ text box can be used to display a specific record in the main document.

a.	View Merged Data	c.	Go to Record
b.	Sort Records	d.	Mail Merge

40.

The horizontal lines in the nameplate are called __________.

a.	subheads	c.	rules or ruling lines
b.	references	d.	run-arounds

41.

To include the Total row in the design grid, right-click the grid, and then click ________on the shortcut menu.

a.	Totals	c.	Function
b.	Statistics	d.	Calculations

42.

Goal seeking assumes the value of __________ referenced directly or indirectly can be changed.

a.	no cells	c.	two or more cells
b.	only one cell	d.	any number of cells

43.

To save a workbook a second time using a new name or on a different drive, __________.

a.	click Save on the File menu	c.	click Save As on the File menu
b.	press SHIFT+F12	d.	press CTRL+S

44.

To make changes to the structure of a table, right-click the table in the Database window and then click __________ on the shortcut menu.

a.	Change	c.	Structure
b.	Restructure	d.	Design View

45.

In print preview, the Print Preview toolbar displays __________.

a.	above the menu bar, but below the Standard and Formatting toolbars
b.	below the menu bar; the Standard and Formatting toolbars disappear from the screen
c.	above the Standard and Formatting toolbars, but below the menu bar
d.	below the Standard and Formatting toolbars; the menu bar disappears from the screen

46.

In Excel, functions can be entered using any of the following methods except the __________.

a.	Function command on the Tools menu
b.	keyboard or mouse
c.	Insert Function box on the formula bar
d.	AutoSum menu or Voice Command mode

47.

The scroll box on the vertical scroll bar indicates the __________.

a.	position of the insertion point from the top of the page
b.	distance of the insertion point from the left margin
c.	current relative location of the insertion point in the document
d.	rank of the word in which the insertion point is found

48.

The difference between a text box and a frame is that __________.

a.	a frame has more graphical formatting options than does a text box
b.	a frame is more versatile
c.	a text box has more graphical formatting options than does a frame
d.	there is no difference

49.

A(n) __________ key is a field in one table whose values are required to match a primary key of another table.

a.	secondary	c.	foreign
b.	auxiliary	d.	matching

50.

To use a delete query to delete all records with the value GA in the State field, create a new query for the Client table, select Delete from the Query Type on the shortcut menu, place the State field in the design grid, and then enter GA in the __________ row.

a.	Criteria	c.	Show
b.	Delete	d.	Update To

True/False

Indicate whether the sentence or statement is true or false.

51.

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click Zoom.

52.

If a print area is not selected, Excel automatically prints all 16,777,216 cells in the worksheet.

53.

The formulas version of a worksheet usually is significantly narrower than the values version.

54.

In Access, all the tables, report, forms, and queries are stored in separate files. Collectively, these files are called a database.

55.

When a window is split into panes, any change made in one pane has no effect in the other panes.

56.

Formatting marks, such as the end-of-cell mark, do not print on a hard copy.

57.

The end mark will display one blank line above the insertion point when line spacing is single.

58.

The first item copied displays at the top of the Office Clipboard gallery.

59.

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

60.

When you click Header and Footer on the View menu bar, Word switches from print layout view to normal view and displays the Header and Footer toolbar.

61.

A dimmed command on a short or full menu indicates that it is not available for a current selection in a menu.

62.

When a clip art image is inserted into a document, Word inserts the picture as part of the current paragraph.

63.

To obtain a printed copy of the relationships within a database, display the Relationships window, click File on the menu bar, and then click Print Relationships.

64.

To display field codes on the screen, press the CTRL+F9 keys.

65.

When a word has been flagged with a red wavy underline it indicates that it is not in Word’s dictionary.

66.

Excel has hundreds of toolbar buttons, most of which display on 19 built-in toolbars.

67.

The basic content of a group of form letters is the same; however, items like name and address are the different from one letter to the next.

68.

In Access, a database consists of a collection of tables.

69.

The column border, the border to the right of a column, can be dragged until a row is at a desired height.

70.

When goal seeking, the cell to change has to be referenced directly in the formula or function

71.

It is possible that the same document could wordwrap on different words if printed on different printers.

72.

Fields can be added to a table structure and deleted from a table structure.

73.

When the system date is entered, the date displays left-aligned in the cell because Excel treats the date as text.

74.

To find the largest amount paid amount for a customer, select LARGE as the entry in the Total row for the Amount Paid column.

75.

Columns in which the text in each column uses the same amount of vertical space are said to be snaking columns.

76.

In a business letter, the inside address, placed three to eight lines below the date line, usually contains the sender’s title plus full name, business affiliation, and full geographical address.

77.

To filter records based on values in more than one field, click the Filter By Form button rather than the Filter By Selection button.

78.

To create a compound criterion using OR, enter each criterion on different lines.

79.

The >= in a condition is the expression.

80.

You can click the ruler to set a custom tab stop at the right margin.

81.

A password can be up to 15 characters long and is case-sensitive, meaning Excel can differentiate between uppercase and lowercase letters.

82.

Each time the ENTER key is pressed Word creates a new paragraph.

83.

All documents have at least one section.

84.

A docked toolbar is attached to the edge of the Word window.

85.

To move from Form view to Datasheet view, click the View button down arrow on the Form View toolbar and then click Datasheet View in the list that displays.

86.

The asterisk (*) wildcard represents any individual character.

87.

Word provides an Undo button on the Standard toolbar that can be used to cancel the most recent command or action, including typing.

88.

When you change the margin settings in the text boxes in the Page Setup dialog box, the Preview area adjusts to reflect a changed margin setting.

89.

When a multiple-field index is created, Access automatically assigns a name to the index.

90.

The AutoShapes button displays on the Formatting toolbar.

91.

When you drag the Hanging Indent marker, the Left Indent marker moves with it.

92.

To specify a required field validation rule for a field, select the field, click the Required property box in the Field Properties area, click the down arrow that displays, and then click Yes in the list.

93.

To enter an absolute reference, the dollar sign ($) can be typed as part of the cell reference or with the insertion point to the right of the cell reference to be changed to absolute, the F4 key can be pressed.

94.

An add query adds a group of records from one table to the end of another table.

95.

The shortcut keys, CTRL+ENTER, instruct Word to insert an automatic page break immediately above the insertion point and position the insertion point immediately below the automatic page break.

96.

To split the window into four panes, first select the cell where the panes should intersect.

97.

The first step in the mail merge process is to identify the main document.

98.

Tables can be centered horizontally between the left and right margins.

99.

Most formats assigned to a cell will display on the Standard toolbar when the cell is selected.

100.

Files can be previewed in both the Open and Insert File dialog boxes by clicking the Preview button in the respective dialog boxes.