True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
In an Access
database, you must determine how you want to sort data before you enter it.
|
|
|
2.
|
More than
one person can be entering, updating, and using an Access database at the same time.
|
|
|
3.
|
Excel lacks
many of the database advantages provided by Access.
|
|
|
4.
|
Tables
contain all of the raw data in the database.
|
|
|
5.
|
Data is
physically stored in the form object.
|
|
|
6.
|
You can
print a form.
|
|
|
7.
|
An Access
module stores C++ programming code.
|
|
|
8.
|
Access
reports are used to provide Web page connectivity features to an Access database.
|
|
|
9.
|
In Access,
data entry screens are called forms.
|
|
|
10.
|
Access
information can be printed from forms, queries, and tables.
|
|
|
11.
|
Access data
can be entered through reports.
|
|
|
12.
|
The toolbars
and menus within Access modify themselves to reflect those features that you most commonly
use.
|
|
|
13.
|
There is
more than one way to start Access.
|
|
|
14.
|
The Database
title bar contains the filename of the active database.
|
|
|
15.
|
Field names
appear in the top row of a datasheet.
|
|
|
16.
|
A new record
may be added on any row of a datasheet.
|
|
|
17.
|
You can move
datasheet columns by dragging the field name left or right.
|
|
|
18.
|
You cannot
undo a record deletion operation.
|
|
|
19.
|
You can
resize the width of the field in a datasheet.
|
|
|
20.
|
You can
temporarily hide a field in a datasheet.
|
|
|
21.
|
You can
print a datasheet.
|
|
|
22.
|
A primary
key field contains unique information for each record.
|
|
|
23.
|
It is
possible to import data from other sources such as a spreadsheet to create an Access
table.
|
|
|
24.
|
As you add
more field property entries, you are generally expanding the amount or type of data that can be
entered into a field.
|
|
|
25.
|
You can
change the font and color of a datasheet.
|
|
|
26.
|
You can
print a datasheet.
|
|
|
27.
|
The Find and
Replace dialog box allows you to specify whether Access looks for search criteria in the current
field or in all fields.
|
|
|
28.
|
The question
mark (?) is the wildcard character which stands for any single character in find
criteria.
|
|
|
29.
|
The asterisk
(*) is the wildcard used to represent one and only one character in find criteria.
|
|
|
30.
|
You can sort
by more than one field in a datasheet.
|
|
|
31.
|
Filtering
displays all of the records at all times.
|
|
|
32.
|
Primary key
fields can have a null entry.
|
|
|
33.
|
A query is
commonly used as the source of data for a form or report.
|
|
|
34.
|
A query can
be used to create calculated fields.
|
|
|
35.
|
A form is
the primary object used to enter, edit, and find data.
|
|
|
36.
|
In a
datasheet, sometimes all of the fields are not visible.
|
|
|
37.
|
A text box
control is a bound control.
|
|
|
38.
|
Whether you
create the form from scratch in Design View or by using the Form Wizard, you can modify it later if
needed.
|
|
|
39.
|
Forms can be
used to enter and edit data.
|
|
|
40.
|
By designing
a form to match a source document, you facilitate fast and accurate data entry.
|
|
|
|
|
|
41.
|
In the
figure above, item 1 points to text box controls.
|
|
|
42.
|
In the
figure above, item 2 points to text box controls.
|
|
|
43.
|
In the
figure above, item 4 points to option button controls.
|
|
|
44.
|
You can
modify a form that you have created using Form Design View, but those created by the Form Wizard
cannot be modified later.
|
|
|
45.
|
You can
resize a form to be wider or narrower.
|
|
|
46.
|
When you
create a form with the Form Wizard, it places a list box to the left of each text box with the
field's name.
|
|
|
47.
|
On a form,
text box controls display data from an underlying record source.
|
|
|
48.
|
Data from a
report cannot be displayed on the screen.
|
|
|
49.
|
Reports can
include clip art.
|
|
|
50.
|
You cannot
enter or edit data through a report.
|
|
|
51.
|
Grouping
means to sort records plus provide extra report sections.
|
|
|
52.
|
Calculated
expressions within text boxes start with an equal sign.
|
|
|
53.
|
When
entering an expression, the field name must be referenced exactly and surrounded by square
brackets.
|
|
|
|
|
|
54.
|
In the
figure above, item 8 points to a Group Footer section.
|
|
|
55.
|
You can sort
records within groups.
|
|
|
56.
|
If you try
to print colors on a black and white printer, the printer will display an error message indicating
that it cannot print color.
|
|
|
57.
|
The Report
Wizard applies many formatting choices to a report.
|
|
|
58.
|
In the
figure above, item 1 refers to the Bold button.
|
|
|
59.
|
In the
figure above, to change the color of the text of selected label, click the button labeled item
6.
|
|
|
60.
|
Portrait
orientation is 8.5" wide by 11" tall.
|
|
|
61.
|
Landscape
orientation is 11" wide by 8.5" tall.
|
|
|
62.
|
With what-if
analysis, the user inputs new data into the spreadsheet and then uses a calculator or manually
recalculates the new results.
|
|
|
63.
|
Excel
creates and updates charts based on changes made to the worksheet.
|
|
|
64.
|
A chart can
be created based on information in a worksheet.
|
|
|
65.
|
Once a
spreadsheet is created, it cannot be changed.
|
|
|
66.
|
An
electronic spreadsheet uses a computer to perform numeric calculations.
|
|
|
67.
|
Excel does
NOT automatically update a chart when worksheet data changes.
|
|
|
68.
|
In the
worksheet window, columns are identified by numbers.
|
|
|
69.
|
A cell can
contain any combination of text, numbers, or formulas.
|
|
|
70.
|
Each toolbar
button has a picture of its function on its face.
|
|
|
71.
|
In a
worksheet window, columns are labeled alphabetically.
|
|
|
72.
|
The cell
address is identified by the coordinates of the intersecting column and row.
|
|
|
73.
|
The
intersection of a row and a column is called a sheet tab.
|
|
|
74.
|
The status
bar tells you the active command or task in progress.
|
|
|
75.
|
It is a good
idea to save your work every 10-15 minutes.
|
|
|
76.
|
The only way
to move around the worksheet is to use the vertical and horizontal scroll bars.
|
|
|
77.
|
To return to
cell A1 at the top of a worksheet, press [Ctrl][Home].
|
|
|
78.
|
You can use
[Page Down] and [Page Up] to navigate a worksheet.
|
|
|
79.
|
You can use
the arrow keys (on the keyboard) to move one cell at a time in a worksheet.
|
|
|
80.
|
Use the Help
feature to get assistance using Excel.
|
|
|
81.
|
You must
exit Excel before you can use the Office Assistant.
|
|
|
82.
|
You can
press the F1 key at any time to get immediate help.
|
|
|
83.
|
There is no
difference between closing a workbook and exiting Excel.
|
|
|
84.
|
In the
figure above, item 3 points to the cell pointer.
|
|
|
85.
|
The figure
above illustrates the Print Preview screen.
|
|
|
86.
|
In the
figure above, item 1 points to buttons for moving between pages.
|
|
|
87.
|
In the
figure above, item 2 points to the Zoom button, which reduces the screen image.
|
|
|
88.
|
In the
figure above, item 3 points to the Setup button, which is used to create a worksheet.
|
|
|
89.
|
In the
figure above, item 4 points to the Close button, which is used to exit Excel.
|
|
|
90.
|
The
information you collect for a worksheet is called output.
|
|
|
91.
|
Numbers used
in calculations are called results.
|
|
|
92.
|
The desired
results for a worksheet are called the output.
|
|
|
93.
|
Labels are
used in calculations.
|
|
|
94.
|
When entered
in a cell, text, such as "Summer 2003", is a label.
|
|
|
95.
|
When entered
in a cell, text, such as "Summer 2003", is a value.
|
|
|
96.
|
To change
the contents of a cell, put Excel into Edit mode.
|
|
|
97.
|
The Undo
button allows you to reverse up to 16 previous actions at the same time.
|
|
|
98.
|
In the
figure above, item 3 is the Redo button.
|
|
|
99.
|
The mode
indicator is located on the far-left side of the status bar.
|
|
|
100.
|
In the Open
dialog box, you can double-click the filename to open a workbook.
|
|
|
101.
|
A group of
two or more cells is called a range.
|
|
|
102.
|
To select a
range of cells, click the first cell and drag to the last cell.
|
|
|
103.
|
Excel is not
case-sensitive which means that B3 and b3 both refer to the same cell.
|
|
|
104.
|
All Excel
formulas begin with an asterisk (*).
|
|
|
105.
|
Formulas are
used to perform calculations, such as addition, multiplication, and averaging.
|
|
|
106.
|
There is NO
order of precedence in Excel formulas.
|
|
|
107.
|
Addition and
subtraction are first in the order of precedence in Excel formulas.
|
|
|
108.
|
An Excel
formula can include several operations; for example, multiplication and addition.
|
|
|
109.
|
All Excel
functions begin with a question mark (?).
|
|
|
110.
|
Like
formulas, functions always begin with the formula prefix =.
|
|
|
111.
|
Functions
are predefined worksheet formulas that can be used in calculations.
|
|
|
112.
|
You can
enter functions in a worksheet manually, or you can use the Insert Function button.
|
|
|
113.
|
A value can
serve as a function argument.
|
|
|
114.
|
A range of
cells can serve as a function argument.
|
|
|
115.
|
In the
formula, =SUM(B3:D3), the (B3:D3) is the argument.
|
|
|
116.
|
SUM and
AVERAGE are examples of arguments.
|
|
|
117.
|
You can use
the Cut, Copy, and Paste buttons or Excel's drag-and-drop feature to copy or move information from
one cell or range in a worksheet to another.
|
|
|
118.
|
Formatting
affects how information appears in cells and does not alter the data in any way.
|
|
|
119.
|
Formatting
alters the data in cells.
|
|
|
120.
|
The Increase
Decimal button automatically adds dollar signs and two decimal places to your data.
|
|
|
121.
|
Bold,
italics, and underlining are examples of Format Painter.
|
|
|
122.
|
Format
Painter allows you to copy only the format of a cell.
|
|
|
123.
|
If you
change the font size of a single cell, Excel will automatically adjust the font size of all the cells
in the worksheet.
|
|
|
124.
|
The physical
size of text is measured in inches.
|
|
|
125.
|
The default
font in Excel is 10 point Arial.
|
|
|
126.
|
Excel
provides 16 preset formats, called AutoFormats, which allow instant formatting of large amounts of
data.
|
|
|
127.
|
The AutoFit
Selection command automatically resizes a worksheet column to fit the widest entry in that
column.
|
|
|
128.
|
Row height
is calculated in units of measure called points.
|
|
|
129.
|
You might
need to adjust column widths to make a worksheet more useable.
|
|
|
130.
|
You can
adjust both the width of columns and height of rows in an Excel worksheet.
|
|
|
131.
|
When you
delete a row or column within a range used in a formula you must change the formula.
|
|
|
132.
|
Excel does
NOT automatically adjust formulas when a column or a row is inserted within a range used in a
formula.
|
|
|
133.
|
Borders can
be applied to selected cells in a worksheet.
|
|
|
134.
|
In the
Format Cells dialog box, you can see what your text will look like in the Sample box.
|
|
|
135.
|
Automatically applying formatting attributes based on cell values is called
conditional formatting.
|
|
|
136.
|
Any words
you've added to the dictionary using Word, PowerPoint, and Access are also available in Excel's spell
checker.
|
|
|
|
|
|
137.
|
In the
figure above, item 2 displays the currently selected font.
|
|
|
138.
|
In the
figure above, item 3 shows a sample of the selected font which is 10 point Arial, Excel's default
font.
|
|
|
139.
|
In the
figure above, item 1 points to the available fonts.
|
|
|
140.
|
In the
figure above, item 2 indicates line length in picas.
|
|
|
141.
|
Data points
exist only on the y-axis.
|
|
|
142.
|
A collection
of related data points in a chart is called a data series.
|
|
|
143.
|
Each value
in a chart is called a data series.
|
|
|
144.
|
Charts are
derived from worksheet data.
|
|
|
145.
|
Tick marks
create a scale of measure for each value on the y-axis.
|
|
|
146.
|
A chart's
vertical axis is called the y-axis.
|
|
|
147.
|
A line chart
compares trends over even time intervals.
|
|
|
148.
|
The Excel
program defaults to a column chart.
|
|
|
149.
|
The Chart
Wizard uses a series of dialog boxes.
|
|
|
150.
|
The Chart
Wizard button is located on the Edit menu.
|
|
|
151.
|
You can move
charts anywhere on a worksheet without affecting formulas or data in the worksheet.
|
|
|
152.
|
You cannot
change the position of a legend.
|
|
|
153.
|
To
manipulate data in a chart, you must first change the data in the worksheet.
|
|
|
154.
|
If you
change data values in a worksheet, the chart will be updated automatically to reflect the new
data.
|
|
|
155.
|
If columns
are obscured in a 3-dimensional chart, you can rotate the chart for a better view.
|
|
|
156.
|
Gridlines
are the horizontal lines in the chart that enable the eye to follow the value on an
axis.
|
|
|
157.
|
In a pie
chart, slices that are pulled away are referred to as "exploded."
|
|
|
158.
|
The
Chart menu only appears on the menu bar when a chart or one of its objects is selected.
|
|
|
159.
|
In the
figure above, item 2 points to a sample chart with gridlines.
|
|
|
160.
|
In the
figure above, item 3 indicates the x-axis gridlines have NOT been selected.
|
|
|
161.
|
PowerPoint
is a word-processing program.
|
|
|
162.
|
You cannot
create audience handouts using PowerPoint.
|
|
|
163.
|
You can
print an outline copy of your presentation.
|
|
|
164.
|
In
the figure above, number 1 is pointing to Microsoft PowerPoint program icon.
|
|
|
165.
|
The
figure above is a picture of the PowerPoint window.
|
|
|
166.
|
The title
bar lists the names of menus from which you choose PowerPoint commands.
|
|
|
167.
|
The task
pane contains sets of hyperlinks for commonly used commands.
|
|
|
168.
|
The Standard
toolbar contains buttons for copying and pasting.
|
|
|
169.
|
The Outline
tab displays the slides of your presentation as small images, called thumbnails.
|
|
|
170.
|
In
the figure above, number 3 is pointing to the Outline tab.
|
|
|
171.
|
In
the figure above, number 4 is pointing to one of PowerPoint's view buttons.
|
|
|
172.
|
In
the figure above, number 2 is pointing to the Standard toolbar.
|
|
|
173.
|
The
figure above is a picture of a presentation in Slide Show view.
|
|
|
174.
|
In
the figure above, number 3 is pointing to the Slide Sorter view button.
|
|
|
175.
|
A wizard is
a series of steps that guides you through a task.
|
|
|
176.
|
In Slide
Show view, you can advance to the next slide by clicking the left mouse button or pressing
[Enter].
|
|
|
177.
|
At the end
of a Slide Show a black slide appears.
|
|
|
178.
|
Each
PowerPoint view displays your presentation in a different way and allows you to manipulate your
presentation differently.
|
|
|
179.
|
Slide Sorter
view displays the title and main topics in the form of an outline.
|
|
|
180.
|
The Slide
Show View displays your presentation as an electronic slide show.
|
|
|
181.
|
It’s wise to save your work about every 5 to 10 minutes and before
printing.
|
|
|
182.
|
You can use
the Save command to save a presentation with a different name.
|
|
|
183.
|
You can type
a word, a phrase, or a question in the Type a question for help box to get help on a
topic.
|
|
|
184.
|
After
a power interruption or computer failure, the Document Recovery task pane displays original and
recovered versions of PowerPoint files.
|
|
|
185.
|
When you
close a file, you also automatically exit PowerPoint.
|
|
|
186.
|
Before you
begin a presentation, you should plan and outline the message you want to communicate.
|
|
|
187.
|
The type of
output you choose depends on time constraints and hardware availability.
|
|
|
188.
|
An object is
any item on a slide that can be manipulated.
|
|
|
189.
|
Objects are the building blocks that make up a presentation.
|
|
|
|
|
|
190.
|
The
figure above shows a new blank title slide.
|
|
|
191.
|
To create a
new slide, click the New Slide button on the Formatting toolbar.
|
|
|
192.
|
Slide
layouts include placeholders such as text, clip art, charts, and media clips.
|
|
|
193.
|
To change a
slide's layout, click the slide layout icon in the Slide Layout task pane.
|
|
|
|
|
|
194.
|
In
the figure above, number 5 is pointing to a new slide thumbnail.
|
|
|
195.
|
In
the figure above, number 6 is pointing to a title placeholder.
|
|
|
196.
|
The Outline
tab is used to enter slide information.
|
|
|
197.
|
To help you
use the Outline tab more efficiently, you can open the Outlining toolbar.
|
|
|
198.
|
Text
you enter next to a slide icon in the Outline tab becomes the title text for that
slide.
|
|
|
|
|
|
199.
|
In
the figure above, number 6 is pointing to a slide icon.
|
|
|
200.
|
In
the figure above, number 4 is pointing to the selected slide icon for the current
slide.
|
|
|
201.
|
In
the figure above, number 5 is pointing to body text.
|
|
|
202.
|
In
the figure above, number 2 is pointing to a slide title.
|
|
|
203.
|
In
the figure above, number 3 is pointing to the selected slide icon of the current slide.
|
|
|
204.
|
Information
that you would commonly use in a header or footer would be a company or product name or a slide
number.
|
|
|
205.
|
Footer text on your slides is visible in the PowerPoint views and when you print the
slides.
|
|
|
206.
|
You
can apply footer text to one slide or to all the slides in the presentation.
|
|
|
207.
|
You
can enter notes in either Notes Page view or in the Notes pane in Normal view.
|
|
|
208.
|
A PowerPoint
design template cannot be changed but you can add new templates to the list.
|
|
|
209.
|
If you do
not like one of the PowerPoint's prepared templates, you can customize it for your particular
needs.
|
|
|
210.
|
You can
create a new design template by adding design elements, color, shapes, and pictures to a blank
presentation.
|
|
|
211.
|
Creating a
new presentation from an old one can save time by eliminating the need to re-enter existing
information.
|
|
|
212.
|
When you
make a copy of a file and then change the design of the copy, these changes will be reflected in the
original file as well.
|
|
|
213.
|
When you
position the pointer over a sizing handle, the pointer changes shape.
|
|
|
214.
|
Sizing
handles appear around the text object after you have selected it.
|
|
|
215.
|
In
the figure above, number 1 is pointing to a sizing handle.
|
|
|
216.
|
In
the figure above, number 4 is pointing to the dotted outline of the body text object.
|
|
|
217.
|
In
the figure above, number 6 is pointing to the middle sizing handle.
|
|
|
218.
|
You cannot
add text to drawn PowerPoint objects.
|
|
|
219.
|
Using
the commands on the Order Menu, you can layer an object by moving it to the front of the slide or
sending it to the back of the slide.
|
|
|
220.
|
Objects are aligned on a grid of evenly spaced vertical and horizontal
lines.
|
|
|
221.
|
When the
entire text box is selected, you can format all the text at one time.
|
|
|
222.
|
You can
import information into PowerPoint from other word processing documents.
|
|
|
223.
|
Each
PowerPoint presentation has a color scheme.
|
|
|
224.
|
You can
customize the Clip Organizer by adding clips to a collection, moving clips between collections, or
creating new collections.
|
|
|
225.
|
Clip art are
pictures that you design and draw yourself in PowerPoint.
|
|
|
226.
|
You can add
clips to the Clip Organizer from the Web.
|
|
|
227.
|
Scanned
photographs are the only pictures PowerPoint recognizes.
|
|
|
228.
|
The Crop
command on the Picture toolbar allows you to enlarge a picture.
|
|
|
229.
|
Cropping a
picture means to hide a portion of the picture.
|
|
|
230.
|
When you
scale a picture you are actually resizing it.
|
|
|
231.
|
You
can save a PowerPoint slide as a graphic and later use it in a presentation.
|
|
|
232.
|
In Microsoft
Graph a datasheet contains the graphical representation of data.
|
|
|
233.
|
A datasheet
contains the data you want to display, while a chart uses graphical representations of the data to
display the data.
|
|
|
234.
|
Formatting
an embedded chart object changes the original object.
|
|
|
235.
|
In
the figure above, number 12 is pointing to the active cells in the datasheet.
|
|
|
236.
|
In
the figure above, number 3 is pointing to a data series marker.
|
|
|
237.
|
You can
import data from a spreadsheet into a Microsoft Graph datasheet.
|
|
|
238.
|
The
horizontal axis is also called the Category axis.
|
|
|
239.
|
You
would use a PowerPoint table to insert information in a row and column format.
|
|
|
240.
|
Using
PowerPoint, you can show a presentation on any compatible computer using Slide Show
view.
|
|
|
241.
|
During a slide show in Slide Show view, you can show multiple slides at
once.
|
|
|
242.
|
If
you want, you can annotate, or draw, on the slides of your presentation during a slide
show.
|
|
|
243.
|
You
can determine how much time each slide in your presentation stays on the screen during a slide
show.
|
|
|
244.
|
A
slide timing is the amount of time a slide stays hidden before appearing in a slide
show.
|
|
|
245.
|
A
slide transition is a special audio or visual effect you can apply to a slide during a slide
show.
|
|
|
246.
|
Animation effects let you control how graphics and text appear on screen during a
slide show.
|
|
|
247.
|
You
can animate text, graphics, and even chart elements.
|
|
|
248.
|
If
you use PowerPoint to create your presentation, there is no need to rehearse your slide show before
you present it.
|