Excel - Introduction to Working with Calculations

1. Open the ExcelPractice2JohnDoe spreadsheet.
2. Right-click on the Row 5 heading.

1. From the pop-up menu click on the Insert option.

1. In Cell A5, key in Bill.
2. In Cell B5, key in 100.
3. In Cell C5, Key in 90.
4. In Cell D5, key in 95.

1. Right-click on the Row 6 heading.

1. Click on the Delete option.  This will delete the Jane’s information.

10. Click in Cell B3.

10. Hold down the shift key and click on Cell B6. This will select the range B3 through B6.

10. Move your cursor over one of the selected cells (B3, B4, B5, or B6), right-click, then click on the copy option from the pop-up menu. Using the copy option will the leave a copy the text at its current location.  If you select the cut option, the text will remove from its current location.

10. Click on Cell E3. Move your curser of Cell E3, right-click, then click on the Paste option from the pop-up menu. 

10. Double-click after the 1 in Cell E3, click the backspace key to delete the 1, then key in a 4. Now the contents of Cell E3 should be Test 4.
11. Click in Cell F3 and key in Test 5.
12. Click in Cell F4 and key in 100.
13. Move the cursor to the bottom right corner of Cell F4. The cursor will change to a black + sign.

10. After you get the black + sign, double-click your mouse. This will auto fill Bill and Sue’s test grades. 
11. Right-click on the Row 1 heading. Select the Delete option from the pop-up menu. Also, you can delete columns by right-clicking on the column heading and selecting delete from the pop-up menu.

10. Move the cursor between the Column A and Column B headings. This will change the cursor to a double left-right cursor ( ).  After you get the new cursor, double-click your mouse.  By double-clicking between the column headings, it will adjust the width of Column A to the largest value in Column A.

10. Using the directions that are listing in Step 20, adjust the column widths of Columns B, C, D, E, and F.
11. Right-click on the Column A heading and select the Column Width option from the pop-up menu.

10. Change the column width to 5 and click the OK button.

10. Select the Range A1:F1 by clicking on Cell A1, hold down the shift key, then click on Cell F1.

10. On the home tab, in the alignment group, click on the merge and center button.

10. Click in Cell A1 and key in History Grades.

1. Select the Range B2:F2 by clicking on Cell B2, hold down the shift key, then click on Cell F2.

10. On the Home tab, in the font group, click on the bold button.

10. Select the Range A3:A5 by clicking on Cell A3, hold down the shift key, then click on Cell A5.

10. On the Home tab, in the font group, click on the bold and italic buttons.

10. Select the Range B3:F5 by clicking on Cell B3, hold down the shift key, then click on Cell F5.

10. On the Home tab, in the font group, click on the down chevron beside of the font color button, then select the Blue option.

10. With the B3:F5 still selected - On the Home tab, in the alignment group, click on the Center button.

10. Key your first name in Cell A7.
11. Key your last name in Cell A8.
12. Click on the file tab, click the Save As option, select a location to save you file, change the filename to ExcelPractice2FirstNameLastName (replace your FirstNameLastName with your name).