*Note: Feel free to enter some of the data horizontally along the row, instead of vertically down the column, to get practice with the different keyboard functions. Data for columns E and F will be entered later in the Formulas and Functions section.

5.) In cell E1, enter Final Grade, and in cell F1, enter Pass/Fail. 4.) In cells D1-D16, enter the following text and numbers in order starting at the top of the column, moving downward: Test 3, 93, 57, 55, 93, 80, 94, 97, 90, 79, 98, 92, 89, 77, 88, and 61.

3.) In cells C1-C16, enter the following text and numbers in order starting at the top of the column, moving downward: Test 2, 88, 56, 48, 91, 78, 86, 91, 87, 76, 95, 87, 88, 74, 84, and 58. 1.) In cells A1-A16, enter the following text in order starting at the top of the column, moving downward: Student, Heather A., Ryan A., Jack C., Colleen D., Phil E., Sara F., Tom G., Paulene G., Tim H., Dan I., Brian K., Forrest L., Morgan M., Danielle N., Beatrice S., and Class Average 2.) In cells B1-B16, enter the following text and numbers in order starting at the top of the column, moving downward: Test 1, 81, 55, 35, 87, 76, 78, 90, 67, 70, 92, 84, 80, 72, 81, and 55. You decide to use an Excel spreadsheet to accomplish this. Scenario: Suppose you are a teacher who needs an effective way to organize your student’s grades on various assignments. For some practice with entering data, follow these next steps listed: *Note: By default, text data will be left-aligned within the cell and number data will be right-aligned. There are two main types of data that people enter into Excel: Text and Numbers.

Microsoft map excel 2010