Name: 
 

Computer Applications Final Study Guide



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

 1. 

Outlook is a spreadsheet application.  (BASIC APPLICATIONS)
 

 2. 

Applications are designed to perform specific tasks. (BASIC APPLICATIONS)
 

 3. 

Buttons on the toolbar are clicked to perform an action. (BASIC APPLICATIONS)
 

 4. 

The insertion point can be positioned by clicking in a specific location in a document. (BASIC APPLICATIONS)
 

 5. 

A file with a .doc extension was created in Word. (WORD)
 

 6. 

A word processor application and a spreadsheet application can be running at the same time. (WORD AND EXCEL)
 

 7. 

The Undo command can be used to reverse an edit. (BASIC APPLICATIONS)
 

 8. 

If a sentence is selected and the Delete key is pressed, the selected sentence will be deleted. (BASIC APPLICATIONS)
 

 9. 

A Word document can be e-mailed as an attachment from Word. (WORD and GROUPWISE)
 

 10. 

Pagination is how a document is divided into pages. (WORD)
 

 11. 

As a document is edited, Word automatically updates the pagination. (WORD)
 

 12. 

Tab stops are displayed on the status bar at the bottom of a document. (WORD)
 

 13. 

Footnotes appear at the top of the page by default. (WORD)
 

 14. 

In a table, clicking the Insert Rows button on the toolbar adds a row below the selected row. (WORD)
 

 15. 

Roman numerals appear as 1, 2, 3, and so on. (WORD)
 

 16. 

Cycle diagrams show steps in an ongoing process. (EXCEL)
 

 17. 

Individual rows on a worksheet are identified by a letter. (EXCEL)
 

 18. 

The selected cell is called the active cell. (EXCEL)
 

 19. 

Values can be used in calculations. (EXCEL)
 

 20. 

To decrease the width of a column, drag the column boundary to the right. (EXCEL)
 

 21. 

Long column headings can be wrapped to the next line of the same cell. (EXCEL)
 

 22. 

If the value 6.2 is rounded to 0 decimals, the rounded result is 7. (EXCEL)
 

 23. 

A method for computing equal period payments for an installment loan is called amortization. (EXCEL)
 

 24. 

A header and footer can be added to a chart sheet. (EXCEL)
 

 25. 

A linked chart in a Word document is automatically updated if the source chart is updated in Excel. (EXCEL and WORD)
 

 26. 

Pie charts have axes. (EXCEL)
 

 27. 

A primary key can be defined as a combination of data in two fields if that is what is required to make every record in a table unique. (ACCESS)
 

 28. 

A form displays all the fields for one record. (ACCESS)
 

 29. 

A form is automatically updated when a table is modified. (ACCESS)
 

 30. 

Related fields must have the same field name. (ACCESS)
 

 31. 

A select query limits the data displayed to that which meets certain criteria. (ACCESS)
 

 32. 

The criteria >C in the FirstName field queries names that come before the letter C. (ACCESS)
 

 33. 

The AND logical operator requires a record to match both criteria in order to be displayed. (ACCESS)
 

 34. 

Addresses for mailing labels must be individually typed, even when a database of the names and addresses exists. (ACCESS)
 

 35. 

The content on a slide should include everything a speaker is going to say while that slide is displayed. (POWERPOINT)
 

 36. 

Headers and footers can be added to the printout of a presentation. (POWERPOINT)
 

 37. 

Animation is a visual effect that refers to the way items move onto a slide. (POWERPOINT)
 

 38. 

An entire slide can be copied to another open presentation. (POWERPOINT)
 

 39. 

A chart from an Excel workbook can only be added to a slide that has no placeholders. (POWERPOINT)
 

 40. 

If the e-mail address, christina@lpdatafiles.com, is typed on a slide, no automatic formatting is applied. (POWERPOINT)
 

 41. 

Mrs. Deiss is a fan of right clicking.
 

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

 42. 

Which button is clicked to expand the window to fill the screen?
a.
Close button
c.
Minimize button
b.
Maximize button
d.
Restore button
 

 43. 

Which button in a dialog box displays information about dialog box elements?
a.
Close button
c.
Desktop shortcut
b.
Help button
d.
Information button
 

 44. 

An invalid file name contains
a.
numbers.
c.
colons (:).
b.
letters.
d.
spaces.
 

 45. 

Which file name is valid?
a.
Cover Letter 1?
b.
Research Notes *2006*02*08
c.
Chapter 7 Assignment:1
d.
resume_CISposition
 

 46. 

Which action removes the application window from the Desktop?
a.
opening a file
c.
quitting an application
b.
closing a document
d.
saving a file
 

 47. 

In Word, the thesaurus can be used to
a.
create a new document with alternate words.
b.
check the grammar of a selected phrase.
c.
display a list of synonyms for a selected word.
d.
check the spelling of a selected word.
 

 48. 

A synonym for sleep is
a.
alert.
c.
nap.
b.
aware.
d.
slope.
 

 49. 

Which task pane displays thesaurus results?
a.
New Document task pane
c.
Reveal Formatting task pane
b.
Clip Art task pane
d.
Research task pane
 

 50. 

To select text
a.
single-click anywhere in the text.
b.
drag the I-beam pointer over the text.
c.
place the insertion point in the text and press the F9 key twice.
d.
select the Select Text command.
 

 51. 

Selecting text and then selecting Copy
a.
places a copy of the selected text on the Clipboard.
b.
places a copy of the selected text at the insertion point.
c.
deletes the selected text.
d.
displays a dialog box asking how many copies to place at the insertion point.
 

 52. 

The way in which a character is emphasized is called its
a.
font.
c.
shape.
b.
size.
d.
style.
 

 53. 

A paragraph that is center aligned
a.
is positioned equally distant from the left and right sides of the page.
b.
has a jagged left edge and a straight right edge.
c.
has straight edges at both sides of the paragraph.
d.
has a straight left edge and a jagged right edge.
 

 54. 

In a four page document, a header appears on
a.
page 1.
c.
page 2 and 4.
b.
all four pages.
d.
page 1 and 3.
 

 55. 

Which type and size of indent is illustrated in the following picture?

mc055-1.jpg
a.
first line indent of 0.25"
c.
first line indent of 0.5"
b.
hanging indent of 0.25"
d.
hanging indent of 0.5"
 

 56. 

Which file name extension is added when a Word document is saved as a Web page?
a.
.web
c.
.htm
b.
.doc
d.
.mht
 

 57. 

An intersection of a row and a column in a table is called
a.
a meeting point.
c.
an insertion point.
b.
a cell.
d.
a row intersection.
 

 58. 

Double-clicking the boundary between two columns in a table
a.
selects the two columns.
b.
deletes the two columns.
c.
changes the column to the right so that it is just wide enough to display the data entirely.
d.
changes the column to the left so that it is just wide enough to display the data entirely.
 

 59. 

What is added to a document so that parts of it can have different page formats applied?
a.
a page break
c.
a section break
b.
an indent
d.
a style
 
 
Assume cell C8 stores a value of 3 and cell D9 stores a value of 2.
 

 60. 

What will be displayed when the formula =C8+D9/0 is entered?
a.
3+2
c.
#DIV/O!
b.
5
d.
0
 

 61. 

The Fill handle is
a.
used to change the color of a cell.
b.
used to copy the contents of the selected cell to adjacent cells.
c.
an icon used to scroll a worksheet.
d.
a cell representing a column of labels.
 

 62. 

Cell references that reflect the row or column they have been copied to are called
a.
absolute cell references.
b.
reflective cell references.
c.
copied cell references.
d.
relative cell references.
 

 63. 

Which error values indicates the formula contains a reference that is not valid?
a.
#DIV/0
c.
#NUM
b.
#REF
d.
####
 

 64. 

To remove a column and all of its data from a worksheet,
a.
double-click the column letter.
b.
select the column and then press the Delete key.
c.
right-click the column letter and select Delete.
d.
rename the column letter.
 

 65. 

Changing the data on one sheet automatically updates the data on the other sheet when the cells are
a.
upgraded.
c.
linked.
b.
pasted.
d.
copied.
 

 66. 

A selected chart is deleted by
a.
selecting the Delete button on the Chart toolbar.
b.
double-clicking a handle.
c.
pressing the Delete key.
d.
pressing the Backspace key.
 
 
nar002-1.jpg
 

 67. 

In the chart above, which is the first y-axis label?
a.
0
c.
2005
b.
Architecture
d.
Program
 

 68. 

A relational database management system
a.
is any data that is stored on a computer.
b.
stores related data in tables.
c.
groups unrelated data in forms.
d.
uses only currency fields.
 

 69. 

Which is not a date/time field format?
a.
short
c.
long
b.
medium
d.
extra
 

 70. 

Which date is formatted as short?
a.
6/24/03
c.
Saturday, June 24, 2003
b.
24-June-03
d.
June 24, 2003, Saturday
 

 71. 

Which key is pressed to move from column to column when defining fields?
a.
spacebar
c.
Tab
b.
Esc
d.
Backspace
 

 72. 

Which is a database object that displays a window with a single record?
a.
table
c.
form
b.
field
d.
record