Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Referencing Data

Now that all of the billable hours are displayed, you can use that information in another table. Let’s add a second, reporting table to this sheet so that you can compare the total hours worked with the billable hours.

1.
In the toolbar, click the Tables button and choose Sums.

A new table is added to the sheet.

2.
In the Sheets pane, double-click the table name to select it and rename the table Report.

Let’s style this table to match the first table.

3.
Click the Beige button to apply the identical table style. Drag the table so that it is aligned with the first table.

4.
Label the first three header row cells as follows: Time, Billable Time, and Ratio.

Let’s remove the unused column.

5.
Select column D; then click the cell reference pop-up menu and choose Delete Column.

6.
In the Report table, click cell A2. This is where the billable time will be added.

7.
Press the = (equal sign) key to open the Formula Editor.

8.
In the Billable Hours table, drag to select cells D3 through D36.

The formula should read =SUM(Billable Hours :: D3:D36). SUM is a basic function that adds the range of selected cells. You’ll explore functions in depth later in this lesson.

9.
Press Return. The cell should display a value of 2550 minutes.

Let’s perform a similar calculation for the next column.

10.
In the Report table, click cell B2, and then press the = (equal sign) key to open the Formula Editor.

11.
In the Billable Hours table, select cells E3 through E36.

The formula should read =SUM(Billable Hours :: E3:E36).

12.
Press Return. The cell should display a value of 2100 minutes.

13.
Let’s remove the unused cells. Drag up the Column and Row handle for the table so that it is three rows by three columns.

14.
In the Report table, click cell C3 and press the = (equal sign) key.

15.
Enter the following formula: =B3/A3. Press Return.

You have successfully created a new table. By formatting the Report table, you can make displayed values easier to understand.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint