Question 1 of 40 2.5 Points
When two different types of charts are displayed together, this is called a:
A. focus chart.
B. joint chart.
C. combination chart.
D. cooperative chart.
Question 2 of 40 2.5 Points
Which one of the following statements is TRUE?
A. A chart is saved separately from a worksheet.
B. A chart is saved only if it is in a separate window.
C. A chart is saved only if it is an embedded chart.
D. A chart is saved when the worksheet is saved.
Question 3 of 40 2.5 Points
When you select a range of data to chart, Excel treats each row or column of data in the range as:
A. a data range.
B. separate data series.
C. a set of values.
D. mathematical operators.
Question 4 of 40 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.
A. malleable
B. experiential
C. dynamic
D. linked
Question 5 of 40 2.5 Points
In Excel, the x-axis on a chart is called the:
A. category axis.
B. value axis.
C. vertical axis.
D. legend axis.
Question 6 of 40 2.5 Points
The XY, or Scatter graph is unique because it:
A. uses numeric values on both axes.
B. requires only one set of data.
C. cannot be saved.
D. uses categories on both axes.
Question 7 of 40 2.5 Points
Which one of the following types of chart best emphasizes the amount of change?
A. Area
B. Column
C. Bar
D. Pie
Question 8 of 40 2.5 Points
Which one of the following characteristics distinguishes a two-dimensional chart from a three-dimensional chart?
A. Symbols: 2-dimensional symbols versus 3-dimensional symbols
B. Data Series: 2 series versus 3 series
C. Axis: 2 axes versus 3 axes
D. Text: 2-dimensional versus 3-dimensional
Question 9 of 40 2.5 Points
Which one of the following is a benefit of using gridlines on a chart?
A. The chart is more readable.
B. The scales can be modified.
C. The labels can be viewed.
D. The chart can be printed.
Question 10 of 40 2.5 Points
A chart is selected by:
A. highlighting the chart and selecting Control C.
B. double clicking on the chart.
C. clicking once in an open area of the chart.
D. highlighting the chart and clicking on the Chart option.
Question 11 of 40 2.5 Points
A Pie chart shows:
A. the amount of change.
B. an element of data proportionate to the sum.
C. values and categories.
D. trends over a period of time.
Question 12 of 40 2.5 Points
A chart that is created on the same worksheet as the data is referred to as a/an:
A. separate document.
B. chart window.
C. embedded chart.
D. local chart.
Question 13 of 40 2.5 Points
An element in a chart item must be selected before it can be edited. When an item is selected, it is:
A. shaded.
B. marked by squares.
C. marked by black or white diamonds.
D. placed in another worksheet window.
Question 14 of 40 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.
A. Chart options
B. File Print
C. Chart Wizard
D. CTRL Print
Question 15 of 40 2.5 Points
A range of data has ten rows and five columns. By default, which will Excel use as the data series?
A. X-axis
B. Y-axis
C. Rows
D. Columns
Question 16 of 40 2.5 Points
The following function can be easily performed by selecting the chart and using your mouse:
A. moving the chart.
B. saving the chart.
C. deleting the chart.
D. printing the chart.
Question 17 of 40 2.5 Points
Comparisons of data in relationship to time are best emphasized by using which one of the following combinations of charts?
A. Line and Pie
B. Line and Column
C. Scatter and Area
D. Bar and Pie
Question 18 of 40 2.5 Points
The most important step in creating a chart is:
A. finishing the chart.
B. printing the chart.
C. establishing the purpose.
D. establishing the titles.
Question 19 of 40 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:
A. CTRL key.
B. Chart Wizard.
C. Location command.
D. EDIT key.
Question 20 of 40 2.5 Points
The default chart type in Excel is a(n):
A. two-dimensional column chart.
B. XY chart.
C. line chart.
D. scattergraph.
Question 21 of 40 2.5 Points
By selecting options from the Style, Format, and __________ menus, you can make changes in the characteristics of the current workbook.
A. Functions
B. Formulas
C. Font
D. OperatorS
Question 22 of 40 2.5 Points
The best way to avoid having duplicate filenames is to immediately rename any file that you are using as a:
A. template.
B. folder.
C. document page.
D. clipboard.
Question 23 of 40 2.5 Points
Which of the following is NOT a level at which changes in the appearance of data can be made?
A. Individual cells
B. Individual columns
C. Individual item within a cell
D. Individual workbook
Question 24 of 40 2.5 Points
__________ refers to a specific document created to a particular purpose, such as completion of an assignment.
A. Directory listing
B. Spreadsheet
C. Workbook
D. Filename
Question 25 of 40 2.5 Points
The primary risk associated with duplicate filenames is:
A. over-writing existing files.
B. losing track of which file has which version of your work.
C. saving a file with name of an existing file.
D. storing data that is difficult to locate at a later time.
Question 26 of 40 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.
A. Functions
B. Manage Panes
C. Workbook
D. Select All
Question 27 of 40 2.5 Points
The Save function will automatically save changes to the:
A. selected data fields.
B. formulas.
C. worksheet.
D. workbook.
Question 28 of 40 2.5 Points
Which of the following is NOT a tip offered by Microsoft on Excel management?
A. Use documents.
B. Find files using Windows Explorer.
C. Back up files often.
D. Store working files and program files together.
Question 29 of 40 2.5 Points
Range names can be deleted by selecting the __________ in the Defined Names group on the Formulas tab.
A. Name Box Drop-Down arrow
B. Name Manager button
C. F5 Key
D. Delete command
Question 30 of 40 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.
•
A. selected cells.
B. new data.
C. current workbook.
D. all future workbooks by default.
Question 31 of 40 2.5 Points
Which file name is most likely the most current budget?
A. ProjectBudget.xlsx Microsoft Excel 9/12/2011 08:00 AM
B. ProjectBudget.xlsx Microsoft Excel 9/01/2011 08:15 AM
C. ProjectPlans.xlsx Microsoft Excel 9/12/2011 09:16 AM
D. ProjectBudget.xlsx Microsoft Excel 9/12/2011 08:15 AM
Question 32 of 40 2.5 Points
The Documents feature is actually a:
A. thumbnail.
B. virtual library.
C. listserv.
D. details page.
Question 33 of 40 2.5 Points
The Freeze Panes button allows you to freeze a row or a column (or both) in place so that:
A. you can move quickly between different worksheets in a workbook.
B. you can enter formulas in multiple rows or columns simultaneously.
C. it always stays on the screen no matter where the cell pointer is.
D. you can easily enter mathematical operators.
Question 34 of 40 2.5 Points
Within a __________, you would include individual Excel files.
A. directory
B. spreadsheet
C. workbook
D. data file
Question 35 of 40 2.5 Points
When learning how to manage files and folders, it is important that you develop a __________ for the kinds of files you create most often and then stick to it.
A. naming scheme
B. numbering system
C. root directory
D. core directory
Question 36 of 40 2.5 Points
At a minimum, your filename should always identify the __________ of the spreadsheet:
A. purpose
B. directory location
C. highlights
D. creator
Question 37 of 40 2.5 Points
You will find that once you've created a useful spreadsheet it becomes a valuable __________ for future work.
A. reference point
B. template
C. repository
D. data source
Question 38 of 40 2.5 Points
Once you've established where your files will reside, spend some time thinking about how you are going to __________ your files.
A. name
B. access
C. organize
D. cross-reference
Question 39 of 40 2.5 Points
Where is the recommended place to store your data files?
A. with the program files
B. on the desktop
C. in the Windows directory
D. in a data directory separate from the program files
Question 40 of 40 2.5 Points
Files are kept organized by storing related files in the same folder. This folder can also be referred to as the:
A. child.
B. parent.
C. root.
D. tree.
