Color 1.) Select the cells you wish to modify -In this case, select cells A1-F1 again. Learning some keyboard shortcuts can help you save precious time. 2.) Under the HOME tab at the top of the page, locate the drop-down arrow next to the font size command 3.) Click on the drop-down arrow 4.) Scroll over the various font sizes and choose size 12. Size 1.) Select the cells you wish to modify -In this case, please select cells A1-F1 (Column Headers). 2.) To change the font style of the cells as well as the row and column headers, click on the PAGE LAYOUT tab at the top of the page 3.) Click the drop-down arrow next to the FONT command in the upper left corner of the screen 4.) Scroll over the various fonts and choose “ Office Classic 2-Arial-Arial” *Note: to change the font of ONLY the cells and not the row and column headers, complete the same directions just given, only under the HOME tab at the top of the page. These instructions will cover some of the more basic and widely-used formatting options available: Changing the Font Font commands will allow you to change the style, size, or color of the text you wish to alter: Style 1.) Select the cells you wish to modify. Once all the data is entered, your spreadsheet should match the image above.įormatting Data There are many different options in Microsoft Excel to format numbers, text, and the cells themselves.
#LEARN EXCEL ONLINE 2010 FREE#
*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. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.
#LEARN EXCEL ONLINE 2010 HOW TO#
Learning how to use Excel is an investment in both your personal and professional life. 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. Microsoft Excel is the most commonly used spreadsheet application. There are two main types of data that people enter into Excel: Text and Numbers.
0 kommentar(er)
