Excel+2007+Tutorial-1

Excel+2007+Tutorial-1 - USING MICROSOFT EXCEL2007 Microsoft...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
U SING M ICROSOFT E XCEL ®2007 Microsoft Excel®2007 may be downloaded free of charge at http://iuware.iu.edu . Make sure that a complete download is successful, as the statistical tools required for the course may be omitted in condensed versions of the software. Please refer to Appendix B in the laboratory manual or Microsoft® Office Online ( http://office.microsoft.com/en-us/excel ) for additional assistance. The “Help” icon ( ) may be pressed for assistance as well. Many of the features are nearly identical between the 2003 and 2007 versions, including but not limited to the general appearance of the spreadsheet, entering data, as well as the organization of the data. This sheet is intended to provide a specific guide through the 2007 version of Excel, as there are minor differences in navigating through the software for applications used frequently in C125. This sheet was prepared using a PC, thus there may be minor differences on Macintosh computers or computers with Vista. Saving Data Use the mouse pointer to select the Windows icon ( ) and click Save ( ). A dialog box appears that will indicate that you need to name your file, select the type of file, and select the destination of your file. Type an appropriate name and hit return or click Save. (The file type will be the default Excel workbook; you may want to save the file as an Excel 97-2003 workbook which may be universally accessed on most campus computers.) Make it a point to periodically save your data. Adjusting Decimal Places on Entered Data Excel automatically illustrates data with the fewest number of decimal places; however, this may conflict with the number of significant digits that are required for an experiment. For example, the concentration below should read 1.0M; however, Excel will adjust this to 1M. In order to add decimal places, select the data to be adjusted and click the Increase Decimal icon ( ). Every click of this icon will add a trailing zero to your data. Repeat clicking until the data match the desired significant digits. G RAPHING THE DATA Selecting the data to be graphed Use the mouse pointer to click and drag over the data thereby highlighting it. If you are constructing a calibration curve, do not include any of the unknown y -points at this time. To plot the data points
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Highlight the data and axis labels for the plot. Click the Insert tab on the top of the screen. Within the Chart area, click the Scatter icon ( ). Select the Scatter with only Markers icon ( ) from the drop down options. A plot with the default settings for the chart title, axes, along with the data points will appear on the screen. In order to adjust the formatting of the graph, select the Layout tab on the top of the screen.
Background image of page 2
F ORMATTING THE C HART (Layout tab) 1. Chart Title: The default title is the y-axis label. This will need to be adjusted to y vs. x. Click on the title text and pause for the text box to appear. Click on the formula box, and modify the default
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 10

Excel+2007+Tutorial-1 - USING MICROSOFT EXCEL2007 Microsoft...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online