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
- Slides: 81