CIS 110 Test 2 (Chap. 3 and Units C-I)

Name:

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

____ performs functions specific to a business or industry.

a.	Custom software	c.	Shareware
b.	Packaged software	d.	Public-domain software

Once loaded into memory, a program is displayed in a(n) ____, which is a rectangular area of the screen that displays data and/or information.

a.	screen	c.	frame
b.	window	d.	baseline

To ____ a document means to make changes to its existing content.

a.	save	c.	format
b.	edit	d.	print

Figure 3-3

A function like the one shown in Figure 3-3 ____.

a.	provides images, pictures, and video to enhance the spreadsheet
b.	is a request for specific data from a spreadsheet
c.	compares the spelling of words with an electronic dictionary
d.	is a predefined formula that performs common calculations

____ is a type of education in which students learn by using and completing exercises with instructional software.

a.	CBT	c.	DTP
b.	WBT	d.	E-learning

Microsoft Word is a ____ program you can use to create text documents, such as letters, memos, newsletters, and reports.

a.	spreadsheet	c.	desktop publishing
b.	word-processing	d.	typing

In the accompanying figure, item 6 points to the ____.

a.	Ribbon	c.	Status bar
b.	Insertion Point	d.	Close button

All Office programs have similar commands on the ____ tab for viewing documents in different ways.

a.	View	c.	Display
b.	Locate	d.	File

If there are other common commands that you use often and want to have available at all times, you can add them to the ____ toolbar.

a.	Access	c.	Quick Use
b.	Quick Access	d.	Short Cut

10.

In the accompanying figure, item 3 points to the ____.

a.	Quick Access toolbar	c.	Undo Button
b.	Redo Button	d.	Office button

11.

In the accompanying figure, item 4 points to the ____.

a.	Customize Quick Access toolbar Button	c.	Undo Button
b.	Redo Button	d.	Office button

12.

The ____ tool makes corrections to certain words as you type.

a.	SpellCorrect	c.	Spell Check
b.	WordCorrect	d.	AutoCorrect

13.

To delete individual letters, first click to the right of the unwanted letters to place the insertion point and then press ____.

a.	[Delete]	c.	[Backspace]
b.	[Erase]	d.	[Undo]

14.

In the accompanying figure, item 5 points to the ____.

a.	selected text	c.	Clipboard task pane
b.	Copy button	d.	Clipboard dialog launcher

15.

In the accompanying figure, item 1 points to the ____.

a.	Print Layout button	c.	Font Size text box
b.	Bold button	d.	Grow Font button

16.

In the accompanying figure, item 1 points to the ____.

a.	Live Preview feature	c.	Font selected
b.	Font list	d.	Font list arrow

17.

In the accompanying figure, the text in item 3 displays the ____ by changing to show the font style and size being chosen on the left.

a.	Live Preview feature	c.	Allignment
b.	Font list	d.	Font list arrow

18.

By default, Word 2007 sets page margins at ____ from the top and bottom of the page.

a.	.5 inches	c.	1.25 inches
b.	1 inch	d.	1.5 inches

19.

In the accompanying figure, item 3 points to the ____ margins setting.

a.	narrow	c.	mirrored
b.	current	d.	wide

20.

In the accompanying figure, item 2 points to the ____.

a.	default tab stops	c.	Tab indicator
b.	View Ruler button	d.	horizontal ruler

21.

When you apply the bullet format to a paragraph, Word sets off the paragraph with a bullet and automatically formats the text with a(n) ____.

a.	indent	c.	right indent
b.	left indent	d.	hanging indent

22.

The ____ style is applied to any text you type in a new document.

a.	Default	c.	Normal Paragraph
b.	Default Paragraph	d.	Normal Text

23.

In the accompanying figure, item 1 points to a(n) ____.

a.	end-of-cell mark	c.	row
b.	end-of-row mark	d.	column

24.

In the accompanying figure, item 3 points to the ____ tab.

a.	Table	c.	Table Tools Design
b.	Table Tools	d.	Table Design

25.

To format text in multiple columns use the ____ button, on the Page Layout tab.

a.	Columns	c.	Gutter
b.	Rows	d.	Newspaper

26.

In the accompanying figure, item 1 points to the ____ button.

a.	Insert Left	c.	New Column
b.	Insert Below	d.	New Row

27.

In the accompanying figure, item 2 points to the ____ button.

a.	Insert Left	c.	New Column
b.	Insert Below	d.	New Row

28.

____ is a new feature that lets you easily create professional looking business diagrams such as organizational charts, process diagrams, or timelines.

a.	SmartArt	c.	SmartOrg
b.	OrgArt	d.	SmartDiagram

29.

In the accompanying figure, item 3 points to ____.

a.	resize boxes	c.	sizing handles
b.	resize handles	d.	sizing boxes

30.

Manual page breaks are called ____ page breaks.

a.	hard	c.	easy
b.	soft	d.	fixed

31.

You can refer to a cell by its ____, a column letter followed by a row number.

a.	cell id	c.	placement
b.	cell address	d.	grid id

32.

The ____ box shows the address of the selected cell.

a.	formula	c.	name
b.	data	d.	address

33.

In the accompanying figure, item 8 points to the ____.

a.	View buttons	c.	Formula bar
b.	Office button	d.	Quick Access toolbar

34.

References to cell addresses, such as A1, E42 are known as ____.

a.	cell ids	c.	referent addresses
b.	cell references	d.	referent ids

35.

The category of common worksheet functions that is used for simple and complex mathematical calculations is ____.

a.	Math and Trig	c.	Logical
b.	Lookup and Reference	d.	Financial

36.

The category of common worksheet functions that is used for finding values in lists or tables or finding cell references is ____.

a.	Math and Trig	c.	Logical
b.	Lookup and Reference	d.	Financial

37.

____ are shading patterns that use two or three colors to show the relative values of a range of cells.

a.	Relative patterns	c.	Color scales
b.	Relative scales	d.	Color patterns

38.

Excel lets you analyze a separate range of worksheet data called a(n) ____, or rows and columns of data with a similar structure.

a.	record	c.	structure
b.	table	d.	object

39.

Excel table columns are often called ____.

a.	fields	c.	objects
b.	records	d.	columnar data records

40.

When you tell Excel which pieces of information you want to see, you are specifying the ____ for your filter.

a.	objects	c.	data
b.	items	d.	criteria

41.

The ____ is the horizontal line at the base of the chart.

a.	title axis	c.	x-axis
b.	z-axis	d.	y-axis

42.

The ____ identifies what each data series represents.

a.	legend	c.	data title
b.	data marker	d.	gridline

43.

In the accompanying figure, item 3 points to the ____.

a.	x-axis	c.	axis titles
b.	y-axis	d.	data series

44.

In the accompanying figure, item 8 points to the ____.

a.	chart gridlines	c.	data marker
b.	chart title	d.	data series

45.

In the accompanying figure, item 4 points to the ____.

a.	ScreenTip	c.	Insert tab
b.	Line button	d.	Line subtype

46.

A chart ____ is a predefined set of chart colors and fills.

a.	tool	c.	layout
b.	gallery	d.	style

47.

You can choose from a variety of commands and galleries on the ____ Format tab to make enhancements and adjustments to a selected chart object.

a.	Chart	c.	Chart Tools
b.	Tools	d.	Graph Tools

48.

The ____ dialog box provides options you can select to enhance and change the appearance of a selected data marker.

a.	Format Data Group	c.	Format Data Objects
b.	Format Data	d.	Format Data Series

49.

Use consistent ____ to ensure that all colors, in a chart, complement each other.

a.	style colors	c.	set colors
b.	theme data	d.	theme colors

50.

Your ____ goal when using charts is to communicate worksheet information effectively.

a.	only	c.	primary
b.	unique	d.	secondary

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

51.

Public-domain software is copyrighted software provided at little cost to an individual or company.

52.

To click a button on the screen requires moving the pointer to the button and then pressing and releasing a button on the mouse.

Figure 3-4

53.

As shown in Figure 3-4, a line chart, also called a column chart, shows the relationship of parts to a whole.

54.

The cost of accounting software for small businesses is more than several hundred thousand dollars.

55.

Training centers, educational institutions, and online magazine publications all use computer-aided design software to develop interactive applications.

56.

A large amount of application software is designed for home, personal, and educational use.

57.

Office comes in only two versions, or product combinations.

58.

In the course of working on various documents, you often need to open an existing file that you have already saved.

59.

To add text to a document, you first need to click where you want to insert text, and then start typing.

60.

You can change AutoCorrect settings in the AutoCorrect dialog box.

61.

When editing a document, you often need to copy text from one place to another.

62.

Sometimes you want to emphasize certain words, phrases, or lines of text.

63.

Word provides a number of additional preset margin settings that you can easily view and choose by clicking the Margins button on the Page Layout tab of the Ribbon.

64.

You can improve the appearance of a document by using spaces to align text within a line at specific positions on the page.

65.

The ruler makes it easy to set tab stops.

66.

You can improve the appearance of text on a page by setting indents.

67.

It is a good idea to insert headers and footers at the top and bottom of each page that contain the page number and other information that you want to appear on every page of your document.

68.

Cells can only contain text.

69.

Entering data in a worksheet requires you to first type data into the active cell and then accept the entry.

70.

You can format numbers to appear in one of several standard formats, including currency, percent, and date.

71.

When you create worksheets that contain many calculations, you rarely need to create formulas that contain more than one mathematical operator.

72.

In a formula, addition and subtraction are performed before multiplication and division.

73.

Microsoft lets you access several preformatted Excel templates on the Web for dozens of common office forms, such as billing statements, invoices, and purchase orders.

74.

To change the size of a chart, you must recreate it.

75.

A data table in a chart is a grid containing the chart’s underlying worksheet data.

Completion
Complete each statement.

76.

____________________ is application software that assists people in becoming more effective and efficient while performing their daily business activities.

Figure 3-2

77.

A(n) ____________________ is a name assigned to a specific design of characters, like the one shown in Figure 3-2, such as Cambria or Calibri, as shown in the accompanying figure.

78.

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

79.

____________________ is a type of application software that allows users to draw pictures, shapes, and other graphical images with various on-screen tools such as a pen, brush, eyedropper, and paint bucket.

80.

____________________ is a type of application software that helps users of all skill levels create Web pages that include graphical images, video, audio, animation, and other special effects.

81.

____________________ is a type of software that can guide individuals, families, or small business through the process of filing federal taxes.

82.

____________________ is a type of software that teaches a particular skill.

83.

Microsoft Office 2007 Professional Edition comes with a variety of ____________________ (sometimes called applications) and tools you can use to create documents, analyze data, and complete almost any business task.

84.

Microsoft Access is a(n) ____________________ management program you can use to store, organize, and display information, such as names and addresses, product inventories, and employee data.

85.

The easiest way to start an Office program is to use the Start menu on the ____________________, the bar at the bottom of your screen.

86.

The ____________________ menu contains file commands, such as saving a file, printing it, or sending it electronically.

87.

A temporary storage area in your computer’s memory for copied items is known as the Windows ____________________.

88.

You can duplicate text using a technique called drag and ____________________, where you select the text you want to copy, and then use the mouse to drag a copy of it to a new location.

89.

Using the ____________________ command removes selected text from your document and places it on the Windows Clipboard as well as the Office Clipboard if it is activated.

90.

A predesigned set of formatting elements, including colors that you can use to achieve a coordinated overall look in your document is known as a(n) ____________________.

91.

A set amount of space between the edge of a paragraph and the right or left margin is known as a(n) ____________________.

92.

A(n) ____________________ is a predefined set of formatting attributes, such as shading, fonts, and border color, that specifies how a table looks.

93.

____________________ is the most frequently used worksheet function. It totals all numbers and cell references included as function arguments.

94.

You can move or resize many of the individual components of a chart, such as the chart background or the legend, sometimes called chart ____________________.

95.

A chart ____________________ is a predefined arrangement of chart elements such as the legend and chart title.

Matching

Identify the letter of the choice that best matches the phrase or definition.

a.	accounting	f.	Spreadsheet
b.	CBT	g.	word processing
c.	functional	h.	Button
d.	Web page authoring	i.	Browser
e.	PIM	j.	chat client

96.

A graphical element that you activate to cause a specific action to take place

97.

Software with many features to make documents look professional and visually appealing

98.

One of the more powerful features of this kind of software is the capability of recalculating the rest of a worksheet when data in a worksheet changes

99.

In addition to this kind of software, a variety of business software is available for PDAs

100.

Newer versions of this software supports online credit checks, billing, direct deposit, and payroll services

101.

Departments, centers, and divisions are collectively known as this kind of unit

102.

Software used to create sophisticated Web pages

103.

Typically consists of self-directed, self-paced instruction about a topic

104.

Allows users to access Web pages on the Internet

105.

Software integrated in some operating systems, e-mail programs, and Web browsers

Match each button found in the Open and Save As dialog boxes with a statement below.

a.	Views	d.	Organize
b.	Forward	e.	Back
c.	New Folder

106.

Includes commands for working with files and changing the layout of the dialog box

107.

Includes commands for viewing files in the current folder as icons, in a list, with details, or as tiles

108.

Creates new folder within current folder

109.

Displays the last previously viewed folder location in the Look In list box

110.

Displays the next folder location

Match each item with a statement below.

a.	Select a cell in a column, then press [Ctrl][Spacebar]	d.	Use the arrow keys
b.	Select a cell in a row, then press [Shift][Spacebar]	e.	Press [Ctrl][A]
c.	Press [Shift], then use arrow keys

111.

To select a cell

112.

To select the row

113.

To select the column

114.

To select a group of cells

115.

To select the worksheet