If you right click on the column heading Excel will display a popup menu with options for changing the cell format and the cell width. Now continue entering the labels as shown below. Place the mouse cursor in cell A1 and click the left mouse button A1, and type Physics Experiment in Projectile Motion, and hit enter.

You need to understand each step that is described in order to use that information in subsequent parts of the tutorial where each step might not be explained.Ģ Labeling & Entering Data Entering Text To open a new Excel worksheet, double click on the Excel icon found on the desktop screen. The tutorial will start slow, assuming very little knowledge of Excel, but will progress quickly. The physics behind this experiment is not important for this lab it is used to demonstrate Excel in a more practical way. You will be asked to perform several calculations, graph several groups of data, and perform types of analysis. It is an experiment in projectile motion, showing the position of a projectile after being given an initial velocity and angle. Practice Experiment In order to demonstrate many of the tools in Excel, you will be analyzing data from a fictional experiment. It is also a good idea to and save this section for future reference. Each of theses tools will be used extensively throughout the laboratory, so it is very important that you understand how and why these tools are used. After completing this tutorial you should be able to navigate through Excels menus, have an understanding of the usefulness of Excel, and understand concepts such as copying and pasting, entering formulas, absolute and relative cell referencing, graphing, and regression analysis. This tutorial will cover many of the tools available in Excel that will be used during the laboratory experiments to analyze data. Many of the experiments performed in lab require the use of Excel in order to analyze the collected data. Objective The purpose of this lab is to become familiar with the Microsoft Excel spreadsheet program.

No part of this publication may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, or any information storage or retrieval system, without permission in writing from the author. Parks Department of Physics and Astronomy 401 Nielsen Physics Building The University of Tennessee Knoxville, Tennessee Copyright August, 2000 by James Edgar Parks* *All rights are reserved.

Tutorial on how to use microsoft excel