Microsoft Office Applications
content control
An interactive object you can add to customize documents; may contains instructions for filling in text and graphics
destination document
The document to which items are being pasted.
.docx
The file extension for Microsoft Word 2016, 2013, 2010, and 2007 files.
logical test
The first part of an IF function; if the logical test is true, then the second part of the function is applied; if it is false, then the third part of the function is applied.
fill
The formatting of the interior of a shape or slide background, such as color, picture, texture, or pattern.
transparency
The opacity of an object, such as a fill pattern that lets you see through the object so that any text behind it is visible.
nameplate/banner
The portion of a newsletter that contains the title of the newsletter and usually an issue information line; also called a banner.
issue information line
The portion of a newsletter that identifies the specific publication
.dot
is a file in Microsoft word template that is used to store the default settings such as font, font size, content of a file, etc.
line break
is a poetic device that is used at the end of a line, and the beginning of the next line.
NOW function
In Excel, a function that returns a number that corresponds to the system date and time, beginning with December 31, 1899.
font set
A format that lets you define one font for headings and another for body text.
filtered Web Page format
A format that saves a file in webpage format and then reduces the file size by removing specific Microsoft Office formats.
web page format
A format that saves certain webpage components in a folder, separate from the webpage.
Adobe Reader
A free Adobe application that lets you view, navigate, and print PDF files.
nested IF function
A function in which the action to be taken for the true or false case includes another IF function.
volatile function
A function that automatically recalculates its values every time Excel does any calculation in the workbook
gradient
A gradual progression of colors and shades, usually from one color to another color or from one shade to another shade of the same color.
subhead
A heading that is subordinate to a higher level heading.
ruling line
A line that separates areas of a newsletter.
snaking columns
A multiple-column report that prints with the "down, then across" layout, with the first label printed in the upper-left corner on the first page, the second label printed to its right, the third label printed below the first label, and so on; also called newspaper-style columns
category names
A range that identifies the major groups for a chart.
building block
A ready-made graphic or text element you can insert in a document, such as a cover page, design accent, or header.
Horizontal rule
A ruler that appears below the ribbon in the document window in Print Layout, Draft, and Web Layout view
HTML
A special language that software developers use to create and format webpage elements; stands for Hypertext Markup Language
handout master
A template element that designates the placement of text, such as page numbers, on a sheet of paper intended for distribution to audience members.
Office Clipboard
A temporary storage area in the computer's memory that lets you collect text and objects from a file created by a Microsoft Office app, and then paste the text or objects into files created by any Microsoft Office app; can hold a maximum of 24 items.
pull-quote
A text box that contains a quote or an excerpt from an article, given graphical emphasis, and placed on the same page; also called a pullout.
justified
A type of alignment in which the first and last characters of each line are aligned and extra space is inserted between words to evenly spread the words across the line.
Vertical rule
A vertical line that separates areas of a newsletter.
What-if analysis
A way to explore the impact that changing input values has on calculated values and output values
sparkline chart
provides a simple way to show trends and variations in a range of data within a single cell.
newsletter
A (usually) double-sided multipage publication with newspaper features, such as columns and a masthead, and the added eye appeal of sidebars, pictures, and other graphics
texture fill
A background fill that uses a specific file or an image that simulates a material, such as cork, granite, marble, or canvas; also called a picture fill.
mixed cell reference
A cell reference that changes when the formula containing that reference is moved to a new location
assumptions
A cell value that you can change to determine a new value for formulas.
hide slide
A command that hides a slide from the audience during the running of a slide show
column break
A command that places the insertion point at the top of the next column.
Mark as Final
A command that saves a presentation as a read-only document.
SmartArt graphics
A diagram that shows information or ideas visually using a combination of shapes and text.
source document
A document from which items are being copied; also, the documents that are used when combining or comparing documents.
resume
A document that contains an applicant's personal information, educational background, and job experience.
Document Inspector
A feature that examines a file for hidden properties, personal information, and comments.
.mht
A file extension associated with the HTML format that allows webpages to be saved in a single file and opened in a browser.
single file web page format
A file format that saves all webpage components in a single MHTML file that has a .mht extension.
template
A file with a theme applied and that may contain formatted placeholder text, headers and footers, and graphics that you replace with your own information for hundreds of purposes, including budgets, flyers, and resumes; template files have slightly different file extensions than standard application files, such as .xltx, .pptx., or .dotx.
gradient fill
A fill that consists of one-color shade gradually progressing to another shade of the same color or one-color progressing to another color.
When using spreadsheet software, explain the importance of using cell references in a formula.
Cell references allow you to change a value in multiple formulas by changing the value in a single cell.
gradient stop
Color tops are stopping points in a gradient that show a specific color at the exact location we set.
Describe Microsoft Word's template feature.
Contains formatted placeholder text in content controls, header and footers, and Graphics which you can replace with your own information.
What elements could be included about an individual within a resume?
Contains personal information, educational background, and job experience.
data series
Data from a column or row in a sheet; the set of values represented in a chart.
WordArt
Formatted, decorative text in a text box or other shape, created using WordArt tools.
IF function
In Excel, a function that assigns a value to a cell based on a logical test.
format symbols
In Excel, a symbol that assigns a format to numbers as they are entered.
Gridlines
In Excel, horizontal and vertical lines in a worksheet or chart that make it easier to read. In PowerPoint, evenly spaced horizontal and vertical lines on the slide that help you align objects. In a table, nonprinting lines that show cell boundaries.
rehearsal feature
In PowerPoint, a feature that lets you advance through slides at your own pace, and the amount of time you view each slide is recorded.
offset
In PowerPoint, a feature that lets you move the background away from the slide borders in varying distances by percentage.
tiling option
In PowerPoint, a feature that repeats the background image many times vertically and horizontally on the slide; the smaller the tiling percentage, the greater the number of times the image is repeated.
notes master
In PowerPoint, a layout template that defines the formatting for speaker's notes.
variant
In PowerPoint, a slight modification of a theme, usually with different colors for the slide background, objects, and text.
rehearsal toolbar
In PowerPoint, a toolbar that contains buttons allowing you to start, pause, and repeat viewing the slides in the slide show and to view the times for each slide as well as the elapsed time.
drop cap
In Publisher and Word, a decorative, large initial capital letter that extends down below the other letters in the line.
text box
In Publisher, a publication object designed to hold text in a specific shape, size, and style. In Access, the most common type of control used to display field values, also, a form element in which you enter text.
placeholder text
In Publisher, prewritten template text that you select and replace to customize a publication. In Word, default text that indicates where text can be typed in documents.
navigating
In Windows, to find a location on a storage device, such as from one file or folder to another.
sections
In Word, a part of a document that can have its own page orientation, margins, headers, footers, and so on. In other words, each section is like a document within a document.
relative cell reference
In a formula, a cell address that automatically changes to reflect the new location when the formula is copied or moved; the default type of referencing used in Excel worksheets; also called a relative reference.
absolute cell reference
In a formula, a cell address that refers to a specific cell and does not change when you copy the formula.
.odt
Is a OpenDocument Text Document file. The files are most often created by the free OpenOffice writer word processor program. Is similar to DOCX file.
What is a newsletter?
Is a mini newspaper, information about any upcoming dates and events.
What is the purpose behind creating a resume?
Is to present you in a good why on why you are the best candidate for the job. To also sent out to employers too.
In what ways, can a large worksheet be manipulated better?
One of the commands is that you can freeze rows and columns so that they remain visible even when you scroll. You can split the worksheet into separate panes so you can view different parts of the worksheet on the screen once. To see the magnification to allow you to see more content, at a smaller size.
Watermark
Semitransparent text or a graphic that appears behind or in front of existing text on the printed pages of a document, spreadsheet, or publication.
Short for Portable Document Format, a file format developed by Adobe Systems that is the standard format for exchanging documents; lets users view a file using the free Adobe Reader software, without needing to have the program or computer platform that created it.
.rtf
Stands for Rich Text Format. It's a file format standardized by Microsoft for creating formatted text files. Include information such as text style, size, and color.
What groups of individuals might newsletters generally be created for?
Subscribers, employees, customers, patrons, students, etc.
What are the advantages of using templates to create new presentations?
Templates can speed up and simplify the process of creating a presentation. That a template contains text formats, themes, placeholder text, headers, footers, and graphics.
accessibility
The practice of removing barriers that may prevent individuals with disabilities from interacting with data or an app. In relation to digital content, term used to refer to content that is adaptable or available to users who require assistance.
What purpose do slide masters serve within Microsoft PowerPoint?
The slide master is a template that create all five slides in a presentation.
slide master
The template for the slides in a presentation that contains theme elements and styles, text formatting, the slide background, and other objects that appear on all the slides in the presentation.
Explain the advantages paired with using desktop publishing software.
There are more design features in desktop publishing software.
Why are cell references also called assumptions?
To answer what if questions, during a problem or statement.
crop
To trim away part of a picture
Content control
an interactive object you can add to customize documents; may contains instructions for filling in text and graphics.
XPS
a file format created by Microsoft that shows all elements of a printed document as a electronic image and enables file sharing, short for XML Paper Specification.
Multilevel list
a list that contains several levels of list items, with each lower level displaying a different numeric, alphabetic, or bullet character.
Planning proposal
a proposal that offers solutions to a problem or improvement to a situation
Sales proposal
a proposal that sells an idea, a product, or a service
Research proposal
a proposal that usually requests funding for a research project
Cover page
a separate title page in a multipage document that contains, at a minimum, the title of a document, and often the writer's name and sometimes the date.
Column
a single field in a data table; in text layout, a text placeholder used for lists.
Row
a single record in a data table.
autocomplete
a software function that gives users the option of completing words or forms by a shorthand method based on what has been typed before.
Small caps
a typographic convention in which no lowercase letters are used.
.dotx
are template files created by Microsoft word to have pre-formatted settings for generation of further DOCX files.
.txt
is a standard text document that contains unformatted text. They are useful for storing information in plain text with no special formatting beyond basic fonts and font styles.
goal seek
is the ability to calculate backward to obtain an input that would result in a given output.
.htm
means Hyper Text Markup, it's a file extension. The markup tells web browsers how to display a web page's words and images.
.doc
stands for document file. It contain formatted text, images, tables, graphs, charts, page formatting, and print settings.