• Microsoft Excel - Assignment #1 - Ecology

     
If you are having trouble viewing the document, you may download the document.
  • See below the How to Hints below for the directions and assignments. 
     

     
     

    How do I Insert a new column or row?

    1. Click on the column heading Letter that you want to add a column to the left of.

    2.  Right click on it, click on insert.  Column with automatically be added to the left or the selected row.

    or

    1.  Click on the row heading number that you want to add a row above it.

    2.  Right click on it, click on insert.  Row with automatically be added above the selected row.

     

    How do I rotate text in a cell?

    1.  Highlight cells you want to rotate

    2.  Right click, select format cells

    3.  Click on the alignment tab

    4.  At the top right corner, drag the text orientation handle to the desired degree.

     

    How do I print with gridlines and/or column/row headings?

    1.  Go to the Page Layout tab

    2.  Click on Page Setup drop down menu

    3. Click on sheet tab, check the appropriate boxes

    4. Click on OK

     

    How do I print the worksheet centered vertically and horizontally on the page?

    1. Click on the Page Layout tab

    2. Click on Page Setup

    3. Click on the margins tab

    4. Check the boxes for vertical and/or horizontal centering

     

    How do I put my name in the footer?

     1.  Go to the Page Layout tab

    2.  Click on Page Setup drop down menu

    3. Click on Header/Footer tab and click Custom Footer

    4. Put your name in the left section and the filename in the center section.  Click on OK 

     

    How do I complete a formula sheet?

    1. Copy the tab that contains your work

    2. Rename the tab FORMULAS

    3. Hold down the Control and the ~ key

    4. Shrink the columns not needed.  This page should fit onto one page.  If it still doesn’t, you may change the orientation of the page or decrease the margins of the page. 

     


  • Contact Mrs. Cashman at mcashman@lrhsd.org or 609-654-5111 ext. 8454