Excel Formulas. Lesson 1 familiarized you with the Excel 2. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform. To start this lesson, open Excel. Set the Enter Key Direction. In Microsoft Excel, you can specify the direction the cursor moves. This tutorial is here to teach you the various ways to save, or open existing files in Microsoft Word. It will also show you the various nerdy ways you can close a. Using Tables for Organizing and Formatting in Microsoft Word What You Will Learn. After completing this lesson, you will be able to. In this 2015 article we list the best free Windows programs available from Microsoft. In Microsoft Excel, you can enter numbers and mathematical formulas into cells. Whether you enter a number or a formula, you can reference the cell when you. To better work with styles, it helps to be able to see your document the way Word sees it. On the Home toolbar, click the ShowHide button it looks like a paragraph. Free Printable Borders requires no downloads or templates. Simply pick your border design and print or copy your free border. Looking for free borders clip art Microsoft Word features a vast collection of borders accessible via its clip art library and via Office Online. Once. Creater a checklist you can fill out in Word, or one you can print using check marks, check boxes, or any symbols in the builtin font library. An Extreme Tutorial on Creating FillIn Forms in Microsoft Word Discussion. This is a long article. There are over 40 graphics alone, and its equivalent to 17 pages. Get that report to me, ASAP A core set of Microsoft Excel and Word tricks can make this task less stressful and help you whiz up a stylish report in no time. Able Borders For Microsoft Word' title='Able Borders For Microsoft Word' />Enter key. In the exercises that follow, the cursor must move down one cell when you press Enter. You can use the Direction box in the Excel Options pane to set the cursor to move up, down. Perform the steps that follow to set the cursor to move down when you press the Enter key. Click the Microsoft Office button. A menu appears. Click Excel Options in the lower right corner. The Excel Options pane appears. Click Advanced. If the check box next to After Pressing Enter Move Selection is not checked, click the box to check it. If Down does not appear in the Direction box, click the down arrow next to the Direction box and then. Down. Click OK. Excel sets the Enter direction to down. Perform. Mathematical Calculations. In Microsoft Excel, you can enter numbers and mathematical formulas. Whether you enter a number or a formula, you can reference the cell when you perform mathematical. When entering a mathematical formula, precede the formula with an equal. Use the following to indicate the type of calculation you wish. Addition Subtraction Multiplication Division Exponential. Microsoft Word With Compliments Template. In the following exercises, you practice some of the methods you can use to move around a worksheet and you learn how to perform mathematical calculations. Refer to Lesson 1 to learn more about moving around a worksheet. EXERCISE 1. Addition. Type Add in cell A1. Press Enter. Excel moves down one cell. Type 1 in cell A2. Press Enter. Excel moves down one cell. Type 1 in cell A3. Press Enter. Excel moves down one cell. Type A2A3 in cell A4. Click the check mark on the Formula bar. Excel adds cell A1 to cell A2 and displays the result in cell A4. The formula displays on the Formula bar. Note Clicking the check mark on the Formula bar is similar to pressing Enter. Excel records your entry but does not move to the next cell. Subtraction Press F5. The Go To dialog box appears. Type B1 in the Reference field. Press Enter. Excel moves to cell B1. Type Subtract. Press Enter. Excel moves down one cell. Type 6 in cell B2. Press Enter. Excel moves down one cell. Type 3 in cell B3. Press Enter. Excel moves down one cell. Type B2 B3 in cell B4. Click the check mark on the Formula bar. Excel subtracts cell B3 from cell B2 and the result. B4. The formula displays on the Formula bar. Multiplication Hold down the Ctrl key while you press g Ctrlg. The. Go To dialog box appears. Type C1 in the Reference field. Press Enter. Excel moves to cell C1. Type Multiply. Press Enter. Excel moves down one cell. Type 2 in cell C2. Press Enter. Excel moves down one cell. Type 3 in cell C3. Press Enter. Excel moves down one cell. Type C23 in cell C4. Click the check mark on the Formula bar. Excel multiplies C1 by cell C2 and displays the result in cell C3. The formula displays on the Formula bar. Division Press F5. Type D1 in the Reference field. Press Enter. Excel moves to cell D1. Type Divide. Press Enter. Excel moves down one cell. Type 6 in cell D2. Press Enter. Excel moves down one cell. Type 3 in cell D3. Press Enter. Excel moves down one cell. Type D2D3 in cell D4. Click the check mark on the Formula bar. Excel divides cell D2 by cell D3 and displays the result. D4. The formula displays on the Formula bar. When creating formulas, you can reference cells and include numbers. All of the following formulas are valid A2B2A11. B3A221. 22. 45. Auto. Sum. You can use the Auto. Sum button on the Home tab to automatically add a column. When you press the Auto. Sum button, Excel selects the numbers it thinks you want to add. If you then click the check mark on the Formula bar or press the Enter key, Excel adds the numbers. If Excels guess as to which numbers you want to add is wrong, you can select the cells you want. EXERCISE 2. Auto. Sum The following illustrates Auto. Sum Go to cell F1. Type 3. Press Enter. Excel moves down one cell. Type 3. Press Enter. Excel moves down one cell. Type 3. Press Enter. Excel moves down one cell to cell F4. Choose the Home tab. Click the Auto. Sum button in the Editing group. Excel selects cells F1 through F3 and enters a formula in cell F4. Press Enter. Excel adds cells F1 through F3 and displays the result in cell F4. Perform Automatic. Calculations. By default, Microsoft Excel recalculates. This makes it easy for you to correct mistakes and analyze a variety of scenarios. EXERCISE 3 Automatic Calculation. Make the changes described below and note how Microsoft Excel automatically. Move to cell A2. Type 2. Press the right arrow key. Excel changes the result in cell A4. Excel adds cell A2 to. A3 and the new result appears in cell A4. Move to cell B2. Type 8. Press the right arrow key. Excel subtracts cell B3 from cell B3. B4. Move to cell C2. Type 4. Press the right arrow key. Excel multiplies cell C2 by cell C3 and the new result appears in cell C4. Loader Silkroad 2013. Move to cell D2. Type 1. Press the Enter key. Excel divides cell D2 by cell D3 and the new result appears in cell D4. Align Cell Entries. When you type text into a cell, by default your entry aligns with the left side of the cell. When you type numbers into a cell, by default your entry aligns with the right side of the cell. You can change the cell alignment. You can center, left align, or right align any cell entry. Look at cells A1 to D1. Note that they are aligned with the left side of the cell. Nero 12 Full Version With Key For Windows 8 more. EXERCISE 4. Center To center cells A1 to D1 Select cells A1 to D1. Choose the Home tab. Click the Center button in the Alignment group. Excel centers each cells content. Left Align To left align cells A1 to D1 Select cells A1 to D1. Choose the Home tab. Click the Align Text Left button in the Alignment group. Excel left aligns each cells content. Right Align To right align cells A1 to D1 Select cells A1 to D1. Click in cell A1. Choose the Home tab. Click the Align Text Right button. Excel right aligns the cells content. Click anywhere on your worksheet to clear the highlighting. Note. You can also change the alignment of cells with numbers in them by using the alignment buttons. Perform Advanced. Mathematical Calculations. When you perform mathematical calculations in Excel, be careful. Calculations are performed from left to right, with multiplication. EXERCISE 5 Advanced Calculations. Move to cell A7. Type 331. Press Enter. Note Microsoft Excel divides 1. The answer, 3. 0, displays in. A7. To change the order of calculation, use parentheses. Microsoft Excel. calculates the information in parentheses first. Double click in cell A7. Edit the cell to read 331. Press Enter. Note Microsoft Excel adds 3 plus 3 plus 1. The answer, 3. 6, displays in cell. A7. Copy, Cut, Paste, and Cell. Addressing. In Excel, you can copy data from one area of a worksheet and place the data you copied anywhere in the same or another worksheet. In other words, after you type information into a worksheet, if you want to place the same information somewhere else, you do not have to retype the information. You simple copy it and then paste it in the new location.