Myitlab Excel Chapter 1 Homework My Accounting

1) XL Step 1.1.1: Enter Text Application: Excel Page Number: 378 Scenario: Training Scenario 1 Score:1.00 Time Taken:08:50(mm:ss) Status : Correct Show All | Hide all 1 ) Enter the title OK Office Systems Pricing Information in cell A1. Keyboard 1. Type OK Office Systems Pricing Information in cell A1, and then press ENTER. Keyboard (2) 1. Type OK Office Systems Pricing Information in cell A1, and then press ENTER (or TAB, or DOWN ARROW). Alternatively, click the Enter button on the Formula bar. Other 1. With cell A1 selected, click in the Formula bar and type OK Office Systems Pricing Information. Click the Enter button on the Formula bar (or press ENTER). 2 ) Enter the column labels Product in cell A4 and Cost in cell B4. Keyboard 1. Click cell A4, type Product, and press TAB. 2. Type Cost in cell B4, and press TAB. Keyboard (2) 1. Type Product in cell A4, and then press ENTER (or TAB, or DOWN ARROW). Alternatively, click the Enter button on the Formula bar.

XL Step 2.1.1: Use Relative Cell References in a Formula Application: Excel Page Number: 448 Scenario: Training Scenario 1 Score:1.00 Time Taken:02:10(mm:ss) Status : Correct Show All | Hide all 1 ) Enter a formula in cell D8 that calculates the difference between the House Cost and the Down Payment using relative cell references. Copy the formula from cell D8 to the range D9:D12. Keyboard 1. Click cell D8, and type =B8-C8. 2. Click the Enter button to the left of the Formula Bar. 3. Double-click the fill handle in cell D8. Keyboard (2) 1. Click cell D8, and then type =(B8-C8) (or =(B8)-(C8) or =b8-c8 or =(b8-c8) or =(b8)-(c8) or =-c8+b8 or =-C8+B8). 2. Press ENTER (or TAB or CTRL+ENTER or click the Enter button to the left of the Formula Bar). 3. Click cell D8 (or press TAB or use ARROW keys to select cell D8), and on the HOME tab, in the Clipboard group, click Copy. Alternatively, right-click, and from the shortcut menu, click Copy. 4. Select cells D9 through D12 (or D8:D12), and on the HOME tab, in the Clipboard group, click Paste.

Leave a Comment

(0 Comments)

Your email address will not be published. Required fields are marked *