BOS Semester Review

Flashcards for PowerPoint, Spreadsheet, and Word Processing Review

Template

A document that creates a pattern and structure with design and layout to memos, resumes, fax cover sheets, etc.

Slide Master

Controls the look of an entire presentation including fonts, backgrounds, effects, and even allows a logo to show up on all slides; controls the style & layout to be customized.

Theme

Uses a unique set of colors, fonts, and effects to create a consistent look.

Entrance

When you want an element to show up during a slide presentation, you must apply this effect to that element.

Four types of animation effects

Entrance, exit, emphasis, motion path

Slide Show View

The view where your presentation is put before an audience and fills your screen completely.

Five Basic Presentation Views

Normal, Outline View, Slide Sorter, Notes Page, Reading View

Formatting

Editing a presentation slide, changing the appearance of text, layout and design of a slide.

Title Slide

The default slide that opens when you open a new presentation in PowerPoint.

Slide Layouts

Used to introduce the topic and set the tone for the presentation by changing the arrangement of content placeholders on a slide.

Hyperlink

This Slideshow element moves the presentation to another slide, opens another file or opens a web page.

Presentation View

The view where an audience and presenter walk through the presentation.

Slide Sorter View

The view that shows each slide as a thumbnail and makes rearranging slides easy.

Animations

Making the text appear letter by letter in a slideshow.

Image

Added to presentation adding visual interest & conveying messages.

Transition

Moving from one slide to another.

Keys to push to Show Formulas in excel

Ctl + ' (apostrophe)

Absolute Cell Reference

Does not increase during copying and uses a $ as the signifier; after the formula press F4 to change

Merging Cells

Grouping adjacent cells into one bigger cell.

Part of a chart that labels 'Sales in $ Mn'

Chart Title

Part of a chart on the vertical side with dollar amounts

Value Axis

Part of a chart on the horizontal bottom labels

Category Axis

Part of the chart which shows the color coordinated labels for data

Chart Legend

Part of the chart that shows number near each of the data

Data Labels

Part of the chart that labels on the vertical axis.

Vertical Axis Title

MAX Function

Finds the highest number in a specified series.

MIN Function

Finds the Lowest number in a specified series.

SUM Function

Adds the numbers in a specified series and presents the total.

AVERAGE Function

Adds the numbers in a specified series and divides by the total number of items in the series.

AVERAGEIF Function

Adds only specific numbers in a series that match your criteria and then divides by the same number of items that were added together.

SUMIF Function

Adds only specific numbers in a series that match the criteria you choose.

Type of Alignment in header cells in row 1

Horizontal - Left Vertical - Bottom

Working Sumlf function

=SUMIF(B2:B5, "John", C2:C5)

Named Ranges

Areas of data to use in formulas - use these instead of absolute references

Conditional Formatting

Changes what cells look like based on meeting specific criteria, trends, and patterns.

Sorting

When creating Spreadsheet subtotals, keep things organized by first.

Which Column Controlled the Sort in this Table?

Amount

Text to Columns

Tool useful to convert chunks of text into various columns

Filter

Displays data that meets criteria and temporarily hides rows that don't match specific criteria.

Split Panes

View Option to divide your window into two different panes.

Sorting

Rearranging information in alphabetical, numerical or chronological order.

Range

Adjacent group of cells in a spreadsheet.

Named Range

Area of data to use in a formula - Instead of absolute reference.

Wrap Text

Turn on this option when you want multiple lines of content in one cell.

Order of operations

PEMDAS parentheses, exponents, multiply, divide, add, subtract 8 + 10(6-2) - 6/3 = 46

Az

Sorting Tool/Button in Microsoft Excel

Σ

AutoSum Tool/Button in Microsoft Excel

.0 .00 .00 .0

Increase/Decrease Decimals Tool/Button in Microsoft Excel

Alignment Tool

Alignment Tool/Button in Microsoft Excel

fx

Insert Function Tool/Button in Microsoft Excel

Wrap Text

Wrap extra-long text into multiple lines so you can see it all

Merge

Combines Selected Cells

Scaling

Page feature in spreadsheet to print on specific # of pages

Freeze Pane

Keeps certain rows or columns visible while scrolling

Pie Chart

Chart shows 1 piece of data compared to the whole

Merge & Center

Merge & Center Tool

Range

Selecting more than 1 cell

Lookup Function

To look in a single row or column and find a value from the same position in a second row or column

If Function

Allows you to make logical comparisons between a value and what you expect resulting in True or False

Count Function

Counts the number of cells that contain numbers, and counts numbers within the list of arguments in a number field in range of numbers

Left, Right, Center, Justify

She sells seashells at the seashore. If she sells seashells at the seashore, where are the seashells she sells at the seashore?

Some file extensions you can save word processing documents as

.doc, .docx, .rtf, .txt, .pdf

Header or Footer

Pieces of text, or graphics, that appear at the top and/or bottom of a page. After you set one up, they will appear on all of your pages.

Column Break

Forces the text to start at the top of the next column.

Page Break

Forces the text to start at the top of the next page.

Continuous Section Break

Inserts a hidden break but doesn’t change the way the text looks.

Next Page Section Break

Starts a new section but ends the text on that page and starts it on the next page.

Add Column Chart

Adds Column Chart

Remove Duplicates

Remove Duplicates

Format Painter

Format Painter

Format Painter

Copy a set of text colors, alignment, font, etc and paste it onto a new piece of text.

Scaling

Change this Printing setting to get to your document to print on one page or more than one page if you want!

Watermark

Applying a dimmed or washed out look to a picture that shows up behind the body of a document.

Word Art

Convert text into a graphic

Style

Saved collection of formatting characteristics that can be applied to text, tables, etc.

Theme

Uses a unique set of colors, fonts, and effects to create a consistent look

Mail Merge

Combine a doc with data that personalizes it.

Multi-level List Levels

Multi-level List Levels I am level one I am level two ■ I am level three ● I am level four

Vertical Alignment

Center the text vertically between the top and bottom margins.

Wrap Text

When you place a picture in a document and the words move around it

Text Wrap

One long string of text that can go onto multiple lines

Indents

Indents: Left, Right, Hanging, First Line

Terms

The words: Currency, Decrease Indent, Merge & Center, Paste with Images

Save As

Save file with a new name

Table

Consists of rows, borders, and columns

Select Entire Table

Click top left corner

Page Orientation

Layout options of the page including Portrait & Landscape

Line Spacing

The space between each line in a paragraph single, double, justified

Justification

how text is positioned between margins of page

Types of Indents

Right indent, Hanging indent, First line, Left indent

First line indent, Decrease Indent button, Right indent, Increase Indent button

Type Indents and buttons

Left vs. Right Indent

Left Indent, First Line Indent, Hanging Indent, Right Indent

Report Parts

Report Parts: Bibliography, Header, Footer, Endnote Table of Contents

Labels

Customer Service Center User Guide Contents References Endnote Bibliography Final Draft Footer Table of Contents AAI Shane Co Header Footnotes