Excel Features Category, 10 points
False.
Excel Features Category, 20 points
DEC-98 JAN-99
In this case, there are two values (month, year) that are incremented. To choose which values to increment, use the right mouse button to drag and drop the fill handle.
Hold down the Ctrl key before you drag and drop the fill handle if you want to copy the value instead of incrementing it.
Excel Features Category, 30 points
1) Hold the Ctrl key as you drag and drop a worksheet tab
2) Edit menu, Move or Copy Sheet..., Create a Copy
Excel Features Category, 40 points
A split window displays two panes for one worksheet. You can scroll each pane separate from the other. Freezing panes allows you to see the top rows (or left most columns) even when you've scrolled the data beyond the size of the window.
Excel Features Category, 50 points
A chart that uses two or more chart types to emphasize that the chart contains different kinds of information.
Excel References Category, 10 points
This is an absolute cell reference. When a formula containing an absolute cell reference is copied, the absolute cell reference does not change.
Excel References Category, 20 points
A worksheet cell reference (containing a relative cell reference).
Excel References Category, 30 points
This is a relative cell range of C3 through C9, inclusive. When a formula containing a relative cell range is copied, the range of cells is changed to reflect the "distance" between the original cell and the copied-to cell.
Excel References Category, 40 points
A 3-D reference is in the formula. The formula will sum cells H5 through H7 on worksheets Sheet1 through Sheet4.
Excel References Category, 50 points
It contains an external reference forumula. It copies the value found in cell $B$6 on Sheet1 of the Annual Budget.xls workbook file.
Excel Tools Category, 10 points
False. The target cell must have a formula in it.
Excel Tools Category, 20 points
True.
Excel Tools Category, 30 points
True.
Excel Tools Category, 40 points
False.
Excel Tools Category, 50 points
True.
Excel Charts Category, 10 points
True.
Excel Charts Category, 20 points
True.
Excel Charts Category, 30 points
False. In step 2 of the Chart Wizard, you can specify (change) the data range.
Excel Charts Category, 40 points
True.
Excel Charts Category, 50 points
Right click the data series (e.g., a line, bar, or column), select Format Data Series... from the shortcut menu, change Area fill color or click on Fill Effects... to select a pattern.
Excel Formatting Category, 10 points
1) File menu, Print Preview, Setup..., Header/Footer tab, Custom Footer..., type in information
2) File menu, Page Setup..., Header/Footer tab, Custom Footer..., type in information
Excel Formatting Category, 20 points
1) Change the font color (either Font Color drop-down list on formatting toolbar or Format menu, Cells..., Font, Color)
2) Change the fill color (either Fill Color drop-down list on formatting toolbar or Format menu, Cells..., Pattern
Excel Formatting Category, 30 points
True.
Excel Formatting Category, 40 points
Click on the Arrow button (found on the Drawing toolbar). Click where the arrow starts, then drag the moust pointer to the other end of the arrow.
Excel Formatting Category, 50 points
Select None from the Table format list found on the AutoFormat dialog box.