Found 295 related files. Current in page 2
Excel 2010 Modifying Columns, Rows, and Cells Page 1 Introduction When you open a new, blank workbook, the cells are set to a default size.You do have the ability to modify cells, and to insert and delete columns, rows, and cells, as needed. In this lesson, you will learn how to change row height and column width; insert and delete rows and columns; wrap text in a cell; and merge cells. Page 2 Working with Columns, Rows, and Cells By default, every row and column of a new workbook is always set to the same height and width. Excel allows you to modify column width and row height in a variety of different ways. Video: Modifying Cells, Rows, and Columns in Excel 2010 Watch the video (3:22). Need help? To Modify Column Width: 1. Position your mouse over the column line in the column heading so that the white cross double arrow . ©1998-2013 Goodwill Community Foundation, Inc. All rights reserved. becomes a Positioning mouse over the column line 2. Click and drag the column to the right to increase the column width or to the left to decrease the column width. Increasing the column width 3. Release the mouse. The column width will be changed in your spreadsheet. Increased column width To Set Column Width with a Specific Measurement: 1. Select the columns you want to modify. 2. Click the Format command on the Home tab. The format drop-down menu appears. 3. Select Column Width. ©1998-2013 Goodwill Community Foundation, Inc. All rights reserved. Increasing the column width 4. The Column Width dialog box appears. Enter a specific measurement. Increasing column width to 258 pixels 5. Click OK. The width of each selected column will be changed in your worksheet. Select AutoFit Column Width from the format drop-down menu and Excel will automatically adjust each selected column so that all the text will fit. Page 3 To Modify the Row Height: ©1998-2013 Goodwill Community Foundation, Inc. All rights reserved.
Let's consider the following example: One has measured the force necessary to extend a spring from its rest (equilibrium position) for various extensions. The goal is to find the spring constant. The theory (Hook's Law) predicts the linear dependence between the force and the change of the length of the spring: F = -kx To find the spring constant k, one needs to plot the negative force -F as a function of x and find the straight-line fit. The slope of that line is equal to the spring constant k. Finding the best straight-line fit could be quite time consuming if done with a calculator. Using Microsoft Excel program significantly simplifies the whole procedure. Follow the steps shown below to make a graph and then draw a straight line that fits your data. A. Start Microsoft Excel 2010 (or Excel 2007). B. Enter your data into Excel spreadsheet. C. Highlight all cells containing data. In our example, the first column (A) contains values of x, whereas the second column (B) contains values of force -F: D. From the "Insert" tab select "Charts - Scatter". Use the first type of scatter charts – “Scatter with only Markers”. You should see a simple plot prepared by Excel. E. Next step is to add axis labels and legend to the graph. Select “Layout” tab from “Chart Tools”. Then add a header using the “Chart Title” button and add axis labels using “Axis Titles” button (both for horizontal and for vertical axes). Optionally, you may edit or simply remove the legend. Grab and drag a corner of the graph (chart) to enlarge its size. F. The last step is to add the linear fit (a straight line fit) to your graph (chart). Click once anywhere inside the graph area. Select the “Layout” tab from “Chart Tools”. Click on the “Trendline” icon and select the “Linear Trendline” option. You should see a graph similar to this: ...
Audience Profile The Core‐level Microsoft Office Excel 2010 User should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel 2010. The core‐level user should be able to use Microsoft Office Excel 2010 to create and edit professional‐looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to: • Program/Project Managers • Accountants • Sales • Clerical, Office professionals • Students • Consultants • Other members of the general • Executives/Managers population • Help desk personnel • Instructors/Trainers Tasks that might be undertaken or work products created by members of the Microsoft Excel 2010 Core‐ level User Target Audience might include, but would not be limited to: Case studies Charting Classroom instructional materials Create analytical, financial, etc. reports Data collaboration Data entry Data formatting Data manipulation Family budget Format numerical (financial, statistical, etc.) reports Forms Graphing Instructional development Investor info and analyses Process data Recipes Reporting Studies Technical support Tracking Trending
If you haven’t already viewed Excel 2010: Creating an Accessible Excel Spreadsheet, Part 1, you’ll want to check it out to ensure you’re doing everything you can to make your Excel tables and spreadsheets accessible. In that module we described a lot of good, general practices in Excel that also improve accessibility. In this module, we go further with more tips, most of which are specifically for assistive technology screen readers like JAWS. Note: for making forms in Excel accessible, see Excel 2010: Creating Accessible Forms Parts 1 and 2 in addition to ensuring your form has covered the accessibility considerations in these two modules for spreadsheets. Further Steps to Assist with Screen Readers in Excel Screen Reader Help Text in Cell A1 Provide help text for navigation using screen readers, in cell A1. • For example, “Press TAB to move to input areas. Press UP or DOWN ARROW in column A to read through the document.” • You can make this text fairly small, or even change the color to match the background color. This way it will not show up visually, but will still be read by the screen reader. Page 1 of 6 Last Modified: 8/16/2012 9:24:00 AM 15-Excel02.docx Microsoft Office 2010 Project Accessible Excel Spreadsheets 2 Table Titles Table titles should be placed in the first column so screen readers can find them easily, as discussed in the previous module. If that looks funny you can merge cells and center them, but keep the original text in the first column. Images Ensure that any images have alternate text descriptions. Follow the steps below, or use the method for charts that we’ll discuss next. • Insert the image, then right-click and choose Size and Properties. • In the Size and Properties dialog box, choose the Alt Text tab. Type in a brief description with enough detail to explain the pictures. You don’t need to say “image of” or “picture of” because the screen reader alerts the reader that it is an image. Page 2 of 6 Last Modified: 8/16/2012 9:24:00 AM 15-Excel02.docx Microsoft Office 2010 Project • Accessible Excel Spreadsheets 2 Click Close. Charts Ensure that any charts have alternative text descriptions. This is different than images, since charts created in Excel don’t have an area for Alt Text. • Resize the row where you want to insert the chart. You may merge cells if you want. • Insert the chart. • In the cell where the chart is, type the description. This description may need to be fairly long to adequately explain the chart.
Protecting Cells in Excel 2010 A few notes before we begin: All cells in an Excel worksheet are locked by default, this way when you turn on Protect Sheet everything is safe. So you must unlock cells you would like to be able to edit before you turn on Protect Sheet 1. Open the spreadsheet you wish to protect 2. Highlight a cell, row, or column (or group of them) you would like to be able to edit after protection is turned on 3. Select the Format button in the Cells area 4. Select Lock Cell (this will toggle it off so the cell is unlocked) Page 1 of 3 Protecting Cells in Excel 2010 5. Repeat steps 2-4 until all cells that need to remain editable have been unlocked 6. Select the Format button in the Cells area 7. Select Protect Sheet… 8. Create a password to use to lock the sheet and enter it in the password field (you must remember this password to unlock the sheet at a later date) Page 2 of 3 Protecting Cells in Excel 2010 9. Click the OK button 10. Confirm the password by entering it again and click the OK button 11. Now the only cells that are editable are the ones you unlocked earlier Page 3 of 3
The Westmont Montessori School provides an environment that fosters independence, self-esteem, integrity, and personal responsibility. Our Montessori curriculum empowers each child by providing the foundation to excel academically, to develop respect for self and others, and to value the world in which we live. Self-confidence and a lifelong love of learning characterize the Westmont graduate.
Excel Metal Building Systems Inc is a Nationwide Supplier and Manufacturer of high quality, low cost Do-It-Yourself Steel Building Kits and Metal Building Systems of all sizes and specifications. We were rewarded a U.S. Patent for our Do-It-Yourself "Rigid Cee" Steel Garage kits and Metal Workshop Buildings which are available from 15' wide to 40' wide up to 16' eave heights. Excel also is one of the nations leading suppliers of Mini Storage Building Kits and Self Storage Building Kits. Excel Metal Buildings is also Accredited through the Better Business Bureau.
EE122 - Introduction to Electronic Circuit Design Prof. Greg Kovacs with Amy Droitcour and Bob Ricks Department of Electrical Engineering Stanford University About EE122 • “Curiosity-driven” laboratories with a flexible structure. • A team-based approach to learning. • Practical, rather than theory-driven content. • Preparation for laboratories will involve team research and analysis, rather then lengthy write-ups. • An informal lab-book-based approach to taking data. • No formal examinations (midterms or final), with grading based on laboratory notebooks, teamwork, and final project. • Final project with a full three weeks provided for design and construction. • Final demos given by each team to the entire class. EE122, Stanford University, Prof. Greg Kovacs 2 An introduction to gEEk culture. EE122, Stanford University, Prof. Greg Kovacs 3 EE122 Course Goals • Analog circuit design knowledge. • Introduction to sensors. • Working knowledge of interface electronics (to the “real world”). • Developing circuit design intuition. • Experience with teamwork in experimentation, documentation and design. EE122, Stanford University, Prof. Greg Kovacs 4 Basic Things You Have to Handle • Know how to use Excel (how to enter data and how to make plots). • Know how to use Word (including importing graphics) and how to generate PDF files. • Find a form of SPICE that you are comfortable with (B2Spice, PSPICE, HSPICE, or whatever). TA’s will help. • Get a copy of Horowitz and Hill, “The Art of Electronics.” EE122, Stanford University, Prof. Greg Kovacs
Impreza WRX | STI WRX/STI Life moves fast. Don’t slow it down with a car you can’t trust. At Subaru, we build each of our vehicles with the highest standards of manufacturing, and with designs that are inherently tough and resilient. It’s why our It’s not disposable. It’s family. vehicles excel in the extreme rigors of rally racing. And why 96% of all the vehicles we’ve built in the last 10 years are still on the road today.1 It’s also why Subaru owners are so likely to stay Subaru owners for years and years. What’s more, keeping cars on the road means they stay out of landfills longer. And if we can make the world a cleaner and greener place while making cars that inspire and motivate their drivers, we’ve done our job. Find out more about our efforts to keep it cleaner and greener. subaru.com/environment 1 Based on Polk registration data in the U.S. 2002–2011. Love. It’s what makes a Subaru, a Subaru. This brochure is printed in the U.S.A. on 10% recycled paper. ©2012 Subaru of America, Inc. 13.WRX.SRB.525 (S-13482, 87K, 7/12, CG) Subaru Impreza WRX STI Subaru Impreza WRX The edge is just the beginning. We start with an insatiable desire to bring performance to the people. We take it to the limit with the streetscorching Impreza WRX, then push it unbelievably farther with the g-defying WRX STI. Which stirs you?
HOW TO GET TO SALON INTERNATIONAL EXHIBITION TICKETS Exhibition Entrance Tickets must be purchased before you can buy any Salon Live, Salon Seminar or Business Extra tickets. No. of tickets £ Total Advance one day entrance ticket (£28+VAT on door) Advance three day season ticket (£55+VAT on door) TICKETS £20+VAT £41+VAT £ Student ticket (group booking of 10+ Monday only) (Call box office in advance to make group bookings) +VAT £ £10 Online www.salonexhibitions.co.uk Phone 0844 894 2000 (UK) or +44 (0)20 7744 2000 (Int’l) Individual Student entrance ticket (Monday only £16+VAT on door) +VAT £ £14 Fax +44 (0)870 013 0231 Total number of entrance tickets ordered £ Post Salon International, ticketSOUP, Glasgow G3 8YW Total number of Salon Live tickets £ Total number of Salon Seminar tickets £ SATURDAY 12 OCTOBER SUNDAY 13 OCTOBER MONDAY 14 OCTOBER Total number of Business Extra tickets 9.30 – 17.00 9.30 – 18.30 9.30 – 17.00 VAT £ Booking fee £5 (inc VAT) 1 £5 Postage option Please use this colour denominator as a guide to the timetable below. SATURDAY 12 OCTOBER 11:00 - 13:00 Mahogany 13:00 - 14:00 Philip Kingsley Trichology Taster seats £77+VAT seats £20+VAT 13:00 - 14:30 Saco seats £73+VAT 14:45 - 16:00 Sassoon Academy seats £81+VAT 15:00 - 16:00 Philip Kingsley Trichology Taster [UK only] Standard Post BY AIR Express trains connect Heathrow, Gatwick, Stansted and Luton airports to central London, from which you can switch to the London Underground and then to the Docklands Light Railway. City Airport is a five minute taxi ride away. You can find out more at www.excel-london.co.uk/visitors/travel [UK only] Special Delivery £ 6.30 (inc VAT) [Int’l only] International Signed for £ 8.30 (inc VAT) EXCEL London is not located within the Congestion Charge Zone. Please visit www.cclondon.com for more information. For Sat Nav, we recommend using postcode E16 1DR. £ 2.30 (inc VAT) (Please select one) GRAND TOTAL £ All ticket prices are exclusive of VAT. Booking fee and postage prices are inclusive of VAT. PLEASE ENSURE YOU ADD UK VAT AT THE PREVAILING RATE TO ENSURE YOUR ORDER IS PROCESSED. Orders cannot be processed unless accompanied by payment in one of the following ways: Credit card or Sterling cheque drawn on a UK bank for the grand total made out to ticketSOUP. We do not cancel, exchange or refund tickets. A £5 transaction booking fee will apply per order. We regret that children under 12 and pushchairs cannot be admitted. For travel and accommodation arrangements call Jigsaw Conferences on +44 (0)870 62 60 148 or email firstname.lastname@example.org and quote ‘Salon 2013’ to benefit from our specially negotiated discounts. PLEASE NOTE Last date for advance overseas ticket orders – Monday 23 September 2013. Advance ticket prices are only available on bookings made by Friday 11 October at 9pm BST, either online or via our Box Office. Tickets purchased after this time will be charged the full rate.