Weebly



MS Excel 2013 Training Ch 2 Task NameTask IDTask Instruction1.?? Set the print area EX3506 Click and drag to select the range A3:D19. In the Page Setup group on the PAGE LAYOUT tab, click the Print Area button. Then, on the Print Area menu, click Set Print Area. 2.?? Print a section of a worksheet EX3508 Click the FILE tab on the Ribbon to open Backstage view, and on the navigation bar, click the Print command. In the Settings section, click the Print Active Sheets button, and click Print Selection. Click the Print button to print the selected range of cells. 3.?? Change the fill color of a cell EX3295 In the Font group on the Ribbon, click the Fill Color arrow, and then click Orange, Accent 6 (row 1, last column) to change the fill color of the selected cell. 4.?? Add a border to a range EX3304 In the Font group on the Ribbon, click the Borders arrow, and then click the Thick Box Border option to add a border around the selected range. 5.?? Center cell contents EX3328 Position the mouse pointer over cell A3, then press and hold the left mouse button while you drag the mouse downward until it is over cell A12. Release the mouse button, and then, in the Alignment group, click the Center button. 6.?? Apply the Currency number format EX3498 Click and drag to select the range B5:D17. Then, in the Number group on the Ribbon, click the Number Format arrow and click Currency. 7.?? Apply the Date number format EX3499 In the Number group on the Ribbon, click the Dialog Box Launcher. On the Type list of the Date category, click the Date format 03/14/12, and then click OK to apply the change. 8.?? Increase the number of decimal places EX3500 In the Number group on the Ribbon, click the Increase Decimal button twice to increase the number of decimal places shown in the selected range from zero decimal places to two. 9.?? Apply the Percent number format EX3501 Point to cell B20 and drag to select the range B20:D20. In the Number group on the HOME tab, click the Percent Style button to format the range as percentages with no decimal places. 10.?? Apply conditional formatting to a range EX3366 To apply conditional formatting to cells G4:G15, in the Styles group on the Ribbon, click the Conditional Formatting button, then point to Highlight Cells Rules. Click Greater Than, type 17 in the Format cells that are GREATER THAN text box, and click OK. 11.?? Create a conditional formatting rule EX3533 To create a conditional formatting rule, in the Styles group, click the Conditional Formatting button and click New Rule. In the Select a Rule Type section of the New Formatting Rule dialog box, click Format only top or bottom ranked values. In the Edit the Rule Description section, double-click the value text box that currently displays the number 10 and type 25 in the text box, then click the % of the selected range check box to select it. Click the Format button, and in the Format Cells dialog box, click the Fill tab. In the Background color section, click the dark red color option, the first color option in the bottom row. Click OK twice to close the dialog boxes. 12.?? Modify row height EX3509 Point to the boundary at the bottom of the row selector for the selected row until the pointer changes to a crosshair shape. Then press the left mouse button as you drag the boundary down until the screen tip indicates 27.00 (36 pixels), and release the mouse button. 13.?? Specify a column width EX3527 In the Cells group on the Ribbon, click the Format button. On the Format menu, in the Cell Size section, click Column Width. In the Column Width dialog box, type 15 to replace the contents, and then click OK. 14.?? Change a sparkline style EX3536 In the Style group on the SPARKLINE TOOLS DESIGN tab, click the More button. Click Sparkline Style Accent 1, Darker 25% (the first style in the second row). 15.?? Insert a header EX3541 To insert a header, click the VIEW tab on the Ribbon, then in the Workbook Views group, click the Page Layout button. Click the center section of the header, then type Income Statement in the header. 16.?? Apply a theme to a worksheet EX3521 In the Themes group on the PAGE LAYOUT tab, click the Themes button to display the Themes gallery, and then click the Retrospect theme (the last theme in the second row) to apply it to the current workbook. 17.?? Change worksheet orientation EX3505 In the Page Setup group on the PAGE LAYOUT tab, click the Orientation button, and then click Landscape to change the worksheet orientation. 18.?? Change worksheet margins EX3547 To change worksheet margins, click the Page Layout button on the status bar. Click the PAGE LAYOUT tab on the Ribbon, and in the Page Setup group, click the Margins button, and then click Narrow. 19.?? Create a formula using the AVERAGE function EX3537 To create a formula using the AVERAGE function, type =AV in cell J6, then in the Formula AutoComplete list, double-click AVERAGE. Position the mouse pointer over cell E4. Press and hold the left mouse button as you drag the pointer downward until it is over cell E11. Release the mouse button. Type ) to complete the formula, then press ENTER. 20.?? Create a formula using the MAX function EX3539 To create a formula using the MAX function, click the Insert Function button on the formula bar, click the Or select a category arrow, and then click Statistical. In the Select a function box, click MAX, and then click OK. In the Function Arguments dialog box, type G4:G11 in the Number1 box, and click OK. 21.?? Create a formula using the MIN function EX3540 To create a formula using the MIN function, in the Editing group, click the AutoSum arrow and click Min. In the formula bar, click and drag to select the text J5:J8. Release the mouse button. Click and drag to select G4:G11, then release the mouse button. 22.?? Check spelling for a word EX3518 In the Proofing group on the REVIEW tab, click the Spelling button to check the spelling in the current worksheet. In the Spelling dialog box, click Change to accept the suggested correction, and then click OK to close the message box. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download