Which location on the ribbon contains the commands for adding a table to a document responses?

Formulas and PivotTables. Many of us have gotten caught up creating formulas outside of a PivotTable by referencing cells within a pivot table, only to be disappointed when we update our PivotTable and cells shift back and forth. There are several ways of dealing with this issue. One way is to create a Calculated Field within your PivotTable. This is something we cover briefly in Excel PivotTables sessions, but it is definitely worth a review.

Exercise File

If you would like to follow along, here is an exercise file:

CalculatedFieldDownload

This document contains two sheets: one sheet contains the PivotTable, and the other contains the source data, showcasing a couple years of dessert sales. Right now, you have income and expense information in the values of the PivotTable. Since we have those figures handy in our data, it would be nice to figure out net income.

For this Byte, I am assuming you are comfortable with PivotTables in Excel. If you are not, please come attend my PivotTables, Charts, and Pictures sessions! Sessions are listed in myTraining and are updated regularly.

PivotTable Contextual Tabs

We are going to be working a lot with the PivotTable Tools contextual tabs. Like any other contextual tab in Microsoft, remember that you need to click on the element to see the corresponding contextual tab(s).

When you click on the PivotTable, you should see two contextual tabs for PivotTable Tools: Analyze and Design.

Be sure you can see these tabs before moving on to the next step.

Inserting a Calculated Field

Remember, our end goal is to create a Net Income field that will subtract the Expenses from the Revenue.

1. With the PivotTable Tools activated, go to the Analyze tab, Calculations Group.

2. Select the dropdown for Fields, Items & Sets and select Calculated Field.

3. In the popup screen that appears, you will see all the PivotTable fields listed at the bottom of the screen. At the top is an opportunity to name the field and a space for a formula.

4. Click in to the Name box and change Field1 to Net Income.

5. Click in to the Formula box, and double click on Revenue in the Fields area. Type a “-” on your number pad, and double click on Expense. We are building a formula that will read: = Revenue – Expense.

6. Press Add.

7. Press OK, and look at the field you just created incorporating a formula from two other fields. Pretty cool!

Notes

• PivotTable Fields: You will see this calculated field appear in the Values section of your PivotTable Fields.

• Calculations from Calculations: If you are creating another Calculated Field, you will see the Net Income field we just created as a field option for use in future formulas.

Thoughts?

What do you think? Can you incorporate Calculated Fields into your PivotTables? I would love to hear from you!

Open Labs

Did you know that Applications Training has open labs every other week? Whether you have a Banner question or a Microsoft question, feel free to stop by! Open lab times are listed in myTraining under the title Open Lab Assistance on Banner 9, Time Entry, Reporting, & Microsoft/Adobe.

Congratulations, Power Users!

Congratulations to our newest Power Users! For the full gallery, and more information about the WSU Microsoft Office Power User Program, please visit: wichita.edu/poweruser

01microsoftofficeword2007introductionandparts 130906003510- from Emmanuel Alimpolos

When you insert or select a table in Microsoft Publisher 2010 the Table Tools contextual tab will become available on the ribbon. This tab contains two tabs, Design and Layout that give you the ability to quickly format your table, insert or delete rows and columns, set the alignment for cells, and format the typography of the text in your table.

Design tab

The Design tab includes table formatting, cell and table borders, arranging the table on the page, and the size of the table.

Tip:  You can hover over tools to see a short explanation of the tool’s functionality.

Table Formats

The Table Formats group contains a gallery of pre-set formats that you can apply to your table. By resting your pointer over each of the preformatted table styles, you can preview what the table will look like.

1. Click in the table that you want to format.

2. Under Table Tools, click the Design tab.

3. In the Table Formats group, rest the pointer over each table style until you find a style that you want to use.
   

   Note:   To see more styles, click the More arrow.

   

4. Click the style to apply it to the table.

Borders

You can add or remove borders to format a table the way that you want.

Add table borders

1. Under Table Tools, click the Design tab.

2. To change the weight of the borders, select from the Line Weight pull-down menu in the Borders group.

3. To change the color of the borders, select from the Line Color pull-down menu in the Borders group.

4. Then, in the Borders group, click the Borders and select the border options you want.

Remove table borders from the whole table

1. Select the table.

2. Under Table Tools, click the Design tab.

3. In the Borders group, click Borders, and then click No Border.

Add table borders to specified cells only

1. Select the cells that you want.

2. Under Table Tools, click the Design tab.

3. In the Borders group, click Borders, and then select the border options you want.

Remove table borders from specified cells only

1. Select the cells that you want.

2. Under Table Tools, click the Design tab.

3. In the Borders group, click Borders, and then click No Border.

Arrange

In the Arrange group you can set text wrapping around the table, bring the table forward or backwards relative to other objects on the page, align the table on the page or relative to margin guides, group and ungroup the table with other objects, and rotate the table.

Size

In the Size group you can adjust the Height and Width of the cells in your table. If the Grow to Fit Text check-box is selected the row height will automatically increase as needed to fit text.

Layout tab

The Layout tab includes a selection tool for cells, rows, columns, and the entire table; tools to delete or insert rows and columns; tools to merge or divide cells; cell alignment and margin settings; the typography controls for Open Type fonts.

Select

The Select tool enables you to quickly select a cell, column, row, or the entire table. The View Gridlines tools will show or hide the gridlines between the cells in your table.

Rows and columns

The Rows & Columns group contains tools for deleting and inserting rows and columns in your table.

Delete

The delete tool can delete the rows or columns of the currently selected cell, or you can delete the entire table.

Insert

There are four insert tools:

• Insert Above will insert rows above your current selection. If you have cells in two rows selected it will insert two rows above the top cell.

• Insert Below will insert rows below your current selection. If you have cells in two rows selected it will insert two rows below the bottom cell.

• Insert Left will insert columns to the left of your current selection. If you have cells in two columns selected it will insert two columns to the left of the left cell.

• Insert Right will insert columns to the right of your current selection. If you have cells in two columns selected it will insert two columns to the right of the right cell.

Merge

The Merge group enables you to merge and split cells in your table, including splitting cells diagonally.

• Merge Cells allows you to merge two or more selected cells.

• Split Cells allows you to split previously merged cells back into individual cells.

• Diagonals allows you to split individual cells diagonally either down to the right or up to the right. You can also merge diagonally divided cells by selecting No Division.

Alignment

The Alignment group gives you control over the alignment, direction, and hyphenation of text within table cells, and control of cell margins.

Typography

The Typography group gives you advanced typographic controls for some Open Type fonts, as well as the ability to use Drop Caps. For more information on the typography feature please see Use typographic styles to increase the impact of your publication.

Which location on the Ribbon contains the commands for adding a table to a document?

The Insert Tab Groups contain the commands most commonly associated with adding something to the document.

Which tab on the Ribbon contains the command to add a symbol to a document?

The Insert tab is used to insert or add extra features to the document, such as pictures, shapes, pages, symbols, etc. Icons and text are used to identify these options.

Which tab on the Ribbon contains the command for creating a table of contents?

Navigate to the References tab on the Ribbon, then click the Table of Contents command. Select a built-in table from the menu that appears, and the table of contents will appear in your document.

What Ribbon bar that contains table?

Inserting a table is easy. On the Insert tab of the Ribbon, in the Tables group, there is a single Table button, which opens the Insert Table menu.