Computer Applications Study Guide
Which of the following signs is used when creating an absolute reference? #, @, $, or &
$
When you save a document as a template, it is saved with the extension ____. .txt, .dotx, .rft, or .docx
.dotx
E-mail attachments with the extension _____ are especially vulnerable to being blocked. .doc, .exe, .txt, or .jpg
.exe
PowerPoint presentations are saved with a _____ file extension. .pptx, .ppt, .ptpx, or .ppxt
.pptx
In a Word document, the default margins are _____. 1.5", 1", 0.75", or 0.75"
1"
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%
100%
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
13-28
Excel includes more than _____ functions from which you can choose. 1000, 500, 250, or 750
250
The Percent Style button displays cell contents as a percentage, which means .35 is displayed as _____. 0.35%, 3.5%, 350%, or 35%
35%
Which of the following buttons is a Slide Sorter button? 4 squares, open book, front of notebook, or one computer with one slide
4 squares
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 _____. =B6*C3, =B7*C4, =B8*C5, or =B5*C2
=B7*C4
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
=C3+C4
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
=D3+D4
Which of the following buttons should you click to add all fields to the query? >, <<, <, or >>
>>
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
A
Which of the following buttons is the Spelling button? magnifying glass, ABC with check-mark, open book, or finger
ABC with checkmark
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
AutoFit
The _____ key is used to delete text to the left of the insertion point. Delete, Shift + Delete, Backspace, or Shift + Backspace
Backspace
In the accompanying figure, which callout points to the button you should click to select header and footer options? F, C, D, or B
C
To access the Report Wizard, first click the ____ tab. HOME, CREATE, EXTERNAL DATA, or DATABASE TOOLS
CREATE
The ____ form layout displays fields across the screen in rows, with a label above each field. Justified, Tabular, or Datasheet, or Columnar
Datasheet
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
Enter
Press the _____ key to stop the slide show. Esc, Tab, Spacebar, or Backspace
Esc
You can output Excel worksheets as PDF files using the _____ option on the FILE tab. Export, Import, Send to PDF, or Transmit
Export
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
Filtering
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
From
The Font Dialog Box Launcher is accessible from the Font group on the _____ tab. HOME, INSERT, DESIGN, or REVIEW
HOME
You can use buttons in the Font group on the _____ tab to select different font attributes for any data in worksheet cells. HOME, VIEW, FORMAT, or INSERT
HOME
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
Which of the following fields is designed to be used as the primary key in an empty table? AutoNumber, Primary Key, ID, or Identifier
ID
Which of the following chart types is used to show data that changes over time? Pie chart, Line chart, Bar chart, or Column chart
Line chart
You should use the _____ data type for fields that contain variable length data, such as comments, notes, and reviews. Short Text, Long Text, Number, or AutoNumber
Long Text
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
By default, Word saves your file in the _____ folder. My Documents, Word Documents, Documents, or Word Files
My Documents
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
Nominations
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
Outbox
The Border button and the Shading button are located in the _____ group on the HOME tab. Editing, Illustrations, Paragraph, or Preview
Paragraph
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
Presets
To select a specific area of a worksheet to print, you should first use the _____ button. Select Area, Worksheet Area, Print Area, or Area
Print Area
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
To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab. Proofing, Thesaurus, Changes, or Research
Proofing
Which of the following functions calculates the total of a column or row of cells? TOTAL, SUM, SUMCOL, or SUMROW
SUM
You can print a text-only version of your presentation by selecting Outline in the _____ section. Text-only, Handouts, Options, or Settings
Settings
You can hold down the ____ key to select more than one field in a report. Home, +, Shift, or Alt
Shift
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
Slide Sorter
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
The New Style button is located in the _____. Styles group, Styles dialog box, Styles list, or New style dialog box
Styles dialog box
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
Tab
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
Thesaurus
Which of the following is a computer program that seems to perform one function while actually doing something else? spyware, virus, Trojan horse, or computer worm
Trojan horse
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
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
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
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
any
Functions can have _____ argument(s). only one, not more than two, . as many as needed, or three or less
as many as needed
A formula that references the cell in which the formula resides is called a _____. recursive reference, circular reference, self-reference, or relative reference
circular reference
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
click
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
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
complex queries
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
dashes
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
data field
Database software is sometimes referred to as DBMS, which stands for _____. data management software, database management system, database manipulation system, or data basic management software
database management system
A file that contains software to be downloaded is called a(n) _____ file. archive, download, distribution , or program
distribution
The _____ Accounting Number Format button displays cell contents in your local currency format. percentage, dollar sign, apostrophe, or decimal movement
dollar sign
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
Click inside a field to ____ data. enter, edit, either a. or b., or neither a. nor b.
either a.r b.
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
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
A comment that appears at the end of a section or chapter is called a(n) _____. comment, note, endnote, or footnote
endnote
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
envelope
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
Which of the following buttons is used to filter numbers? funnel, funnel with red x, funnel with marker, or finger
funnel
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
A personal computer is designed to meet the computing needs of an___________. department, government, individual, or company
individual
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
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
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
one-to-one
Which of the following buttons represents the Format Painter tool? Letter underlined, bucket pouring out paint, marker, or paintbrush
paintbrush
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
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
Which of the following is a New sheet button? plus button, x button, two pieces of paper, or boxes and arrows
plus button
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
When a database is open, it is displayed in the Access _____ window. record, program, table, or object
program
Which of the following buttons should be clicked to save the current file? finger, word pages, two files, purple save box
purple save box
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 delete an entire record, _____ the row header containing the record, click Delete Record, then click the Yes button. right-click, click, left-click, or double-click
right-click
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
right-clicking
To move a section of text from one part of your document to another, first select the text, then click the _____ button. scissors, clipboard, two pages, or reload
scissors
Paragraph formatting options - such as line spacing, font, size, and bullets - are typically applied to _____. selected text, sections, blocks, or pages
selected text
Each presentation _____ contains objects such as titles, items in a bulleted list, graphics, and charts. slide, chart, worksheet, or video clip
slide
A ____ contains information about the current condition of the application. scroll bar, title bar, status bar, or menu bar
status bar
Excel worksheets are saved in a(n) _____-dimensional workbook three, two, one, or multi
three
The default workbook contains _____ worksheets. one, two, three, or four
three
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
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
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
You can use _____ type(s) of graphics to enhance documents created with Microsoft Word. one, three, two, or many
two
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
A programming language is a(n)______. operating system, application software, computer program, or utility
utility
All of the following are arithmetic operators used in Excel, except _____. x (multiplication), ^ (exponent), % (percent), or + (addition)
x (multiplication)
