Chapter 4 Vocabulary

Table Tools Contextual tab

15. Table Tools Contextual tab - Whenever you select a cell inside a table, you will notice a new tab appearin the ribbon labelled Table Tools Design. This is a contextual tab and only appears when a tableis selected. When the active cell moves outside the table, the tab will disappear again.

Table Tools Contextual Tab

A Contextual Tab is a tab that displays when certain features are applied to a document. This tab will display when a table has been created in a document. There are two ribbons associated with this tab, the Design Tab and the Layout Tab. This document will describe the tabs, groups and buttons that are available on the Layout Tab. This tab is used to apply different formatting features to a table.

Callouts

A callout is a type of text box that also includes a line for pointing to any location on the document. A callout is helpful when you need to identify and to explain parts of a picture.

Export a Table

A table, query, form, or report. The data, including the formatting. The workbook isoverwritten by the exported data. All existing worksheets are removed, and a new worksheethaving the same name as the exported object is created. The data in the Excel worksheetinherits the format settings of the source object

Convert to Range

After you create an Excel table, you may only want the table style without the table functionality. To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet. Click anywhere in the table and then go to Table Tools > Design on the Ribbon.>> In the Tools group, click Convert to Range OR Right-click the table, then in the shortcut menu, click Table > Convert to Range.

Custom Sort

Allows you to view your data in different ways. Follow these steps: Select the columnsto sort. ..., In the ribbon, click Data > Sort. In the Sort popup window, in the Sort by drop-down,choose the column on which you need to sort. ... From the Order drop-down, select Custom List.In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet.

Name Range

Create Excel names that refer to cells, a constant value, or a formula. Use names in formulas, or quickly select a named range.

Fill Series

Fills the selected range of cells in the spreadsheet with a series of numbers, characters, or dates.

Lock Tracking

On the Review tab, go to Tracking and select Track Changes. When Track Changes is on, deletions are marked with a strikethrough, and additions are marked with an underline. Different authors' changes are indicated with different colors. When Track Changes is off, Word stops marking changes, but the colored underlines and strikethrough from your changes remain in the document until they're accepted or rejected.

Table Layout

You can create a custom look for tables by splitting or merging cells, adding or deleting columns or rows, or adding borders. If you're working with a long table, you can repeat the table headings on each page on which the table appears. To prevent awkward page breaks that disrupt the flow of your table, you can also specify just how and where the table should break across pages.

Get External Data

data that exists outside of the Excel workbook. Examples: data stored on web pages, in text files, or in other programs.

Alignment

how your text or numbers are positioned in the cell. ... You can align vertically, meaning towards the top, the middle or the bottom. And you can also align horizontally, meaning to the left, the center or to the right. Excel actually has its own defaults for alignment.

Bullets

icons used to organize and draw attention to text.

Page Breaks

marks the point at which one page ends and the other begins, located in Layout tab, Page Setup group.

Wrap Text

means displaying the cell contents on multiple lines, rather than one long line.

Numbered Lists

numbering lists to organize and draw attention to text

Column-alphabetical

on the top of the worksheet

Copy

puts a copy of the selection on clipboard so you can paste it in another location.

Cut

removes the selection and puts it on the clipboard so you can paste it to another location.

Non-Continuous Range

scattered cells, not next to or adjoined to each other.

List Level

used to organize or create an outline within the text.

Name Manager

used to work with all the defined names and table names in a workbook

Row-numerical

-numbered on the left side of the worksheet

Table Properties

All Excel tables have a style applied by default, but you can change this at any time.Select any cell in the table and use the Table Styles menu on the Table Tools tab of the ribbon.*** To use a table without formatting, select the first style in the styles menu, which is called "None"

Workbook

Excel auto names a blank workbook as "Book 1 - Excel" and consists of one Worksheet called Sheet 1.

Sort & Filter

The filter tool gives you the ability to filter a column of data within a table to isolate thekey components you need. The sorting tool allows you to sort by date, number, alphabetic orderand more.

Data

information that is stored in any spreadsheet program such as Excel or Google Sheets.

Insertions

- Comment Insertion is used when you share a document with someone else to have them check it for errors or comment on how to make the document better. (Others may "see" what you did not.)

Header Row

- Row header or Row heading is the gray-colored column located on the left side ofcolumn 1 in the worksheet which contains the numbers (1, 2, 3, etc.) where it helps out to identifyeach row in the worksheet. Whereas column header is the gray-colored row, usually it will beletters (A, B, C, etc.

Deletions

- To delete all the comments in the document, go to the Review tab, click the down-arrow on Delete, and choose Delete All Comments in Document.

Formatting

- You can also tract if formatting has been changed and view the changes before accepting or rejecting.

Fill Handle

- a feature in Excel that enables you to auto-complete a list in a row/column by simply dragging (+ ) it using your mouse.

Table Style

- can be set from the Ribbon by clicking on the subgroup SYLES, and then select Cell Styles.

Endnotes

- noun. a note, as of explanation, emendation, or the like, added at the end of an article, chapter, etc.

Orientation

- refers to how output is printed on the page. If you change the orientation, the onscreen page breaks adjust automatically to accommodate the new paper orientation.

Spreadsheet

-a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions

Table of Content

-an organized listing of the chapters and major sections of your document. Readers will immediately be able to see how your manuscript is organized and then skip down to sections that are most relevant to them.

Contiguous Range

-cells adjacent (next to or adjoining) to each other

17. Win/Loss

-chart displays positive and negative values with different colors which can help you to view the trends of multiple data. View material

Remove all table functionality

Below are the steps to remove the Excel table formatting:Select any cell in the Excel table, Click the Design tab (this is a contextual tab and only appearswhen you click any cell in the table), In Table Styles, click on the More icon (the one at the bottom ofthe small scrollbar), and then click on the CLEAR option.

Microsoft Excel

a digital application software designed in a menu driven, grid format that is used to hold data for the purpose of mathematical calculations.

Paste Special

a feature gives you more control of how the content is displayed or functions when pasted from the clipboard

Merge and Center

a feature in excel that combines multiple cells and centers the contents of the first cell. You can merge columns and rows too.

Cell Range

a group of cells. Example C2:F2 consists of C2, D2, E2, and F2

Transpose

change the data layout from rows to columns or vice-versa.

Bibliography

when someone writes a list of books or other written works. You may have included a bibliography with a research paper you have written, to give credit to your sources.

AutoFit to Window

will adjust the table dimensions to line up with the page

AutoFit to Contents

will adjust the table dimensions to the information inside of the tables.

My table has header

A table header is a row at the top of a table used to label each column.to create a Header in Excel: Open the Excel spreadsheet. Use your mouse to select the cells thatcontain the information for the table. Click the "Insert" tab > Locate the "Tables" group. Click"Table". ... If you have column headings, check the box "My table has headers". Verify that therange is correct > Click [OK].

Sources -

should include information in the following order: 1.author (the person or organization responsible for the site) 2. year (date created or last updated) 3. page title (in italics) 4. name of sponsor of site (if available) 5. accessed day month year (the day you viewed the site) 6. URL or Internet address (pointed brackets)

. Smart Tip

-small windows that pop up when you select or highlight certain cells. These windows generally include a message specific to the connected cell, and offer you some information about the data in the cell, or about what you should enter into the cell

Number Filter

By specifying conditions, you can create custom filters that narrow down the data in theexact way that you want. You do this by building a filter. Point to either Number Filters or TextFilters in the list. A menu appears that allows you to filter on various conditions. Choose acondition and then select or enter criteria. Click the And button to combine criteria (that is, two ormore criteria that must both be met), and the Or button to require only one of multiple conditionsto be met. Click OK to apply the filter and get the results you expect.

Name box-

The box is next to the formula bar, and usually displays the address of the cell that you are in.

Text Filter

EX: Filter a range of data. Select any cell within the range. Select Data > Filter. Select thecolumn header arrow. Select Text Filters or Number Filters, and then select a comparison, likeBetween. Enter the filter criteria and select OK.

Table Style Options

Go to INSERT>TABEL STYLE OPTIONS subgroup to add a complementary style toyour table. You can change

. Number Formats

Number formats are used to control the display of cell values that contain numeric data. This numeric data can include things like dates, times, costs, percentages, and anything else expressed as a number. The most important thing to understand about number formats is that they only affect how a number looks—they have no effect on the actual value stored by Excel.

Banded Columns & Rows

Shading alternate rows in a large spreadsheet can improve legibility. Excel's Conditional Formatting feature allows you to apply cell shading to every other row in a work sheet range using the Modulus ( =mod ) function. Select the range of cells or rows or columns toformat.

Insert Slicer

Slicers provide buttons that you can click to filter tables, or PivotTables. In addition toquick filtering, slicers also indicate the current filtering state, which makes it easy to understandwhat exactly is currently displayed. Create a slicer to filter data: Click anywhere in the table orPivotTable. On the Home tab, go to Insert > Slicer. In the Insert Slicers dialog box, select the checkboxes for the fields you want to display, then select OK. A slicer will be created for every field thatyou selected.

Sort Criteria

Sort by using levels. Sorting levels: Select a cell in the column you want to sort by.Click the Data tab, then select the Sort command. The Sort dialog box will appear. Click Add Levelto add another column to sort by. Select the next column you want to sort by, then click OK. Theworksheet will be sorted according to the selected order.

AutoFill

a feature that helps you quickly enter sequential data. If you are entering a predictable series (e.g. 1, 2, 3...; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.

Footnotes

a note of reference, explanation, or comment usually placed below the text on a printed page.

Worksheet

a page/tab within a Workbook and also called a spreadsheet. There is a limit of 255 sheets (tabs) in a new workbook, but Excel doesn't limit how many worksheets you can add after you've created a workbook.

Sparklines

a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.

Paste

add content from your clipboard to your chosen destination.

Shapes

adding a shape to a document can bring emphasis to a point of information. There are 9 shape categories: Recently used (common category), Lines, Rectangles, Basic Shapes, Block Arrows, Equation Shapes, Flowcharts, Stars and Banners, and Callouts

Line & Paragraph Spacing

adjusts how much space appears between lines of text or between paragraphs. Located in Home tab, paragraph group.

Freeze Panes

allows you to lock your column and/or row headings so that, when you scroll down or over to view the rest of your sheet, the first column and/or top row remain on the screen.

Tabs

also called Sheets in a Workbook

Title Bar

at the top of the window and displays the name of the workbook

Section Breaks

breaks that occur within a page and indicate when a new column ends & starts

Artistic Effects

can be applied to images or pictures in Microsoft Office, making them appear to have been created from various mediums, from paint strokes to plastic wrap.

. Format Painter

lets you copy all of the formatting from one object and apply it to another one - think of it as copying and pasting for formatting. Select the text or graphic that has the formatting that you want to copy.

Add a Comment

located in the Review, Comments sub group. Attaching your comments to specific parts of a document makes your feedback more clear. If someone else is commenting on the document, replying to their comments lets you have a discussion, even when you're not all in the document at the same time.

Landscape

page display of 11.5 X 8 inches, located in Layout tab, Page Setup group.

Portrait

page display of 8 X 11.5 inches, located in Layout tab, Page Setup group

Ribbon

the Ribbon is set up similar to Word (and all Microsoft apps) with various tabs shown below the Title Bar

Citations

the act of citing or quoting a reference to an authority or a precedent. a passage cited; quotation.

Cell

the block created where the row & column meet & identified by the row and column intersection.

Subgroup

these are located under each individual tab on the Worksheet/Spreadsheet.

Page Layout

tools to control the display of your page, located in the Layout tab, in the Page Setup group. These tools include Margins, Size, Column, Breaks, Line Numbers, and Hyphenation.