Get ahead with a $300 test prep scholarship
| Enter to win by Tuesday 9/24
Computer Applications Study Guide
Terms in this set (100)
A personal computer is designed to meet the computing needs of an___________.
department, government, individual, or company
A programming language is a(n)______.
operating system, application software, computer program, or utility
Which of the following is a type of productivity software? a database application, an antivirus program, a device driver, or a player
a database application
Spreadsheet software includes all of the following data-handling features, except _____.
report printing, data sorting, search of data that meets specific criteria, or complex queries
Database software is sometimes referred to as DBMS, which stands for _____.
data management software, database management system, database manipulation system, or data basic
database management system
A file that contains software to be downloaded is called a(n) _____ file.
archive, download, distribution , or program
A ____ contains information about the current condition of the application.
scroll bar, title bar, status bar, or menu bar
Which of the following buttons should be clicked to save the current file?
finger, word pages, two files, purple save box
purple save box
When you save a document as a template, it is saved with the extension ____.
.txt, .dotx, .rft, or .docx
To select the entire document you should follow the sequence _____.
HOME, Editing, Select, Select All,
VIEW, Editing, Select, Select All,
HOME, Editing, Select Text, or
HOME, Select All
HOME, Editing, Select, Select All
To move a section of text from one part of your document to another, first select the text, then click the _____
scissors, clipboard, two pages, or reload
To find a synonym for a phrase, select the phrase, then right-click it to display the shortcut menu. Point to
Synonyms, then click Thesaurus to open the _____ pane.
Research, Synonyms, Review, or Thesaurus
By default, Word saves your file in the _____ folder.
My Documents, Word Documents, Documents, or Word Files
If you would like to print pages 13 through 28, you would enter _____ into the Pages text field.
13:28 , 13 to 28, 13-28, or 13, 28
The Font Dialog Box Launcher is accessible from the Font group on the _____ tab.
HOME, INSERT, DESIGN, or REVIEW
The New Style button is located in the _____.
Styles group, Styles dialog box, Styles list, or New style dialog box
Styles dialog box
The Paragraph Dialog Box can be opened from _____ tab.
only the HOME, either the HOME or PAGE LAYOUT, only the PAGE LAYOUT, or only the VIEW
either the HOME or PAGE LAYOUT
The position of the tab stop is measured _____.
from the right margin, from the previous stop, from the left margin, or from the center of the page
from the left margin
A comment that appears at the end of a section or chapter is called a(n) _____.
comment, note, endnote, or footnote
Paragraph formatting options - such as line spacing, font, size, and bullets - are typically applied to _____.
selected text, sections, blocks, or pages
You can use _____ type(s) of graphics to enhance documents created with Microsoft Word.
one, three, two, or many
In a Word document, the default margins are _____.
1.5", 1", 0.75", or 0.75"
E-mail attachments with the extension _____ are especially vulnerable to being blocked.
.doc, .exe, .txt, or .jpg
The Border button and the Shading button are located in the _____ group on the HOME tab.
Editing, Illustrations, Paragraph, or Preview
Excel worksheets are saved in a(n) _____-dimensional workbook
three, two, one, or multi
All of the following are arithmetic operators used in Excel, except _____.
x (multiplication), ^ (exponent), % (percent), or + (addition)
After you click a cell for a formula, a rectangle of _____ called a marquee appears around that cell.
dots, dots and dashes, blue lines, or dashes
A formula that references the cell in which the formula resides is called a _____.
recursive reference, circular reference, self-reference, or relative reference
Excel includes more than _____ functions from which you can choose.
1000, 500, 250, or 750
Which of the following functions calculates the total of a column or row of cells?
TOTAL, SUM, SUMCOL, or SUMROW
Functions can have _____ argument(s).
only one, not more than two, . as many as needed, or three or less
as many as needed
Which of the following signs is used when creating an absolute reference?
#, @, $, or &
In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When that formula is copied
to cell C7, the relative references in the formula change to _____.
C5, or =B5
The default workbook contains _____ worksheets.
one, two, three, or four
Which of the following is a New sheet button?
plus button, x button, two pieces of paper, or boxes and arrows
To add borders around the outside and inside edges of selected cells, click both Outline and Inside buttons in the
_____ section in the Format Cells dialog box.
Border, Presets, Style, or Line
You can use buttons in the Font group on the _____ tab to select different font attributes for any data in worksheet
HOME, VIEW, FORMAT, or INSERT
The _____ Accounting Number Format button displays cell contents in your local currency format.
percentage, dollar sign, apostrophe, or decimal movement
The Percent Style button displays cell contents as a percentage, which means .35 is displayed as _____.
0.35%, 3.5%, 350%, or 35%
To manually adjust the width of a column, position the pointer over the vertical line between two column headings
so that the pointer changes to a _____ shape.
box, line and arrow, finger, or line
line and arrow
Excel automatically adjusts the height and width of selected cells when you use the _____ command located in the
HOME tab's Format button.
AutoFormat, AutoAdjust, AutoFit, or Auto
To quickly select all cells in a column, _____.
click the column header at the top of the column, click any cell in the column, click on the first cell in
the column and then drag mouse down, or individually click all cells in the column
click the column header at the top of the column
The formula =D3+D4 changes to _____ if the original column C is deleted.
=E3+E4, =C3+C4, =F3+F4, or The formula does not change
The formula =D5+D6 changes to _____ if rows 1 and 2 are deleted.
=D4+D5, =D2+D3, =D3+D4, or The formula does not change
Which of the following buttons represents the Format Painter tool?
Letter underlined, bucket pouring out paint, marker, or paintbrush
Which of the following chart types is used to show data that changes over time?
Pie chart, Line chart, Bar chart, or Column chart
In general, you begin most modifications on the chart by _____ the chart element you want to change.
left-clicking, right-clicking, double-clicking, or pointing to
Which of the following buttons is used to sort the data in one column in descending order?
box with Z-A & A-Z, Z-A with arrow down, A-Z with arrow down and green +, or A-Z with arrow down
Z-A with arrow down
A data management feature that allows you to focus on a subset of the data in a worksheet is called _____.
Selecting, Filtering, Extracting, or Formatting
Which of the following buttons is used to filter numbers?
funnel, funnel with red x, funnel with marker, or finger
To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab.
Proofing, Thesaurus, Changes, or Research
To select a specific area of a worksheet to print, you should first use the _____ button.
Select Area, Worksheet Area, Print Area, or Area
To get a good view of an entire worksheet before you change margins, you might want to reduce the zoom level to
less than _____.
80%, 100%, 75%, or 50%
Which of the following is the Margins button?
paper with lines on two sides, paper with four lines on the inside, two papers with an arrow in between, or paper and printer
paper with four lines on the inside
In the accompanying figure, which callout points to the button you should click to select header and footer
F, C, D, or B
In the accompanying figure, which callout points to the area you should click first when adding a header or footer?
D, G, C, or A
Which of the following buttons should you click to specify label titles that should be repeated on every page?
paper with mountains, grid paper with printer, two pieces of paper with an arrow in between, or paper with printer
grid paper with printer
You can output Excel worksheets as PDF files using the _____ option on the FILE tab.
Export, Import, Send to PDF, or Transmit
Each presentation _____ contains objects such as titles, items in a bulleted list, graphics, and charts.
slide, chart, worksheet, or video clip
When a presentation is open in Normal view, the Slides list is shown _____ of the PowerPoint window.
in the center, near the bottoms, to the left, or to the right
to the left
To select a slide from the Slides list you should _____ the slide that you want to view.
double-click, Shift-click, right-click, or click
PowerPoint presentations are saved with a _____ file extension.
.pptx, .ppt, .ptpx, or .ppxt
Which of the following icons should you click to insert a piece of clip art?
picture with globe, arrow and box, picture with computer, or bars
picture with globe
To adjust the height of cells, position the pointer over one of the dividing lines between cells. When the pointer
changes to the _____ shape, drag the dividing line to the correct position.
left and right arrow going threw vertical line, up and down arrow going threw horizontal line, paper with little up and down arrows at the top and bottom of page, or little up and down arrows to the left of lines
up and down arrow going threw horizontal line
To access Video Tools, click the movie window, then select _____ tab.
either the FORMAT or PLAYBACK, only the FORMAT, only the PLAYBACK, or the VIEW
either the FORMAT or PLAYBACK
You can use the Hyperlink button to create links to _____.
other slides in your presentation, e-mail addresses, slides in different presentations, or all of the above
all of the above
Press the _____ key to stop the slide show.
Esc, Tab, Spacebar, or Backspace
Which of the following buttons should you click to start the presentation with the current slide?
computer with play button, red computer with one slide, two pages, or red notebook
red computer with one slide
To move to the next slide in Slide Show view, _____.
click the left mouse button, press the right-arrow key, either a or b, or neither nor b
either a or b
To move to the previous slide in Slide Show view, _____.
click the right mouse button, press the left-arrow key, either a or b, or neither a nor b
press the left-arrow key
Which of the following keys is useful for taking you to the next slide, bullet, or placeholder, when entering text
into the Outline panel?
Tab, Shift Tab, Enter, or Ctrl Tab
The easiest way to rearrange slides, delete slides, hide slides, and duplicate slides is to use _____.
Normal View, Slide Sorter view, Outline View,, or Special View
Slide Sorter view
Which of the following buttons is a Slide Sorter button?
4 squares, open book, front of notebook, or one computer with one slide
In Slide Show view, a presentation advances from one slide to the next when you press _____ key.
the Enter, the Tab, the Shift, or any
After applying a slide master use _____ view to verify that the new font attributes are applied to the text on all of
the slides in your presentation.
Normal, Slide Sorter, Slide Preview, or Slide Show
Which of the following buttons is the Spelling button?
magnifying glass, ABC with check-mark, open book, or finger
ABC with checkmark
Which of the following buttons is the Slide Show button used to start the presentation?
4 squares, front of notebook, open book, or one computer with one slide
one computer with one slide
You can print a text-only version of your presentation by selecting Outline in the _____ section.
Text-only, Handouts, Options, or Settings
Some presentation software converts slides to HTML pages that you can post online, but these pages typically do
not incorporate _____.
transitions, transitions and animations, animations, or bitmap graphics
transitions and animations
When a database is open, it is displayed in the Access _____ window.
record, program, table, or object
You should use the _____ data type for fields that contain variable length data, such as comments, notes, and
Short Text, Long Text, Number, or AutoNumber
Which of the following fields is designed to be used as the primary key in an empty table?
AutoNumber, Primary Key, ID, or Identifier
When entering data, you can use the _____ key(s) to move from one field to the next without having to move your
hand to the mouse.
Ctrl+Tab, Ctrl+Alt, Esc, or Tab
To delete an entire record, _____ the row header containing the record, click Delete Record, then click the Yes
right-click, click, left-click, or double-click
The _____ key is used to delete text to the left of the insertion point.
Delete, Shift + Delete, Backspace, or Shift + Backspace
All of the following are controls for operations that can be performed on a table, except _____.
Delete a record, Sort records, or Move a record, or Search
Move a record
Which of the following buttons should you click to add all fields to the query?
>, <<, <, or >>
Referring to the accompanying figure, Leon asks which of the following fields uses a Number data type. What
field does Maxwell point to?
Film Title, or Director, MPAA , or Nominations
To move a label and the associated ____, click to select the object, move the pointer over the edge of the object
until the pointer changes to a 4-headed arrow shape, then drag the label and data field to a new location.
record field, data field, query field, or tab field
Click the FILE tab, click Print, then click Print again to display the ____.
Table dialog box, Report dialog box, Print dialog box, or Save As dialog box
Print dialog box
A ____ relationship means that a record in one table is related to only one record in another table. This type of
relationship is rare in the world of databases.
many-to-many, one-to-one, many-to-one, or one-to-many
The ____ form layout displays fields across the screen in rows, with a label above each field.
Justified, Tabular, or Datasheet, or Columnar
Click inside a field to ____ data.
enter, edit, either a. or b., or neither a. nor b.
either a.r b.
You can hold down the ____ key to select more than one field in a report.
Home, +, Shift, or Alt
To access the Report Wizard, first click the ____ tab.
HOME, CREATE, EXTERNAL DATA, or DATABASE TOOLS
As you compose e-mail messages, they can be stored in a(n) _____ until you are ready to send them.
Outbox, Inbox, Draft folder, or Sent folder
Which of the following fields in an e-mail header can be used to sort messages according to the sender?
Date, Subject, From. or To
Which of the following is the New Email button?
envelope with person and calendar, envelope, mail with left purple arrow, or mail with right blue arrow
Which of the following is a computer program that seems to perform one function while actually doing something
spyware, virus, Trojan horse, or computer worm
A key characteristic of viruses is their ability _____.
to see the contents of your screen, to perform one function while actually doing something else, to
spread themselves from one computer to another, or to replicate themselves on the host computer
to replicate themselves on the host computer