Make sure you take the practice exam!!!
TaskName
Task Instruction
1.
Absolute Cell Address
With the cursor in the Formula Bar, press the F4 key so that the G3 cell reference becomes absolute $G$3. Then press ENTER.
2.
Add data labels
In the Labels group on the Chart Tools Layout tab on the Ribbon, click the Data Labels button. On the Data Labels menu, click Outside End to add data labels above each column in the chart.
3.
Align Cell Contents
Right align the contents of the range A13:A17 by clicking the Align Text Right button in the Alignment group on the Ribbon.
4.
Chart - Change Type
In the Type group on the Chart Tools Design tab on the Ribbon, click the Change Chart Type button to display the Change Chart Type dialog box. In the Column section of the Change Chart Type dialog box, click the 3-D Cone button. Click the OK button.
5.
Create formulas using the OR function
In the Insert Function dialog box, click the Or select a category: arrow, and click Logical. Then, in the Select a function: list, click OR, and click OK to open the Function Arguments dialog box.
6.
Cut Cells
Click the Cut button in the Clipboard group on the Ribbon to cut the contents of the Total Amount fields that are currently selected.
7.
Delete Cells
Select the range A13:C13, click the Delete arrow on the Ribbon, click Delete Cells, click OK.
8.
Delete Rows
In the Cells group on the Home tab, click the Delete arrow, and then click Delete Sheet Rows to delete the selected row from the worksheet.
9.
Fill Series - Drag and Drop
Fill the range A4:A19 by continuing the series started in the range A2:A3 by positioning the pointer over the fill handle and dragging down to cell A19 before releasing the mouse.
10.
Format - Copy
In the Clipboard group on the Ribbon, click the Format Painter button to copy the formatting of the selected cell.
11.
Format chart data labels
In the Labels group on the Chart Tools Layout tab, click the Data Labels button and then click More Data Label Options. In the Label Options section of the Format Data Labels dialog box, click the Value check box to select it, and click the Percentage check box to deselect it, then click Close.
12.
Format charts
Format the chart area of the New Sales 2010 chart with the Colored Fill - Accent 4 shape style.
13.
Format worksheet tabs
In the Cells group on the Ribbon, click the Format button, point to Tab Color, and click Orange under Standard Colors.
14.
Goal Seek
On the Data tab on the Ribbon, in the Data Tools group, click the What-If Analysis button and use the Goal Seek command to open the Goal Seek dialog box. Use the Goal Seek dialog box to change the value in cell B3 so that the result of the formula in cell H18 is $100,000.00 by typing $100,000.00 in the To value box and B3 in the By changing cell box. Click OK twice to start the analysis.
15.
Indent Cell Contents
In the Alignment group on the Home tab, click the Increase Indent button to increase the text indent of the selected cell.
16.
Insert Cells
Click the Insert arrow in the Cells group on the Ribbon, and then click the Insert Cells command to open the Insert dialog box. In the Insert dialog box, click OK to insert cells in the currently selected Dues Collected 2009 column (H) of the workbook, shifting the existing cells to the right.
17.
Insert Row
In the Cells group on the Ribbon, click the Insert arrow. Click Insert Sheet Rows.
18.
Italicize Cell Contents
In the Font group on the Ribbon, click the Italic button to apply the italic format to the text in cell A2.
19.
Move Cells
To move the contents of cell B9 to cell B10, point to the border of the selected cell B9. When the pointer becomes a move pointer, hold down the left mouse button, drag cell B9 to cell B10, and then release the mouse button.
20.
Number Format - Currency
Apply the Accounting number format to the values in the range E2:E20 by clicking the Accounting Number Format button in the Number group on the Ribbon.
21.
Panes - Freeze
On the View tab on the Ribbon, in the Window group, use the Freeze Panes button to freeze columns A and B in the worksheet so that they will remain visible when the worksheet is scrolled.
22.
Paste Cells
In the Clipboard group on the Ribbon, click the Paste button to paste the last item placed on the Clipboard into the selected range.
23.
Print a chart
To print the New Sales 2010 chart, click the Office button, click Print, and then click OK in the Print dialog box.
24.
Rotate and tilt a 3-D Pie chart
In the Background group on the Chart Tools Layout tab on the Ribbon, click the 3-D Rotation button. Click the up arrow in the X box twice to change the 3-D rotation for the X-axis to 20 degrees, then click the up arrow in the Y box once to set the 3-D rotation for the Y-axis to 40 degrees, and click Close.
25.
Rotate Text
Use the Orientation button in the Alignment group on the Home tab on the Ribbon to change the orientation of the text in the selected cells in the current workbook. Re-orient the text so that it rotates counterclockwise at a 45-degree angle.
26.
Series - Fill Cells
Click the Fill button arrow in the Editing group on the Ribbon and then click Series to open the Series dialog box. In the Series dialog box, click the Month radio button in the Date unit and then click OK to enter the remaining months of the year in the selected cells.
27.
Shading
Click the Fill Color button arrow in the Font group on the Ribbon to display the Fill Color palette. Click the No Fill button on the Fill Color palette to remove the fill from the title cell which is currently selected.
28.
Split a window into panes
Split the window into two horizontal panes so that the top pane's bottom row is row 19 by clicking the View tab, then clicking the Split button in the Window group.
29.
Underline Cell Contents
Click the Underline button in the Font group on the Ribbon to underline the selected cell.
30.
Undo
Click the Undo button on the Quick Access Toolbar to undo the most recent change.
31.
Zoom
Click the Zoom button in the Zoom group on the View tab on the Ribbon to open the Zoom dialog box. In the Zoom dialog box, click the 200% option button and then click OK to change the Zoom setting for the current worksheet to 200%
No comments:
Post a Comment