Monday, November 10, 2008

no subject

BT-230 - Test 2 - STUDY GUIDE
Your response has been submitted successfully.
Points Awarded
0
Points Missed
75
Percentage
0%

1.
An Excel formula can include more than one operation; for example, multiplication and addition.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
A
Your Response:
2.
To enter a function into a cell, you can manually type the function, including its arguments, into the cell.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
A
Your Response:
3.
When you cut cells, the original data remains in the original location.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
4.
Absolute cell references are the default in Excel.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
5.
With each press of the [F1] key, you cycle through all the possible combinations of relative, absolute, and mixed references.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
6.
You can change the font and font size of any cell or range using the Mini toolbar.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
A
Your Response:
7.
The Format Painter button copies both the cell’s content and formatting.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
8.
With Excel, you can adjust the width of one or more columns by using the Ribbon.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
A
Your Response:
9.
You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
10.
The horizontal axis is also called the value axis.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
11.
A bar chart compares trends over even time intervals.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
12.
A chart must be located in a specific cell or at a specific range address.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
13.
Any data changed in the worksheet is automatically updated in the chart.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
A
Your Response:
14.
When the landscape orientation is selected, the data and chart will be positioned vertically on a page.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
15.
In the figure above, the button labeled L is used to apply borders under text.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
16.
The location of each margin (right, left, top, and bottom) is shown on the rulers at the intersection of the white and shaded areas.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
A
Your Response:
17.
Landscape orientation means a page is taller than it is wide.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
18.
A gutter can be added to the right margin of a document.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
19.
Pressing [Ctrl][Enter] inserts an automatic page break.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
20.
When you format text in the header, the same formatting is automatically applied to the main document.
A.
True
B.
False

Points Earned:
0/1
Correct Answer:
B
Your Response:
21.
Which of the following values would be considered a complex formula?
A.
=B3+C9*D12
B.
=B3
C.
=B3+C9
D.
=B3*D12

Points Earned:
0/1
Correct Answer:
A
Your Response:
22.
The formula =(20-8)/6 equals ____.
A.
1.33
B.
2
C.
6
D.
18.67

Points Earned:
0/1
Correct Answer:
B
Your Response:
23.
In the calculation =8+.98/3500*9-7, which operation is performed second?
A.
Division
B.
Multiplication
C.
Addition
D.
Subtraction

Points Earned:
0/1
Correct Answer:
B
Your Response:
24.
As shown in the figure above, item 1 points to a(n) ____ formula.
A.
absolute
B.
relative
C.
mixed
D.
complex

Points Earned:
0/1
Correct Answer:
D
Your Response:
25.
As shown in the figure above, item 2 points to the ____.
A.
Expand button
B.
Minimize button
C.
Insert Function button
D.
Collapse button

Points Earned:
0/1
Correct Answer:
C
Your Response:
26.
As shown in the figure above, item 2 points to the ____.
A.
Copy button
B.
Paste button
C.
Clipboard launcher
D.
Collapse button

Points Earned:
0/1
Correct Answer:
A
Your Response:
27.
The formula =SUM(A4:A13) contains ____ cell references.
A.
absolute
B.
relative
C.
mixed
D.
complex

Points Earned:
0/1
Correct Answer:
B
Your Response:
28.
You can create an absolute cell reference by selecting a cell address on the formula bar and then pressing ____.
A.
[F2]
B.
[F3]
C.
[F4]
D.
[F5]

Points Earned:
0/1
Correct Answer:
C
Your Response:
29.
In the reference $C14, ____.
A.
both the column letter and the row number would be updated relative to their location
B.
the column letter would not change, but the row number would be updated relative to its location
C.
the column letter would be updated relative to its location, but the row number would not change
D.
neither the column letter nor the row number would change

Points Earned:
0/1
Correct Answer:
B
Your Response:
30.
As shown in the figure above, item 1 points to the ____.
A.
Auto Fill Options button
B.
fill handle
C.
Paste Options button
D.
Clipboard launcher

Points Earned:
0/1
Correct Answer:
B
Your Response:
31.
An Excel template has the extension ____.
A.
.xml
B.
.temp
C.
.xltx
D.
.xlsx

Points Earned:
0/1
Correct Answer:
C
Your Response:
32.
The ____ of a cell determines how the labels and values look.
A.
value
B.
formula
C.
label
D.
format

Points Earned:
0/1
Correct Answer:
D
Your Response:
33.
To format a cell or range, first you select it, and then you apply the formatting using the ____ or a keyboard shortcut.
A.
Name box
B.
formula box
C.
Ribbon
D.
Sheet tabs

Points Earned:
0/1
Correct Answer:
C
Your Response:
34.
Cells and ranges in a worksheet can be formatted ____.
A.
only before data is entered
B.
only after data is entered
C.
before or after data is entered
D.
at the same time data is entered

Points Earned:
0/1
Correct Answer:
C
Your Response:
35.
As shown in the figure above, item 1 is the ____ list arrow.
A.
Number Format
B.
Accounting Format
C.
Commands in Number
D.
Decimal Number

Points Earned:
0/1
Correct Answer:
A
Your Response:
36.
As shown in the figure above, item 2 points to the ____ button in the Styles group on the Home tab of the Ribbon.
A.
Format as Table
B.
Cell Styles
C.
Format Painter
D.
Conditional Formatting

Points Earned:
0/1
Correct Answer:
A
Your Response:
37.
As shown in the figure above, item 3 points to the ____ button in the Styles group on the Home tab of the Ribbon.
A.
Format as Table
B.
Cell Styles
C.
Format Painter
D.
Conditional Formatting

Points Earned:
0/1
Correct Answer:
B
Your Response:
38.
The ____ size is the physical size of the text.
A.
style
B.
format
C.
point
D.
font

Points Earned:
0/1
Correct Answer:
D
Your Response:
39.
As shown in the figure above, the currently selected font is ____.
A.
Regular
B.
Calibri
C.
Times New Roman
D.
font 11

Points Earned:
0/1
Correct Answer:
B
Your Response:
40.
You can change the ____ of labels and values in cells to be left, right, or center.
A.
font
B.
font size
C.
cell style
D.
alignment

Points Earned:
0/1
Correct Answer:
D
Your Response:
41.
As shown in the figure above, item ____ points to the Center button.
A.
4
B.
5
C.
6
D.
8

Points Earned:
0/1
Correct Answer:
B
Your Response:
42.
As shown in the figure above, item ____ points to the Merge & Center button.
A.
4
B.
5
C.
6
D.
8

Points Earned:
0/1
Correct Answer:
D
Your Response:
43.
The formatting due to ____ formatting is automatically updated if you change data in the worksheet.
A.
conditional
B.
spatial
C.
dynamic
D.
data

Points Earned:
0/1
Correct Answer:
A
Your Response:
44.
The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.
A.
Home
B.
Page Layout
C.
Review
D.
Data

Points Earned:
0/1
Correct Answer:
A
Your Response:
45.
____ indicate the scale of measure for each value on the y-axis.
A.
Data points
B.
Tick marks
C.
Data markers
D.
Data series

Points Earned:
0/1
Correct Answer:
B
Your Response:
46.
As shown in the figure above, item 4 points to a ____.
A.
data point
B.
tick mark
C.
data series
D.
data marker

Points Earned:
0/1
Correct Answer:
D
Your Response:
47.
As shown in the figure above, item 5 represents ____.
A.
a plot area
B.
tick marks
C.
a data series
D.
a legend

Points Earned:
0/1
Correct Answer:
C
Your Response:
48.
The arrows shown in the figure above point to ____.
A.
data markers
B.
I-beams
C.
legends
D.
sizing handles

Points Earned:
0/1
Correct Answer:
D
Your Response:
49.
You can modify the data range and configuration of a chart in the ____ group of the Chart Tools Design tab.
A.
Data
B.
Type
C.
Chart Layouts
D.
Chart Styles

Points Earned:
0/1
Correct Answer:
A
Your Response:
50.
You can apply a chart type to an existing data series in a chart to create a(n) ____ chart.
A.
nested
B.
combination
C.
complex
D.
exploded

Points Earned:
0/1
Correct Answer:
B
Your Response:
51.
____ are the horizontal and vertical lines in a chart that enable the eye to follow the value on an axis.
A.
Tick marks
B.
Axis lines
C.
Arrows
D.
Gridlines

Points Earned:
0/1
Correct Answer:
D
Your Response:
52.
You can add data labels by selecting your chart, and clicking the Data Labels button in the Labels group in the Chart Tools ____ tab on the Ribbon.
A.
Design
B.
Layout
C.
Format
D.
Text

Points Earned:
0/1
Correct Answer:
B
Your Response:
53.
As shown in the figure above, item 2 points to a ____.
A.
vertical axis label
B.
horizontal axis label
C.
horizontal axis title
D.
vertical axis title

Points Earned:
0/1
Correct Answer:
A
Your Response:
54.
As shown in the figure above, item 4 points to a ____.
A.
vertical axis label
B.
horizontal axis label
C.
horizontal axis title
D.
vertical axis title

Points Earned:
0/1
Correct Answer:
B
Your Response:
55.
____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.
A.
SmartArt
B.
WordArt
C.
ClipArt
D.
3-DArt

Points Earned:
0/1
Correct Answer:
A
Your Response:
56.
Which tool would you use to change the format of text to 20 points?
A.
Font list arrow
B.
Font size list arrow
C.
Font color list arrow
D.
Style list arrow

Points Earned:
0/1
Correct Answer:
B
Your Response:
57.
Which command would you use to quickly format 20 point Comic Sans text to the default format?
A.
Clear Formatting command in the Font group on the Home tab
B.
Font command in the Font group on the Home tab
C.
Undo command on the Quick Access toolbar
D.
Replace command on the Quick Access toolbar

Points Earned:
0/1
Correct Answer:
A
Your Response:
58.
Which of the following formats can be changed using the Character Spacing tab in the Font dialog box?
A.
Character scale
B.
Character effects
C.
Character style
D.
Character size

Points Earned:
0/1
Correct Answer:
A
Your Response:
59.
In the figure above, name 1 is best described as what?
A.
Bold text
B.
Italic text
C.
Times New Roman
D.
Sans Serif font

Points Earned:
0/1
Correct Answer:
D
Your Response:
60.
In the figure above, which number shows a name formatted with a font effect?
A.
2
B.
3
C.
4
D.
5

Points Earned:
0/1
Correct Answer:
D
Your Response:
61.
In the figure above, which number shows an example of a name formatted as bold text?
A.
1
B.
2
C.
4
D.
5

Points Earned:
0/1
Correct Answer:
B
Your Response:
62.
In the figure above, which button is used to change line spacing?
A.
J
B.
E
C.
K
D.
B

Points Earned:
0/1
Correct Answer:
A
Your Response:
63.
Which of the following formats cannot be changed using the Paragraph dialog box?
A.
Indents
B.
Line Spacing
C.
Style
D.
Alignment

Points Earned:
0/1
Correct Answer:
C
Your Response:
64.
What is the alignment of text that is positioned evenly between both margins?
A.
Justified
B.
Centered
C.
Left-aligned
D.
Right-aligned

Points Earned:
0/1
Correct Answer:
B
Your Response:
65.
What is the alignment of text that is flush with the left margin and has a ragged right edge?
A.
Justified
B.
Centered
C.
Left-aligned
D.
Right-aligned

Points Earned:
0/1
Correct Answer:
C
Your Response:
66.
How do you open the Tabs dialog box?
A.
Double-click a tab stop on the ruler
B.
Click the launcher in the Paragraph group, then click Tabs
C.
Click the Tabs button in the View group
D.
Both A and B

Points Earned:
0/1
Correct Answer:
D
Your Response:
67.
What do the indent markers on the horizontal ruler always indicate?
A.
The indent settings for the active paragraph
B.
The default indent settings
C.
The left and right margins
D.
The alignment of the active paragraph

Points Earned:
0/1
Correct Answer:
A
Your Response:
68.
What happens when you click a number in a numbered list?
A.
Only that number is selected.
B.
The insertion point is placed to the right of the number.
C.
All the numbers in the list are selected.
D.
You can't click a number in a numbered list.

Points Earned:
0/1
Correct Answer:
C
Your Response:
69.
How do you remove bullets from a bulleted list?
A.
Select each bullet, then press [Delete].
B.
Use the [Backspace] key to remove each bullet.
C.
Select the list, then change the bullet character.
D.
Select the list, then click the Bullets button.

Points Earned:
0/1
Correct Answer:
D
Your Response:
70.
What is the default format for text in a Word 2007 document?
A.
12 point Times New Roman
B.
11 point Calibri
C.
11 point Arial
D.
12 point Garamond

Points Earned:
0/1
Correct Answer:
B
Your Response:
71.
Which tab in the Page Setup dialog box is used to add a gutter to a document?
A.
Margins
B.
Paper
C.
Layout
D.
Page

Points Earned:
0/1
Correct Answer:
A
Your Response:
72.
How can you display the rulers?
A.
Click the View Ruler button at the top of the vertical scroll bar
B.
Click Ruler in the Show/Hide group on the View tab
C.
Both A and B
D.
Neither A or B

Points Earned:
0/1
Correct Answer:
C
Your Response:
73.
In the document shown in the figure above, what is the total number of sections in the document?
A.
2
B.
4
C.
7
D.
Impossible to tell

Points Earned:
0/1
Correct Answer:
D
Your Response:
74.
Which is not true of the graphic shown in the figure above?
A.
It is an inline graphic.
B.
It is selected.
C.
It is a floating graphic.
D.
Text is wrapped around the graphic.

Points Earned:
0/1
Correct Answer:
A
Your Response:
75.
What does it mean to balance the columns on page?
A.
Adjust the spacing between the columns.
B.
Hyphenate the text in the columns.
C.
Make all the columns the same width.
D.
Make all the columns the same length.

Points Earned:
0/1
Correct Answer:
D
Your Response:

Top of Form
Bottom of Form

No comments: