Computer Basic
Double click in between cells.
How to Autofit?
This feature allows you to add extra or less space between lines of text within a paragraph.
What is "Change paragraph spacing"?
Use dialogue launcher to open up paragraph section.
The symbol that tells Excel you are about to start a formula.
What is the "=" symbol?
Add these visual effects to slides for object entrances, exits, and emphasis.
What are "Add animations and change animation effect"?
Animations Tab - Choose Animation
What is Save As?
This formatting option indents the first line of a paragraph while leaving the other lines aligned to the left margin.
What is add first line indent?
Expand Paragraph Section -Indentation - Special- First Line
Use this feature to lock a column in place while scrolling through other data.
What is "Freeze a column"?
View - Freeze Panes - Freeze First Column
Change the position of objects layered on top of each other.
What is "Modify stacking order"?
Format - Arrange Section - Bring Forward/Backward
A set of tools organized into 9 different default tabs.
What is the ribbon
Use this layout tool to divide your document into two vertical sections for newspaper-style formatting.
What is apply two-column format.
Layout-Column-Two
The small box on the bottom right corner of a cell.
What is the fill handle?
Access a grid-like view of all slides in this presenter tool.
What Use Presenter View - See all Slides?
Screen Icon at bottom right of screen - See all slides icon.
Add or Create - File - Browse - Submit.
How to attach document to classroom assignment.
This type of break forces text to continue in the next column of a multi-column document.
What is "Insert column break"?
Layout - Breaks - Column
Easily see trends in data by setting this rule to color certain cells based on different criteria.
What is conditional formatting?
Home - Styles Section - Conditional Formatting -
Highlight Cells Rule
This feature allows you to print slides for handouts.
What is Print All Slides option in Settings?
What is Word?
The location where you can apply the feature that automatically inserts the current date in a preselected format
What is the text section in the insert tab?
How to paste range of cells with values only.
What is special paste formatting to show values only?
Home - Paste Dropdown - Values Only
The location of slide master.
What is the view tab?
Helps to sort through large sets of data.
What is Excel?
The page number option to center page numbers in the middle of the bottom of a page.
What is bottom of page, plain number 2?
Insert - Header and Footer - Page Numbers
Highlight a specific area of a worksheet to define which cells will print.
What is "Set Print Area"?
Page Layout - Page Set-up - Print Area - Set Print Area
The slide to add an image to in slide master so that the image becomes a part of the theme for every slide.
What is the first slide?
True or False: It is okay on the final to do the tasks out of order.
FALSE!!
Use this referencing tool to add explanatory notes at the bottom of a page.
What is insert a footnote?
References -Footnotes-Insert Footnote
Right click on titles at the bottom of the page.
How to change tab color?
How to make background image transparent.
Design - Format Background - Picture/Texture - Insert Picture - Move Transparency Toggle.
This action will allow you to change the footnote number to Roman Numerals.
What is expand footnote dialogue box, format, number format, choose i, ii, iii?
The equation for SUMIF.
What is =SUMIF(Criteria Range, Criteria, Sum_Range)?
How to change slide order.
What is click and drag on slides to move?
This action allows you to modify a citation to include page numbers.
What is click on citation, dropdown arrow, edit citation, enter page number.
A little yellow ! on the corner of a cell.
What is an error?
To investigate - click on the icon, look at issues, make edits to formula.
The location to find a built-in bibliography.
What is references tab and citations section?
Double click on line between the cells.
What is autofit?
To apply a right tab stop.
What is expand paragraph, tab button, enter tab stop position and choose right alignment.
Table style that you can change in the table style options that takes away the alternate shading.
What is banded rows?
To change alignment of cells in table.
What is highlight cells, table layout, alignment section.
To remove data labels.
What is click on plus symbol, uncheck data labels?