1) Enter the data exactly as shown above into the Claris spreadsheet.

• to change the width of a column, position the cursor on the right-hand column border in the gray band at the top (where the letters marking each column are located) The cursor should now be a cross-hairs symbol. Hold down the mouse button, drag the line to the desired location, and then release.

2) Find the car with the median cost (the middle value when the data is in numerical order).

• Sort the data in ascending order by the cost of the car:
  • holding down the mouse button, highlight all of the entered data EXCEPT the 1st row
    
  • under the Calculate menu, select Sort...
    
  • in the box marked "1st", replace the A2 with D2, then click OK
    
  • the car that is now in the middle is the median value

3) Compute the average for each column of numbers:

• select the empty cell in which you would like the result to appear (probably below the column of data you wish to average)
  
• from the Edit menu, select Paste Function...
  
• select AVERAGE(number1, number 2,...) and click OK
  
• in the entry bar at the top of the spreadsheet, select the area between the parentheses by holding down the mouse button and highlighting the area
  
• in the spreadsheet, hold down the mouse button and drag the cursor over the cells you wish to average, then press Return
  
• fill the AVERAGE function across the other 2 columns:
  • place the cursor in the cell you entered the AVERAGE formula into and drag the cursor across the other 2 columns while holding down the mouse button
    
  • under the Calculate menu, select Fill Right

• change the number format:
  • highlight the cells containing the averages
    
  • under the Format menu, select Number...
    
  • click the circle next to Fixed
    
  • in the box labelled Precision, type 2

4) Insert a row of cells to separate the averages from the rest of the data:

• at the left of the spreadsheet, click on the row number for the row containing the average values
  
• under the Calculate menu, select Insert Cells...
  

5) Create a graph of cost vs. car:

• insert a column of cells between the Car and Acceleration sec. columns:
  • select the Acceleration sec. column by clicking on the column letter at the top of the spreadsheet
    
  • under the Calculate menu, select Insert Cells...

• Copy the Cost column and Paste it into the empty column of cells to the right of the Car column:
  • use the mouse to highlight the Cost column (do not highlight the average)
    
  • under the Edit menu, select Copy
    
  • move the cursor to the top of the empty column next to the Car column
    
  • under the Edit menu, select Paste
    
    
• use the mouse to drag the cursor over the Car and Cost columns to select them both
  
• under the Options menu, select Make Chart...
  
• select Bar from the Gallery and then select Labels under Modify
  
• in the Title bar enter "Car Prices", then click OK
  
• to better see the car names, expand the graph by dragging the corners left or right.
  
• OR (an alternative to help better see the car names) turn the graph sideways (horizontally)
  • double click on the graph to pull up the Chart Options. Under Gallery check the box for Horizontal. Click OK.

6) Label the axes of the graph:

• double-click on the graph
  
• select Axes under Modify
  
• select X-axis and enter "Car" in the Axis label box
  
• select Y-axis and enter "Price" in the Axis label box, then click OK
  

The table below gives combined ratings of eight staff members of Car and Driver magazine in a test of compact automobiles.

1) Enter the data exactly as shown above into the Claris spreadsheet.

2) Average the numbers in each row and each column:

• position the cursor in the cell at the end of the first row of numbers
  
• under the Edit menu, select Paste Function...
  
• select AVERAGE(number1, number2,...) then click OK
  
• in the entry bar at the top of the spreadsheet, select the area between the parentheses using the mouse
  
• In the spreadsheet, hold down the mouse button and drag the cursor across the row of cells containing the data you wish to average, then press Return
  
• fill the AVERAGE function down for all the rows:
  • position the cursor in the cell you have entered the AVERAGE function into and drag the cursor down through the last row of numbers while holding down the mouse button
    
  • under the Calculate menu, select Fill Down

• go back to the top of the column and type "averages" in the empty cell
• position the cursor in the cell beneath the first column of numbers
  
• under the Edit menu, select Paste Function...
  
• select AVERAGE(number1, number2,...) then click OK
  
• in the entry bar at the top of the spreadsheet, select the area between the parentheses using the mouse
  
• In the spreadsheet, hold down the mouse button and drag the cursor down the column of cells containing the data you wish to average, then press Return
  
• fill the AVERAGE function across for all the columns:
  • position the cursor in the cell you have entered the AVERAGE function into and drag the cursor across through the last column of numbers while holding down the mouse button (do not include the averages column)
    
  • under the Calculate menu, select Fill Right
    
  • if necessary, change the number format (see part one for directions)

3) Make a scatter plot of Fun to drive vs. Ergonomics:

• select the last 2 columns (Ergonomics and Fun to drive) by highlighting them with the mouse (include the column titles)
  
• under the Options menu, select Make Chart...
  
• select X-Y Scatter from the Gallery and select Labels under Modify
  
• click the box to the left of Legend such that it no longer has an X, then click OK
  
  

4) Make a bar graph of average rating vs. car type:

• highlight column B by clicking on the letter B at the top of the spreadsheet
  
• under the Calculate menu, select Insert Cells...
  
• copy the column of averages by selecting the data in the averages column and selecting Copy under the Edit menu
  
• position the cursor in the cell at the top of column B, and then select Paste Special... under the Edit menu
  
• select Paste Values Only and click OK
  
• select the first two columns (now Car and averages) by highlighting them with the mouse
  
• under the Options menu, select Make Chart...
  
• select Bar from the Gallery and then select Labels under Modify
  
• in the Title bar enter "Car averages", then click OK
  
• to better see the car names, expand the graph by dragging the corners left or right

5) Go back and label the axes of the graph:

• double-click on the graph
  
• select Axes under Modify
  
• select X-axis and enter "Car type" in the Axis label box
  
• select Y-axis and enter "average rating" in the Axis label box, then click OK

The table contains data on the LA Lakers basketball team taken from the 16 December 1989 Los Angeles Laker - Boston Celtic game. FG indicates field goals, FT is free throws, R is rebounds, A is assists, and T is total points.

1. Enter the data exactly as shown above into the Claris spreadsheet.

2. Add the data in each column:

• select the cell beneath the column of data you want to add
  
• then enter an equal sign (=) followed by the individual cells you want to add

  - for example: =B2+B3+B4+B5+B6+B7

• then press Return
  

OR (alternate method for adding cells)

• select the cell beneath the column of data you want to add
  
• under the Edit menu, select Paste Function...
  
• select SUM(number1, number2,...) then click OK
  
• in the entry bar at the top of the spreadsheet, select the area between the parentheses using the mouse
  
• in the spreadsheet, hold down the mouse button and drag the cursor down the column of cells containing the data you wish to add, then press Return
  
• fill the SUM function across for all the columns you wish to sum:
  
• position the cursor in the cell in which you have entered the SUM function and drag the cursor across through the last column of numbers while holding down the mouse button
  
• under the Calculate menu, select Fill Right
  
  

3. Divide cells to determine the overall percentage of Field Goals or Free Throws made:

• select the cell in which you would like the answer to appear
  
• enter the equal sign (=) followed by a formula that describes the division of total Field Goals (Free Throws) by Field Goal (Free Throw) Attempts
  
• for example, if total Field Goal Attempts is in cell C8 and total Field Goals is in cell B8, the formula is: =B8/C8*100
  
• press Return
  
• if necessary, change the number format
  

4. Make a Pie Chart of points scored by each player.

• insert a column of cells between the Player and FG columns:
  • click on the FG column letter at the top of the spreadsheet (in this case B)
    
  • under the Calculate menu, select Insert Cells...
    
    
• Copy the T column (do not include the sum at the bottom of the column) and Paste it into the empty column of cells to the right of the Player column
  
  • use the mouse to highlight the T column
    
  • under the Edit menu, select Copy
    
  • move the cursor to the top of the empty column (column B)
    
  • under the Edit menu, select Paste
    
• use the mouse to highlight over the Player and T columns to select them
  
• under the Options menu, select Make Chart...
  
• select Pie from the Gallery and then select Labels under Modify
  
• in the Title bar enter "Player points", then select Series under Modify
  
• check the box marked "Label data", then click OK