Mr. Winter Office 1 Final Exam

Name: ID:

Email:

Ms. Davis Office 1 Final Exam - Odd

Multiple Choice

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

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!

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

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

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

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

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

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

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

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

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

10.

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

11.

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

12.

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

13.

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

14.

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

15.

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

16.

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

17.

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

18.

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

19.

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

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

20.

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

21.

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

22.

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

23.

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

24.

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

25.

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

26.

Basic installations of Word support __________ types of main documents.

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

27.

__________ 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

28.

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

29.

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

30.

The Mail Merge Wizard is accessed through the _________ menu.

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

31.

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

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

32.

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

33.

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

34.

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 (/)

35.

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

36.

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

37.

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

38.

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

39.

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

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

40.

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

41.

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

42.

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

43.

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 (( ))

44.

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

45.

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

46.

Each row in a data source is called a __________.

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

47.

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

48.

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

49.

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

50.

The horizontal lines in the nameplate are called __________.

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

True/False

Indicate whether the sentence or statement is true or false.

51.

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

52.

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

53.

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.

54.

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

55.

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

56.

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

57.

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

58.

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

59.

The asterisk (*) wildcard represents any individual character.

60.

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

61.

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

62.

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

63.

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

64.

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.

65.

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.

66.

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

67.

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

68.

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.

69.

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

70.

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

71.

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

72.

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

73.

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

74.

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

75.

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

76.

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.

77.

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.

78.

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

79.

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

80.

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

81.

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.

82.

The AutoShapes button displays on the Formatting toolbar.

83.

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.

84.

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

85.

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

86.

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.

87.

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

88.

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

89.

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

90.

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

91.

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

92.

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

93.

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

94.

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

95.

All documents have at least one section.

96.

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

97.

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

98.

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.

99.

The >= in a condition is the expression.

100.

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