chapter 4 vocabulary

Bullets

- icons used to organize and draw attention to text.

Clipboard

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

Fill Series

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

Workbook

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

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.

Data

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

Formatting

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

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.

Transpose

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

Win/Loss

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

Get External Data

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

Row

numerical -numbered on the left side of the worksheet

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

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.

Copy

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

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.

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.

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)

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.

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.)

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.

. 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.

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.

Name box

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

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.

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.

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.

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.

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.

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.

Cell Range

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

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 and 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

Table of Contents

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.

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.

Contiguous Range

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

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.

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.

Endnotes

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

Numbered Lists

numbering lists to organize and draw attention to text.

Column

on the top of the worksheet

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

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

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. Example: cell C2 is located at the intersection of row 2 and column C.

Subgroup

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

Page layout

tools to control the display of the page located in the layout tab in the page set up group. The tools include Margins ,size, column, breaks , lines, and numbers

AutoFit to Contents

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