Excel Features Category, 10 points
True or False?
Excel can only have one workbook open at a time.
Excel Features Category, 20 points
Describe the contents of the next two cells when you drag and drop the fill handle to the right, for a cell that contains NOV-98.
Excel Features Category, 30 points
Identify a method for copying a worksheet.
Excel Features Category, 40 points
What is the difference between split windows and freezing panes?
Excel Features Category, 50 points
What is a combination chart?
Excel References Category, 10 points
What type of reference is the following, and what happens when this type of cell reference is copied?
$A$2
Excel References Category, 20 points
What type of reference is in the following formula?
='Sheet2'!C3
Excel References Category, 30 points
What type of reference is the following, and what happens when this type of cell reference is copied?
C3:C9
Excel References Category, 40 points
What type of reference is in the following formula, and what does the formula do?
=SUM('Sheet1:Sheet4'!H5:H7)
Excel References Category, 50 points
What does the following formula do?
='[Annual Budget.xls]Sheet1'!$B$6
Excel Tools Category, 10 points
True or False?
The Solver tool will determine a value for a target cell by changing values in one or more cells. The target cell can not have a formula in it.
Excel Tools Category, 20 points
True or False?
The difference between Solver and Goal Seek is that Goal Seek can change only one cell, while Solver can change many cells.
Excel Tools Category, 30 points
True or False?
The main dictionary used by Excel is the same one used by Word.
Excel Tools Category, 40 points
True or False?
Excel has a Thesaurus.
Excel Tools Category, 50 points
True or False?
Excel has an AutoCorrect feature.
Excel Charts Category, 10 points
True or False?
The Chart Wizard button is on the standard toolbar.
Excel Charts Category, 20 points
True or False?
After the chart has been created, you may move or delete the legend.
Excel Charts Category, 30 points
True or False?
Before you start the Chart Wizard, you must have selected the range of cells that contain the data.
Excel Charts Category, 40 points
True or False?
Chart gridlines, chart title, legend, plot area, category name and value-axis title are all chart elements.
Excel Charts Category, 50 points
Describe how you can change the fill pattern associated with a data series.
Excel Formatting Category, 10 points
How do you create a custom footer?
Excel Formatting Category, 20 points
Explain two ways that you can change the color within a cell.
Excel Formatting Category, 30 points
True or False?
With a 3-D Pie Chart, you can select a wedge and drag it away from the pie.
Excel Formatting Category, 40 points
Describe how you would add an arrow to point to a part of a chart.
Excel Formatting Category, 50 points
How do you remove an AutoFormat?