BOS Semester Review Power Point Review A document

BOS Semester Review

Power. Point Review A document that creates a pattern and structure with design and layout. Template

Power. Point Review ● Controls the look of an entire presentation including fonts, backgrounds, effects, and even allows a logo to show up on all slides. Slide master

Power. Point Review Uses a unique set of colors, fonts, and effects to create a consistent look Theme

Power. Point Review When you want an element to show up during a slide presentation, what kind of effect must you apply to that element? Entrance

Power. Point Review The four types of animations effects are: Entrance, exit, emphasis, motion path

Power. Point Review The view where your presentation is put before an audience and fills your screen completely Slide Show View

Five Basic Views: o. Normal o. Outline View o. Slide Sorter o. Notes Page o. Reading View

Power. Point Review Editing a presentation slide, changing the appearance of text, layout and design of a slide is referred to Formatting

Power. Point Review When you open a new presentation in Power. Point, the default slide that opens is which Layout? Title Slide

Power. Point Review What is used to change the arrangement of content placeholders on a slide? Slide Layouts

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

Power. Point Review The view where an audience and presenter walk through the presentation. Presentation View

Power. Point Review The view that shows each slide as a thumbnail and makes rearranging slides easy. Slide Sorter View

Access Review A collection of records Database

Access Review One piece of data, the same as a cell in a table, design by column headings as a category Data Field

Access Review The same as a row in a table, a complete set of information about a single item in a table Data Record

Access Review Unique value for each row of data Key

Access Review A question requesting information from the database Query

Access Review Label the following First Record Last Record New Record Previous Record Current Record Next Record

Spreadsheet Review What keys to you push to Show Formulas in excel? Ctl + ‘ (apostrophe)

Spreadsheet Review This kind of cell reference does not increase during copying and uses a ____ as the signifier. Absolute, $

Spreadsheet Review Grouping adjacent cells into one bigger cell is. . . Merging Cells

Spreadsheet Review What part of the chart is this? Chart Title

Spreadsheet Review What part of the chart is this? Value Axis

Spreadsheet Review What part of the chart is this? Category Axis

Spreadsheet Review What part of the chart is this? Chart Legend

Spreadsheet Review What part of the chart is this? Data Labels

Spreadsheet Review What part of the chart is this? Vertical Axis Title

Spreadsheet Review This Function finds the highest number in a specified series. MAX

Spreadsheet Review This Function finds the Lowest number in a specified series. MIN

Spreadsheet Review This function adds the numbers in a specified series and presents the total. SUM

Spreadsheet Review This function adds the numbers in a specified series and divides by the total number of items in the series. AVERAGE

Spreadsheet Review This 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. AVERAGEIF

Spreadsheet Review This function adds only specific numbers in a series that match the criteria you choose. SUMIF

Spreadsheet Review What type of Alignment is used in these header cells? Horizontal - Center Vertical - Center

Spreadsheet Review What does a working Sum. If function look like? =SUMIF(B 2: B 5, "John", C 2: C 5)

Spreadsheet Review Use these instead of absolute references (areas of data to use in formulas) Named Ranges

Spreadsheet Review This changes what cells look like based on meeting specific criteria. Conditional Formatting

Spreadsheet Review When creating Spreadsheet subtotals, keep things organized by _______ first, then doing subtotals Sorting

Spreadsheet Review Which Column Controlled the Sort in this Table? Amount (descending)

Spreadsheet Review This tool is useful to convert chunks of text into various columns Text to Columns

Spreadsheet Review This displays data that meets criteria and temporarily hides rows that don’t match specific criteria. Filter

Spreadsheet Review Want to Divide your window into two different panes? Use this View Option. Split Panes

Spreadsheet Review Rearranging information in alphabetical, numerical or chronological order is called…. Sorting

Spreadsheet Review Adjacent group of cells in a spreadsheet are called a …. Range

Spreadsheet Review Area of data to use in a formula – Instead of absolute reference Named Range

Spreadsheet Review When you want multiple lines of content in one cell you must turn on the _______ option. Wrap Text

Spreadsheet Review Use the Order of operations to get the right answer! PEMDAS parentheses, exponents, multiply, divide, add, subtract 8 + 10(6 -2) - 6/3 = 46

Spreadsheet Review What is this Tool/Button in Microsoft Excel? Sort

Spreadsheet Review What is this Tool/Button in Microsoft Excel? Auto. Sum

Spreadsheet Review What is this Tool/Button in Microsoft Excel? Increase/Decrease Decimals

Spreadsheet Review What is this Tool/Button in Microsoft Excel? Alignment

Spreadsheet Review What is this Tool/Button in Microsoft Excel? Insert Function

Spreadsheet Review Extra long string of text into multiple lines so you can see it all Wrap Text

Word Processing Review This paragraph is aligned how? Left? Right? Center? Or Justified? Left

Word Processing Review This paragraph is aligned how? Left? Right? Center? Or Justified? Center

Word Processing Review This paragraph is aligned how? Left? Right? Center? Or Justified? Right

Word Processing Review This paragraph is aligned how? Left? Right? Center? Or Justified? Justified

Word Processing Review Some File extensions you can save word processing documents as include. . doc, . docx, . rtf, . txt, . pdf

Word Processing Review These are pieces of text, or graphics, that appear at the top and bottom of a page. After you set one up, they will appear on all of your pages. Header or Footer

Word Processing Review This kind of break forces the text to start at the top of the next column. Column Break

Word Processing Review This kind of break forces the text to start at the top of the next page. Page Break

Word Processing Review This kind of break inserts a hidden break but doesn’t change the way the text looks. Continuous Section Break

Word Processing Review This kind of break starts a new section but ends the text on that page and starts it on the next page. Next Page Section Break

Word Processing Review What is this Tool/Button in Microsoft Word? Add Column Chart

Word Processing Review What is this Tool/Button in Microsoft Excel? Remove Duplicates

Word Processing Review What is this Tool/Button in Microsoft Word? Format Painter

Word Processing Review Copy a set of text colors, alignment, font, etc and paste it onto a new piece of text using the _____ Format Painter

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

Word Processing Review Use this type of Break to get the text to start on the next page. Page Break

Word Processing Review Applying a dimmed or washed out look to a picture that shows up behind the body of a document is called a Watermark

Word Processing Review Convert text into a graphic using the _____ tool. Word Art

Word Processing Review A Saved collection of formatting characteristics that can be applied to text, tables, etc is called a. . . Style

Word Processing Review Uses a unique set of colors, fonts, and effects to create a consistent look Theme

Word Processing Review Mail Merge Combine a doc with data that personalizes it.

Word Processing Review I am level one ● ○ ■ I am level two I am level three I am level four ● Multi-level List Levels

Word Processing Review Center the text vertically between the top and bottom margins. Vertical Alignment

Word Processing Review When you place a picture in a document and the words move around it Wrap Text

Word Processing Review One long string of text that can go onto multiple lines Text Wrap

Word Processing Review Left Right She sells seashells at the seashore. If she sells seashells at the seashore, where are the seashells she sells at the seashore? Hanging She sells seashells at the seashore. If she sells seashells at the seashore, where are the seashells she sells at the seashore? First Line Indents