Question 1 2.5 / 2.5 points
The following function can be easily performed by selecting the chart and using your mouse:
Question options:
moving the chart. OK
saving the chart.
deleting the chart.
printing the chart.
Question 2 2.5 / 2.5 points
Which one of the following options is especially valuable when a chart has more than one data series?
Question options:
Axes
Data Labels
Text
Legend OK
Question 3 2.5 / 2.5 points
Creating a chart in a separate window rather than with data on a worksheet is best when:
Question options:
the chart is to be printed on the same page as the data.
the chart is to be printed separately from the data. OK
the chart is three-dimensional.
what-if analysis is to be performed.
Question 4 2.5 / 2.5 points
The axes on a chart serve as the:
Question options:
scales against which data is plotted. OK
scales that appear in the legend.
categories for the values.
intersection point for the values.
Question 5 0 / 2.5 points
The __________ chart reverses the horizontal and vertical axes of the Column chart.
Question options:
Area
Radar
Bar
Scatter WRONG
Question 6 0 / 2.5 points
The most important step in creating a chart is:
Question options:
finishing the chart.
printing the chart.
establishing the purpose.
establishing the titles. WRONG
Question 7 2.5 / 2.5 points
A chart that is created on the same worksheet as the data is referred to as a/an:
Question options:
separate document.
chart window.
embedded chart. OK
local chart.
Question 8 2.5 / 2.5 points
A Line chart is used primarily to emphasize:
Question options:
the amount of change.
the significant elements.
a comparison of items.
trends over a period of time. OK
Question 9 2.5 / 2.5 points
When you select a range of data to chart, Excel treats each row or column of data in the range as:
Question options:
a data range.
separate data series. OK
a set of values.
mathematical operators.
Question 10 2.5 / 2.5 points
The XY, or Scatter graph is unique because it:
Question options:
uses numeric values on both axes. OK
requires only one set of data.
cannot be saved.
uses categories on both axes.
Question 11 0 / 2.5 points
The default chart type in Excel is a(n):
Question options:
two-dimensional column chart.
XY chart.
line chart. WRONG
scattergraph.
Question 12 2.5 / 2.5 points
An element in a chart item must be selected before it can be edited. When an item is selected, it is:
Question options:
shaded.
marked by squares. OK
marked by black or white diamonds.
placed in another worksheet window.
Question 13 0 / 2.5 points
When you have data in several locations on a worksheet that you wish to plot in a single chart, you may select several ranges at once using the mouse and the:
Question options:
CTRL key.
Chart Wizard.
Location command. WRONG
EDIT key.
Question 14 0 / 2.5 points
Three tabs are available for enhancing a chart title: Patterns, Font, and:
Question options:
Color. WRONG
Alignment.
Fill Effects.
Textures.
Question 15 2.5 / 2.5 points
Which one of the following is a benefit of using gridlines on a chart?
Question options:
The chart is more readable. OK
The scales can be modified.
The labels can be viewed.
The chart can be printed.
Question 16 2.5 / 2.5 points
You can print the worksheet and the chart together as they appear on your screen. First, deselect the chart by clicking anywhere on the worksheet itself. Then execute the __________ command.
Question options:
Chart options
File Print OK
Chart Wizard
CTRL Print
Question 17 0 / 2.5 points
In Excel, charts are __________. This means that when you change data in the worksheet, you can immediately see the graphical impact of the change by looking at the chart.
Question options:
malleable
experiential
dynamic
Linked WRONG
Question 18 2.5 / 2.5 points
When two different types of charts are displayed together, this is called a:
Question options:
focus chart.
joint chart.
combination chart. OK
cooperative chart.
Question 19 0 / 2.5 points
Which one of the following statements is TRUE?
Question options:
A chart is saved separately from a worksheet.
A chart is saved only if it is in a separate window.
A chart is saved only if it is an embedded chart. WRONG
A chart is saved when the worksheet is saved.
Question 20 2.5 / 2.5 points
A chart is selected by:
Question options:
highlighting the chart and selecting Control C.
double clicking on the chart.
clicking once in an open area of the chart. OK
highlighting the chart and clicking on the Chart option.
Question 21 2.5 / 2.5 points
In Excel, you can change all EXCEPT the __________ of the data:
Question options:
font
Value OK
style
color
Question 22 2.5 / 2.5 points
A directory within a directory is referred to as a:
Question options:
new directory.
file.
subdirectory. OK
listserv.
Question 23 2.5 / 2.5 points
You will find that once you've created a useful spreadsheet it becomes a valuable __________ for future work.
Question options:
reference point
Template OK
repository
data source
Question 24 0 / 2.5 points
When developing your file management strategy, focus first on:
Question options:
how you are going to name your files. WRONG
how you will back-up your files.
where your files will be located.
your file types, like word processing files.
Question 25 0 / 2.5 points
If you ever want to copy an entire worksheet, click the __________ button in the top-left corner box of the worksheet. Then click the Copy button, select another sheet, and click the Paste button.
Question options:
Functions
Manage Panes WRONG
Workbook
Select All
Question 26 0 / 2.5 points
The method of changing the appearance of data shown below applies to:
• Select Tools, Options (or Excel Options under the File menu or Office button.)
• Click Tab(s) of option(s) to be changed.
• Enter change(s).
• Click OK.
Question options:
selected cells.
new data.
current workbook. WRONG
all future workbooks by default.
Question 27 2.5 / 2.5 points
Which of the following is an unacceptable file name?
Question options:
Budget#2.xls OK
Budget2.xls
Budgetver2.xls
Budget 4-24.xls
Question 28 2.5 / 2.5 points
Which of the following is NOT a level at which changes in the appearance of data can be made?
Question options:
Individual cells
Individual columns
Individual item within a cell OK
Individual workbook
Question 29 2.5 / 2.5 points
A folder contained inside another folder is NOT called a:
Question options:
subdirectory.
branch. OK
child.
subfolder.
Question 30 2.5 / 2.5 points
As a student, your files should always include the following EXCEPT:
Question options:
Course name OK
Course number
Student number
Assignment
Question 31 2.5 / 2.5 points
Which of the following filenames conforms to school policy?
Question options:
homework.xls
Mark.xls
scan001.pdf
AC0004934MarkAnthonyA01Assignment6.xls OK
Question 32 2.5 / 2.5 points
The method of changing the appearance of data shown below applies to:
• Select the cell, column, row, or range to format.
• Select Format, Cells (or Format under the Cells group).
• In Format Cells dialog box, click the Tab for option to be changed.
• Select the characteristic to change and make changes as appropriate.
• Click OK.
Question options:
selected cells. OK
new data.
current workbook.
all future workbooks by default.
Question 33 2.5 / 2.5 points
By selecting options from the Style, Format, and __________ menus, you can make changes in the characteristics of the current workbook.
Question options:
Functions
Formulas
Font
OperatorS
Question 34 0 / 2.5 points
At a minimum, your filename should always identify the __________ of the spreadsheet:
Question options:
Purpose
directory location WRONG
Highlights
Creator
Question 35 2.5 / 2.5 points
Once you've established where your files will reside, spend some time thinking about how you are going to __________ your files.
Question options:
Name OK
Access
Organize
cross-reference
Question 36 0 / 2.5 points
Range names can be deleted by selecting the __________ in the Defined Names group on the Formulas tab.
Question options:
Name Box Drop-Down arrow
Name Manager button
F5 Key
Delete command WRONG
Question 37 2.5 / 2.5 points
The primary risk associated with duplicate filenames is:
Question options:
over-writing existing files.
losing track of which file has which version of your work. OK
saving a file with name of an existing file.
storing data that is difficult to locate at a later time.
Question 38 2.5 / 2.5 points
When developing your file management strategy, focus first on:
Question options:
filenames.
where your files will be located. OK
the data directory.
spreadsheet files.
Question 39 2.5 / 2.5 points
__________ refers to a specific document created to a particular purpose, such as completion of an assignment.
Question options:
Directory listing
Spreadsheet
Workbook
Filename OK
Question 40 0 / 2.5 points
Where is the recommended place to store your data files?
Question options:
with the program files
on the desktop WRONG
in the Windows directory
in a data directory separate from the program files
________________________________________
The following function can be easily performed by selecting the chart and using your mouse:
Question options:
moving the chart. OK
saving the chart.
deleting the chart.
printing the chart.
Question 2 2.5 / 2.5 points
Which one of the following options is especially valuable when a chart has more than one data series?
Question options:
Axes
Data Labels
Text
Legend OK
Question 3 2.5 / 2.5 points
Creating a chart in a separate window rather than with data on a worksheet is best when:
Question options:
the chart is to be printed on the same page as the data.
the chart is to be printed separately from the data. OK
the chart is three-dimensional.
what-if analysis is to be performed.
Question 4 2.5 / 2.5 points
The axes on a chart serve as the:
Question options:
scales against which data is plotted. OK
scales that appear in the legend.
categories for the values.
intersection point for the values.
Question 5 0 / 2.5 points
The __________ chart reverses the horizontal and vertical axes of the Column chart.
Question options:
Area
Radar
Bar
Scatter WRONG
Question 6 0 / 2.5 points
The most important step in creating a chart is:
Question options:
finishing the chart.
printing the chart.
establishing the purpose.
establishing the titles. WRONG
Question 7 2.5 / 2.5 points
A chart that is created on the same worksheet as the data is referred to as a/an:
Question options:
separate document.
chart window.
embedded chart. OK
local chart.
Question 8 2.5 / 2.5 points
A Line chart is used primarily to emphasize:
Question options:
the amount of change.
the significant elements.
a comparison of items.
trends over a period of time. OK
Question 9 2.5 / 2.5 points
When you select a range of data to chart, Excel treats each row or column of data in the range as:
Question options:
a data range.
separate data series. OK
a set of values.
mathematical operators.
Question 10 2.5 / 2.5 points
The XY, or Scatter graph is unique because it:
Question options:
uses numeric values on both axes. OK
requires only one set of data.
cannot be saved.
uses categories on both axes.
Question 11 0 / 2.5 points
The default chart type in Excel is a(n):
Question options:
two-dimensional column chart.
XY chart.
line chart. WRONG
scattergraph.
Question 12 2.5 / 2.5 points
An element in a chart item must be selected before it can be edited. When an item is selected, it is:
Question options:
shaded.
marked by squares. OK
marked by black or white diamonds.
placed in another worksheet window.
Question 13 0 / 2.5 points
When you have data in several locations on a worksheet that you wish to plot in a single chart, you may select several ranges at once using the mouse and the:
Question options:
CTRL key.
Chart Wizard.
Location command. WRONG
EDIT key.
Question 14 0 / 2.5 points
Three tabs are available for enhancing a chart title: Patterns, Font, and:
Question options:
Color. WRONG
Alignment.
Fill Effects.
Textures.
Question 15 2.5 / 2.5 points
Which one of the following is a benefit of using gridlines on a chart?
Question options:
The chart is more readable. OK
The scales can be modified.
The labels can be viewed.
The chart can be printed.
Question 16 2.5 / 2.5 points
You can print the worksheet and the chart together as they appear on your screen. First, deselect the chart by clicking anywhere on the worksheet itself. Then execute the __________ command.
Question options:
Chart options
File Print OK
Chart Wizard
CTRL Print
Question 17 0 / 2.5 points
In Excel, charts are __________. This means that when you change data in the worksheet, you can immediately see the graphical impact of the change by looking at the chart.
Question options:
malleable
experiential
dynamic
Linked WRONG
Question 18 2.5 / 2.5 points
When two different types of charts are displayed together, this is called a:
Question options:
focus chart.
joint chart.
combination chart. OK
cooperative chart.
Question 19 0 / 2.5 points
Which one of the following statements is TRUE?
Question options:
A chart is saved separately from a worksheet.
A chart is saved only if it is in a separate window.
A chart is saved only if it is an embedded chart. WRONG
A chart is saved when the worksheet is saved.
Question 20 2.5 / 2.5 points
A chart is selected by:
Question options:
highlighting the chart and selecting Control C.
double clicking on the chart.
clicking once in an open area of the chart. OK
highlighting the chart and clicking on the Chart option.
Question 21 2.5 / 2.5 points
In Excel, you can change all EXCEPT the __________ of the data:
Question options:
font
Value OK
style
color
Question 22 2.5 / 2.5 points
A directory within a directory is referred to as a:
Question options:
new directory.
file.
subdirectory. OK
listserv.
Question 23 2.5 / 2.5 points
You will find that once you've created a useful spreadsheet it becomes a valuable __________ for future work.
Question options:
reference point
Template OK
repository
data source
Question 24 0 / 2.5 points
When developing your file management strategy, focus first on:
Question options:
how you are going to name your files. WRONG
how you will back-up your files.
where your files will be located.
your file types, like word processing files.
Question 25 0 / 2.5 points
If you ever want to copy an entire worksheet, click the __________ button in the top-left corner box of the worksheet. Then click the Copy button, select another sheet, and click the Paste button.
Question options:
Functions
Manage Panes WRONG
Workbook
Select All
Question 26 0 / 2.5 points
The method of changing the appearance of data shown below applies to:
• Select Tools, Options (or Excel Options under the File menu or Office button.)
• Click Tab(s) of option(s) to be changed.
• Enter change(s).
• Click OK.
Question options:
selected cells.
new data.
current workbook. WRONG
all future workbooks by default.
Question 27 2.5 / 2.5 points
Which of the following is an unacceptable file name?
Question options:
Budget#2.xls OK
Budget2.xls
Budgetver2.xls
Budget 4-24.xls
Question 28 2.5 / 2.5 points
Which of the following is NOT a level at which changes in the appearance of data can be made?
Question options:
Individual cells
Individual columns
Individual item within a cell OK
Individual workbook
Question 29 2.5 / 2.5 points
A folder contained inside another folder is NOT called a:
Question options:
subdirectory.
branch. OK
child.
subfolder.
Question 30 2.5 / 2.5 points
As a student, your files should always include the following EXCEPT:
Question options:
Course name OK
Course number
Student number
Assignment
Question 31 2.5 / 2.5 points
Which of the following filenames conforms to school policy?
Question options:
homework.xls
Mark.xls
scan001.pdf
AC0004934MarkAnthonyA01Assignment6.xls OK
Question 32 2.5 / 2.5 points
The method of changing the appearance of data shown below applies to:
• Select the cell, column, row, or range to format.
• Select Format, Cells (or Format under the Cells group).
• In Format Cells dialog box, click the Tab for option to be changed.
• Select the characteristic to change and make changes as appropriate.
• Click OK.
Question options:
selected cells. OK
new data.
current workbook.
all future workbooks by default.
Question 33 2.5 / 2.5 points
By selecting options from the Style, Format, and __________ menus, you can make changes in the characteristics of the current workbook.
Question options:
Functions
Formulas
Font
OperatorS
Question 34 0 / 2.5 points
At a minimum, your filename should always identify the __________ of the spreadsheet:
Question options:
Purpose
directory location WRONG
Highlights
Creator
Question 35 2.5 / 2.5 points
Once you've established where your files will reside, spend some time thinking about how you are going to __________ your files.
Question options:
Name OK
Access
Organize
cross-reference
Question 36 0 / 2.5 points
Range names can be deleted by selecting the __________ in the Defined Names group on the Formulas tab.
Question options:
Name Box Drop-Down arrow
Name Manager button
F5 Key
Delete command WRONG
Question 37 2.5 / 2.5 points
The primary risk associated with duplicate filenames is:
Question options:
over-writing existing files.
losing track of which file has which version of your work. OK
saving a file with name of an existing file.
storing data that is difficult to locate at a later time.
Question 38 2.5 / 2.5 points
When developing your file management strategy, focus first on:
Question options:
filenames.
where your files will be located. OK
the data directory.
spreadsheet files.
Question 39 2.5 / 2.5 points
__________ refers to a specific document created to a particular purpose, such as completion of an assignment.
Question options:
Directory listing
Spreadsheet
Workbook
Filename OK
Question 40 0 / 2.5 points
Where is the recommended place to store your data files?
Question options:
with the program files
on the desktop WRONG
in the Windows directory
in a data directory separate from the program files
________________________________________