Transcription

Microsoft Excel 2010Lesson 1: IntroductionMicrosoft Excel is a spreadsheet program that enables us to organize and make calculations withlarge amounts of data.When you open Excel, you willsee something like this picture.The Ribbon that you see willdepend on the tab that is active.The Home ribbon is illustrated inthe picture at the right.The basic element of an Excel worksheet is a cell. The cells are arranged in rows (labeled withnumbers) and columns (labeled with letters). Each cell is designated by its column and row – thecell shown above is called C3, for example. Many of the icons on the ribbons have the samefunction as on other Microsoft products. A few, some of which we will encounter in theselessons, are limited to Excel.Entering TextClick on cell A1 to select it and type in the phrase “ExampleWorksheet.” Notice that the entry is displayed both in the cell and inthe formula bar.Press twice on the down arrow key on the keyboard to move thecursor down to cell A3.Entering DataThe cursor now should be on cell A3. Type in the number 12.46.After you have entered the number, press the down arrow key on thekeyboard to move the cursor down to cell A3. Enter more data as shownhere.Excel: IntroductionOctober 15, 20121

Correcting an ErrorIn the cell A9, make a typing error by entering the number with a commarather than a decimal point (34,56). It is evident that something is wrongbecause the “number” is displayed left-justified in the cell, indicatingthat Excel has interpreted the entry as text rather than as a number.Click on the cell with the error and move the cursor up to theformula bar, so that it is to the right of the comma.Press the backspace key (BkSp) on the keyboard to erase thecomma and then type a period. This will correct the error.Press the Enter key and then the down arrow key to move thecursor to cell A11.Calculations with the AutoSum FunctionLet’s add the seven numbers in cells A3 through A9 and place the sum in cell A11. With thecursor in cell A11, click on the AutoSum function button in the Home ribbon.Excel: IntroductionOctober 15, 20122

When you choose the AutoSum function in a cell, Excel looksfor numbers in either the row or column shared by the cell. Itchooses a range beginning with the most distant number in therow or column and adds all of themIn this example, you will see cells A3 through A10 surroundedby a dotted line, indicating that these cells are in the rangebeing summed.The formula SUM(A3:A10) in cell A11 designates the sumof all numbers in cells A3 through A10.Press the Enter key to calculate the sum.Deleting the Contents of a CellOther functions also are available. Let’s erase the contents of cellA11 and use another function these. Move back to cell A11 andpress the Delete key on the keyboard to delete the contents of thecell.Excel: IntroductionOctober 15, 20123

Calculations with Other FunctionsClick on the Function button at the left of the formula bar.Suppose that you want to calculate the average ofthe numbers in cells A3 through A9. Select theStatistical function category and the AVERAGEfunction name. Click on OK.Next you will see the FunctionArguments window. Thefunction arguments default to thesame range of numbers as for theAutoSum: A3 through A10. Thefunction also is shown in theformula bar: AVERAGE(A3:A10)We could change the range to A3:A9, but in this case it doesnot matter. The AVERAGE function ignores blank cells whencalculating the average.Click on OK in the Function Arguments window.Excel: IntroductionOctober 15, 20124

Formatting TextYou can change the format of text. Suppose that we want the titleof the worksheet to be larger and to be emphasized in bold. Movethe cursor to cell A1 and, in the Home ribbon, click on the smalltriangle at the right of the font size box in the formatting toolbar.Choose 12-point text.With the cursor still on cell A1, click on Bold icon in the Homeribbon.Finally, with the cursor in cell A1, hold down the Shift key andclick on cell I26. This will select all the text between these cells.Choose Arial font.Changing the Decimal Places in a NumberYou also can change the format of numbers.You may want to change the number ofdecimal places displayed for one or morenumbers, for example. In our exampleworksheet, the data have only two decimalplaces, but the average is displayed with fivedecimal places – more significance than isjustified for the calculated number. We wouldlike to display the average so that it too isdisplayed with only two decimal places.Click on cell A11. In the Home ribbon, clickon the Decrease Decimal icon three timesuntil it becomes 59.43.Excel: IntroductionOctober 15, 20125

NOTE: Although the number in cell A11 is only displayed with two decimal places, Excelactually retains many more decimal places for the number than this. The format of a numberchanges only what you see on the screen, not what is in the computer’s memory.Saving a WorksheetClick on the File and and Save As.Save the file on your H: drive as an Excel Workbook with the name“MySS”.Excel: IntroductionOctober 15, 20126

Oct 15, 2012 · Excel: Introduction October 15, 2012 1 Microsoft Excel 2010 Lesson 1: Introduction Microsoft Excel is a spreadsheet program that enables us to organize and make calculations with large amounts of data. When you open Excel, you will see something like this picture. The R